public Form5(object[] values, int UserId) { InitializeComponent(); GetEmployees = StaffInOutHistoryDAL.GetEmployeeHistories(int.Parse(values[0].ToString())); bindingSource = new BindingSource(GetEmployees, null); dataGridView1.DataSource = bindingSource; }
//retreives Employee history from stored procedure GetEmployeeHistories public static DatabaseDataSet.GetEmployeeHistoryDataTable GetEmployeeHistories(int staffId) { DatabaseDataSet.GetEmployeeHistoryDataTable getEmployeeHistories = new DatabaseDataSet.GetEmployeeHistoryDataTable(); using (Database.GetConnection()) { DatabaseDataSetTableAdapters.GetEmployeeHistoryTableAdapter getEmployeeHistoryTableAdapter = new DatabaseDataSetTableAdapters.GetEmployeeHistoryTableAdapter(); getEmployeeHistoryTableAdapter.Fill(getEmployeeHistories, staffId); } return(getEmployeeHistories); }
public static List <EmployeeHistory> GetEmployeeHistories(int id) { List <EmployeeHistory> employeeHistories = new List <EmployeeHistory>(); DatabaseDataSet.GetEmployeeHistoryDataTable getEmployeeHistories = StaffInOutHistoryDAL.GetEmployeeHistories(id); foreach (DatabaseDataSet.GetEmployeeHistoryRow item in getEmployeeHistories.Rows) { employeeHistories.Add(new EmployeeHistory(item.Nickname, item.Status_before_change, item.status_after_change, item.DateChanged, item.Status_change_by)); } return(employeeHistories); }