private void PopulateJobGroupsSheet(IXLWorkbook workbook) { var jobGroups = jobGroupsDataService.GetJobGroupsAlphabetical() .OrderBy(x => x.id) .Select( item => new { JobGroupID = item.id, JobGroupName = item.name } ); AddSheetToWorkbook(workbook, JobGroupsSheetName, jobGroups); }
private void PopulateLearnerInformationExtraFields( LearnerInformationViewModel model, RegistrationData data ) { model.CustomFields = GetEditCustomFieldsFromModel(model, data.Centre !.Value); model.JobGroupOptions = SelectListHelper.MapOptionsToSelectListItems( jobGroupsDataService.GetJobGroupsAlphabetical(), model.JobGroup ); }
internal BulkUploadResult ProcessDelegatesTable(IXLTable table, int centreId, DateTime?welcomeEmailDate = null) { var jobGroupIds = jobGroupsDataService.GetJobGroupsAlphabetical().Select(item => item.id).ToList(); var delegateRows = table.Rows().Skip(1).Select(row => new DelegateTableRow(table, row)).ToList(); foreach (var delegateRow in delegateRows) { ProcessDelegateRow(centreId, welcomeEmailDate, delegateRow, jobGroupIds); } return(new BulkUploadResult(delegateRows)); }
public IActionResult Index( int page = 1, string?searchString = null, string?sortBy = null, string sortDirection = BaseSearchablePageViewModel.Ascending, string?filterBy = null, string?filterValue = null ) { sortBy ??= DefaultSortByOptions.Name.PropertyName; filterBy = FilteringHelper.GetFilterBy( filterBy, filterValue, Request, DelegateFilterCookieName, DelegateActiveStatusFilterOptions.IsActive.FilterValue ); var centreId = User.GetCentreId(); var jobGroups = jobGroupsDataService.GetJobGroupsAlphabetical(); var customPrompts = centreCustomPromptHelper.GetCustomPromptsForCentre(centreId); var delegateUsers = userDataService.GetDelegateUserCardsByCentreId(centreId); var model = new AllDelegatesViewModel( delegateUsers, jobGroups, customPrompts, page, searchString, sortBy, sortDirection, filterBy ); Response.UpdateOrDeleteFilterCookie(DelegateFilterCookieName, filterBy); return(View(model)); }
public IActionResult Index( string?filterBy = null, string?filterValue = null, bool selectAll = false ) { var newFilterBy = FilteringHelper.GetFilterBy(filterBy, filterValue, Request, EmailDelegateFilterCookieName); var jobGroups = jobGroupsDataService.GetJobGroupsAlphabetical(); var customPrompts = centreCustomPromptHelper.GetCustomPromptsForCentre(User.GetCentreId()); var delegateUsers = GetDelegateUserCards(); var model = new EmailDelegatesViewModel( delegateUsers, jobGroups, customPrompts, newFilterBy, selectAll ); Response.UpdateOrDeleteFilterCookie(EmailDelegateFilterCookieName, newFilterBy); return(View(model)); }
public IActionResult EditDetails(DlsSubApplication dlsSubApplication) { var userAdminId = User.GetAdminId(); var userDelegateId = User.GetCandidateId(); var(adminUser, delegateUser) = userService.GetUsersById(userAdminId, userDelegateId); var jobGroups = jobGroupsDataService.GetJobGroupsAlphabetical().ToList(); var customPrompts = promptsService.GetEditDelegateRegistrationPromptViewModelsForCentre(delegateUser, User.GetCentreId()); var model = new MyAccountEditDetailsViewModel( adminUser, delegateUser, jobGroups, customPrompts, dlsSubApplication ); return(View(model)); }
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); }
GenerateGroupsFromRegistrationField_calls_data_service_methods_with_correct_values_for_job_group() { // Given const string groupName = "Nursing"; const int jobGroupId = 1; var timeNow = DateTime.UtcNow; var jobGroups = new List <(int id, string name)> { (jobGroupId, groupName) }; var registrationField = RegistrationField.JobGroup; var groupGenerationDetails = new GroupGenerationDetails( 1, 101, registrationField, false, true, false, true, true ); A.CallTo(() => jobGroupsDataService.GetJobGroupsAlphabetical()).Returns(jobGroups); SetUpGenerateGroupFakes(timeNow); // When groupsService.GenerateGroupsFromRegistrationField(groupGenerationDetails); // Then AssertCorrectMethodsAreCalledForGenerateGroups( groupGenerationDetails, timeNow, registrationField.LinkedToFieldId, groupName, groupName, jobGroupId ); }
public IEnumerable <(int, string)> GetJobGroupsAlphabetical() { return(jobGroupsDataService.GetJobGroupsAlphabetical()); }