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