public void CreateDbRegistationForNonLRS(string uln)
{
var profileId = SqlQueries.CreateRegistrationProfileForNonLRS(uln);
var pathwayId = SqlQueries.CreateRegistrationPathwayForLrs(profileId);
SqlQueries.CreateRegSpecialismForLrs(pathwayId);
}
protected static void CreateRegistrationForBarnsley(string uln)
{
var profileId = SqlQueries.CreateRegistrationProfileForLrs(uln);
var pathwayId = SqlQueries.CreateRegistrationPathwayForLrs(profileId);
SqlQueries.CreateRegSpecialism(pathwayId);
}
public void CreateDbRegistationNonLrsWithEMAndIP(string uln)
{
var profileId = SqlQueries.CreateRegistrationProfileForNonLrsWithEM(uln);
var pathwayId = SqlQueries.CreateRegistrationPathwayForLrs(profileId);
SqlQueries.CreateRegSpecialismForLrs(pathwayId);
SqlQueries.CreateIndustryPlacement(pathwayId, 1);
}
public void CreateDbRegistationForLrsWithEMAcheived(string uln)
{
var profileId = SqlQueries.CreateRegistrationProfileForLrsWithEM(uln);
var pathwayId = SqlQueries.CreateRegistrationPathwayForLrs(profileId);
SqlQueries.CreateRegSpecialismForLrs(pathwayId);
SqlQueries.CreateQualificationAcheivedForLrs(profileId);
}
public void CreateDbRegistationForLrsMathsNAEnglishA(string uln)
{
var profileId = SqlQueries.CreateRegistrationProfileForLrsMathsAndEnglishNotAchieved(uln);
var pathwayId = SqlQueries.CreateRegistrationPathwayForLrs(profileId);
SqlQueries.CreateRegSpecialismForLrs(pathwayId);
SqlQueries.CreateQualificationAcheivedForLrsMathsNAEnglishA(profileId);
}
public void CreateDbRegWithAssessmentForLrs(string uln)
{
var profileId = SqlQueries.CreateRegistrationProfileForLrs(uln);
var pathwayId = SqlQueries.CreateRegistrationPathwayForLrs(profileId);
SqlQueries.CreateRegSpecialismForLrs(pathwayId);
SqlQueries.CreatePathwayAssessment(pathwayId);
SqlQueries.CreateQualificationAcheivedForLrs(profileId);
}
protected static void CreateDbRegistationForLrsWithEmAndIp(string uln)
{
var profileId = SqlQueries.CreateRegistrationProfileForLrsWithEM(uln);
var pathwayId = SqlQueries.CreateRegistrationPathwayForLrs(profileId);
SqlQueries.CreateRegSpecialismForLrs(pathwayId);
SqlQueries.CreateQualificationAcheivedForLrs(profileId);
SqlQueries.CreateIndustryPlacement(pathwayId, 1);
}
protected static void CreateAndWithdrawRegBarnsley(string uln)
{
var profileId = SqlQueries.CreateRegistrationProfileForNonLRS(uln);
var pathwayId = SqlQueries.CreateRegistrationPathwayForLrs(profileId);
SqlQueries.CreateRegSpecialism(pathwayId);
var pathwayAssessmentId = SqlQueries.CreatePathwayAssessment(pathwayId);
SqlQueries.CreatePathwayResult(pathwayAssessmentId);
SqlQueries.UpdateRegWithdrawn(uln);
}
public void CreateDbRegWithIpForLrs(string uln, int status)
{
var profileId = SqlQueries.CreateRegistrationProfileForLrsWithEM(uln);
var pathwayId = SqlQueries.CreateRegistrationPathwayForLrs(profileId);
SqlQueries.CreateRegSpecialismForLrs(pathwayId);
var pathwayAssessmentId = SqlQueries.CreatePathwayAssessment(pathwayId);
SqlQueries.CreatePathwayResult(pathwayAssessmentId);
SqlQueries.CreateQualificationAcheivedForLrs(profileId);
SqlQueries.CreateIndustryPlacement(pathwayId, status);
}
public void CreateDbRegWithResultForLrs(string uln)
{
//var uln = UlnHelper.GenerateUln().ToString();
var profileId = SqlQueries.CreateRegistrationProfileForLrs(uln);
var pathwayId = SqlQueries.CreateRegistrationPathwayForLrs(profileId);
SqlQueries.CreateRegSpecialismForLrs(pathwayId);
var pathwayAssessmentId = SqlQueries.CreatePathwayAssessment(pathwayId);
SqlQueries.CreatePathwayResult(pathwayAssessmentId);
SqlQueries.CreateQualificationAcheivedForLrs(profileId);
}