private async Task CreateSpecialisms(ResultsAndCertificationDbContext context)
{
await context.TlSpecialism.AddRangeAsync(new List <TlSpecialism>
{
new TlSpecialism {
Id = 1, Name = "Surveying and design for construction and the built environment", TlPathwayId = 1, CreatedBy = "Sys", CreatedOn = DateTime.UtcNow
},
new TlSpecialism {
Id = 2, Name = "Civil Engineering", TlPathwayId = 1, CreatedBy = "Sys", CreatedOn = DateTime.UtcNow
},
new TlSpecialism {
Id = 3, Name = "Building services design", TlPathwayId = 1, CreatedBy = "Sys", CreatedOn = DateTime.UtcNow
},
new TlSpecialism {
Id = 4, Name = "Hazardous materials analysis and surveying", TlPathwayId = 1, CreatedBy = "Sys", CreatedOn = DateTime.UtcNow
},
new TlSpecialism {
Id = 5, Name = "Early years education and childcare", TlPathwayId = 2, CreatedBy = "Sys", CreatedOn = DateTime.UtcNow
},
new TlSpecialism {
Id = 6, Name = "Assisting teaching", TlPathwayId = 2, CreatedBy = "Sys", CreatedOn = DateTime.UtcNow
},
new TlSpecialism {
Id = 7, Name = "Supporting and mentoring students in further and higher education", TlPathwayId = 2, CreatedBy = "Sys", CreatedOn = DateTime.UtcNow
},
new TlSpecialism {
Id = 8, Name = "Digital Production, Design and Development", TlPathwayId = 3, CreatedBy = "Sys", CreatedOn = DateTime.UtcNow
},
});
await context.SaveChangesAsync();
}
public virtual async Task <int> CreateAsync(T entity)
{
await _dbContext.AddAsync(entity);
try
{
await _dbContext.SaveChangesAsync();
}
catch (DbUpdateException due)
{
_logger.LogError(due.Message, due.InnerException);
throw;
}
return(entity.Id);
}
private async Task CreateProviders(ResultsAndCertificationDbContext context)
{
await context.TqProvider.AddRangeAsync(new List <TqProvider>
{
new TqProvider {
TqAwardingOrganisationId = 1, TlProviderId = 1, CreatedBy = "System", CreatedOn = DateTime.UtcNow
},
});
await context.SaveChangesAsync();
}
private async Task CreateTwoAwardOrganisations(ResultsAndCertificationDbContext context)
{
await context.TqAwardingOrganisation.AddRangeAsync(new List <TqAwardingOrganisation>
{
new TqAwardingOrganisation {
Name = "AO1", DisplayName = "Award Org1", UkAon = "test1", CreatedBy = "Sys", CreatedOn = DateTime.UtcNow
},
new TqAwardingOrganisation {
Name = "AO2", DisplayName = "Award Org2", UkAon = "test2", CreatedBy = "Sys", CreatedOn = DateTime.UtcNow
},
});
await context.SaveChangesAsync();
}
private async Task CreateTwoProviders(ResultsAndCertificationDbContext context)
{
await context.TlProvider.AddRangeAsync(new List <TlProvider>
{
new TlProvider {
Name = "P1", DisplayName = "Provider1", UkPrn = 111, CreatedBy = "sys", CreatedOn = DateTime.UtcNow
},
new TlProvider {
Name = "P2", DisplayName = "Provider2", UkPrn = 111, CreatedBy = "sys", CreatedOn = DateTime.UtcNow
},
// TODO: which process will set the flag - IsTlevelProvider..
});
await context.SaveChangesAsync();
}
