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