public void CreateDbRegistationForLrsWithEMAcheived(string uln)
{
var profileId = SqlQueries.CreateRegistrationProfileForLrsWithEM(uln);
var pathwayId = SqlQueries.CreateRegistrationPathwayForLrs(profileId);
SqlQueries.CreateRegSpecialismForLrs(pathwayId);
SqlQueries.CreateQualificationAcheivedForLrs(profileId);
}
protected static void CreateLrsRegWithEmAndIpForDudley(string uln)
{
var profileId = SqlQueries.CreateRegistrationProfileForLrsWithEM(uln);
var pathwayId = SqlQueries.CreateRegistrationPathwayForDudley(profileId);
SqlQueries.CreateRegSpecialismForLrs(pathwayId);
SqlQueries.CreateQualificationAcheivedForLrs(profileId);
SqlQueries.CreateIndustryPlacement(pathwayId, 1);
}
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);
}