//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); }