public string Insert_T12011(t12011 t12011, string user) { string msg = ""; int count = Query($"SELECT T_PRODUCT_CODE FROM T12011 WHERE T_PRODUCT_CODE = '{t12011.T_PRODUCT_CODE}'").Rows.Count; BeginTransaction(); if (count == 0) { if (Command($"INSERT INTO T12011 (T_ENTRY_USER,T_ENTRY_DATE,T_PRODUCT_CODE,T_LANG2_NAME,T_LANG1_NAME, T_EXPIRY_DAYS,T_PROD_PRIORITY,T_STORE_AT, T_ACTIVE) VALUES ('{user}', TRUNC(SYSDATE), '{t12011.T_PRODUCT_CODE}', '{t12011.T_LANG2_NAME}', '{t12011.T_LANG1_NAME}', '{t12011.T_EXPIRY_DAYS}', '{t12011.T_PROD_PRIORITY}','{t12011.T_STORE_AT}', '{t12011.T_ACTIVE}')")) { CommitTransaction(); msg = "N0040"; } else { RollbackTransaction(); msg = "N0071"; } } else { if (Command( $"UPDATE T12011 SET T_UPD_USER='******',T_UPD_DATE=TRUNC(SYSDATE),T_LANG2_NAME='{t12011.T_LANG2_NAME}',T_LANG1_NAME='{t12011.T_LANG1_NAME}',T_EXPIRY_DAYS='{t12011.T_EXPIRY_DAYS}',T_PROD_PRIORITY='{t12011.T_PROD_PRIORITY}',T_STORE_AT='{t12011.T_STORE_AT}',T_ACTIVE='{t12011.T_ACTIVE}' WHERE T_PRODUCT_CODE='{t12011.T_PRODUCT_CODE}'")) { CommitTransaction(); msg = "N0041"; } else { RollbackTransaction(); msg = "N0072"; } } return(msg); }
public ActionResult Insert_T12011(t12011 t12011) { var user = Session["T_EMP_CODE"].ToString(); var data = repository.Insert_T12011(t12011, user); string JSONString = string.Empty; JSONString = JsonConvert.SerializeObject(data); return(Json(JSONString, JsonRequestBehavior.AllowGet)); }
public string Insert_T12011(t12011 t12011, string user) { //var Data = obj.Insert_T12011(t12011, user); //return Data; var data = ""; try { data = obj.Insert_T12011(t12011, user); } catch (Exception e) { MethodBase m = MethodBase.GetCurrentMethod(); obj.Log(m.ReflectedType.Name + "." + m.Name, "1", e.Message); } return(data); }