public ActionResult InsertToT12337(M12337 t12337)
{
string user = HttpContext.Session["T_EMP_CODE"].ToString();
string siteCode = HttpContext.Session["T_SITE_CODE"].ToString();
var data = repository.InsertToT12337(t12337, user, siteCode);
string JSONString = string.Empty;
JSONString = JsonConvert.SerializeObject(data);
return(Json(JSONString, JsonRequestBehavior.AllowGet));
}
public bool UpdateToT12337(M12337 t12337, string user, string siteCode)
{
Command($"UPDATE t12337 SET T_BANK_TYPE='{t12337.BankType1}',T_BANK_TEL='{t12337.BankTelephn}',T_BANK_MGR='{t12337.BankManager}',T_BANK_ACTIVE = '{t12337.T_ACTIVE}',T_MGR_MOBILE_NO='{t12337.MobileNo}',T_EXPIRE_DATE_NO= '{t12337.Expiry}',T_REORDER_NO='{t12337.Reorder}' WHERE T_BANK_CODE='{t12337.BankCode}' AND T_ZONE_CODE = '{t12337.T_ZONE_CODE}'");
return(true);
}
public DataTable CheckExistOrNot(M12337 t12337)
{
return(Query($"select * from t12337 where t_zone_code='{t12337.T_ZONE_CODE}' and t_bank_code='{t12337.BankCode}' and T_BANK_TYPE='{t12337.BankType1}'"));
}
public bool InsertToT12337(M12337 t12337, string user, string siteCode)
{
Command(
$"insert into t12337(T_ENTRY_USER,T_ENTRY_DATE,T_ZONE_CODE,T_BANK_CODE,T_LANG2_NAME,T_LANG1_NAME,T_BANK_TYPE,T_BANK_TEL,T_BANK_MGR,T_BANK_ACTIVE,T_MGR_MOBILE_NO,T_EXPIRE_DATE_NO,T_REORDER_NO,T_SITE_CODE) values ('{user}',trunc(sysdate),'{t12337.T_ZONE_CODE}','{t12337.BankCode}','{t12337.BankNameEng}','{t12337.BankNameArb}','{t12337.BankType1}','{t12337.BankTelephn}','{t12337.BankManager}','{t12337.T_ACTIVE}','{t12337.MobileNo}','{t12337.Expiry}','{t12337.Reorder}','{siteCode}')");
return(true);
}
public string InsertToT12337(M12337 t12337, string user, string siteCode)
{
//string msg = "";
//var dt = obj.CheckExistOrNot(t12337);
//obj.BeginTransaction();
//if (dt.Rows.Count == 0)
//{
// if (obj.InsertToT12337(t12337, user, siteCode))
// {
// obj.CommitTransaction();
// msg = "Data Saved Successfully";
// }
// else
// {
// obj.RollbackTransaction();
// msg = "Data Not Saved";
// }
//}
//else if(dt.Rows.Count > 0)
//{
// if (obj.UpdateToT12337(t12337, user, siteCode))
// {
// obj.CommitTransaction();
// msg = "Data Updated Successfully";
// }
// else
// {
// obj.RollbackTransaction();
// msg = "Data Not Updated";
// }
//}
//return msg;
string msg = "";
try
{
var dt = obj.CheckExistOrNot(t12337);
obj.BeginTransaction();
if (dt.Rows.Count == 0)
{
if (obj.InsertToT12337(t12337, user, siteCode))
{
obj.CommitTransaction();
msg = "Data Saved Successfully";
}
else
{
obj.RollbackTransaction();
msg = "Data Not Saved";
}
}
else if (dt.Rows.Count > 0)
{
if (obj.UpdateToT12337(t12337, user, siteCode))
{
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);
}
