/// <summary>Get all employee tracking documents that are either expired or will expire within 30 days of today's date.</summary> /// <param name="schoolYearId">Indicates which school year to query</param> /// <param name="includeAssistant">Used to specify whether to include assistant therapists in the query</param> /// <param name="employeeId">EmployeeId to query for. If 0, include ALL records.</param> /// <param name="startDate">If not NULL, use a date range query</param> /// <param name="endDate">If not NULL, use a date range query</param> /// <returns>List of Expirations</returns> public List <Expiration> StaffExpirations(bool includeAssistant, int employeeId, int schoolYearId, DateTime?startDate, DateTime?endDate) { List <Expiration> result = new List <Expiration>(); try { DAL.Dashboard.StaffReminders dal = new DAL.Dashboard.StaffReminders(); System.Data.DataTable dt = dal.StaffExpirations(includeAssistant, employeeId, schoolYearId, startDate, endDate); if (dt != null && dt.Rows.Count != 0) { foreach (System.Data.DataRow dataRow in dt.Rows) { Expiration exp = new Expiration(); exp.EmployeeId = (int)dataRow["EmployeeId"]; exp.EmployeeName = dataRow["EmployeeName"].ToString().Trim(); exp.SupervisorId = (int)dataRow["SupervisorId"]; exp.SupervisorName = dataRow["SupervisorName"].ToString().Trim(); exp.ItemName = dataRow["ItemName"].ToString().Trim(); DateTime itemDueDate = DateTime.TryParse(dataRow["ItemDueDate"].ToString().Trim(), out itemDueDate) ? itemDueDate : DateTime.MinValue; exp.ExpirationDate = itemDueDate; TimeSpan difference = itemDueDate - DateTime.Today; exp.DaysToExpiration = difference.Days; result.Add(exp); } } dt = null; } catch (Exception ex) { throw; } return(result); }
/// <summary>Get all birthdays within 30 days of today's date.</summary> /// <returns>List of Birthdays</returns> public List <Birthday> StaffBirthdays() { List <Birthday> result = new List <Birthday>(); try { DAL.Dashboard.StaffReminders dal = new DAL.Dashboard.StaffReminders(); System.Data.DataTable dt = dal.StaffBirthdays(); if (dt != null && dt.Rows.Count != 0) { foreach (System.Data.DataRow dataRow in dt.Rows) { DateTime dob = DateTime.TryParse(dataRow["BirthDate"].ToString().Trim(), out dob) ? dob : DateTime.MinValue; string displayDate = dob.ToString("MM/dd"); Birthday bd = new Birthday() { EmployeeId = (int)dataRow["EmployeeId"], EmployeeName = dataRow["EmployeeName"].ToString().Trim(), StreetAddress = dataRow["StreetAddress"].ToString().Trim(), CSZ = dataRow["CSZ"].ToString().Trim(), DOB = dob, DisplayDate = displayDate }; result.Add(bd); } } dt = null; } catch (Exception ex) { throw; } return(result); }