public string SaveData(M12300 t12300, string lang, string user, string sitCode)
{
string dt = "";
try
{
dt = obj.SaveData(t12300, lang, user, sitCode);
}
catch (Exception e)
{
MethodBase m = MethodBase.GetCurrentMethod();
obj.Log(m.ReflectedType.Name + "." + m.Name, "1", e.Message);
}
return(dt);
//var Data = obj.SaveData(t12300,lang,user, sitCode);
//return Data;
}
public ActionResult SaveData(M12300 t12300)
{
try
{
var sitCode = Session["T_SITE_CODE"].ToString();
var lang = Session["T_LANG"].ToString().ToString();
var user = Session["T_EMP_CODE"].ToString();
var data = repository.SaveData(t12300, lang, user, sitCode);
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 string SaveData(M12300 t12300, string lang, string user, string sitCode)
{
string sms = "";
int count = 0;
//var accept = Query($"SELECT NVL (T_REQ_STATUS,0)T_REQ_STATUS FROM T12012 WHERE T_REQUEST_NO ='{t12300.T_REQUEST_NO}'").Rows[0]["T_REQ_STATUS"].ToString();
var accept = Query($"select decode(cnt_req,0,'0',T_REQ_STATUS)T_REQ_STATUS, cnt_req from ( select T_REQ_STATUS,T_REQUEST_NO, decode(T_REQUEST_NO,'{t12300.T_REQUEST_NO}',1,0)cnt_req FROM T12012 WHERE T_REQUEST_NO = '{t12300.T_REQUEST_NO}' or 1=1 order by cnt_req desc) t where rownum=1").Rows[0]["T_REQ_STATUS"].ToString();
if (accept == "1")
{
sms = GetUserMsg("S0715", "LANG" + lang) + "+" + t12300.T_REQUEST_NO;
}
else
{
int chk = Query($"Select T_REQUEST_NO from T12012 where T_REQUEST_NO ='{t12300.T_REQUEST_NO}'").Rows.Count;
BeginTransaction();
if (chk < 1)
{
string maxRequest = Query("select lpad( nvl(max(NVL(to_number(T_REQUEST_NO),0)),0)+1,8,'0') T_REQUEST_NO from T12012").Rows[0]["T_REQUEST_NO"].ToString();
if (t12300.T_PAT_NO != "")
{
Command("INSERT INTO T12012(T_ENTRY_DATE,T_ENTRY_USER, T_REQUEST_NO,T_ABO_CODE, T_ANEMIA_HB," +
"T_CHECK_BOX,T_CHECK_BOX_DATE,T_CHECK_BOX_TIME,T_COAGULOPATHY_PT," +
"T_CONSULTANT_CODE,T_HOSP_CODE,T_LOCATION_CODE,T_MTHR_BG_CODE,T_NURSE_CODE," +
"T_PAT_NO,T_REQUEST_DATE,T_REQUEST_TIME,T_SURGEON_CODE,T_SURGEON_DATE," +
"T_SURGEON_TIME,T_THROMBOCYTOPENIA,T_UNITNO,T_VERIFIED_BY,T_VERIFY_DATE,T_VERIFY_TIME," +
"T_CLINICAL_DIAGNOSIS,T_SPI_IRRADIATED,T_SPI_LEUKOCYTE,T_SPI_VOL,T_SPI_VOL_ML," +
"T_COAGULOPATHY_FIB,T_OTHERS,T_POST_TRANSF_REACTION_YN,T_PREV_PREGNANCIES_YN," +
"T_PREV_TRANSFUSION_YN,T_TRANSFUSION_NONE,T_PREV_UN_EXPECTED_ANTIBODY,T_WITHOUT," + "T_BLEEP_NO,T_X_MATCH_WITHOUT_BLOOD,T_X_MATCH_WITH_BLOOD,T_IMMEDIATE_SPIN_X,T_DOC_CODE,T_REQUISITION,T_COAGULOPATHY_APPT,T_SITE_CODE)"
+ $" VALUES (SYSDATE, '{user}','{maxRequest}', " +
$"'{t12300.T_ABO_CODE}','{t12300.T_ANEMIA_HB}','{t12300.T_CHECK_BOX}'," +
$"'{t12300.T_CHECK_BOX_DATE}','{t12300.T_CHECK_BOX_TIME}','{t12300.T_COAGULOPATHY_PT}'," +
$"'{t12300.T_CONSULTANT_CODE}','{t12300.T_HOSP_CODE}','{t12300.T_LOCATION_CODE}'," +
$"'{t12300.T_MTHR_BG_CODE}','{t12300.T_NURSE_CODE}','{t12300.T_PAT_NO}'," +
$"'{t12300.T_REQUEST_DATE}','{t12300.T_REQUEST_TIME}'," +
$"'{t12300.T_SURGEON_CODE}','{t12300.T_SURGEON_DATE}','{t12300.T_SURGEON_TIME}', " +
$"'{t12300.T_THROMBOCYTOPENIA}', '{t12300.T_UNITNO}', '{t12300.T_VERIFIED_BY}', " +
$"'{t12300.T_VERIFY_DATE}', '{t12300.T_VERIFY_TIME}','{t12300.T_CLINICAL_DIAGNOSIS}'," +
$"'{t12300.T_SPI_IRRADIATED}','{t12300.T_SPI_LEUKOCYTE}','{t12300.T_SPI_VOL}'," +
$"'{t12300.T_SPI_VOL_ML}','{t12300.T_COAGULOPATHY_FIB}','{t12300.T_OTHERS}'," +
$"'{t12300.T_POST_TRANSF_REACTION_YN}','{t12300.T_PREV_PREGNANCIES_YN}'," +
$"'{t12300.T_PREV_TRANSFUSION_YN}','{t12300.T_TRANSFUSION_NONE}'," +
$"'{t12300.T_PREV_UN_EXPECTED_ANTIBODY}','{t12300.T_WITHOUT}','{t12300.T_BLEEP_NO}', " +
$"'{t12300.T_X_MATCH_WITHOUT_BLOOD}', '{t12300.T_X_MATCH_WITH_BLOOD}', " + $"'{t12300.T_IMMEDIATE_SPIN_X}','{t12300.T_DOC_CODE}','{t12300.T_REQUISITION}','{t12300.T_COAGULOPATHY_APPT}','{sitCode}')");
sms = GetUserMsg("N0040", "LANG" + lang) + "+" + maxRequest;
count = 1;
}
}
else
{
Command($"UPDATE T12012 SET T_UPD_DATE=SYSDATE,T_UPD_USER='******',T_ABO_CODE = '{t12300.T_ABO_CODE}',T_ANEMIA_HB='{t12300.T_ANEMIA_HB}',T_CHECK_BOX='{t12300.T_CHECK_BOX}',T_CHECK_BOX_DATE ='{t12300.T_CHECK_BOX_DATE}',T_CHECK_BOX_TIME='{t12300.T_CHECK_BOX_TIME}', T_COAGULOPATHY_PT='{t12300.T_COAGULOPATHY_PT}',T_CONSULTANT_CODE='{t12300.T_CONSULTANT_CODE}',T_HOSP_CODE='{t12300.T_HOSP_CODE}',T_LOCATION_CODE='{t12300.T_LOCATION_CODE}',T_MTHR_BG_CODE='{t12300.T_MTHR_BG_CODE}',T_NURSE_CODE='{t12300.T_NURSE_CODE}',T_REQUEST_DATE='{t12300.T_REQUEST_DATE}',T_REQUEST_TIME='{t12300.T_REQUEST_TIME}',T_SURGEON_CODE='{t12300.T_SURGEON_CODE}',T_SURGEON_DATE='{t12300.T_SURGEON_DATE}',T_SURGEON_TIME='{t12300.T_SURGEON_TIME}',T_THROMBOCYTOPENIA='{t12300.T_THROMBOCYTOPENIA}',T_UNITNO='{t12300.T_UNITNO}',T_VERIFIED_BY='{t12300.T_VERIFIED_BY}',T_VERIFY_DATE='{t12300.T_VERIFY_DATE}',T_VERIFY_TIME='{t12300.T_VERIFY_TIME}',T_CLINICAL_DIAGNOSIS='{t12300.T_CLINICAL_DIAGNOSIS}',T_SPI_IRRADIATED='{t12300.T_SPI_IRRADIATED}',T_SPI_LEUKOCYTE='{t12300.T_SPI_LEUKOCYTE}',T_SPI_VOL='{t12300.T_SPI_VOL}',T_SPI_VOL_ML='{t12300.T_SPI_VOL_ML}',T_COAGULOPATHY_FIB='{t12300.T_COAGULOPATHY_FIB}',T_OTHERS='{t12300.T_OTHERS}',T_POST_TRANSF_REACTION_YN='{t12300.T_POST_TRANSF_REACTION_YN}',T_PREV_PREGNANCIES_YN='{t12300.T_PREV_PREGNANCIES_YN}',T_PREV_TRANSFUSION_YN='{t12300.T_PREV_TRANSFUSION_YN}',T_TRANSFUSION_NONE='{t12300.T_TRANSFUSION_NONE}',T_PREV_UN_EXPECTED_ANTIBODY='{t12300.T_PREV_UN_EXPECTED_ANTIBODY}',T_WITHOUT='{t12300.T_WITHOUT}',T_BLEEP_NO='{t12300.T_BLEEP_NO}',T_X_MATCH_WITHOUT_BLOOD='{t12300.T_X_MATCH_WITHOUT_BLOOD}',T_X_MATCH_WITH_BLOOD='{t12300.T_X_MATCH_WITH_BLOOD}',T_IMMEDIATE_SPIN_X='{t12300.T_IMMEDIATE_SPIN_X}',T_DOC_CODE='{t12300.T_DOC_CODE}',T_REQUISITION='{t12300.T_REQUISITION}',T_COAGULOPATHY_APPT='{t12300.T_COAGULOPATHY_APPT}',T_SITE_CODE='{sitCode}' WHERE T_REQUEST_NO='{t12300.T_REQUEST_NO}' AND T_PAT_NO = '{t12300.T_PAT_NO}'");
sms = GetUserMsg("N0041", "LANG" + lang) + "+" + t12300.T_REQUEST_NO;
count = 1;
}
if (count == 1)
{
CommitTransaction();
}
else
{
RollbackTransaction();
}
}
return(sms);
}
