public LearningDeliveryHE BuildLearningDeliveryHERecord(int ukprn, ILooseLearner learner, ILooseLearningDelivery learningDelivery, ILooseLearningDeliveryHE looseLearningDeliveryHe, int learningDeliveryHEId) { return(new LearningDeliveryHE { LearningDeliveryHE_Id = learningDeliveryHEId, AimSeqNumber = learningDelivery.AimSeqNumberNullable, UKPRN = ukprn, LearnRefNumber = learner.LearnRefNumber, DOMICILE = looseLearningDeliveryHe.DOMICILE, ELQ = looseLearningDeliveryHe.ELQNullable, FUNDCOMP = looseLearningDeliveryHe.FUNDCOMPNullable, FUNDLEV = looseLearningDeliveryHe.FUNDLEVNullable, GROSSFEE = looseLearningDeliveryHe.GROSSFEENullable, HEPostCode = looseLearningDeliveryHe.HEPostCode, MODESTUD = looseLearningDeliveryHe.MODESTUDNullable, MSTUFEE = looseLearningDeliveryHe.MSTUFEENullable, NETFEE = looseLearningDeliveryHe.NETFEENullable, NUMHUS = looseLearningDeliveryHe.NUMHUS, PCFLDCS = (double?)looseLearningDeliveryHe.PCFLDCSNullable, PCOLAB = (double?)looseLearningDeliveryHe.PCOLABNullable, PCSLDCS = (double?)looseLearningDeliveryHe.PCSLDCSNullable, PCTLDCS = (double?)looseLearningDeliveryHe.PCTLDCSNullable, QUALENT3 = looseLearningDeliveryHe.QUALENT3, SEC = looseLearningDeliveryHe.SECNullable, SOC2000 = looseLearningDeliveryHe.SOC2000Nullable, SPECFEE = looseLearningDeliveryHe.SPECFEENullable, SSN = looseLearningDeliveryHe.SSN, STULOAD = (double?)looseLearningDeliveryHe.STULOADNullable, TYPEYR = looseLearningDeliveryHe.TYPEYRNullable, UCASAPPID = looseLearningDeliveryHe.UCASAPPID, YEARSTU = looseLearningDeliveryHe.YEARSTUNullable }); }
public LearnerHEFinancialSupport BuildLearnerHEFinancialSupport(int ukprn, ILooseLearner learner, ILooseLearnerHEFinancialSupport support, int learnerHEFinancialSupportId) { return(new LearnerHEFinancialSupport { LearnerHEFinancialSupport_Id = learnerHEFinancialSupportId, FINAMOUNT = support.FINAMOUNTNullable, FINTYPE = support.FINTYPENullable, LearnRefNumber = learner.LearnRefNumber, UKPRN = ukprn }); }
public LearnerHE BuildLearnerHE(int ukprn, ILooseLearner learner, ILooseLearnerHE learnerHe, int learnerId, int learnerHEId) { return(new LearnerHE { LearnerHE_Id = learnerHEId, Learner_Id = learnerId, LearnRefNumber = learner.LearnRefNumber, TTACCOM = learnerHe.TTACCOMNullable, UKPRN = ukprn, UCASPERID = learnerHe.UCASPERID }); }
public LearnerFAM BuildLearnerFAM(int ukprn, ILooseLearner learner, ILooseLearnerFAM fam, int learnerId, int learnerFAMId) { return(new LearnerFAM { LearnerFAM_Id = learnerFAMId, Learner_Id = learnerId, UKPRN = ukprn, LearnRefNumber = learner.LearnRefNumber, LearnFAMCode = fam.LearnFAMCodeNullable, LearnFAMType = fam.LearnFAMType }); }
public ContactPreference BuildContactPreference(int ukprn, ILooseLearner learner, ILooseContactPreference contactPreference, int learnerId, int contactPreferenceId) { return(new ContactPreference { ContactPreference_Id = contactPreferenceId, Learner_Id = learnerId, UKPRN = ukprn, LearnRefNumber = learner.LearnRefNumber, ContPrefCode = contactPreference.ContPrefCodeNullable, ContPrefType = contactPreference.ContPrefType }); }
public LLDDandHealthProblem BuildLLDDAndHealthProblem(int ukprn, ILooseLearner learner, ILooseLLDDAndHealthProblem problem, int learnerId, int lLDDandHealthProblemId) { return(new LLDDandHealthProblem { LLDDandHealthProblem_Id = lLDDandHealthProblemId, Learner_Id = learnerId, LearnRefNumber = learner.LearnRefNumber, LLDDCat = problem.LLDDCatNullable, PrimaryLLDD = problem.PrimaryLLDDNullable, UKPRN = ukprn }); }
public EmploymentStatusMonitoring BuildEmploymentStatusMonitoring(int ukprn, ILooseLearner learner, ILooseLearnerEmploymentStatus learnerEmploymentStatus, ILooseEmploymentStatusMonitoring employmentStatusMonitoring, int learnerEmploymentStatusId, int learnerEmploymentStatusMonitoringId) { return(new EmploymentStatusMonitoring { EmploymentStatusMonitoring_Id = learnerEmploymentStatusMonitoringId, LearnerEmploymentStatus_Id = learnerEmploymentStatusId, UKPRN = ukprn, LearnRefNumber = learner.LearnRefNumber, DateEmpStatApp = learnerEmploymentStatus.DateEmpStatAppNullable, ESMCode = employmentStatusMonitoring.ESMCodeNullable, ESMType = employmentStatusMonitoring.ESMType }); }
public LearnerEmploymentStatus BuildLearnerEmploymentStatus(int ukprn, ILooseLearner learner, ILooseLearnerEmploymentStatus learnerEmploymentStatus, int learnerId, int learnerEmploymentStatusId) { return(new LearnerEmploymentStatus { Learner_Id = learnerId, LearnerEmploymentStatus_Id = learnerEmploymentStatusId, UKPRN = ukprn, LearnRefNumber = learner.LearnRefNumber, DateEmpStatApp = learnerEmploymentStatus.DateEmpStatAppNullable, EmpId = learnerEmploymentStatus.EmpIdNullable, EmpStat = learnerEmploymentStatus.EmpStatNullable }); }
public LearningDeliveryFAM BuildLearningDeliveryFAMRecord(int ukprn, ILooseLearner learner, ILooseLearningDelivery learningDelivery, ILooseLearningDeliveryFAM learningDeliveryFam, int learnerDeliveryId, int learnerDeliveryFamId) { return(new LearningDeliveryFAM { LearningDeliveryFAM_Id = learnerDeliveryFamId, LearningDelivery_Id = learnerDeliveryId, UKPRN = ukprn, LearnRefNumber = learner.LearnRefNumber, AimSeqNumber = learningDelivery.AimSeqNumberNullable, LearnDelFAMCode = learningDeliveryFam.LearnDelFAMCode, LearnDelFAMDateFrom = learningDeliveryFam.LearnDelFAMDateFromNullable, LearnDelFAMDateTo = learningDeliveryFam.LearnDelFAMDateToNullable, LearnDelFAMType = learningDeliveryFam.LearnDelFAMType }); }
public AppFinRecord BuildLearningDeliveryAppFinRecord(int ukprn, ILooseLearner learner, ILooseLearningDelivery learningDelivery, ILooseAppFinRecord appFinRecord, int learnerDeliveryId, int appFinRecordId) { return(new AppFinRecord { AppFinRecord_Id = appFinRecordId, LearningDelivery_Id = learnerDeliveryId, LearnRefNumber = learner.LearnRefNumber, UKPRN = ukprn, AFinAmount = appFinRecord.AFinAmountNullable, AFinCode = appFinRecord.AFinCodeNullable, AFinDate = appFinRecord.AFinDateNullable, AFinType = appFinRecord.AFinType, AimSeqNumber = learningDelivery.AimSeqNumberNullable }); }
public IEnumerable <ValidationErrorRow> Build( IEnumerable <ValidationError> ilrValidationErrors, ILooseMessage message, IReadOnlyCollection <Models.ReferenceData.MetaData.ValidationError> validationErrorsMetadata) { List <ValidationErrorRow> validationErrorModels = new List <ValidationErrorRow>(); var learnerDictionary = BuildLearnerDictionary(message); foreach (ValidationError validationError in ilrValidationErrors) { ILooseLearner learner = learnerDictionary?.GetValueOrDefault(validationError.LearnerReferenceNumber?.Trim()); ILooseLearningDelivery learningDelivery = learner?.LearningDeliveries?.FirstOrDefault(x => x.AimSeqNumberNullable == validationError.AimSequenceNumber); validationErrorModels.Add(new ValidationErrorRow() { AimSequenceNumber = validationError.AimSequenceNumber, ULN = learner?.ULNNullable, FamilyName = learner?.FamilyName, GivenNames = learner?.GivenNames, ErrorMessage = validationErrorsMetadata.FirstOrDefault(x => x.RuleName.CaseInsensitiveEquals(validationError.RuleName))?.Message, FieldValues = validationError.ValidationErrorParameters == null ? string.Empty : GetValidationErrorParameters(validationError.ValidationErrorParameters), FundModel = learningDelivery?.FundModelNullable, LearnAimRef = learningDelivery?.LearnAimRef, LearnerReferenceNumber = validationError.LearnerReferenceNumber, PartnerUKPRN = learningDelivery?.PartnerUKPRNNullable, ProviderSpecDelOccurA = learningDelivery?.ProviderSpecDeliveryMonitorings?.FirstOrDefault(x => x.ProvSpecDelMonOccur.CaseInsensitiveEquals("A"))?.ProvSpecDelMon, ProviderSpecDelOccurB = learningDelivery?.ProviderSpecDeliveryMonitorings?.FirstOrDefault(x => x.ProvSpecDelMonOccur.CaseInsensitiveEquals("B"))?.ProvSpecDelMon, ProviderSpecDelOccurC = learningDelivery?.ProviderSpecDeliveryMonitorings?.FirstOrDefault(x => x.ProvSpecDelMonOccur.CaseInsensitiveEquals("C"))?.ProvSpecDelMon, ProviderSpecDelOccurD = learningDelivery?.ProviderSpecDeliveryMonitorings?.FirstOrDefault(x => x.ProvSpecDelMonOccur.CaseInsensitiveEquals("D"))?.ProvSpecDelMon, ProviderSpecLearnOccurA = learner?.ProviderSpecLearnerMonitorings?.FirstOrDefault(x => x.ProvSpecLearnMonOccur.CaseInsensitiveEquals("A"))?.ProvSpecLearnMon, ProviderSpecLearnOccurB = learner?.ProviderSpecLearnerMonitorings?.FirstOrDefault(x => x.ProvSpecLearnMonOccur.CaseInsensitiveEquals("B"))?.ProvSpecLearnMon, RuleName = validationError.RuleName, SWSupAimId = learningDelivery?.SWSupAimId, Severity = validationError.Severity }); } return(validationErrorModels .OrderBy(e => e.Severity) .ThenBy(e => e.RuleName)); }
public LearningDelivery BuildLearningDelivery(int ukprn, ILooseLearner learner, ILooseLearningDelivery learningDelivery, int learnerId, int deliveryId) { return(new LearningDelivery { Learner_Id = learnerId, LearningDelivery_Id = deliveryId, UKPRN = ukprn, LearnRefNumber = learner.LearnRefNumber, LearnAimRef = learningDelivery.LearnAimRef, AimSeqNumber = learningDelivery.AimSeqNumberNullable, AchDate = learningDelivery.AchDateNullable, AddHours = learningDelivery.AddHoursNullable, AimType = learningDelivery.AimTypeNullable, CompStatus = learningDelivery.CompStatusNullable, ConRefNumber = learningDelivery.ConRefNumber, DelLocPostCode = learningDelivery.DelLocPostCode, EmpOutcome = learningDelivery.EmpOutcomeNullable, EPAOrgID = learningDelivery.EPAOrgID, FundModel = learningDelivery.FundModelNullable, FworkCode = learningDelivery.FworkCodeNullable, LearnActEndDate = learningDelivery.LearnActEndDateNullable, LearnPlanEndDate = learningDelivery.LearnPlanEndDateNullable, LearnStartDate = learningDelivery.LearnStartDateNullable, LSDPostcode = learningDelivery.LSDPostcode, OrigLearnStartDate = learningDelivery.OrigLearnStartDateNullable, OtherFundAdj = learningDelivery.OtherFundAdjNullable, OTJActHours = learningDelivery.OtjActHoursNullable, OutGrade = learningDelivery.OutGrade, Outcome = learningDelivery.OutcomeNullable, PartnerUKPRN = learningDelivery.PartnerUKPRNNullable, PHours = learningDelivery.PHoursNullable, PriorLearnFundAdj = learningDelivery.PriorLearnFundAdjNullable, ProgType = learningDelivery.ProgTypeNullable, PwayCode = learningDelivery.PwayCodeNullable, StdCode = learningDelivery.StdCodeNullable, SWSupAimId = learningDelivery.SWSupAimId, WithdrawReason = learningDelivery.WithdrawReasonNullable }); }
public Learner BuildInvalidLearner(int ukprn, ILooseLearner ilrLearner, int id) { return(new Learner { Learner_Id = id, LearnRefNumber = ilrLearner.LearnRefNumber, UKPRN = ukprn, Accom = ilrLearner.AccomNullable, AddLine1 = ilrLearner.AddLine1, AddLine2 = ilrLearner.AddLine2, AddLine3 = ilrLearner.AddLine3, AddLine4 = ilrLearner.AddLine4, ALSCost = ilrLearner.ALSCostNullable, CampId = ilrLearner.CampId, DateOfBirth = ilrLearner.DateOfBirthNullable, Email = ilrLearner.Email, EngGrade = ilrLearner.EngGrade, Ethnicity = ilrLearner.EthnicityNullable, FamilyName = ilrLearner.FamilyName, GivenNames = ilrLearner.GivenNames, LLDDHealthProb = ilrLearner.LLDDHealthProbNullable, MathGrade = ilrLearner.MathGrade, NINumber = ilrLearner.NINumber, PlanEEPHours = ilrLearner.PlanEEPHoursNullable, PlanLearnHours = ilrLearner.PlanLearnHoursNullable, PMUKPRN = ilrLearner.PMUKPRNNullable, Postcode = ilrLearner.Postcode, PostcodePrior = ilrLearner.PostcodePrior, PrevLearnRefNumber = ilrLearner.PrevLearnRefNumber, PrevUKPRN = ilrLearner.PrevUKPRNNullable, PriorAttain = ilrLearner.PriorAttainNullable, Sex = ilrLearner.Sex, TelNo = ilrLearner.TelNo, ULN = ilrLearner.ULNNullable }); }
private bool HasLearningDeliveryWithFundModel(ILooseLearner learner, int fundModel) { return(learner.LearningDeliveries != null && learner.LearningDeliveries.Any(ld => ld.FundModelNullable == fundModel)); }
public ProviderSpecLearnerMonitoring BuildProviderSpecLearnerMonitorings(int ukprn, ILooseLearner learner, ILooseProviderSpecLearnerMonitoring monitoring, int learnerId, int providerSpecLearnerMonitoringId) { return(new ProviderSpecLearnerMonitoring { ProviderSpecLearnerMonitoring_Id = providerSpecLearnerMonitoringId, Learner_Id = learnerId, LearnRefNumber = learner.LearnRefNumber, UKPRN = ukprn, ProvSpecLearnMon = monitoring.ProvSpecLearnMon, ProvSpecLearnMonOccur = monitoring.ProvSpecLearnMonOccur }); }
public LearningDeliveryWorkPlacement BuildLearningDeliveryWorkPlacement(int ukprn, ILooseLearner learner, ILooseLearningDelivery learningDelivery, ILooseLearningDeliveryWorkPlacement learningDeliveryWorkPlacement, int learnerDeliveryId, int learningDeliveryWorkPlacementId) { return(new LearningDeliveryWorkPlacement { LearningDeliveryWorkPlacement_Id = learningDeliveryWorkPlacementId, LearningDelivery_Id = learnerDeliveryId, AimSeqNumber = learningDelivery.AimSeqNumberNullable, UKPRN = ukprn, LearnRefNumber = learner.LearnRefNumber, WorkPlaceEmpId = learningDeliveryWorkPlacement.WorkPlaceEmpIdNullable.GetValueOrDefault(-1), WorkPlaceEndDate = learningDeliveryWorkPlacement.WorkPlaceEndDateNullable, WorkPlaceHours = learningDeliveryWorkPlacement.WorkPlaceHoursNullable, WorkPlaceMode = learningDeliveryWorkPlacement.WorkPlaceModeNullable, WorkPlaceStartDate = learningDeliveryWorkPlacement.WorkPlaceStartDateNullable }); }
public ProviderSpecDeliveryMonitoring BuildProviderSpecDeliveryMonitoring(int ukprn, ILooseLearner learner, ILooseLearningDelivery learningDelivery, ILooseProviderSpecDeliveryMonitoring monitoring, int learnerDeliveryId, int providerSpecDeliveryMonitoringId) { return(new ProviderSpecDeliveryMonitoring { ProviderSpecDeliveryMonitoring_Id = providerSpecDeliveryMonitoringId, LearningDelivery_Id = learnerDeliveryId, AimSeqNumber = learningDelivery.AimSeqNumberNullable, LearnRefNumber = learner.LearnRefNumber, ProvSpecDelMon = monitoring.ProvSpecDelMon, ProvSpecDelMonOccur = monitoring.ProvSpecDelMonOccur, UKPRN = ukprn }); }