public int SaveRecord(SETUP_Calendar lrow_Calendar)
{
int li_ReturnValue = 0;
try
{
SCMSDataContext dbSCMS = Connection.Create();
SETUP_Calendar lRow_ExistingData = dbSCMS.SETUP_Calendars.Where(b => b.Cldr_Id.Equals(lrow_Calendar.Cldr_Id)).SingleOrDefault();
if (lRow_ExistingData != null)
{
lRow_ExistingData.Loc_Id = lrow_Calendar.Loc_Id;
lRow_ExistingData.Cmp_Id = lrow_Calendar.Cmp_Id;
lRow_ExistingData.Cldr_Title = lrow_Calendar.Cldr_Title;
lRow_ExistingData.Cldr_Prefix = lrow_Calendar.Cldr_Prefix;
lRow_ExistingData.Cldr_DateStart = lrow_Calendar.Cldr_DateStart;
lRow_ExistingData.Cldr_DateEnd = lrow_Calendar.Cldr_DateEnd;
lRow_ExistingData.CldrType_Id = lrow_Calendar.CldrType_Id;
}
else
{
dbSCMS.SETUP_Calendars.InsertOnSubmit(lrow_Calendar);
}
dbSCMS.SubmitChanges();
li_ReturnValue = Convert.ToInt32(lrow_Calendar.Cldr_Id);
}
catch
{
return 0;
}
return li_ReturnValue;
}
// Insertion
public ActionResult SaveRecord(String ps_Code, String CalenderType, String Prefix, String Title, DateTime SratrtDate, DateTime EndDate)
{
SETUP_Calendar lrow_Calendar = new SETUP_Calendar();
String ls_Action = "Delete", IsAuditTrail = "", ls_UserId = "";
String[] ls_Lable = new String[6], ls_Data = new String[6];
Int32 li_ReturnValue = 0;
// Get Company name show in list
List<SCMSDataLayer.DB.SETUP_CalendarType> ListCalendarType = new List<SCMSDataLayer.DB.SETUP_CalendarType>();
ListCalendarType = new SCMSDataLayer.DALCalendarType().GetAllRecords().ToList();
SCMSDataLayer.DB.SETUP_CalendarType CalendarTypeRow = ListCalendarType.Where(c => c.CldrType_Id.Equals(CalenderType)).SingleOrDefault();
try
{
if (String.IsNullOrEmpty(ps_Code))
{
if (DALCommon.AutoCodeGeneration("SETUP_Calendar") == 1)
{
ps_Code = DALCommon.GetMaximumCode("SETUP_Calendar");
ls_Action = "Add";
}
}
if (!String.IsNullOrEmpty(ps_Code))
{
lrow_Calendar.Cldr_Id = ps_Code;
lrow_Calendar.Cldr_Code = ps_Code;
lrow_Calendar.CldrType_Id = CalenderType;
lrow_Calendar.Cldr_Prefix = Prefix;
lrow_Calendar.Cldr_Title = Title;
lrow_Calendar.Cldr_DateStart = SratrtDate;
lrow_Calendar.Cldr_DateEnd = EndDate;
lrow_Calendar.CldrType_Level = CalendarTypeRow.CldrType_Level;
lrow_Calendar.Cldr_Active = 1;
li_ReturnValue = objDalCalendar.SaveRecord(lrow_Calendar);
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] = "Calendar Type";
ls_Lable[4] = "Start Date";
ls_Lable[5] = "End Date";
ls_Data[0] = ps_Code;
ls_Data[1] = Title;
ls_Data[2] = Prefix;
ls_Data[3] = CalenderType;
ls_Data[4] = SratrtDate.ToString("dd/MM/yyyy");
ls_Data[5] = EndDate.ToString("dd/MM/yyyy");
objAuditLog.SaveRecord(14, ls_UserId, ls_Action, ls_Lable, ls_Data);
}
// Audit Trail Section End
}
return PartialView("GridData");
}
catch
{
return PartialView("GridData");
}
}
