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); }