internal static int UpdatePublicHoliday() { n = 0; try { daPublicHoliday = new TblPublicHolidayTableAdapter(); dtPublicHoliday = new DsLiveOutlook.TblPublicHolidayDataTable(); daPublicHoliday.FillByID(dtPublicHoliday, PublicHolidayInfo.Day, PublicHolidayInfo.Month); drwPublicHoliday = dtPublicHoliday[0]; drwPublicHoliday.BeginEdit(); drwPublicHoliday.Day = PublicHolidayInfo.NewDay; drwPublicHoliday.Month = PublicHolidayInfo.NewMonth; drwPublicHoliday.EndEdit(); n = daPublicHoliday.Update(dtPublicHoliday); return(n); } catch (Exception ex) { Interactive.LInfoError(ex.Message, "Record was not saved !"); return(n); } }
internal static DataTable GetAllPublicHolidaysByID() { try { PublicHolidayInfo.Recs = false; dt = new DataTable(); daPublicHoliday = new TblPublicHolidayTableAdapter(); dtPublicHoliday = new DsLiveOutlook.TblPublicHolidayDataTable(); daPublicHoliday.FillByID(dtPublicHoliday, PublicHolidayInfo.Day, PublicHolidayInfo.Month); dt = dtPublicHoliday; if (dt.Rows.Count > 0) { PublicHolidayInfo.Recs = true; } } catch (Exception ex) { Interactive.LInfoError("Could not load PublicHoliday Information\n" + ex.Message, "Database connection failure"); } return(dt); }