private void tsmiFileLoad_Click(object sender, EventArgs e)
{
//Build data table
dsEmpData.EmployeeDataTable dtEmployees = new dsEmpData.EmployeeDataTable();
dsEmpData.DeptartmentDataTable dtDept = new dsEmpData.DeptartmentDataTable();
//Make a table adapter
dsEmpDataTableAdapters.EmployeeTableAdapter taEmployees = new dsEmpDataTableAdapters.EmployeeTableAdapter();
dsEmpDataTableAdapters.DeptartmentTableAdapter taDept = new dsEmpDataTableAdapters.DeptartmentTableAdapter();
//Fill using table adapter
taEmployees.Fill(dtEmployees);
//Loop through all of the rows
foreach (dsEmpData.EmployeeRow dr in dtEmployees)
{
taDept.FillByID(dtDept, dr.DeptID);
StringBuilder sb = new StringBuilder();
foreach (dsEmpData.DeptartmentRow dr2 in dtDept)
{
//sb.Append(", ");
sb.Append(dr2.DeptName);
}
lbxEmployee.Items.Add($"EmpID={dr.EmpID}, FirstName{dr.FirstName}, LastName={dr.LastName}, Dept={sb.ToString()}, Type={dr.EmpType}");
}
}
private void enterPayrollDataToolStripMenuItem_Click(object sender, EventArgs e)
{
dsEmpData.EmployeeDataTable dtEmployees = new dsEmpData.EmployeeDataTable();
dsEmpDataTableAdapters.EmployeeTableAdapter taEmployees = new dsEmpDataTableAdapters.EmployeeTableAdapter();
taEmployees.Fill(dtEmployees);
foreach (dsEmpData.EmployeeRow dr in dtEmployees)
{
Department dept = new Department();
StringBuilder sb = new StringBuilder();
if (dr.EmpType == "Bonus")
{
fmPromptBonus bonus = new fmPromptBonus();
bonus.EmpID = dr.EmpID;
bonus.ShowDialog();
EmployeeBonus bonusEmp = new EmployeeBonus(dr.EmpID, dr.FirstName, dr.LastName, dr.Address, dept, Convert.ToDouble(dr.AnnualSalary));
bonusEmp.Bonus = bonus.Bonus / 100;
lbxPayData.Items.Add($"EmpID={dr.EmpID}, Bonus={bonus.Bonus:F2}%");
EmpList.Add(bonusEmp);
}
else if (dr.EmpType == "Hourly")
{
fmPromptHours hours = new fmPromptHours();
hours.EmpID = dr.EmpID;
hours.ShowDialog();
EmployeeHourly hourly = new EmployeeHourly(dr.EmpID, dr.FirstName, dr.LastName, dr.Address, dept, Convert.ToDouble(dr.HourlyRate));
hourly.Hours = hours.Hours;
lbxPayData.Items.Add($"EmpID={dr.EmpID}, Hours={hours.Hours}");
EmpList.Add(hourly);
}
else if (dr.EmpType == "Adjunct")
{
lbxPayData.Items.Add($"EmpID={dr.EmpID}");
EmpList.Add(new EmployeeAdjunct(dr.EmpID, dr.FirstName, dr.LastName, dr.Address, dept, Convert.ToDouble(dr.ContractAmount), dr.ContractWeeks));
}
else if (dr.EmpType == "Professor")
{
lbxPayData.Items.Add($"EmpID={dr.EmpID}");
EmpList.Add(new EmployeeProfessor(dr.EmpID, dr.FirstName, dr.LastName, dr.Address, dept, Convert.ToDouble(dr.AnnualSalary)));
}
}
}
