public SkillsServiceResponse ImportForSocs(string jobProfileSocs)
        {
            if (string.IsNullOrWhiteSpace(jobProfileSocs))
            {
                throw new ArgumentNullException(nameof(jobProfileSocs));
            }

            reportAuditRepository.CreateAudit(SummaryDetailsKey, $"Updating Job profiles for SOC(s) - {jobProfileSocs}");
            var startingNumber = skillsFrameworkService.GetSocMappingStatus();

            reportAuditRepository.CreateAudit(SummaryDetailsKey, $"Before Import  - SOCs awaiting import-{startingNumber.AwaitingUpdate} : SOCs completed-{startingNumber.UpdateCompleted} :  SOCs started but not completed-{startingNumber.SelectedForUpdate} ");

            var socs = jobProfileSocs.Split(',');

            reportAuditRepository.CreateAudit(SummaryDetailsKey, $"Importing {socs.Count()} SOC(s)");
            foreach (var soc in socs)
            {
                ImportForSingleSoc(soc.Trim());
            }

            var endingNumber = skillsFrameworkService.GetSocMappingStatus();

            reportAuditRepository.CreateAudit(SummaryDetailsKey, $"After Import  - SOCs awaiting import-{endingNumber.AwaitingUpdate} : SOCs completed-{endingNumber.UpdateCompleted} :  SOCs started but not completed-{endingNumber.SelectedForUpdate} ");
            return(new SkillsServiceResponse {
                Success = true
            });
        }
        public void GetSocMappingStatusTest()
        {
            // Arrange
            var dummySocMappingStatus = new SocMappingStatus {
                AwaitingUpdate = 1, SelectedForUpdate = 2, UpdateCompleted = 3
            };
            var skillsImportService = new SkillsFrameworkDataImportService(fakeSkillsFrameworkService, fakeFrameworkSkillRepository, fakeJobProfileSocCodeRepository, fakeJobProfileRepository, fakeSocSkillMatrixRepository, fakeReportAuditRepository);

            A.CallTo(() => fakeSkillsFrameworkService.GetSocMappingStatus()).Returns(dummySocMappingStatus);

            // Act
            var result = skillsImportService.GetSocMappingStatus();

            A.CallTo(() => fakeSkillsFrameworkService.GetSocMappingStatus()).MustHaveHappenedOnceExactly();
            result.Should().BeEquivalentTo(dummySocMappingStatus);
        }