private void btnView_Click(object sender, RoutedEventArgs e) { try { db = new LetranIntegratedSystemEntities(); TList = new List <TransactionList>(); var query = db.GetHRiSLeaveTransactionReport().ToList(); foreach (var x in query) { TransactionList tl = new TransactionList(); tl.Days = x.Days.Value; tl.Designation = x.Designation; tl.EmployeeName = x.EmployeeName; tl.EmployeeNo = x.EmployeeNo; tl.EndDate = x.EndDate.Value; tl.FiledDate = x.FiledDate.Value; tl.RangeDate = x.RangeDate; tl.Reason = x.Reason; tl.StartDate = x.StartDate.Value; tl.Type = x.Type; TList.Add(tl); } if (rbSpecific.IsChecked == true) { if (!String.IsNullOrEmpty(dpEnd.Text) && !String.IsNullOrEmpty(dpStart.Text)) { DateTime StartDate = Convert.ToDateTime(dpStart.SelectedDate); DateTime EndDate = Convert.ToDateTime(dpEnd.SelectedDate); TList = TList.Where(m => m.StartDate >= StartDate && m.StartDate <= EndDate).ToList(); } else { MessageBox.Show("Date/s cannot be empty", "System Warning!", MessageBoxButton.OK, MessageBoxImage.Warning); return; } } if (rbToday.IsChecked == true) { TList = TList.Where(m => m.StartDate == DateTime.Now.Date).ToList(); } if (rbMonth.IsChecked == true) { TList = TList.Where(m => m.StartDate.Month == DateTime.Now.Month && m.StartDate.Year == DateTime.Now.Year).ToList(); } if (rbYear.IsChecked == true) { TList = TList.Where(m => m.StartDate.Year == DateTime.Now.Year).ToList(); } dgLeaveTransaction.ItemsSource = TList; } catch (Exception) { MessageBox.Show("Something went wrong.", "System Error!", MessageBoxButton.OK, MessageBoxImage.Error); } }