public int SaveRecord(SETUP_Bank lrow_Bank)
{
int li_ReturnValue = 0;
try
{
SCMSDataContext dbSCMS = Connection.Create();
SETUP_Bank lRow_ExistingData = dbSCMS.SETUP_Banks.Where(c => c.Bank_Id.Equals(lrow_Bank.Bank_Id)).SingleOrDefault();
if (lRow_ExistingData != null)
{
lRow_ExistingData.Bank_Title = lrow_Bank.Bank_Title;
//lRow_ExistingData.Loc_Id = lrow_Bank.Loc_Id;
}
else
{
dbSCMS.SETUP_Banks.InsertOnSubmit(lrow_Bank);
}
dbSCMS.SubmitChanges();
li_ReturnValue = Convert.ToInt32(lrow_Bank.Bank_Id);
}
catch
{
return 0;
}
return li_ReturnValue;
}
public ActionResult SaveRecord(String ps_Code, String Title)
{
SETUP_Bank lrow_Bank = new SETUP_Bank();
String ls_Action = "Edit", IsAuditTrail = "", ls_UserId = "";
String[] ls_Lable = new String[2], ls_Data = new String[2];
Int32 li_ReturnValue = 0;
try
{
if (String.IsNullOrEmpty(ps_Code))
{
if (DALCommon.AutoCodeGeneration("SETUP_Bank") == 1)
{
ps_Code = DALCommon.GetMaximumCode("SETUP_Bank");
ls_Action = "Add";
}
}
if (!String.IsNullOrEmpty(ps_Code))
{
lrow_Bank.Bank_Id = ps_Code;
lrow_Bank.Bank_Code = ps_Code;
lrow_Bank.Bank_Title = Title;
//lrow_Bank.Loc_Id = Location;
lrow_Bank.Bank_Active = 1;
li_ReturnValue = objDalBank.SaveRecord(lrow_Bank);
ViewData["SaveResult"] = li_ReturnValue;
IsAuditTrail = System.Configuration.ConfigurationManager.AppSettings.GetValues("IsAuditTrail")[0];
// Save Audit Log
if (li_ReturnValue > 0 && IsAuditTrail == "1")
{
DALAuditLog objAuditLog = new DALAuditLog();
ls_UserId = ((SECURITY_User)Session["user"]).User_Id;
ls_Lable[0] = "Code";
ls_Lable[1] = "Title";
//ls_Lable[2] = "Location";
ls_Data[0] = ps_Code;
ls_Data[1] = Title;
//ls_Data[2] = Location;
objAuditLog.SaveRecord(11, ls_UserId, ls_Action, ls_Lable, ls_Data);
}
}
return PartialView("GridData");
}
catch
{
return PartialView("GridData");
}
}
