public List<EmployeeVacation> GetAll() { EmployeeVacationDAC _employeeVacationComponent = new EmployeeVacationDAC(); IDataReader reader = _employeeVacationComponent.GetAllEmployeeVacation().CreateDataReader(); List<EmployeeVacation> _employeeVacationList = new List<EmployeeVacation>(); while(reader.Read()) { if(_employeeVacationList == null) _employeeVacationList = new List<EmployeeVacation>(); EmployeeVacation _employeeVacation = new EmployeeVacation(); if(reader["EmployeeVacationID"] != DBNull.Value) _employeeVacation.EmployeeVacationID = Convert.ToInt32(reader["EmployeeVacationID"]); if(reader["EmployeeID"] != DBNull.Value) _employeeVacation.EmployeeID = Convert.ToInt32(reader["EmployeeID"]); if(reader["VacationTypeID"] != DBNull.Value) _employeeVacation.VacationTypeID = Convert.ToInt32(reader["VacationTypeID"]); if(reader["StartDate"] != DBNull.Value) _employeeVacation.StartDate = Convert.ToDateTime(reader["StartDate"]); if(reader["EndDate"] != DBNull.Value) _employeeVacation.EndDate = Convert.ToDateTime(reader["EndDate"]); if(reader["DurationInDays"] != DBNull.Value) _employeeVacation.DurationInDays = Convert.ToInt32(reader["DurationInDays"]); if(reader["RequestDate"] != DBNull.Value) _employeeVacation.RequestDate = Convert.ToDateTime(reader["RequestDate"]); if(reader["ApprovalDate"] != DBNull.Value) _employeeVacation.ApprovalDate = Convert.ToDateTime(reader["ApprovalDate"]); if(reader["ApprovedBy"] != DBNull.Value) _employeeVacation.ApprovedBy = Convert.ToInt32(reader["ApprovedBy"]); _employeeVacation.NewRecord = false; _employeeVacationList.Add(_employeeVacation); } reader.Close(); return _employeeVacationList; }