private PatientScoreRangeData GetData(PatientScoreRangeParameters parameters)
{
using (var connection = _connectionFactory.CreateConnection())
{
var reportDtos = connection.Query <PatientScoreRangeDto>(GetQuery(parameters)).ToList();
if (!reportDtos.Any())
{
return(null);
}
var returnData = new PatientScoreRangeData();
var data = reportDtos.Select(
reportDto => new PatientScoreRangeDataObject
{
Age = reportDto.PatientAge,
AssessmentDate = reportDto.ScoreDate.ToShortDateString(),
Change = reportDto.ScoreChange,
Gender = reportDto.PatientGender,
PatientName = reportDto.PatientFirstName + " " + reportDto.PatientLastName,
Score = reportDto.AssessmentScore,
PatientKey = reportDto.PatientKey,
AssessmentInstanceKey = reportDto.AssessmentInstanceKey,
AssessmentName = reportDto.AssessmentName
}).ToList();
returnData.Data = data;
return(returnData);
}
}
private void SetStrings(PatientScoreRangeData data, PatientScoreRangeParameters reportParams, string reportName)
{
if (reportParams == null || data == null)
{
return;
}
var start = reportParams.StartDate;
var end = reportParams.EndDate;
var dateRange = start.GetValueOrDefault().ToShortDateString() + " - " + end.GetValueOrDefault().ToShortDateString();
if (reportParams.TimePeriod != null)
{
reportParams.TimePeriod.GetRange(out start, out end);
dateRange = reportParams.TimePeriod.DisplayName;
}
var ageRange = _resourcesManager.GetResourceManagerByName(reportName).GetString("NA");
if (reportParams.AgeRangeLow != null && reportParams.AgeRangeHigh != null)
{
ageRange = reportParams.AgeRangeLow + " - " + reportParams.AgeRangeHigh;
}
var gender = _resourcesManager.GetResourceManagerByName(reportName).GetString("NA");
if (!string.IsNullOrWhiteSpace(reportParams.Gender))
{
gender = reportParams.Gender;
}
data.AssessmentParameter = _resourcesManager.GetResourceManagerByName(reportName).GetString("Assessment") + ": " + reportParams.AssessmentName;
data.DateRangeParameter = _resourcesManager.GetResourceManagerByName(reportName).GetString("DateRange") + ": " + dateRange;
data.RiskCategoryParameter = _resourcesManager.GetResourceManagerByName(reportName).GetString("RiskCategory") + ": " + GetScoreTypeValue(reportParams);
data.AgeGroupParameter = _resourcesManager.GetResourceManagerByName(reportName).GetString("AgeGroup") + ": " + ageRange;
data.GenderParameter = _resourcesManager.GetResourceManagerByName(reportName).GetString("Gender") + ": " + gender;
data.ReportName = _resourcesManager.GetResourceManagerByName(reportName).GetString("ReportName");
data.HeaderName = _resourcesManager.GetResourceManagerByName(reportName).GetString("HeaderName");
data.HeaderAge = _resourcesManager.GetResourceManagerByName(reportName).GetString("HeaderAge");
data.HeaderGender = _resourcesManager.GetResourceManagerByName(reportName).GetString("HeaderGender");
data.HeaderScore = _resourcesManager.GetResourceManagerByName(reportName).GetString("HeaderScore");
data.HeaderChart = _resourcesManager.GetResourceManagerByName(reportName).GetString("HeaderChart");
data.HeaderChange = _resourcesManager.GetResourceManagerByName(reportName).GetString("HeaderChange");
data.HeaderDate = _resourcesManager.GetResourceManagerByName(reportName).GetString("HeaderDate");
data.HeaderViewAssessment = _resourcesManager.GetResourceManagerByName(reportName).GetString("HeaderViewAssessment");
}
private XRTableRow GetHeaderRow(PatientScoreRangeData source)
{
var headerFont = new Font("Times New Roman", 13F);
var trHeader = new XRTableRow();
var tdNameHeader = new XRTableCell
{
Text = source.HeaderName,
CanGrow = true,
Borders = BorderSide.Bottom,
BorderWidth = 3,
BorderColor = Color.DarkGray,
TextAlignment = TextAlignment.BottomLeft,
Font = headerFont,
SizeF = new Size(NameHeaderWidth, Height),
};
trHeader.Cells.Add(tdNameHeader);
var tdAgeHeader = new XRTableCell
{
Text = source.HeaderAge,
CanGrow = true,
Borders = BorderSide.Bottom,
BorderWidth = 3,
BorderColor = Color.DarkGray,
TextAlignment = TextAlignment.BottomCenter,
Font = headerFont
};
trHeader.Cells.Add(tdAgeHeader);
var tdGenderHeader = new XRTableCell
{
Text = source.HeaderGender,
CanGrow = true,
Borders = BorderSide.Bottom,
BorderWidth = 3,
BorderColor = Color.DarkGray,
TextAlignment = TextAlignment.BottomCenter,
Font = headerFont
};
trHeader.Cells.Add(tdGenderHeader);
var tdScoreHeader = new XRTableCell
{
Text = source.HeaderScore,
CanGrow = true,
Borders = BorderSide.Bottom,
BorderWidth = 3,
BorderColor = Color.DarkGray,
TextAlignment = TextAlignment.BottomCenter,
Font = headerFont
};
trHeader.Cells.Add(tdScoreHeader);
var tdChangeHeader = new XRTableCell
{
Text = source.HeaderChange,
CanGrow = true,
Borders = BorderSide.Bottom,
BorderWidth = 3,
BorderColor = Color.DarkGray,
TextAlignment = TextAlignment.BottomCenter,
Font = headerFont
};
trHeader.Cells.Add(tdChangeHeader);
var tdDateHeader = new XRTableCell
{
Text = source.HeaderDate,
CanGrow = true,
Borders = BorderSide.Bottom,
BorderWidth = 3,
BorderColor = Color.DarkGray,
TextAlignment = TextAlignment.BottomLeft,
Font = headerFont
};
trHeader.Cells.Add(tdDateHeader);
var tdViewHeader = new XRTableCell
{
Text = source.HeaderViewAssessment,
CanGrow = true,
Borders = BorderSide.Bottom,
BorderWidth = 3,
BorderColor = Color.DarkGray,
TextAlignment = TextAlignment.BottomCenter,
Font = headerFont
};
trHeader.Cells.Add(tdViewHeader);
return(trHeader);
}