//Question 2.1
public static DatabaseDataSet.InOutStatusDataTable GetEmployeeList()
{
DatabaseDataSet.InOutStatusDataTable inOutStatusDataTable = new DatabaseDataSet.InOutStatusDataTable();
using (Database.GetConnection())
{
DatabaseDataSetTableAdapters.InOutStatusTableAdapter getEmployeeListTableAdapter = new DatabaseDataSetTableAdapters.InOutStatusTableAdapter();
getEmployeeListTableAdapter.Fill(inOutStatusDataTable);
}
return(inOutStatusDataTable);
}
public static List <InOutStatus> GetStatuses()
{
List <InOutStatus> statuses = new List <InOutStatus>();
DatabaseDataSet.InOutStatusDataTable inOutStatusRows = InOutStatusDAL.GetEmployeeList();
foreach (DatabaseDataSet.InOutStatusRow item in inOutStatusRows.Rows)
{
statuses.Add(new InOutStatus(item.InOutStatusID, item.Description));
}
return(statuses);
}
