private void btnPrint_Click_1(object sender, RoutedEventArgs e) { Mouse.OverrideCursor = Cursors.Wait; if (dpStartDate.SelectedDate == null || dpEndDate.SelectedDate == null) { MessageBox.Show("Date fields cannot be empty.", "System Error!", MessageBoxButton.OK, MessageBoxImage.Error); Mouse.OverrideCursor = Cursors.Arrow; return; } if (rbDesignation.IsChecked == false && rbDepartment.IsChecked == false && rbEmployeeName.IsChecked == false) { MessageBox.Show("Date fields cannot be empty.", "System Error!", MessageBoxButton.OK, MessageBoxImage.Error); Mouse.OverrideCursor = Cursors.Arrow; return; } using (var db = new LetranIntegratedSystemEntities()) { var startDate = dpStartDate.SelectedDate.Value.ToShortDateString(); var endDate = dpEndDate.SelectedDate.Value.ToShortDateString(); var reporttype = cbReportType.Text; var empid = Convert.ToInt32(cbEmployee.SelectedValue); var deptid = Convert.ToInt32(cbDepartment.SelectedValue); var designationid = Convert.ToInt32(cbDesignation.SelectedValue); List <Model.Employee> employees = new List <Model.Employee>(); List <GetEmployeeDTR_Result> lresult = new List <GetEmployeeDTR_Result>(); var department = db.AcademicDepartments.Where(m => m.AcaDeptID == deptid).FirstOrDefault(); string dept; if (department == null) { dept = cbDesignation.Text; } else { dept = department.AcaDepartmentName; } if (rbDepartment.IsChecked == true) { employees = db.Employees.Where(m => m.EmployeeDepartmentID == deptid && m.EmployeeDepartmentID != null && m.bioid != null && m.Archive == false).ToList(); } else if (rbEmployeeName.IsChecked == true) { employees = db.Employees.Where(m => m.EmployeeID == empid).ToList(); } else if (rbDesignation.IsChecked == true) { employees = db.Employees.Where(m => m.EmployeeDesignation == designationid).ToList(); } if (reporttype == "DTR") { foreach (var emp in employees) { var qry = from a in db.GetEmployeeDTR(startDate, endDate, emp.bioid) select a; lresult.AddRange(qry); } Mouse.OverrideCursor = Cursors.Arrow; PrintWindow x = new PrintWindow(); x.rptid = 29; x.startDate = dpStartDate.SelectedDate.Value.ToString("MM/dd/yy"); x.endDate = dpEndDate.SelectedDate.Value.ToString("MM/dd/yy"); x.Report29 = lresult; x.ShowDialog(); } else if (reporttype == "Attendance Report") { foreach (var emp in employees) { var qry = from a in db.GetEmployeeDTR(startDate, endDate, emp.bioid) select a; lresult.AddRange(qry); } Mouse.OverrideCursor = Cursors.Arrow; PrintWindow x = new PrintWindow(); x.rptid = 30; x.startDate = dpStartDate.SelectedDate.Value.ToString("MM/dd/yy"); x.endDate = dpEndDate.SelectedDate.Value.ToString("MM/dd/yy"); x.department = dept; x.Report30 = lresult; x.ShowDialog(); } } }