public ActionResult InsertToT12338(M12338 t12338)
{
string user = HttpContext.Session["T_EMP_CODE"].ToString();
string siteCode = HttpContext.Session["T_SITE_CODE"].ToString();
var data = repository.InsertToT12338(t12338, user);
string JSONString = string.Empty;
JSONString = JsonConvert.SerializeObject(data);
return(Json(JSONString, JsonRequestBehavior.AllowGet));
}
public string InsertToT12338(M12338 t12338, string user)
{
//string msg = "";
//var dt = obj.CheckExistOrNot(t12338);
//obj.BeginTransaction();
//if (dt.Rows.Count == 0)
//{
// if (obj.InsertToT12338(t12338, user))
// {
// obj.CommitTransaction();
// msg = "Data Saved Successfully";
// }
// else
// {
// obj.RollbackTransaction();
// msg = "Data Not Saved";
// }
//}
//else if (dt.Rows.Count > 0)
//{
// if (obj.UpdateToT12338(t12338, user))
// {
// obj.CommitTransaction();
// msg = "Data Updated Successfully";
// }
// else
// {
// obj.RollbackTransaction();
// msg = "Data Not Updated";
// }
//}
//return msg;
string msg = "";
try
{
var dt = obj.CheckExistOrNot(t12338);
obj.BeginTransaction();
if (dt.Rows.Count == 0)
{
if (obj.InsertToT12338(t12338, user))
{
obj.CommitTransaction();
msg = "Data Saved Successfully";
}
else
{
obj.RollbackTransaction();
msg = "Data Not Saved";
}
}
else if (dt.Rows.Count > 0)
{
if (obj.UpdateToT12338(t12338, user))
{
obj.CommitTransaction();
msg = "Data Updated Successfully";
}
else
{
obj.RollbackTransaction();
msg = "Data Not Updated";
}
}
}
catch (Exception e)
{
MethodBase m = MethodBase.GetCurrentMethod();
obj.Log(m.ReflectedType.Name + "." + m.Name, "1", e.Message);
}
return(msg);
}
public bool InsertToT12338(M12338 t12338, string user)
{
Command($"INSERT INTO T12338 (T_ENTRY_USER,T_ENTRY_DATE,T_CENTRAL_BANK_CODE,T_BANK_CODE,T_LANG2_NAME,T_LANG1_NAME,T_BANK_ACTIVE) VALUES ('{user}',TRUNC(SYSDATE),'{t12338.T_CENTRAL_BANK_CODE}','{t12338.T_BANK_CODE}','{t12338.T_LANG2_NAME}','{t12338.T_LANG1_NAME}','{t12338.T_BANK_ACTIVE}')");
return(true);
}
public bool UpdateToT12338(M12338 t12338, string user)
{
Command($"UPDATE T12338 SET T_UPD_USER='******',T_UPD_DATE=TRUNC(SYSDATE),T_BANK_ACTIVE='{t12338.T_BANK_ACTIVE}' WHERE T_CENTRAL_BANK_CODE = '{t12338.T_CENTRAL_BANK_CODE}' AND T_BANK_CODE = '{t12338.T_BANK_CODE}'");
return(true);
}
public DataTable CheckExistOrNot(M12338 t12338)
{
return(Query($"SELECT * FROM T12338 WHERE T_CENTRAL_BANK_CODE='{t12338.T_CENTRAL_BANK_CODE}' AND T_BANK_CODE='{t12338.T_BANK_CODE}'"));
}
