public static DatabaseDataSet.GetEmployeeListDataTable getEmployeeList()
{
DatabaseDataSet.GetEmployeeListDataTable getEmployeeDetails = new DatabaseDataSet.GetEmployeeListDataTable();
DatabaseDataSetTableAdapters.GetEmployeeListTableAdapter getEmployeeDetailsTableAdapter = new DatabaseDataSetTableAdapters.GetEmployeeListTableAdapter();
getEmployeeDetailsTableAdapter.Fill(getEmployeeDetails);
return(getEmployeeDetails);
}
private void btnLogin_Click(object sender, EventArgs e)
{
DatabaseDataSet.GetEmployeeListDataTable getEmployeeListRows = StaffDAL.getEmployeeList();
foreach (DatabaseDataSet.GetEmployeeListRow item in getEmployeeListRows.Rows)
{
if (item.Username == txtUsername.Text)
{
Form1 form = new Form1(item.StaffID);
form.Show();
this.Hide();
}
}
}
public static void ExportReports()
{
try
{
using (StreamWriter writer = new StreamWriter("E:\\Projects\\EmployeeStatusTest\\EmployeeStatusTest\\Reports\\Report.csv"))
{
DatabaseDataSet.GetEmployeeListDataTable GetEmployees = StaffDAL.getEmployeeList();
writer.WriteLine("StaffID|FirstName|LastName|Username|Nickname|FlagDeleted|Extension|Status");
foreach (var item in GetEmployees)
{
writer.WriteLine(item.StaffID + "|" + item.Firstname + "|" + item.Lastname + "|" + item.Username + "|" + item.Nickname + "|" + item.FlagDeleted + "|" + item.TelephoneExtension + "|" + item.Description);
}
}
}
catch (Exception)
{
}
}
public static List <Staff> GetStaffs()
{
List <Staff> staffs = new List <Staff>();
DatabaseDataSet.GetEmployeeListDataTable getEmployee = StaffDAL.getEmployeeList();
foreach (DatabaseDataSet.GetEmployeeListRow item in getEmployee.Rows)
{
if (item.ManagerID == null)
{
staffs.Add(new Staff(item.StaffID, item.Lastname, item.Firstname, item.Nickname, item.Username, item.InOutStatusID, item.TelephoneExtension, item.FlagDeleted));
}
else
{
staffs.Add(new Staff(item.StaffID, item.Lastname, item.Firstname, item.Nickname, item.Username, item.InOutStatusID, item.TelephoneExtension, item.FlagDeleted, item.ManagerID));
}
}
return(staffs);
}
