public void CreateDbRegistationForLrsMathsAEnglishNA(string uln) { var profileId = SqlQueries.CreateRegistrationProfileForLrsMathsAndEnglishNotAchieved(uln); var pathwayId = SqlQueries.CreateRegistrationPathwayForLrs(profileId); SqlQueries.CreateRegSpecialismForLrs(pathwayId); SqlQueries.CreateQualificationAcheivedForLrsMathsAEnglishNA(profileId); }
protected static void CreateDbRegistationForLrsCombination(string uln, string EmStatus, string IpStatus) { var ipStat = IpStatus switch { "IP completed" => 1, "IP completed with special consideration" => 2, _ => 3 }; switch (EmStatus) { case "MathEng not Achieved Min Standard Math-A Eng-NA": var profileId = SqlQueries.CreateRegistrationProfileForLrsCombination(uln, "NULL", "0", "NULL", "0"); var pathwayId = SqlQueries.CreateRegistrationPathwayForLrsCombination(profileId); SqlQueries.CreateRegSpecialismForLrs(pathwayId); SqlQueries.CreateQualificationAcheivedForLrsMathsAEnglishNA(profileId); SqlQueries.CreateIndustryPlacement(pathwayId, ipStat); var pathwayAssessmentId = SqlQueries.CreatePathwayAssessment(pathwayId); SqlQueries.CreatePathwayResult(pathwayAssessmentId); break; case "MathEng not Achieved Min Standard Math-NA Eng-A": var profileId1 = SqlQueries.CreateRegistrationProfileForLrsCombination(uln, "NULL", "0", "NULL", "0"); var pathwayId1 = SqlQueries.CreateRegistrationPathwayForLrsCombination(profileId1); SqlQueries.CreateRegSpecialismForLrs(pathwayId1); SqlQueries.CreateQualificationAcheivedForLrsMathsAEnglishNA(profileId1); SqlQueries.CreateIndustryPlacement(pathwayId1, ipStat); var pathwayAssessmentId1 = SqlQueries.CreatePathwayAssessment(pathwayId1); SqlQueries.CreatePathwayResult(pathwayAssessmentId1); break; case "MathEng not Achieved Min Standard Math-NA Eng-NA": var profileId4 = SqlQueries.CreateRegistrationProfileForLrsCombination(uln, "NULL", "0", "NULL", "0"); var pathwayId4 = SqlQueries.CreateRegistrationPathwayForLrsCombination(profileId4); SqlQueries.CreateRegSpecialismForLrs(pathwayId4); SqlQueries.CreateQualificationAcheivedForLrsMathsNaEnglishNa(profileId4); SqlQueries.CreateIndustryPlacement(pathwayId4, ipStat); var pathwayAssessmentId4 = SqlQueries.CreatePathwayAssessment(pathwayId4); SqlQueries.CreatePathwayResult(pathwayAssessmentId4); break; case "MathEng Achieved with SEND": var profileId2 = SqlQueries.CreateRegistrationProfileForLrsCombination(uln, "1", "1", "NULL", "0"); var pathwayId2 = SqlQueries.CreateRegistrationPathwayForLrsCombination(profileId2); SqlQueries.CreateRegSpecialismForLrs(pathwayId2); SqlQueries.CreateQualificationAcheivedForLrsSEND(profileId2); SqlQueries.CreateIndustryPlacement(pathwayId2, ipStat); var pathwayAssessmentId2 = SqlQueries.CreatePathwayAssessment(pathwayId2); SqlQueries.CreatePathwayResult(pathwayAssessmentId2); break; case "MathEng Achieved Min Standard": var profileId3 = SqlQueries.CreateRegistrationProfileForLrsCombination(uln, "NULL", "1", "NULL", "0"); var pathwayId3 = SqlQueries.CreateRegistrationPathwayForLrsCombination(profileId3); SqlQueries.CreateRegSpecialismForLrs(pathwayId3); SqlQueries.CreateQualificationAcheivedForLrs(profileId3); SqlQueries.CreateIndustryPlacement(pathwayId3, ipStat); var pathwayAssessmentId3 = SqlQueries.CreatePathwayAssessment(pathwayId3); SqlQueries.CreatePathwayResult(pathwayAssessmentId3); break; } }