public void GetLeave() { try { db = new LetranIntegratedSystemEntities(); opl = new List <OnProcessList>(); var x = db.GetHRiSLeaveOnProcess().ToList(); foreach (var i in x) { OnProcessList Olist = new OnProcessList(); Olist.LeaveID = i.LeaveID; Olist.EmployeeNo = i.EmployeeNo; Olist.EmployeeName = i.EmployeeName.ToUpper(); Olist.DateFiled = i.FiledDate.Value; Olist.StartDate = i.StartDate.Value; Olist.EndDate = i.EndDate.Value; Olist.Type = i.LeaveCode; Olist.Days = i.Days.Value; Olist.Status = i.Status; Olist.Reason = i.Reason; Olist.LeaveStatusID = i.LeaveApprovedStatusID.Value; if (i.FiledDate.Value.Date.AddDays(3) <= DateTime.Now.Date) { Olist.IsOverdue = true; } else { Olist.IsOverdue = false; } opl.Add(Olist); } dgOnProcess.ItemsSource = opl.OrderByDescending(m => m.DateFiled); } catch (Exception) { MessageBox.Show("Something went wrong!", "System Warning.", MessageBoxButton.OK, MessageBoxImage.Warning); } }