public List <Absence> getAllAbsence()
{
List <Absence> absences = new List <Absence>();
OleDbCommand cmd = DBConnection.getInstance.getDbCommand();
cmd.CommandText = "SELECT * FROM ABSENCE";
OleDbDataReader result = cmd.ExecuteReader();
if (result.HasRows)
{
while (result.Read())
{
Absence absence = new Absence();
absence.idAbsence = result.GetInt32(0);
absence.employee = employeeControl.getEmployee(result.GetInt32(1));
absence.startDate = result.GetDateTime(2);
absence.endDate = result.GetDateTime(3);
absence.justification = justificationControl.getJustification(result.GetInt32(4));
absences.Add(absence);
}
}
result.Close();
return(absences);
}
