public ActionResult InsertToT12338(M12338 t12338) { string user = HttpContext.Session["T_EMP_CODE"].ToString(); string siteCode = HttpContext.Session["T_SITE_CODE"].ToString(); var data = repository.InsertToT12338(t12338, user); string JSONString = string.Empty; JSONString = JsonConvert.SerializeObject(data); return(Json(JSONString, JsonRequestBehavior.AllowGet)); }
public string InsertToT12338(M12338 t12338, string user) { //string msg = ""; //var dt = obj.CheckExistOrNot(t12338); //obj.BeginTransaction(); //if (dt.Rows.Count == 0) //{ // if (obj.InsertToT12338(t12338, user)) // { // obj.CommitTransaction(); // msg = "Data Saved Successfully"; // } // else // { // obj.RollbackTransaction(); // msg = "Data Not Saved"; // } //} //else if (dt.Rows.Count > 0) //{ // if (obj.UpdateToT12338(t12338, user)) // { // obj.CommitTransaction(); // msg = "Data Updated Successfully"; // } // else // { // obj.RollbackTransaction(); // msg = "Data Not Updated"; // } //} //return msg; string msg = ""; try { var dt = obj.CheckExistOrNot(t12338); obj.BeginTransaction(); if (dt.Rows.Count == 0) { if (obj.InsertToT12338(t12338, user)) { obj.CommitTransaction(); msg = "Data Saved Successfully"; } else { obj.RollbackTransaction(); msg = "Data Not Saved"; } } else if (dt.Rows.Count > 0) { if (obj.UpdateToT12338(t12338, user)) { 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); }
public bool InsertToT12338(M12338 t12338, string user) { Command($"INSERT INTO T12338 (T_ENTRY_USER,T_ENTRY_DATE,T_CENTRAL_BANK_CODE,T_BANK_CODE,T_LANG2_NAME,T_LANG1_NAME,T_BANK_ACTIVE) VALUES ('{user}',TRUNC(SYSDATE),'{t12338.T_CENTRAL_BANK_CODE}','{t12338.T_BANK_CODE}','{t12338.T_LANG2_NAME}','{t12338.T_LANG1_NAME}','{t12338.T_BANK_ACTIVE}')"); return(true); }
public bool UpdateToT12338(M12338 t12338, string user) { Command($"UPDATE T12338 SET T_UPD_USER='******',T_UPD_DATE=TRUNC(SYSDATE),T_BANK_ACTIVE='{t12338.T_BANK_ACTIVE}' WHERE T_CENTRAL_BANK_CODE = '{t12338.T_CENTRAL_BANK_CODE}' AND T_BANK_CODE = '{t12338.T_BANK_CODE}'"); return(true); }
public DataTable CheckExistOrNot(M12338 t12338) { return(Query($"SELECT * FROM T12338 WHERE T_CENTRAL_BANK_CODE='{t12338.T_CENTRAL_BANK_CODE}' AND T_BANK_CODE='{t12338.T_BANK_CODE}'")); }