private async Task <IList <SummaryOfFm35FundingModel> > GetSummaryOfFm35FundingModels(IReportServiceContext reportServiceContext, CancellationToken cancellationToken)
{
Task <FM35Global> fm35Task = _fm35ProviderService.GetFM35Data(reportServiceContext, cancellationToken);
await Task.WhenAll(fm35Task);
cancellationToken.ThrowIfCancellationRequested();
List <SummaryOfFm35FundingModel> summaryOfFm35FundingModels = new List <SummaryOfFm35FundingModel>();
FM35Global fm35Data = fm35Task.Result;
if (fm35Data?.Learners == null)
{
_logger.LogWarning($"No Fm35 data for {nameof(SummaryOfFm35FundingReport)}");
return(summaryOfFm35FundingModels);
}
foreach (FM35Learner learnerAttribute in fm35Data.Learners)
{
foreach (LearningDelivery fundLineData in learnerAttribute.LearningDeliveries)
{
summaryOfFm35FundingModels.AddRange(_summaryOfFm35FundingModelBuilder.BuildModel(fundLineData));
}
}
summaryOfFm35FundingModels.Sort(comparer);
return(summaryOfFm35FundingModels);
}
public async Task GenerateReport(IReportServiceContext reportServiceContext, ZipArchive archive, bool isFis, CancellationToken cancellationToken)
{
Task <IMessage> ilrFileTask = _ilrProviderService.GetIlrFile(reportServiceContext, cancellationToken);
Task <FM25Global> fm25Task = _fm25ProviderService.GetFM25Data(reportServiceContext, cancellationToken);
Task <FM35Global> fm35Task = _fm35ProviderService.GetFM35Data(reportServiceContext, cancellationToken);
Task <List <string> > validLearnersTask = _validLearnersService.GetLearnersAsync(reportServiceContext, cancellationToken);
await Task.WhenAll(ilrFileTask, fm25Task, fm35Task, validLearnersTask);
if (cancellationToken.IsCancellationRequested)
{
return;
}
List <ILearner> learners =
ilrFileTask.Result?.Learners?.Where(x => validLearnersTask.Result.Contains(x.LearnRefNumber)).ToList();
if (learners == null)
{
_logger.LogWarning("Failed to get learners for Main Occupancy Report");
return;
}
string[] learnAimRefs = learners.SelectMany(x => x.LearningDeliveries).Select(x => x.LearnAimRef).Distinct().ToArray();
Task <Dictionary <string, LarsLearningDelivery> > larsLearningDeliveriesTask = _larsProviderService.GetLearningDeliveriesAsync(learnAimRefs, cancellationToken);
Task <List <LearnerAndDeliveries> > larsFrameworkAimsTask = _larsProviderService.GetFrameworkAimsAsync(learnAimRefs, learners, cancellationToken);
await Task.WhenAll(larsLearningDeliveriesTask, larsFrameworkAimsTask);
if (larsLearningDeliveriesTask.Result == null || larsFrameworkAimsTask.Result == null)
{
_logger.LogWarning("Failed to get LARS data for Main Occupancy Report");
return;
}
if (cancellationToken.IsCancellationRequested)
{
return;
}
List <string> larsErrors = new List <string>();
List <MainOccupancyModel> mainOccupancyModels = new List <MainOccupancyModel>();
foreach (var learner in learners)
{
if (learner.LearningDeliveries == null)
{
continue;
}
FM25Global fm25Data = fm25Task.Result;
FM35Global fm35Data = fm35Task.Result;
foreach (ILearningDelivery learningDelivery in learner.LearningDeliveries)
{
if (!CheckIsApplicableLearner(learningDelivery))
{
continue;
}
if (!larsLearningDeliveriesTask.Result.TryGetValue(learningDelivery.LearnAimRef, out LarsLearningDelivery larsModel))
{
larsErrors.Add(learningDelivery.LearnAimRef);
continue;
}
LearningDelivery frameworkAim = larsFrameworkAimsTask.Result?.SingleOrDefault(x => string.Equals(x.LearnerLearnRefNumber, learner.LearnRefNumber, StringComparison.OrdinalIgnoreCase))
?.LearningDeliveries?.SingleOrDefault(x => string.Equals(x.LearningDeliveryLearnAimRef, learningDelivery.LearnAimRef, StringComparison.OrdinalIgnoreCase) &&
x.LearningDeliveryAimSeqNumber == learningDelivery.AimSeqNumber);
if (frameworkAim == null)
{
larsErrors.Add(learningDelivery.LearnAimRef);
continue;
}
if (learningDelivery.FundModel == 35)
{
ILR.FundingService.FM35.FundingOutput.Model.Output.LearningDelivery learnerFm35Data = fm35Data
?.Learners?.SingleOrDefault(l => string.Equals(l.LearnRefNumber, learner.LearnRefNumber, StringComparison.OrdinalIgnoreCase))
?.LearningDeliveries?.SingleOrDefault(l => l.AimSeqNumber == learningDelivery.AimSeqNumber);
if (learnerFm35Data != null)
{
mainOccupancyModels.Add(_mainOccupancyReportModelBuilder.BuildFm35Model(
learner,
learningDelivery,
larsModel,
frameworkAim,
learnerFm35Data,
_stringUtilitiesService));
}
}
if (learningDelivery.FundModel != 25)
{
continue;
}
FM25Learner learnerFm25Data =
fm25Data?.Learners?.SingleOrDefault(l => string.Equals(l.LearnRefNumber, learner.LearnRefNumber, StringComparison.OrdinalIgnoreCase));
mainOccupancyModels.Add(_mainOccupancyReportModelBuilder.BuildFm25Model(
learner,
learningDelivery,
learnerFm25Data));
}
}
LogWarnings(larsErrors);
mainOccupancyModels.Sort(MainOccupancyModelComparer);
string csv = GetReportCsv(mainOccupancyModels);
var jobId = reportServiceContext.JobId;
var ukPrn = reportServiceContext.Ukprn.ToString();
var externalFileName = GetExternalFilename(ukPrn, jobId, reportServiceContext.SubmissionDateTimeUtc);
var fileName = GetFilename(ukPrn, jobId, reportServiceContext.SubmissionDateTimeUtc);
await _streamableKeyValuePersistenceService.SaveAsync($"{externalFileName}.csv", csv, cancellationToken);
await WriteZipEntry(archive, $"{fileName}.csv", csv);
}
public async Task GenerateReport(IReportServiceContext reportServiceContext, ZipArchive archive, bool isFis, CancellationToken cancellationToken)
{
Task <IMessage> ilrFileTask = _ilrProviderService.GetIlrFile(reportServiceContext, cancellationToken);
Task <string> providerNameTask = _orgProviderService.GetProviderName(reportServiceContext, cancellationToken);
Task <List <EasSubmissionValues> > easSubmissionValuesAsync = _easProviderService.GetEasSubmissionValuesAsync(reportServiceContext, cancellationToken);
Task <FM35Global> fm35Task = _fm35ProviderService.GetFM35Data(reportServiceContext, cancellationToken);
Task <ALBGlobal> albGlobalTask = _allbProviderService.GetAllbData(reportServiceContext, cancellationToken);
var lastSubmittedIlrFileTask = _ilrProviderService.GetLastSubmittedIlrFile(reportServiceContext, cancellationToken);
var organisationDataTask = _orgProviderService.GetVersionAsync(cancellationToken);
var largeEmployerDataTask = _largeEmployerProviderService.GetVersionAsync(cancellationToken);
var larsDataTask = _larsProviderService.GetVersionAsync(cancellationToken);
var postcodeDataTask = _postcodeProviderService.GetVersionAsync(cancellationToken);
await Task.WhenAll(
easSubmissionValuesAsync,
fm35Task,
albGlobalTask,
providerNameTask,
ilrFileTask,
lastSubmittedIlrFileTask,
organisationDataTask,
largeEmployerDataTask,
larsDataTask,
postcodeDataTask);
var fundingClaimModel = _adultFundingClaimBuilder.BuildAdultFundingClaimModel(
_logger,
reportServiceContext,
fm35Task.Result,
easSubmissionValuesAsync.Result,
albGlobalTask.Result,
providerNameTask.Result,
lastSubmittedIlrFileTask.Result,
_dateTimeProvider,
_intUtilitiesService,
ilrFileTask.Result,
_versionInfo,
organisationDataTask.Result,
largeEmployerDataTask.Result,
postcodeDataTask.Result,
larsDataTask.Result);
if (cancellationToken.IsCancellationRequested)
{
return;
}
long jobId = reportServiceContext.JobId;
string ukPrn = reportServiceContext.Ukprn.ToString();
var externalFileName = GetExternalFilename(ukPrn, jobId, reportServiceContext.SubmissionDateTimeUtc);
var fileName = GetFilename(ukPrn, jobId, reportServiceContext.SubmissionDateTimeUtc);
var assembly = Assembly.GetExecutingAssembly();
string resourceName = assembly.GetManifestResourceNames().Single(str => str.EndsWith("AdultFundingClaimReportTemplate.xlsx"));
var manifestResourceStream = assembly.GetManifestResourceStream(resourceName);
Workbook workbook = new Workbook(manifestResourceStream);
PopulateWorkbook(workbook, fundingClaimModel, isFis);
using (MemoryStream ms = new MemoryStream())
{
workbook.Save(ms, SaveFormat.Xlsx);
await _streamableKeyValuePersistenceService.SaveAsync($"{externalFileName}.xlsx", ms, cancellationToken);
await WriteZipEntry(archive, $"{fileName}.xlsx", ms, cancellationToken);
}
}