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}'"));
}
