public void RegressionTest_CvdHeartFailureBuilds()
{
PracticeProfileDataBuilder builder = new PracticeProfileDataBuilder(false)
{
AreaCode = AreaCodes.England,
GroupIds = new List<int> { GroupIds.PracticeProfiles_CvdHeartFailure },
AreaTypeId = AreaTypeIds.Ccg
};
var workBook = builder.BuildWorkbook();
Assert.AreEqual(4, workBook.Worksheets.Count);
}
public void TestMultipleGroupIds()
{
PracticeProfileDataBuilder builder = new PracticeProfileDataBuilder(false)
{
AreaCode = AreaCodes.England,
GroupIds = new List<int> { GroupIds.Diabetes_TreatmentTargets,
GroupIds.Diabetes_CareProcesses },
AreaTypeId = AreaTypeIds.Ccg
};
var workBook = builder.BuildWorkbook();
var cells = workBook.Worksheets[SheetNamePractice].Cells;
var parentAreaCode1 = cells[3, 1].Value;
var parentAreaCode2 = cells[4, 1].Value;
Assert.AreEqual(parentAreaCode1, parentAreaCode2);
}
public void TestAllSheetsAreCreatedForCountyUa()
{
PracticeProfileDataBuilder builder = new PracticeProfileDataBuilder(false)
{
AreaCode = AreaCodes.England,
GroupIds = new List<int>{GroupIds.PracticeProfiles_Cvd},
AreaTypeId = AreaTypeIds.CountyAndUnitaryAuthority
};
var workBook = builder.BuildWorkbook();
Assert.AreEqual(4, workBook.Worksheets.Count);
Assert.IsNotNull(workBook.Worksheets[SheetNamePractice]);
Assert.IsNotNull(workBook.Worksheets[SheetNameCountyUA]);
Assert.IsNotNull(workBook.Worksheets["Indicator Metadata"]);
Assert.IsNotNull(workBook.Worksheets["Practice Addresses"]);
}
public void Respond()
{
try
{
DataDownloadBespokeParameters parameters = new DataDownloadBespokeParameters(Context.Request.Params);
var fileInfo = new PracticeProfileFileInfo(parameters.ProfileKey,
parameters.GroupIds,
parameters.AreaCode);
byte[] bytes;
if (ApplicationConfiguration.UseFileCache && fileInfo.DoesFileExist)
{
bytes = File.ReadAllBytes(fileInfo.FilePath);
}
else
{
PracticeProfileDataBuilder builder = new PracticeProfileDataBuilder(UsePopulationData(parameters))
{
AreaCode = parameters.AreaCode,
GroupIds = parameters.GroupIds,
AreaTypeId = parameters.AreaTypeId
};
var workBook = builder.BuildWorkbook();
ExcelFileWriter writer = new ExcelFileWriter
{
UseFileCache = ApplicationConfiguration.UseFileCache
};
bytes = writer.Write(fileInfo, workBook);
}
var response = Context.Response;
ExportHelper.SetResponseAsExcelFile(response,
GetDataDownload.DownloadedFileName + "." + fileInfo.FileExtension);
response.BinaryWrite(bytes);
}
catch (Exception ex)
{
Context.Response.StatusCode = (int)HttpStatusCode.InternalServerError;
ExceptionLog.LogException(ex, Context.Request.Url.AbsoluteUri);
}
Context.Response.Flush();
}
private void WriteExcelFile(string profileKey, int groupId)
{
var builder = new PracticeProfileDataBuilder(UsePopulationData(profileKey))
{
AreaCode = AreaCodes.England,
GroupIds = new List<int> { groupId },
AreaTypeId = AreaTypeIds.Ccg
};
var workBook = builder.BuildWorkbook();
var fileInfo = new PracticeProfileFileInfo(profileKey,
new List<int> { groupId }, AreaCodes.England);
_excelFileWriter.Write(fileInfo, workBook);
}
