public void GetAllDelegatesFileForCentre_returns_expected_excel_data() { // TODO: HEEDLS-810 - run the formatter once review complete. // Given const int centreId = 2; var centreRegistrationPrompts = new List <CentreRegistrationPrompt> { new CentreRegistrationPrompt(RegistrationField.CentreRegistrationField1, 1, "Role type", null, true), new CentreRegistrationPrompt(RegistrationField.CentreRegistrationField2, 2, "Manager", null, true), new CentreRegistrationPrompt(RegistrationField.CentreRegistrationField3, 3, "Base / office / place of work", null, true), new CentreRegistrationPrompt(RegistrationField.CentreRegistrationField4, 4, "Base / office / place of work", null, true), new CentreRegistrationPrompt(RegistrationField.CentreRegistrationField5, 5, "Contact telephone number", null, true), }; A.CallTo(() => centreRegistrationPromptsService.GetCentreRegistrationPromptsByCentreId(centreId)) .Returns(new CentreRegistrationPrompts(centreId, centreRegistrationPrompts)); A.CallTo(() => userDataService.GetDelegateUserCardsByCentreId(2)).Returns(delegateUserCards); // When var resultBytes = delegateDownloadFileService.GetAllDelegatesFileForCentre(2, null, null, GenericSortingHelper.Ascending, null); using var resultsStream = new MemoryStream(resultBytes); using var resultWorkbook = new XLWorkbook(resultsStream); // Then using var expectedWorkbook = new XLWorkbook( TestContext.CurrentContext.TestDirectory + TestAllDelegatesExportRelativeFilePath ); SpreadsheetTestHelper.AssertSpreadsheetsAreEquivalent(expectedWorkbook, resultWorkbook); }
public void GetEvaluationSummaryFileForCentre_returns_expected_excel_data() { // Given using var expectedWorkbook = new XLWorkbook( TestContext.CurrentContext.TestDirectory + EvaluationSummaryDownloadRelativeFilePath ); GivenEvaluationSummaryDataServiceReturnsDataInExampleSheet(); var filterData = new ActivityFilterData( DateTime.Parse("2020-9-1"), DateTime.Parse("2021-9-1"), null, null, null, CourseFilterType.None, ReportInterval.Months ); // When var resultBytes = evaluationSummaryService.GetEvaluationSummaryFileForCentre(101, filterData); using var resultsStream = new MemoryStream(resultBytes); using var resultWorkbook = new XLWorkbook(resultsStream); // Then SpreadsheetTestHelper.AssertSpreadsheetsAreEquivalent(expectedWorkbook, resultWorkbook); }
public void GetCourseDelegateDownloadFile_returns_expected_excel_data() { // Given const int categoryId = 1; const int centreId = 1; using var expectedWorkbook = new XLWorkbook( TestContext.CurrentContext.TestDirectory + CourseDelegateExportAllDataDownloadRelativeFilePath ); A.CallTo(() => courseService.GetCentreCourseDetailsWithAllCentreCourses(centreId, categoryId)).Returns( new CentreCourseDetails { Courses = new[] { new CourseStatisticsWithAdminFieldResponseCounts { ApplicationName = "Course One", CustomisationName = "v1", CustomisationId = 1 }, new CourseStatisticsWithAdminFieldResponseCounts { ApplicationName = "Course Two", CustomisationName = "v1", CustomisationId = 2 }, }, } ); A.CallTo(() => courseDataService.GetDelegatesOnCourseForExport(1, centreId)) .Returns(courseDelegates.Where(c => c.ApplicationName == "Course One")); A.CallTo(() => courseDataService.GetDelegatesOnCourseForExport(2, centreId)) .Returns(courseDelegates.Where(c => c.ApplicationName == "Course Two")); var centreRegistrationPrompts = new List <CentreRegistrationPrompt> { new CentreRegistrationPrompt(1, 1, "Role type", null, true), new CentreRegistrationPrompt(2, 2, "Manager", null, true), new CentreRegistrationPrompt(3, 3, "Base / office / place of work", null, true), new CentreRegistrationPrompt(4, 4, "Base / office / place of work", null, true), new CentreRegistrationPrompt(5, 5, "Contact telephone number", null, true), }; A.CallTo(() => registrationPromptsService.GetCentreRegistrationPromptsByCentreId(centreId)) .Returns(new CentreRegistrationPrompts(centreId, centreRegistrationPrompts)); // When var resultBytes = courseDelegatesDownloadFileService.GetCourseDelegateDownloadFile( centreId, categoryId, null, null, null ); using var resultsStream = new MemoryStream(resultBytes); using var resultWorkbook = new XLWorkbook(resultsStream); // Then SpreadsheetTestHelper.AssertSpreadsheetsAreEquivalent(expectedWorkbook, resultWorkbook); }
public void GetDelegatesAndJobGroupDownloadFileForCentre_returns_expected_excel_data() { // Given A.CallTo(() => jobGroupsDataService.GetJobGroupsAlphabetical()).Returns( JobGroupsTestHelper.GetDefaultJobGroupsAlphabetical() ); A.CallTo(() => userDataService.GetDelegateUserCardsByCentreId(2)).Returns(delegateUserCards); // When var resultBytes = delegateDownloadFileService.GetDelegatesAndJobGroupDownloadFileForCentre(2); using var resultsStream = new MemoryStream(resultBytes); using var resultWorkbook = new XLWorkbook(resultsStream); // Then using var expectedWorkbook = new XLWorkbook( TestContext.CurrentContext.TestDirectory + DelegateUploadFileServiceTests.TestDelegateUploadRelativeFilePath ); SpreadsheetTestHelper.AssertSpreadsheetsAreEquivalent(expectedWorkbook, resultWorkbook); }