public TqRegistrationProfile SeedRegistrationData(long uln, TqProvider tqProvider = null, RegistrationPathwayStatus status = RegistrationPathwayStatus.Active, bool isBulkUpload = true)
{
var profile = new TqRegistrationProfileBuilder().BuildList().FirstOrDefault(p => p.UniqueLearnerNumber == uln);
var tqRegistrationProfile = RegistrationsDataProvider.CreateTqRegistrationProfile(DbContext, profile);
var tqRegistrationPathway = RegistrationsDataProvider.CreateTqRegistrationPathway(DbContext, tqRegistrationProfile, tqProvider ?? TqProviders.First());
tqRegistrationPathway.IsBulkUpload = isBulkUpload;
foreach (var specialism in TlSpecialisms)
{
var tqSpecialism = RegistrationsDataProvider.CreateTqRegistrationSpecialism(DbContext, tqRegistrationPathway, specialism);
tqSpecialism.IsBulkUpload = isBulkUpload;
tqRegistrationPathway.TqRegistrationSpecialisms.Add(tqSpecialism);
}
if (status == RegistrationPathwayStatus.Withdrawn)
{
tqRegistrationPathway.Status = status;
tqRegistrationPathway.EndDate = DateTime.UtcNow.AddDays(-1);
foreach (var tqRegistrationSpecialism in tqRegistrationPathway.TqRegistrationSpecialisms)
{
tqRegistrationSpecialism.IsOptedin = true;
tqRegistrationSpecialism.EndDate = DateTime.UtcNow.AddDays(-1);
}
}
DbContext.SaveChanges();
return(profile);
}
public TqRegistrationProfile SeedRegistrationData(long uln, TqProvider tqProvider = null)
{
var profile = new TqRegistrationProfileBuilder().BuildList().FirstOrDefault(p => p.UniqueLearnerNumber == uln);
var tqRegistrationProfile = RegistrationsDataProvider.CreateTqRegistrationProfile(DbContext, profile);
var tqRegistrationPathway = RegistrationsDataProvider.CreateTqRegistrationPathway(DbContext, tqRegistrationProfile, tqProvider ?? TqProviders.First());
var tqRegistrationSpecialism = RegistrationsDataProvider.CreateTqRegistrationSpecialism(DbContext, tqRegistrationPathway, TlSpecialisms.First());
DbContext.SaveChanges();
return(profile);
}
public List <TqRegistrationProfile> SeedRegistrationsData(List <long> ulns, TqProvider tqProvider = null)
{
var profiles = new List <TqRegistrationProfile>();
foreach (var uln in ulns)
{
profiles.Add(SeedRegistrationData(uln, tqProvider));
}
return(profiles);
}
protected virtual void SeedTestData(EnumAwardingOrganisation awardingOrganisation = EnumAwardingOrganisation.Pearson, bool seedMultipleProviders = false)
{
TlAwardingOrganisation = TlevelDataProvider.CreateTlAwardingOrganisation(DbContext, awardingOrganisation);
Route = TlevelDataProvider.CreateTlRoute(DbContext, awardingOrganisation);
Pathway = TlevelDataProvider.CreateTlPathway(DbContext, awardingOrganisation, Route);
Specialism = TlevelDataProvider.CreateTlSpecialisms(DbContext, awardingOrganisation, Pathway).First();
TqAwardingOrganisation = TlevelDataProvider.CreateTqAwardingOrganisation(DbContext, Pathway, TlAwardingOrganisation);
TlProvider = ProviderDataProvider.CreateTlProvider(DbContext);
TqProvider = ProviderDataProvider.CreateTqProvider(DbContext, TqAwardingOrganisation, TlProvider);
AssessmentSeries = AssessmentSeriesDataProvider.CreateAssessmentSeriesList(DbContext, null, true);
TlLookup = TlLookupDataProvider.CreateTlLookupList(DbContext, null, true);
DbContext.SaveChangesAsync();
}
protected virtual void SeedTestData(EnumAwardingOrganisation awardingOrganisation = EnumAwardingOrganisation.Pearson, bool seedMultipleProviders = false)
{
TlAwardingOrganisation = TlevelDataProvider.CreateTlAwardingOrganisation(DbContext, awardingOrganisation);
Route = TlevelDataProvider.CreateTlRoute(DbContext, awardingOrganisation);
Pathway = TlevelDataProvider.CreateTlPathway(DbContext, awardingOrganisation, Route);
Specialism = TlevelDataProvider.CreateTlSpecialisms(DbContext, awardingOrganisation, Pathway).First();
TqAwardingOrganisation = TlevelDataProvider.CreateTqAwardingOrganisation(DbContext, Pathway, TlAwardingOrganisation);
TlProvider = ProviderDataProvider.CreateTlProvider(DbContext);
TqProvider = ProviderDataProvider.CreateTqProvider(DbContext, TqAwardingOrganisation, TlProvider);
AssessmentSeries = AssessmentSeriesDataProvider.CreateAssessmentSeriesList(DbContext, null, true);
TlLookup = TlLookupDataProvider.CreateTlLookupList(DbContext, null, true);
PathwayComponentGrades = TlLookup.Where(x => x.Category.Equals(LookupCategory.PathwayComponentGrade.ToString(), StringComparison.InvariantCultureIgnoreCase)).ToList();
DbContext.SaveChangesAsync();
}
public static TqProvider CreateTqProvider(ResultsAndCertificationDbContext _dbContext, int tqAwardingOrganisationId, int tlProviderId, int pathwayId, bool addToDbContext = true)
{
var tqProvider = new TqProvider
{
TqAwardingOrganisationId = tqAwardingOrganisationId,
TlProviderId = tlProviderId,
};
if (addToDbContext)
{
_dbContext.Add(tqProvider);
}
return(tqProvider);
}
private void SeedRegistrationData(long uln)
{
_initialRegisteredTqProvider = TqProviders.First();
var profile = new TqRegistrationProfileBuilder().BuildList().FirstOrDefault(p => p.UniqueLearnerNumber == uln);
var tqRegistrationProfile = RegistrationsDataProvider.CreateTqRegistrationProfile(DbContext, profile);
var tqRegistrationPathway = RegistrationsDataProvider.CreateTqRegistrationPathway(DbContext, tqRegistrationProfile, _initialRegisteredTqProvider);
var specialisms = new TlSpecialismBuilder().BuildList(EnumAwardingOrganisation.Pearson, _initialRegisteredTqProvider.TqAwardingOrganisation.TlPathway);
foreach (var specialism in specialisms)
{
tqRegistrationPathway.TqRegistrationSpecialisms.Add(RegistrationsDataProvider.CreateTqRegistrationSpecialism(DbContext, tqRegistrationPathway, specialism));
}
DbContext.SaveChangesAsync();
}
public static TqProvider CreateTqProvider(ResultsAndCertificationDbContext _dbContext, TqAwardingOrganisation tqAwardingOrganisation, TlProvider tlProvider, bool addToDbContext = true)
{
if (tlProvider != null && tqAwardingOrganisation != null)
{
var tqProvider = new TqProvider
{
TlProviderId = tlProvider.Id,
TqAwardingOrganisationId = tqAwardingOrganisation.Id,
TqAwardingOrganisation = tqAwardingOrganisation
};
if (addToDbContext)
{
_dbContext.Add(tqProvider);
}
return(tqProvider);
}
return(null);
}
public TqRegistrationProfile SeedRegistrationDataByStatus(long uln, RegistrationPathwayStatus status = RegistrationPathwayStatus.Active, TqProvider tqProvider = null)
{
var profile = new TqRegistrationProfileBuilder().BuildList().FirstOrDefault(p => p.UniqueLearnerNumber == uln);
var tqRegistrationProfile = RegistrationsDataProvider.CreateTqRegistrationProfile(DbContext, profile);
var tqRegistrationPathway = RegistrationsDataProvider.CreateTqRegistrationPathway(DbContext, tqRegistrationProfile, tqProvider ?? TqProviders.First());
tqRegistrationPathway.Status = status;
var tqRegistrationSpecialism = RegistrationsDataProvider.CreateTqRegistrationSpecialism(DbContext, tqRegistrationPathway, Specialism);
if (status == RegistrationPathwayStatus.Withdrawn)
{
tqRegistrationPathway.EndDate = DateTime.UtcNow.AddDays(-1);
tqRegistrationSpecialism.IsOptedin = true;
tqRegistrationSpecialism.EndDate = DateTime.UtcNow.AddDays(-1);
}
DbContext.SaveChanges();
return(profile);
}
public static TqRegistrationPathway CreateTqRegistrationPathway(ResultsAndCertificationDbContext _dbContext, TqRegistrationProfile tqRegistrationProfile, TqProvider tqProvider, bool addToDbContext = true)
{
if (tqRegistrationProfile == null)
{
tqRegistrationProfile = new TqRegistrationProfileBuilder().Build();
}
var tqRegistrationPathway = new TqRegistrationPathwayBuilder().Build(tqRegistrationProfile);
if (tqProvider != null)
{
tqRegistrationPathway.TqProviderId = tqProvider.Id;
tqRegistrationPathway.TqProvider = tqProvider;
}
if (addToDbContext)
{
_dbContext.Add(tqRegistrationPathway);
}
return(tqRegistrationPathway);
}
public List <TqRegistrationProfile> SeedRegistrationsDataByStatus(Dictionary <long, RegistrationPathwayStatus> ulns, TqProvider tqProvider = null)
{
var profiles = new List <TqRegistrationProfile>();
foreach (var uln in ulns)
{
profiles.Add(SeedRegistrationDataByStatus(uln.Key, uln.Value, tqProvider));
}
return(profiles);
}
public List <TqRegistrationProfile> GetRegistrationsDataToProcess(List <long> ulns, TqProvider tqProvider = null)
{
var tqRegistrationProfiles = new List <TqRegistrationProfile>();
foreach (var(uln, index) in ulns.Select((value, i) => (value, i)))
{
tqProvider ??= TqProviders[index];
var profile = new TqRegistrationProfileBuilder().BuildList().FirstOrDefault(p => p.UniqueLearnerNumber == uln);
var tqRegistrationProfile = RegistrationsDataProvider.CreateTqRegistrationProfile(DbContext, profile, false);
var tqRegistrationPathway = RegistrationsDataProvider.CreateTqRegistrationPathway(DbContext, tqRegistrationProfile, tqProvider, false);
foreach (var specialism in TlSpecialisms)
{
tqRegistrationPathway.TqRegistrationSpecialisms.Add(RegistrationsDataProvider.CreateTqRegistrationSpecialism(DbContext, tqRegistrationPathway, specialism, addToDbContext: false));
}
tqRegistrationProfile.TqRegistrationPathways = new List <TqRegistrationPathway> {
tqRegistrationPathway
};
tqRegistrationProfiles.Add(tqRegistrationProfile);
}
return(tqRegistrationProfiles);
}
public TqRegistrationProfile GetRegistrationsDataToProcess(long uln, TqProvider tqProvider = null)
{
return(GetRegistrationsDataToProcess(new List <long> {
uln
}, tqProvider).First());
}
