internal void UpdateFacility(Entities.Facility model)
{
Execute("[EPONS].[UpdateFacility]", new
{
facilityId = model.Id,
name = model.Name,
monthlyRate = model.MonthlyRate,
admissionTypeId = model.AdmissionTypeId
});
}
internal Entities.Facility FindById(Guid facilityId)
{
Entities.Facility facility = QueryOne <Entities.Facility>("[EPONS].[FindFacilityById]", new
{
facilityId = facilityId
});
facility.AdmissionTypes = Query <ValueObjects.ListItem>("[EPONS].[ListAdmissionTypes]", null);
return(facility);
}
internal void SaveFacility(Entities.Facility model)
{
Execute("[EPONS].[CreateFacility]", new
{
name = model.Name,
monthlyRate = model.MonthlyRate,
avatar = (byte[])null,
isFunder = model.IsFunder,
admissionTypeId = model.AdmissionTypeId
});
}
public DataTable FacilityPerformanceReportDataTable(Guid measurementToolId, DateTime startDate, DateTime endDate, Guid facilityId, List <Guid> medicalSchemeIds, out string facilityName)
{
Entities.Facility facility = _facilityRepository.FindById(facilityId);
facilityName = facility.Name;
string measurementToolName = _listRepository.GetMeasurementTools().Single(x => x.Id == measurementToolId).Name;
var data = FacilityPerformanceReportData(measurementToolId, startDate, endDate, facilityId, medicalSchemeIds);
DataTable dataTable = new DataTable();
for (int i = 0; i < 12; i++)
{
dataTable.Columns.Add("");
}
dataTable.Rows.Add("Facility Performance Report");
dataTable.Rows.Add(facilityName);
dataTable.Rows.Add(string.Format("{0} - {1}", startDate.ToString("dd MMMM yyyy"), endDate.ToString("dd MMMM yyyy")));
dataTable.Rows.Add(string.Format("Number of patients: {0}", data.Count == 0 ? "0" : data.First().Value["TotalPatients"]));
dataTable.Rows.Add(string.Format("Number of Completed Episodes of Care: {0}", data.Count == 0 ? "0" : data.First().Value["TotalEpisodesOfCare"]));
dataTable.Rows.Add(measurementToolName);
dataTable.Rows.Add(" ");
dataTable.Rows.Add(" ");
dataTable.Rows.Add("All columns display the average values, except \"Episodes of Care\" and \" % \"");
dataTable.Rows.Add("Gain = Discharge score minus Admission score");
dataTable.Rows.Add("LOS(days) = Length of Stay");
dataTable.Rows.Add("Efficience = Gain divided by LOS");
dataTable.Rows.Add("Onset Days = Number of days between Onset of episode and Admission to hospital");
dataTable.Rows.Add(" ");
dataTable.Rows.Add("Impairment Group", "Number of Completed Episodes of Care", "% of Total", "Age", "Admission Score", "Discharge Score", "Gain", "LOS(days)", "Efficiency", "Onset Days");
dataTable.Rows.Add(" ");
for (int i = 0; i < data.Keys.Count; i++)
{
Guid impairmentGroupId = data.Keys.ElementAt(i);
dataTable.Rows.Add(data[impairmentGroupId]["ImpairmentGroup"], data[impairmentGroupId]["NumberOfCompletedEpisodesOfCare"], Math.Round(Convert.ToDouble(data[impairmentGroupId]["Percentage"]), 2), Math.Round(Convert.ToDouble(data[impairmentGroupId]["Age"]), 2), data[impairmentGroupId]["AverageAdmitScore"], data[impairmentGroupId]["AverageDischargeScore"], data[impairmentGroupId]["Delta"], data[impairmentGroupId]["AverageLOS"], Math.Round(Convert.ToDouble(data[impairmentGroupId]["Effiency"]), 2), Math.Round(Convert.ToDouble(data[impairmentGroupId]["OnsetDays"]), 2));
}
return(dataTable);
}
public void Save(Entities.Facility model)
{
_facilityRepository.UpdateFacility(model);
}
public void Create(Entities.Facility model)
{
_facilityRepository.SaveFacility(model);
}
