public ActionResult InsertToT12337(M12337 t12337) { string user = HttpContext.Session["T_EMP_CODE"].ToString(); string siteCode = HttpContext.Session["T_SITE_CODE"].ToString(); var data = repository.InsertToT12337(t12337, user, siteCode); string JSONString = string.Empty; JSONString = JsonConvert.SerializeObject(data); return(Json(JSONString, JsonRequestBehavior.AllowGet)); }
public bool UpdateToT12337(M12337 t12337, string user, string siteCode) { Command($"UPDATE t12337 SET T_BANK_TYPE='{t12337.BankType1}',T_BANK_TEL='{t12337.BankTelephn}',T_BANK_MGR='{t12337.BankManager}',T_BANK_ACTIVE = '{t12337.T_ACTIVE}',T_MGR_MOBILE_NO='{t12337.MobileNo}',T_EXPIRE_DATE_NO= '{t12337.Expiry}',T_REORDER_NO='{t12337.Reorder}' WHERE T_BANK_CODE='{t12337.BankCode}' AND T_ZONE_CODE = '{t12337.T_ZONE_CODE}'"); return(true); }
public DataTable CheckExistOrNot(M12337 t12337) { return(Query($"select * from t12337 where t_zone_code='{t12337.T_ZONE_CODE}' and t_bank_code='{t12337.BankCode}' and T_BANK_TYPE='{t12337.BankType1}'")); }
public bool InsertToT12337(M12337 t12337, string user, string siteCode) { Command( $"insert into t12337(T_ENTRY_USER,T_ENTRY_DATE,T_ZONE_CODE,T_BANK_CODE,T_LANG2_NAME,T_LANG1_NAME,T_BANK_TYPE,T_BANK_TEL,T_BANK_MGR,T_BANK_ACTIVE,T_MGR_MOBILE_NO,T_EXPIRE_DATE_NO,T_REORDER_NO,T_SITE_CODE) values ('{user}',trunc(sysdate),'{t12337.T_ZONE_CODE}','{t12337.BankCode}','{t12337.BankNameEng}','{t12337.BankNameArb}','{t12337.BankType1}','{t12337.BankTelephn}','{t12337.BankManager}','{t12337.T_ACTIVE}','{t12337.MobileNo}','{t12337.Expiry}','{t12337.Reorder}','{siteCode}')"); return(true); }
public string InsertToT12337(M12337 t12337, string user, string siteCode) { //string msg = ""; //var dt = obj.CheckExistOrNot(t12337); //obj.BeginTransaction(); //if (dt.Rows.Count == 0) //{ // if (obj.InsertToT12337(t12337, user, siteCode)) // { // obj.CommitTransaction(); // msg = "Data Saved Successfully"; // } // else // { // obj.RollbackTransaction(); // msg = "Data Not Saved"; // } //} //else if(dt.Rows.Count > 0) //{ // if (obj.UpdateToT12337(t12337, user, siteCode)) // { // obj.CommitTransaction(); // msg = "Data Updated Successfully"; // } // else // { // obj.RollbackTransaction(); // msg = "Data Not Updated"; // } //} //return msg; string msg = ""; try { var dt = obj.CheckExistOrNot(t12337); obj.BeginTransaction(); if (dt.Rows.Count == 0) { if (obj.InsertToT12337(t12337, user, siteCode)) { obj.CommitTransaction(); msg = "Data Saved Successfully"; } else { obj.RollbackTransaction(); msg = "Data Not Saved"; } } else if (dt.Rows.Count > 0) { if (obj.UpdateToT12337(t12337, user, siteCode)) { obj.CommitTransaction(); msg = "Data Updated Successfully"; } else { obj.RollbackTransaction(); msg = "Data Not Updated"; } } } catch (Exception e) { MethodBase m = MethodBase.GetCurrentMethod(); obj.Log(m.ReflectedType.Name + "." + m.Name, "1", e.Message); } return(msg); }