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