public int SaveVoucherType(SETUP_VoucherType newSetupVoucherType)
{
try
{
SCMSDataContext dbSCMS = Connection.Create();
SETUP_VoucherType existingSetupVoucherType = dbSCMS.SETUP_VoucherTypes.Where(c => c.VchrType_Id.Equals(newSetupVoucherType.VchrType_Id)).SingleOrDefault();
if (existingSetupVoucherType != null)
{
existingSetupVoucherType.VchrType_Title = newSetupVoucherType.VchrType_Title;
existingSetupVoucherType.VchrType_Prefix = newSetupVoucherType.VchrType_Prefix;
existingSetupVoucherType.VchrType_Active = newSetupVoucherType.VchrType_Active;
existingSetupVoucherType.VchrType_CodeInitialization = newSetupVoucherType.VchrType_CodeInitialization;
existingSetupVoucherType.VchrType_SortOrder = newSetupVoucherType.VchrType_SortOrder;
//existingSetupVoucherType.Loc_Id = newSetupVoucherType.Loc_Id;
existingSetupVoucherType.Cmp_Id = newSetupVoucherType.Cmp_Id;
}
else
{
dbSCMS.SETUP_VoucherTypes.InsertOnSubmit(newSetupVoucherType);
}
dbSCMS.SubmitChanges();
return Convert.ToInt32(newSetupVoucherType.VchrType_Id);
}
catch
{
return 0;
}
}
public ActionResult SaveVoucherType(String Code, String Title, String Prefix, int CodeInitilization)
{
SETUP_VoucherType setupVoucherTypeRow = new SETUP_VoucherType();
String ls_Action = "Delete", IsAuditTrail = "", ls_UserId = "";
String[] ls_Lable = new String[4], ls_Data = new String[4];
Int32 li_ReturnValue = 0;
try
{
if (String.IsNullOrEmpty(Code))
{
if (DALCommon.AutoCodeGeneration("SETUP_VoucherType") == 1)
{
Code = DALCommon.GetMaximumCode("SETUP_VoucherType");
ls_Action = "Add";
}
}
if (!String.IsNullOrEmpty(Code))
{
setupVoucherTypeRow.VchrType_Id = Code;
setupVoucherTypeRow.VchrType_Code = Code;
setupVoucherTypeRow.VchrType_Title = Title;
setupVoucherTypeRow.VchrType_Prefix = Prefix;
setupVoucherTypeRow.VchrType_CodeInitialization = CodeInitilization;
setupVoucherTypeRow.VchrType_SortOrder = 1;
setupVoucherTypeRow.VchrType_Active = 1;
li_ReturnValue = objDALVoucherType.SaveVoucherType(setupVoucherTypeRow);
ViewData["SaveResult"] = li_ReturnValue;
IsAuditTrail = System.Configuration.ConfigurationManager.AppSettings.GetValues("IsAuditTrail")[0];
// Audit Trail Entry Section
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] = "Prefix";
ls_Lable[3] = "Code Initialization";
ls_Data[0] = Code;
ls_Data[1] = Title;
ls_Data[2] = Prefix;
ls_Data[3] = CodeInitilization.ToString();
objAuditLog.SaveRecord(8, ls_UserId, ls_Action, ls_Lable, ls_Data);
}
// Audit Trail Section End
}
return PartialView("GridData");
}
catch
{
return PartialView("GridData");
}
}
