public MainOccupancyModel BuildFm35Model(
ILearner learner,
ILearningDelivery learningDelivery,
LarsLearningDelivery larsModel,
LearningDelivery frameworkAim,
ILR.FundingService.FM35.FundingOutput.Model.Output.LearningDelivery fm35Data,
IStringUtilitiesService stringUtilitiesService)
{
var onProgPayment = fm35Data?.LearningDeliveryPeriodisedValues
?.SingleOrDefault(attr => string.Equals(attr.AttributeName, Constants.Fm35OnProgrammeAttributeName, StringComparison.OrdinalIgnoreCase));
var balancePayment = fm35Data?.LearningDeliveryPeriodisedValues
?.SingleOrDefault(attr => string.Equals(attr.AttributeName, Constants.Fm35BalancingAttributeName, StringComparison.OrdinalIgnoreCase));
var achievePayment = fm35Data?.LearningDeliveryPeriodisedValues
?.SingleOrDefault(attr => string.Equals(attr.AttributeName, Constants.Fm35AimAchievementAttributeName, StringComparison.OrdinalIgnoreCase));
var empOutcomePayment = fm35Data?.LearningDeliveryPeriodisedValues
?.SingleOrDefault(attr => string.Equals(attr.AttributeName, Constants.Fm35JobOutcomeAchievementAttributeName, StringComparison.OrdinalIgnoreCase));
var learnSuppFundCash = fm35Data?.LearningDeliveryPeriodisedValues
?.SingleOrDefault(attr => string.Equals(attr.AttributeName, Constants.Fm35LearningSupportAttributeName, StringComparison.OrdinalIgnoreCase));
var ldms = stringUtilitiesService.GetArrayEntries(learningDelivery.LearningDeliveryFAMs?.Where(x => string.Equals(x.LearnDelFAMType, "LDM", StringComparison.OrdinalIgnoreCase)), 4);
var totalOnProgPayment = (onProgPayment?.Period1 ?? 0) + (onProgPayment?.Period2 ?? 0) +
(onProgPayment?.Period3 ?? 0) + (onProgPayment?.Period4 ?? 0) +
(onProgPayment?.Period5 ?? 0) + (onProgPayment?.Period6 ?? 0) +
(onProgPayment?.Period7 ?? 0) + (onProgPayment?.Period8 ?? 0) +
(onProgPayment?.Period9 ?? 0) + (onProgPayment?.Period10 ?? 0) +
(onProgPayment?.Period11 ?? 0) + (onProgPayment?.Period12 ?? 0);
var totalBalancePayment = (balancePayment?.Period1 ?? 0) + (balancePayment?.Period2 ?? 0) +
(balancePayment?.Period3 ?? 0) + (balancePayment?.Period4 ?? 0) +
(balancePayment?.Period5 ?? 0) + (balancePayment?.Period6 ?? 0) +
(balancePayment?.Period7 ?? 0) + (balancePayment?.Period8 ?? 0) +
(balancePayment?.Period9 ?? 0) + (balancePayment?.Period10 ?? 0) +
(balancePayment?.Period11 ?? 0) + (balancePayment?.Period12 ?? 0);
var totalAchievePayment = (achievePayment?.Period1 ?? 0) + (achievePayment?.Period2 ?? 0) +
(achievePayment?.Period3 ?? 0) + (achievePayment?.Period4 ?? 0) +
(achievePayment?.Period5 ?? 0) + (achievePayment?.Period6 ?? 0) +
(achievePayment?.Period7 ?? 0) + (achievePayment?.Period8 ?? 0) +
(achievePayment?.Period9 ?? 0) + (achievePayment?.Period10 ?? 0) +
(achievePayment?.Period11 ?? 0) + (achievePayment?.Period12 ?? 0);
var totalEmpOutcomePay = (empOutcomePayment?.Period1 ?? 0) + (empOutcomePayment?.Period2 ?? 0) +
(empOutcomePayment?.Period3 ?? 0) + (empOutcomePayment?.Period4 ?? 0) +
(empOutcomePayment?.Period5 ?? 0) + (empOutcomePayment?.Period6 ?? 0) +
(empOutcomePayment?.Period7 ?? 0) + (empOutcomePayment?.Period8 ?? 0) +
(empOutcomePayment?.Period9 ?? 0) + (empOutcomePayment?.Period10 ?? 0) +
(empOutcomePayment?.Period11 ?? 0) + (empOutcomePayment?.Period12 ?? 0);
var totalLearnSuppFundCash = (learnSuppFundCash?.Period1 ?? 0) + (learnSuppFundCash?.Period2 ?? 0) +
(learnSuppFundCash?.Period3 ?? 0) + (learnSuppFundCash?.Period4 ?? 0) +
(learnSuppFundCash?.Period5 ?? 0) + (learnSuppFundCash?.Period6 ?? 0) +
(learnSuppFundCash?.Period7 ?? 0) + (learnSuppFundCash?.Period8 ?? 0) +
(learnSuppFundCash?.Period9 ?? 0) + (learnSuppFundCash?.Period10 ?? 0) +
(learnSuppFundCash?.Period11 ?? 0) + (learnSuppFundCash?.Period12 ?? 0);
LearningDeliveryPeriodisedValue aimPercent = fm35Data?.LearningDeliveryPeriodisedValues?.SingleOrDefault(attr =>
string.Equals(attr.AttributeName, Constants.Fm35AimAchievementPercentAttributeName, StringComparison.OrdinalIgnoreCase));
return(new MainOccupancyModel
{
LearnRefNumber = learner.LearnRefNumber,
Uln = learner.ULN,
DateOfBirth = learner.DateOfBirthNullable?.ToString("dd/MM/yyyy"),
PostcodePrior = learner.PostcodePrior,
PmUkprn = learner.PMUKPRNNullable,
CampId = learner.CampId,
ProvSpecLearnMonA = learner.ProviderSpecLearnerMonitorings
?.SingleOrDefault(x => string.Equals(x.ProvSpecLearnMonOccur, "A", StringComparison.OrdinalIgnoreCase))?.ProvSpecLearnMon,
ProvSpecLearnMonB = learner.ProviderSpecLearnerMonitorings
?.SingleOrDefault(x => string.Equals(x.ProvSpecLearnMonOccur, "B", StringComparison.OrdinalIgnoreCase))?.ProvSpecLearnMon,
AimSeqNumber = learningDelivery.AimSeqNumber,
LearnAimRef = learningDelivery.LearnAimRef,
LearnAimRefTitle = larsModel.LearningAimTitle,
SwSupAimId = learningDelivery.SWSupAimId,
WeightedRateFromEsol = fm35Data?.LearningDeliveryValue?.WeightedRateFromESOL,
ApplicWeightFundRate = fm35Data?.LearningDeliveryValue?.ApplicWeightFundRate,
ApplicProgWeightFact = fm35Data?.LearningDeliveryValue?.ApplicProgWeightFact,
AimValue = fm35Data?.LearningDeliveryValue?.AimValue,
NotionalNvqLevelV2 = larsModel.NotionalNvqLevel,
SectorSubjectAreaTier2 = larsModel.Tier2SectorSubjectArea,
ProgType = learningDelivery.ProgTypeNullable,
FworkCode = learningDelivery.FworkCodeNullable,
PwayCode = learningDelivery.PwayCodeNullable,
AimType = learningDelivery.AimType,
FrameworkComponentType = frameworkAim.FrameworkComponentType,
FundModel = learningDelivery.FundModel,
PriorLearnFundAdj = learningDelivery.PriorLearnFundAdjNullable,
OtherFundAdj = learningDelivery.OtherFundAdjNullable,
OrigLearnStartDate = learningDelivery.OrigLearnStartDateNullable?.ToString("dd/MM/yyyy"),
LearnStartDate = learningDelivery.LearnStartDate.ToString("dd/MM/yyyy"),
LearnPlanEndDate = learningDelivery.LearnPlanEndDate.ToString("dd/MM/yyyy"),
CompStatus = learningDelivery.CompStatus,
LearnActEndDate = learningDelivery.LearnActEndDateNullable?.ToString("dd/MM/yyyy"),
Outcome = learningDelivery.OutcomeNullable,
AchDate = learningDelivery.AchDateNullable?.ToString("dd/MM/yyyy"),
AddHours = learningDelivery.AddHoursNullable,
LearnDelFamCodeSof = learningDelivery.LearningDeliveryFAMs
?.SingleOrDefault(x => string.Equals(x.LearnDelFAMType, "SOF", StringComparison.OrdinalIgnoreCase))?.LearnDelFAMCode,
LearnDelFamCodeFfi = learningDelivery.LearningDeliveryFAMs
?.SingleOrDefault(x => string.Equals(x.LearnDelFAMType, "FFI", StringComparison.OrdinalIgnoreCase))?.LearnDelFAMCode,
LearnDelFamCodeEef = learningDelivery.LearningDeliveryFAMs
?.SingleOrDefault(x => string.Equals(x.LearnDelFAMType, "EEF", StringComparison.OrdinalIgnoreCase))?.LearnDelFAMCode,
LearnDelFamCodeLsfHighest = learningDelivery.LearningDeliveryFAMs
?.Where(x => string.Equals(x.LearnDelFAMType, "LSF", StringComparison.OrdinalIgnoreCase)).Select(x => x.LearnDelFAMCode).DefaultIfEmpty().Max(),
LearnDelFamCodeLsfEarliest = learningDelivery.LearningDeliveryFAMs
?.Where(x => string.Equals(x.LearnDelFAMType, "LSF", StringComparison.OrdinalIgnoreCase)).Select(x => x.LearnDelFAMDateFromNullable ?? DateTime.MinValue)
.DefaultIfEmpty(DateTime.MinValue).Min().ToString("dd/MM/yyyy"),
LearnDelFamCodeLsfLatest = learningDelivery.LearningDeliveryFAMs
?.Where(x => string.Equals(x.LearnDelFAMType, "LSF", StringComparison.OrdinalIgnoreCase))
.Min(x => x.LearnDelFAMDateToNullable)?.ToString("dd/MM/yyyy"),
LearnDelFamCodeLdm1 = ldms[0],
LearnDelFamCodeLdm2 = ldms[1],
LearnDelFamCodeLdm3 = ldms[2],
LearnDelFamCodeLdm4 = ldms[3],
LearnDelFamCodeRes = learningDelivery.LearningDeliveryFAMs
?.SingleOrDefault(x => string.Equals(x.LearnDelFAMType, "RES", StringComparison.OrdinalIgnoreCase))?.LearnDelFAMCode,
ProvSpecDelMonA = learningDelivery.ProviderSpecDeliveryMonitorings
?.SingleOrDefault(x => string.Equals(x.ProvSpecDelMonOccur, "A", StringComparison.OrdinalIgnoreCase))?.ProvSpecDelMon,
ProvSpecDelMonB = learningDelivery.ProviderSpecDeliveryMonitorings
?.SingleOrDefault(x => string.Equals(x.ProvSpecDelMonOccur, "B", StringComparison.OrdinalIgnoreCase))?.ProvSpecDelMon,
ProvSpecDelMonC = learningDelivery.ProviderSpecDeliveryMonitorings
?.SingleOrDefault(x => string.Equals(x.ProvSpecDelMonOccur, "C", StringComparison.OrdinalIgnoreCase))?.ProvSpecDelMon,
ProvSpecDelMonD = learningDelivery.ProviderSpecDeliveryMonitorings
?.SingleOrDefault(x => string.Equals(x.ProvSpecDelMonOccur, "D", StringComparison.OrdinalIgnoreCase))?.ProvSpecDelMon,
FundLine = fm35Data?.LearningDeliveryValue?.FundLine,
PlannedNumOnProgInstalm = fm35Data?.LearningDeliveryValue?.PlannedNumOnProgInstalm,
PlannedNumOnProgInstalmTrans = fm35Data?.LearningDeliveryValue?.PlannedNumOnProgInstalmTrans,
StartPropTrans = fm35Data?.LearningDeliveryValue?.StartPropTrans,
AchieveElement = fm35Data?.LearningDeliveryValue?.AchieveElement,
AchievePercentage = aimPercent == null ? 0 : GetMaxPeriod(aimPercent),
NonGovCont = fm35Data?.LearningDeliveryValue?.NonGovCont,
PartnerUkprn = learningDelivery.PartnerUKPRNNullable,
DelLocPostCode = learningDelivery.DelLocPostCode,
AreaCostFactAdj = fm35Data?.LearningDeliveryValue?.AreaCostFactAdj,
DisUpFactAdj = fm35Data?.LearningDeliveryValue?.DisUpFactAdj,
LargeEmployerID = fm35Data?.LearningDeliveryValue?.LargeEmployerID,
LargeEmployerFM35Fctr = fm35Data?.LearningDeliveryValue?.LargeEmployerFM35Fctr,
CapFactor = fm35Data?.LearningDeliveryValue?.CapFactor,
TraineeWorkPlacement = (fm35Data?.LearningDeliveryValue?.TrnWorkPlaceAim ?? false) ||
(fm35Data?.LearningDeliveryValue?.TrnWorkPrepAim ?? false),
HigherApprentishipHeAim = fm35Data?.LearningDeliveryValue?.PrscHEAim ?? false,
ApplicEmpFactDate = fm35Data?.LearningDeliveryValue?.ApplicEmpFactDate?.ToString("dd/MM/yyyy"),
ApplicFactDate = fm35Data?.LearningDeliveryValue?.ApplicFactDate?.ToString("dd/MM/yyyy"),
Period1OnProgPayment = onProgPayment?.Period1,
Period1BalancePayment = balancePayment?.Period1,
Period1AchievePayment = achievePayment?.Period1,
Period1EmpOutcomePay = empOutcomePayment?.Period1,
Period1LearnSuppFundCash = learnSuppFundCash?.Period1,
Period2OnProgPayment = onProgPayment?.Period2,
Period2BalancePayment = balancePayment?.Period2,
Period2AchievePayment = achievePayment?.Period2,
Period2EmpOutcomePay = empOutcomePayment?.Period2,
Period2LearnSuppFundCash = learnSuppFundCash?.Period2,
Period3OnProgPayment = onProgPayment?.Period3,
Period3BalancePayment = balancePayment?.Period3,
Period3AchievePayment = achievePayment?.Period3,
Period3EmpOutcomePay = empOutcomePayment?.Period3,
Period3LearnSuppFundCash = learnSuppFundCash?.Period3,
Period4OnProgPayment = onProgPayment?.Period4,
Period4BalancePayment = balancePayment?.Period4,
Period4AchievePayment = achievePayment?.Period4,
Period4EmpOutcomePay = empOutcomePayment?.Period4,
Period4LearnSuppFundCash = learnSuppFundCash?.Period4,
Period5OnProgPayment = onProgPayment?.Period5,
Period5BalancePayment = balancePayment?.Period5,
Period5AchievePayment = achievePayment?.Period5,
Period5EmpOutcomePay = empOutcomePayment?.Period5,
Period5LearnSuppFundCash = learnSuppFundCash?.Period5,
Period6OnProgPayment = onProgPayment?.Period6,
Period6BalancePayment = balancePayment?.Period6,
Period6AchievePayment = achievePayment?.Period6,
Period6EmpOutcomePay = empOutcomePayment?.Period6,
Period6LearnSuppFundCash = learnSuppFundCash?.Period6,
Period7OnProgPayment = onProgPayment?.Period7,
Period7BalancePayment = balancePayment?.Period7,
Period7AchievePayment = achievePayment?.Period7,
Period7EmpOutcomePay = empOutcomePayment?.Period7,
Period7LearnSuppFundCash = learnSuppFundCash?.Period7,
Period8OnProgPayment = onProgPayment?.Period8,
Period8BalancePayment = balancePayment?.Period8,
Period8AchievePayment = achievePayment?.Period8,
Period8EmpOutcomePay = empOutcomePayment?.Period8,
Period8LearnSuppFundCash = learnSuppFundCash?.Period8,
Period9OnProgPayment = onProgPayment?.Period9,
Period9BalancePayment = balancePayment?.Period9,
Period9AchievePayment = achievePayment?.Period9,
Period9EmpOutcomePay = empOutcomePayment?.Period9,
Period9LearnSuppFundCash = learnSuppFundCash?.Period9,
Period10OnProgPayment = onProgPayment?.Period10,
Period10BalancePayment = balancePayment?.Period10,
Period10AchievePayment = achievePayment?.Period10,
Period10EmpOutcomePay = empOutcomePayment?.Period10,
Period10LearnSuppFundCash = learnSuppFundCash?.Period10,
Period11OnProgPayment = onProgPayment?.Period11,
Period11BalancePayment = balancePayment?.Period11,
Period11AchievePayment = achievePayment?.Period11,
Period11EmpOutcomePay = empOutcomePayment?.Period11,
Period11LearnSuppFundCash = learnSuppFundCash?.Period11,
Period12OnProgPayment = onProgPayment?.Period12,
Period12BalancePayment = balancePayment?.Period12,
Period12AchievePayment = achievePayment?.Period12,
Period12EmpOutcomePay = empOutcomePayment?.Period12,
Period12LearnSuppFundCash = learnSuppFundCash?.Period12,
TotalOnProgPayment = totalOnProgPayment,
TotalBalancePayment = totalBalancePayment,
TotalAchievePayment = totalAchievePayment,
TotalEmpOutcomePay = totalEmpOutcomePay,
TotalLearnSuppFundCash = totalLearnSuppFundCash,
TotalEarnedCash = totalOnProgPayment + totalBalancePayment + totalAchievePayment
+ totalEmpOutcomePay + totalLearnSuppFundCash
});
}
