protected static void CreateRegistrationForBarnsley(string uln)
{
var profileId = SqlQueries.CreateRegistrationProfileForLrs(uln);
var pathwayId = SqlQueries.CreateRegistrationPathwayForLrs(profileId);
SqlQueries.CreateRegSpecialism(pathwayId);
}
public void CreateDbRegistation(string uln)
{
var profileId = SqlQueries.CreateRegistrationProfile(uln);
var pathwayId = SqlQueries.CreateRegistrationPathway(profileId);
SqlQueries.CreateRegSpecialism(pathwayId);
}
protected static void CreateDbRegWithAssessment(string uln)
{
var profileId = SqlQueries.CreateRegistrationProfile(uln);
var pathwayId = SqlQueries.CreateRegistrationPathway(profileId);
SqlQueries.CreateRegSpecialism(pathwayId);
SqlQueries.CreatePathwayAssessment(pathwayId);
}
protected void CreateRegForBarnsleyNoCoreGrade_Withdrawn_IndPlacementNotComplete(string uln)
{
var profileId = SqlQueries.CreateRegistrationProfileForNonLrsWithEM(uln);
var pathwayId = SqlQueries.CreateWithdrawnRegistrationPathwayRecord(profileId);
SqlQueries.CreateRegSpecialism(pathwayId);
SqlQueries.CreateIndustryPlacement(pathwayId, 3);
}
public void CreateDbRegWithResult(string uln)
{
//var uln = UlnHelper.GenerateUln().ToString();
var profileId = SqlQueries.CreateRegistrationProfile(uln);
var pathwayId = SqlQueries.CreateRegistrationPathway(profileId);
SqlQueries.CreateRegSpecialism(pathwayId);
var pathwayAssessmentId = SqlQueries.CreatePathwayAssessment(pathwayId);
SqlQueries.CreatePathwayResult(pathwayAssessmentId);
}
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);
}
protected static void CreateDbRegWithResultAndTwoAssessmentEntries(string uln)
{
var profileId = SqlQueries.CreateRegistrationProfile(uln);
var pathwayId = SqlQueries.CreateRegistrationPathway(profileId);
SqlQueries.CreateRegSpecialism(pathwayId);
var pathwayAssessmentId = SqlQueries.CreatePathwayAssessment(pathwayId);
SqlQueries.CreatePathwayResult(pathwayAssessmentId);
SqlQueries.CreateSecondPathwayAssessmentEntry(pathwayId);
//SqlQueries.CreatePathwayResult(pathwayAssessmentId1);
}
protected static void CreateRegWithAppealState(string uln)
{
var profileId = SqlQueries.CreateRegistrationProfile(uln);
var pathwayId = SqlQueries.CreateRegistrationPathway(profileId);
SqlQueries.CreateRegSpecialism(pathwayId);
var pathwayAssessmentId = SqlQueries.CreatePathwayAssessment(pathwayId);
SqlQueries.CreatePathwayResult(pathwayAssessmentId);
var updateResult = "update TqPathwayResult set EndDate = GETDATE() where TqPathwayAssessmentId='" + pathwayAssessmentId + "'";
SqlDatabaseConncetionHelper.UpdateSqlCommand(updateResult, ConnectionString);
var insertAppealRow = "Insert into TqPathwayResult values('" + pathwayAssessmentId + "',2,GETDATE(),Null,3,1,0,GETDATE(),'System',GETDATE(),'System')";
SqlDatabaseConncetionHelper.ExecuteSqlCommand(insertAppealRow, ConnectionString);
}