/// <summary>Get active clients not assigned a physician.</summary>
/// <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>
/// <returns>List of MissingPhysicians</returns>
public List <MissingPhysician> MissingPhysicians(bool includeAssistant, int employeeId)
{
List <MissingPhysician> result = new List <MissingPhysician>();
try
{
DAL.Dashboard.ClientDocuments dal = new DAL.Dashboard.ClientDocuments();
System.Data.DataTable dt = dal.MissingPhysicians(includeAssistant, employeeId);
if (dt != null && dt.Rows.Count != 0)
{
foreach (System.Data.DataRow dataRow in dt.Rows)
{
MissingPhysician md = new MissingPhysician()
{
ClientId = (int)dataRow["ClientId"],
Client = dataRow["Client"].ToString().Trim(),
ParentName = dataRow["ParentName"].ToString().Trim(),
ParentPhoneNumber = dataRow["ParentPhone"].ToString().Trim()
};
result.Add(md);
}
}
dt = null;
}
catch (Exception ex)
{
throw;
}
return(result);
}
/// <summary>Get all outstanding RX and Physician documents.</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 MissingDocuments</returns>
public List <MissingClientDocument> MissingRXDocuments(bool includeAssistant, int employeeId, int schoolYearId,
DateTime?startDate, DateTime?endDate)
{
List <MissingClientDocument> result = new List <MissingClientDocument>();
try
{
DAL.Dashboard.ClientDocuments dal = new DAL.Dashboard.ClientDocuments();
System.Data.DataTable dt = dal.MissingRXDocuments(includeAssistant, employeeId, schoolYearId, startDate,
endDate);
if (dt != null && dt.Rows.Count != 0)
{
foreach (System.Data.DataRow dataRow in dt.Rows)
{
MissingClientDocument md = new MissingClientDocument()
{
SchoolYearId = (int)dataRow["SchoolYearId"],
ClientDocTrackId = (int)dataRow["ClientDocTrackId"],
ClientId = (int)dataRow["ClientId"],
PhysicianId = (int)dataRow["PhysicianId"],
DocumentTemplateId = (int)dataRow["DocumentTemplateId"],
DocStylesId = (int)dataRow["DocStylesId"],
TherapistId = (int)dataRow["TherapistId"],
SupervisorId = (int)dataRow["SupervisorId"],
ReceiveDate =
DBNull.Value.Equals(dataRow["ReceiveDate"])
? new DateTime(1901, 1, 1)
: Convert.ToDateTime(dataRow["ReceiveDate"]),
SentDate =
DBNull.Value.Equals(dataRow["SentDate"])
? new DateTime(1901, 1, 1)
: Convert.ToDateTime(dataRow["SentDate"]),
Client = dataRow["Client"].ToString().Trim(),
SchoolYearName = dataRow["SchoolYearName"].ToString().Trim(),
Physician = dataRow["Physician"].ToString().Trim(),
DocumentName = dataRow["DocumentName"].ToString().Trim(),
PhysicianPhone = dataRow["PhysicianPhone"].ToString().Trim(),
ParentName = dataRow["ParentName"].ToString().Trim(),
ParentPhoneNumber = dataRow["ParentPhone"].ToString().Trim()
};
result.Add(md);
}
}
dt = null;
// TODO: Must handle situation where client has multiple therapists under same CYS as SY //
}
catch (Exception ex)
{
throw;
}
return(result);
}
