public bool SubmitBooking(string username, DateTime startDate, DateTime endDate)
{
try
{
int staffID = (from s in db.Staffs
where s.UserID == username
select s.StaffID).FirstOrDefault();
HolidayCheck holiday = new HolidayCheck()
{
StaffID = staffID,
StartDate = startDate,
EndDate = endDate,
Pending = true,
Approved = false,
Cancel = false,
};
db.HolidayChecks.InsertOnSubmit(holiday);
db.SubmitChanges();
return(true);
}
catch (Exception e)
{
Console.WriteLine("Error in " + MethodBase.GetCurrentMethod().Name + "function \nError Message: " + e);
}
return(false);
}
private bool UpdateBooking(string username, DateTime startDate, DateTime endDate, bool approve)
{
try
{
// Get staff
int staffID = (from s in db.Staffs
where s.UserID == username
select s.StaffID).FirstOrDefault();
// Get holiday
HolidayCheck holiday = (from hc in db.HolidayChecks
where hc.StaffID == staffID && hc.StartDate == startDate && hc.EndDate == endDate
select hc).FirstOrDefault();
holiday.Pending = false;
holiday.Approved = approve;
db.SubmitChanges();
return(true);
}
catch (Exception e)
{
Console.WriteLine("Error in " + MethodBase.GetCurrentMethod().Name + "function \nError Message: " + e);
}
return(false);
}
