public string T12264updateT12067andT12065(M12264 t12264, string user, string siteCode) { string msg = ""; try { obj.BeginTransaction(); if (obj.T12264updateT12067(t12264, user)) { if (obj.T12264updateT12065(t12264, user, siteCode)) { obj.CommitTransaction(); msg = "Data updated Successfully"; } } else { obj.RollbackTransaction(); msg = "Data Not Saved"; } } catch (Exception e) { MethodBase m = MethodBase.GetCurrentMethod(); obj.Log(m.ReflectedType.Name + "." + m.Name, "1", e.Message); } return(msg); }
public ActionResult T12264updateT12067andT12065(M12264 t12264) { try { string user = HttpContext.Session["T_EMP_CODE"].ToString(); //string siteCode = HttpContext.Session["T_SITE_CODE"].ToString(); string siteCode = HttpContext.Session["T_REFERRAL_CODE"].ToString(); var data = repository.T12264updateT12067andT12065(t12264, user, siteCode); string JSONString = string.Empty; JSONString = JsonConvert.SerializeObject(data); return(Json(JSONString, JsonRequestBehavior.AllowGet)); } catch (Exception e) { err.SetServerErrorLog(ControllerContext.RouteData.Values["controller"].ToString(), ControllerContext.RouteData.Values["action"].ToString(), Session["T_ENTRY_USER"] == null ? "" : Session["T_ENTRY_USER"].ToString(), e.Message); return(Json(e.Message, JsonRequestBehavior.AllowGet)); } }
public bool T12264updateT12065(M12264 t12264, string user, string siteCode) { Command( $@"UPDATE T12065 SET T_REQUEST_STATUS = '{t12264.T_REQUEST_STATUS}' WHERE T_BLOOD_REQNO = '{t12264.T_BLOOD_REQNO}' AND T_SITE_CODE = '{siteCode}'"); return(true); }
public bool T12264updateT12067(M12264 t12264, string user) { return(Command( $"UPDATE T12067 SET T_HOSP_RECEIVED_FLAG = '{t12264.T_HOSP_RECEIVED_FLAG}', T_HOSP_RECEIVED_BY = '{t12264.T_HOSP_RECEIVED_BY}', T_HOSP_RECEIVED_DATE = TO_DATE('{t12264.T_HOSP_RECEIVED_DATE}','dd/mm/yyyy'), T_HOSP_RECEIVED_TIME = '{t12264.T_HOSP_RECEIVED_TIME}' WHERE T_UNIT_NO = '{t12264.T_UNIT_NO}' AND T_BLOOD_REQNO = '{t12264.T_BLOOD_REQNO}' AND T_SITE_CODE = '{t12264.T_SITE_CODE}'")); }