public void GetEmployeeHistory()
{
try
{
using (var db = new LetranIntegratedSystemEntities())
{
lEmployeeHistoryList = new List <EmployeHistoryList>();
var emphistory = db.EmployeeHistories.ToList();
foreach (var x in emphistory)
{
EmployeHistoryList eh = new EmployeHistoryList();
var emp = db.Employees.Where(m => m.EmployeeID == x.EmployeeID).FirstOrDefault();
var dep = db.AcademicDepartments.Where(m => m.AcaDeptID == x.DepartmentID).FirstOrDefault();
var pos = db.EmployeePositions.Where(m => m.EmployeePositionID == x.EmployeePositionID).FirstOrDefault();
eh.EmployeeName = emp.LastName + ", " + emp.FirstName;
eh.EmployeeNo = emp.EmployeeNo;
eh.Remark = x.Remark;
eh.Department = dep.AcaAcronym;
eh.Position = pos.EmployeePositionName;
eh.StartDate = x.StartDate.Value.Date;
eh.EndDate = x.EndDate.Value.Date;
lEmployeeHistoryList.Add(eh);
}
dgEmployeeHistory.ItemsSource = lEmployeeHistoryList.OrderBy(m => m.EmployeeName);
}
}
catch (Exception)
{
throw;
}
}
private void btnSearch_Click(object sender, RoutedEventArgs e)
{
try
{
using (var db = new LetranIntegratedSystemEntities())
{
lEmployeeHistoryList = new List <EmployeHistoryList>();
var emphistory = db.EmployeeHistories.ToList();
foreach (var x in emphistory)
{
EmployeHistoryList eh = new EmployeHistoryList();
var emp = db.Employees.Where(m => m.EmployeeID == x.EmployeeID).FirstOrDefault();
var dep = db.AcademicDepartments.Where(m => m.AcaDeptID == x.DepartmentID).FirstOrDefault();
var pos = db.EmployeePositions.Where(m => m.EmployeePositionID == x.EmployeePositionID).FirstOrDefault();
eh.EmployeeName = emp.LastName + ", " + emp.FirstName;
eh.EmployeeNo = emp.EmployeeNo;
eh.Remark = x.Remark;
eh.Department = dep.AcaAcronym;
eh.Position = pos.EmployeePositionName;
eh.StartDate = x.StartDate.Value.Date;
eh.EndDate = x.EndDate.Value.Date;
lEmployeeHistoryList.Add(eh);
}
if (rbEmpname.IsChecked == true)
{
lEmployeeHistoryList = lEmployeeHistoryList.Where(m => m.EmployeeName.Contains(txtSearch.Text)).ToList();
}
else if (rbEmpn.IsChecked == true)
{
lEmployeeHistoryList = lEmployeeHistoryList.Where(m => m.EmployeeNo.Contains(txtSearch.Text)).ToList();
}
dgEmployeeHistory.ItemsSource = lEmployeeHistoryList.OrderBy(m => m.EmployeeName);
}
}
catch (Exception)
{
throw;
}
}