internal static int AddPublicHoliday()
{
n = 0;
try
{
daPublicHoliday = new TblPublicHolidayTableAdapter();
dtPublicHoliday = new DsLiveOutlook.TblPublicHolidayDataTable();
drwPublicHoliday = dtPublicHoliday.NewTblPublicHolidayRow();
drwPublicHoliday.Day = PublicHolidayInfo.Day;
drwPublicHoliday.Month = PublicHolidayInfo.Month;
dtPublicHoliday.AddTblPublicHolidayRow(drwPublicHoliday);
n = daPublicHoliday.Update(dtPublicHoliday);
return(n);
}
catch (Exception ex)
{
Interactive.LInfoError(ex.Message, "Record was not saved !");
return(n);
}
}
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 GetAllPublicHolidays()
{
try
{
dt = new DataTable();
daPublicHoliday = new TblPublicHolidayTableAdapter();
dtPublicHoliday = new DsLiveOutlook.TblPublicHolidayDataTable();
daPublicHoliday.Fill(dtPublicHoliday);
dt = dtPublicHoliday;
}
catch (Exception ex)
{
Interactive.LInfoError("Could not load PublicHoliday Information\n" + ex.Message, "Database connection failure");
}
return(dt);
}
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);
}
