public bool AddAbsence(vwAbsence absence)
{
try
{
using (DAN_LIIIEntities context = new DAN_LIIIEntities())
{
tblAbsence newAbsence = new tblAbsence
{
FirstDay = absence.FirstDay,
LastDay = absence.LastDay,
StatusRequest = "on hold",
Reason = absence.Reason,
UserID = absence.UserID
};
context.tblAbsences.Add(newAbsence);
context.SaveChanges();
return(true);
}
}
catch (Exception ex)
{
Debug.WriteLine("Exception" + ex.Message.ToString());
return(false);
}
}
public void addAbsence(int idStudent)
{
tblAbsence abs = new tblAbsence()
{
idStudent = idStudent,
date = DateTime.Now.Date,
day1 = false,
day2 = false,
day3 = false,
day4 = false,
day5 = false,
day6 = false,
day7 = false,
day8 = false,
day9 = false,
day10 = false,
day11 = false,
day12 = false,
day13 = false,
day14 = false,
paid = false,
exam = 0,
};
db.tblAbsences.Add(abs);
db.SaveChanges();
}
public bool RejectRequest(vwAbsence request)
{
try
{
using (DAN_LIIIEntities context = new DAN_LIIIEntities())
{
tblAbsence requestToReject = context.tblAbsences.Where(x => x.AbsenceID == request.AbsenceID).FirstOrDefault();
requestToReject.StatusRequest = "rejected";
context.SaveChanges();
return(true);
}
}
catch (Exception ex)
{
Debug.WriteLine("Exception" + ex.Message.ToString());
return(false);
}
}
