private void btnView_Click(object sender, RoutedEventArgs e) { Mouse.OverrideCursor = Cursors.Wait; try { db = new LetranIntegratedSystemEntities(); LUList = new List <LeaveUsageList>(); DateTime startDate = Convert.ToDateTime(dpStart.SelectedDate); DateTime endDate = Convert.ToDateTime(dpEnd.SelectedDate); if (!String.IsNullOrEmpty(dpStart.Text) && !String.IsNullOrEmpty(dpEnd.Text)) { var query = db.GetHRiSLeaveUsage(startDate, endDate).ToList(); foreach (var x in query) { LeaveUsageList lul = new LeaveUsageList(); lul.EmployeeID = x.EmployeeID; lul.EmployeeNumber = x.EmployeeNo; lul.EmployeeName = x.EmployeeName.ToUpper(); lul.Department = x.Department; lul.Designation = x.Designation; lul.DesignationID = x.EmployeeDesignationID; lul.SL = x.SL.HasValue ? x.SL.Value : 0; lul.SIL = x.SIL.HasValue ? x.SIL.Value : 0; lul.VL = x.VL.HasValue ? x.VL.Value : 0; LUList.Add(lul); } if (rbAll.IsChecked == true) { LUList = LUList.ToList(); } if (rbAdmin.IsChecked == true) { LUList = LUList.Where(m => m.DesignationID == 1).ToList(); } if (rbFaculty.IsChecked == true) { LUList = LUList.Where(m => m.DesignationID == 2).ToList(); } if (rbNT.IsChecked == true) { LUList = LUList.Where(m => m.DesignationID == 3).ToList(); } dgLeaveUsage.ItemsSource = LUList; } else { MessageBox.Show("Date/s cannot be empty.", "System Warning!", MessageBoxButton.OK, MessageBoxImage.Warning); } } catch (Exception) { MessageBox.Show("Something went wrong!", "System Error!", MessageBoxButton.OK, MessageBoxImage.Error); } Mouse.OverrideCursor = null; }