public ActionResult SaveData(M12132 t12132)
{
var lang = Session["T_LANG"].ToString();
var user = Session["T_EMP_CODE"].ToString();
var data = repository.SaveData(t12132, lang, user);
string JSONString = string.Empty;
JSONString = JsonConvert.SerializeObject(data);
return(Json(JSONString, JsonRequestBehavior.AllowGet));
}
public string SaveData(M12132 t12132, string lang, string user)
{
//var data = obj.SaveData(t12132, user, lang);
//return data;
var data = "";
try
{
data = obj.SaveData(t12132, user, lang);
}
catch (Exception e)
{
MethodBase m = MethodBase.GetCurrentMethod();
obj.Log(m.ReflectedType.Name + "." + m.Name, "1", e.Message);
}
return(data);
}
public string SaveData(M12132 t12132, string user, string lang)
{
string msg = "";
int count = 0;
var max = Query($"select MAX(T_LABEL_ID*1)+1 T_LABEL_ID FROM T12132");
var maxId = max.Rows[0]["T_LABEL_ID"];
var collection = Query($"SELECT (SELECT MAX(CASE WHEN T_FORM_NAME = '{t12132.T_FORM_NAME}' AND T_CONTROL_NAME ='{t12132.T_CONTROL_NAME}' THEN '1' ELSE '0' END) FROM T12132)COLLECTION from dual").Rows[0]["COLLECTION"].ToString();
BeginTransaction();
if (collection == "0")
{
Command("INSERT INTO T12132(T_ENTRY_DATE,T_ENTRY_USER, T_FORM_NAME, T_CONTROL_NAME,T_CONTROL_TEXT_LANG1,T_CONTROL_TEXT_LANG2,T_LABEL_ID)"
+ $" VALUES (SYSDATE, '{user}', '{t12132.T_FORM_NAME}','{t12132.T_CONTROL_NAME}','{t12132.T_CONTROL_TEXT_LANG1}','{t12132.T_CONTROL_TEXT_LANG2}','{maxId}')");
// CommitTransaction();
count = 1;
msg = GetUserMsg("N0040", "LANG" + lang);
}
else
{
Command($"UPDATE T12132 SET T_UPD_DATE=SYSDATE,T_UPD_USER='******',T_FORM_NAME = '{t12132.T_FORM_NAME}',T_CONTROL_NAME='{t12132.T_CONTROL_NAME}',T_CONTROL_TEXT_LANG1='{t12132.T_CONTROL_TEXT_LANG1}',T_CONTROL_TEXT_LANG2 ='{t12132.T_CONTROL_TEXT_LANG2}'" +
$" WHERE T_LABEL_ID='{t12132.T_LABEL_ID}'");
// 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'");
}
