public string SaveData(M12281 t12281, string lang, string user)
{
//var Data = obj.SaveData(t12281, user,lang);
//return Data;
var data = "";
try
{
data = obj.SaveData(t12281, user, lang);
}
catch (Exception e)
{
MethodBase m = MethodBase.GetCurrentMethod();
obj.Log(m.ReflectedType.Name + "." + m.Name, "1", e.Message);
}
return(data);
//string msg = "";
//obj.BeginTransaction();
//if (obj.InsertT12281(t12281, user))
//{
// obj.CommitTransaction();
// msg = obj.GetUserMsg("N0040", "LANG" + lang);
//}
//return msg;
}
public ActionResult SaveData(M12281 t12281)
{
var lang = Session["T_LANG"].ToString();
var user = Session["T_EMP_CODE"].ToString();
var data = repository.SaveData(t12281, lang, user);
string JSONString = string.Empty;
JSONString = JsonConvert.SerializeObject(data);
return(Json(JSONString, JsonRequestBehavior.AllowGet));
}
public string SaveData(M12281 t12281, string user, string lang)
{
string msg = "";
int count = 0;
var collection = Query($"SELECT (SELECT MAX(CASE WHEN T_WEIGHT_CODE = '{t12281.T_WEIGHT_CODE}' AND T_ACTION ='{t12281.T_ACTION}' THEN '1' ELSE '0' END) FROM t12081)COLLECTION from dual").Rows[0]["COLLECTION"].ToString();
BeginTransaction();
if (collection == "0")
{
Command("INSERT INTO T12081(T_ENTRY_DATE,T_ENTRY_USER, T_WEIGHT_CODE, T_LANG2_NAME,T_WEIGHT_FR,T_WEIGHT_TO,T_WEIGHT_GM,T_WEIGHT_GMT,T_DISCARD_REASON_CODE,T_ACTION)"
+ $" VALUES (SYSDATE, '{user}', '{t12281.T_WEIGHT_CODE}','{t12281.T_WEIGHT_NAME}','{t12281.T_WEIGHT_FR}','{t12281.T_WEIGHT_TO}','{t12281.T_WEIGHT_GM}','{t12281.T_WEIGHT_GMT}','{t12281.T_DISCARD_REASON_CODE}','{t12281.T_ACTION}')");
// CommitTransaction();
count = 1;
msg = GetUserMsg("N0040", "LANG" + lang);
}
else
{
Command($"UPDATE T12081 SET T_UPD_DATE=SYSDATE,T_UPD_USER='******',T_LANG2_NAME = '{t12281.T_WEIGHT_NAME}',T_WEIGHT_FR='{t12281.T_WEIGHT_FR}',T_WEIGHT_TO='{t12281.T_WEIGHT_TO}',T_WEIGHT_GM ='{t12281.T_WEIGHT_GMT}',T_WEIGHT_GMT='{t12281.T_WEIGHT_GMT}'," +
$"T_DISCARD_REASON_CODE='{t12281.T_DISCARD_REASON_CODE}' WHERE T_ACTION='{t12281.T_ACTION}' AND T_WEIGHT_CODE = '{t12281.T_WEIGHT_CODE}'");
// CommitTransaction();
count = 1;
msg = GetUserMsg("N0041", "LANG" + lang);
}
if (count == 1)
{
CommitTransaction();
}
else
{
RollbackTransaction();
}
return(msg);
// Command($"INSERT INTO T12075(T_ENTRY_DATE, T_UNIT_NO, T_SEGMENT_NO,T_BLD_STORE_ID,T_DONATION_DATE)"
// + $" VALUES (SYSDATE, '{t12022.T_UNIT_NO}', '{t12022.T_SEGMENT_NO}','{storeId}',SYSDATE)");
// Command($"UPDATE T12035 SET T_SEQ_NO = '{t12022.T_SEQ_NO}' WHERE T_HOSPITAL ='1' AND T_WS_CODE = '12'");
}
