public void SetUpOrganisationTests()
{
var databaseConnection = new SqlConnection(_databaseService.WebConfiguration.SqlConnectionString);
var unitOfWork = new UnitOfWork(databaseConnection);
_validationRepository = new RegisterValidationRepository(unitOfWork);
_organisationId1 = "EPA0088";
_ukprn1 = 876533;
_ukprn2 = 9888;
_organisation1 = new OrganisationModel
{
Id = Guid.NewGuid(),
CreatedAt = DateTime.Now.AddYears(-1).Date,
DeletedAt = null,
EndPointAssessorName = "Name 1",
EndPointAssessorOrganisationId = _organisationId1,
EndPointAssessorUkprn = _ukprn1,
PrimaryContact = null,
Status = "new",
UpdatedAt = null,
OrganisationTypeId = null,
OrganisationData = null
};
_organisation2 = new OrganisationModel
{
Id = Guid.NewGuid(),
CreatedAt = DateTime.Now.AddMonths(-1).Date,
DeletedAt = null,
EndPointAssessorName = "Name 2",
EndPointAssessorOrganisationId = "EPA0002",
EndPointAssessorUkprn = _ukprn2,
PrimaryContact = null,
Status = "new",
UpdatedAt = null,
OrganisationTypeId = null,
OrganisationData = null
};
OrganisationHandler.InsertRecords(new List <OrganisationModel> {
_organisation1, _organisation2
});
}
public void SetupOrganisationTests()
{
_repository = new RegisterQueryRepository(_databaseService.WebConfiguration);
_organisationId1 = "EPA0001";
_organisationId2 = "EPA005";
_ukprn1 = 876544;
_organisation1 = new OrganisationModel
{
Id = Guid.NewGuid(),
CreatedAt = DateTime.Now.AddYears(-1).Date,
DeletedAt = null,
EndPointAssessorName = "Name 1",
EndPointAssessorOrganisationId = _organisationId1,
EndPointAssessorUkprn = _ukprn1,
PrimaryContact = null,
Status = "new",
UpdatedAt = null,
OrganisationTypeId = null,
OrganisationData = null
};
_organisation2 = new OrganisationModel
{
Id = Guid.NewGuid(),
CreatedAt = DateTime.Now.AddMonths(-1).Date,
DeletedAt = null,
EndPointAssessorName = "Name 2",
EndPointAssessorOrganisationId = _organisationId2,
EndPointAssessorUkprn = 9888,
PrimaryContact = null,
Status = "new",
UpdatedAt = null,
OrganisationTypeId = null,
OrganisationData = null
};
OrganisationHandler.InsertRecords(new List <OrganisationModel> {
_organisation1, _organisation2
});
}
public void SetupOrganisationTests()
{
_repository = new RegisterQueryRepository(_databaseService.WebConfiguration);
_organisationId1 = "EPA00010";
_organisationId2 = "EPA0050";
_organisationId3 = "EPA0060";
_organisationId4 = "EPA0075";
_ukprn1 = 876544;
_organisation1 = new OrganisationModel
{
Id = Guid.NewGuid(),
CreatedAt = DateTime.Now.AddYears(-1).Date,
DeletedAt = null,
EndPointAssessorName = "Name 1",
EndPointAssessorOrganisationId = _organisationId1,
EndPointAssessorUkprn = _ukprn1,
PrimaryContact = null,
Status = "new",
UpdatedAt = null,
OrganisationTypeId = null,
OrganisationData = null
};
_organisation2 = new OrganisationModel
{
Id = Guid.NewGuid(),
CreatedAt = DateTime.Now.AddMonths(-1).Date,
DeletedAt = null,
EndPointAssessorName = "Name 2",
EndPointAssessorOrganisationId = _organisationId2,
EndPointAssessorUkprn = 9888,
PrimaryContact = null,
Status = "new",
UpdatedAt = null,
OrganisationTypeId = null,
OrganisationData = null
};
_organisation3 = new OrganisationModel
{
Id = Guid.NewGuid(),
CreatedAt = DateTime.Now.AddMonths(-1).Date,
DeletedAt = null,
EndPointAssessorName = "companyNumber 3",
EndPointAssessorOrganisationId = _organisationId3,
EndPointAssessorUkprn = 9888,
PrimaryContact = null,
Status = "new",
UpdatedAt = null,
OrganisationTypeId = null,
OrganisationData = "{\"LegalName\":\"City and Guilds(London / ILM)\",\"CompanyNumber\":\"" + "companyNumber 3" + "\",\"CharityNumber\":\"10009931\"}"
};
_organisation4 = new OrganisationModel
{
Id = Guid.NewGuid(),
CreatedAt = DateTime.Now.AddMonths(-1).Date,
DeletedAt = null,
EndPointAssessorName = "companyNumber 4",
EndPointAssessorOrganisationId = _organisationId4,
EndPointAssessorUkprn = 9888,
PrimaryContact = null,
Status = "new",
UpdatedAt = null,
OrganisationTypeId = null,
OrganisationData = "{\"LegalName\":\"City and Guilds(London / ILM)\",\"CompanyNumber\":\"1234\",\"CharityNumber\":\"charity 4\"}"
};
OrganisationHandler.DeleteAllRecords();
OrganisationHandler.InsertRecords(new List <OrganisationModel> {
_organisation1, _organisation2, _organisation3, _organisation4
});
}
public void SetupOrganisationTests()
{
_organisationIdCreated = "EPA0987";
_repository = new RegisterQueryRepository(_databaseService.WebConfiguration);
_organisationId1 = "EPA0987";
_organisation1 = new OrganisationModel
{
Id = Guid.NewGuid(),
CreatedAt = DateTime.Now.AddYears(-1).Date,
DeletedAt = null,
EndPointAssessorName = "Name 1",
EndPointAssessorOrganisationId = _organisationId1,
EndPointAssessorUkprn = 876544,
PrimaryContact = null,
Status = "new",
UpdatedAt = null,
OrganisationTypeId = null,
OrganisationData = null
};
_organisationStandard = new OrganisationStandardModel
{
Id = _orgStandardId,
EndPointAssessorOrganisationId = _organisationIdCreated,
StandardCode = _standardCode,
Status = OrganisationStatus.New,
EffectiveFrom = DateTime.Today.AddDays(-7),
EffectiveTo = DateTime.Today.AddDays(10),
DateStandardApprovedOnRegister = DateTime.Today.AddDays(-50),
Comments = "comments go here"
};
_deliveryArea1 = new DeliveryAreaModel {
Id = 10, Status = "Live", Area = "North West"
};
_deliveryArea2 = new DeliveryAreaModel {
Id = 20, Status = "New", Area = "Some Other"
};
var deliveryAreas = new List <DeliveryAreaModel> {
_deliveryArea1, _deliveryArea2
};
DeliveryAreaHandler.InsertRecords(deliveryAreas);
var deliveryArea1 = new OrganisationStandardDeliveryAreaModel {
Id = _deliveryAreaId1,
Comments = "comments 1",
DeliveryAreaId = _deliveryArea1.Id,
OrganisationStandardId = _orgStandardId,
Status = OrganisationStatus.New,
};
var deliveryArea2 = new OrganisationStandardDeliveryAreaModel {
Id = _deliveryAreaId2,
Comments = "comments 1",
DeliveryAreaId = _deliveryArea2.Id,
OrganisationStandardId = _orgStandardId,
Status = OrganisationStatus.New
};
OrganisationHandler.InsertRecords(new List <OrganisationModel> {
_organisation1
});
OrganisationStandardHandler.InsertRecord(_organisationStandard);
OrganisationStandardDeliveryAreaHandler.InsertRecords(new List <OrganisationStandardDeliveryAreaModel> {
deliveryArea1, deliveryArea2
});
}
public void ExpectedLatestDateIsReturnedWithUpdatedTakingPrecedence()
{
var organisations = new List <OrganisationModel>
{
new OrganisationModel
{
UKPRN = 23423,
ProviderTypeId = 1,
OrganisationTypeId = 1,
StatusId = OrganisationStatusHandler.Removed,
StatusDate = DateTime.Today.AddDays(-10),
LegalName = "Provider 1",
Id = Guid.NewGuid(),
CreatedAt = DateTime.Now,
CreatedBy = "Test"
},
new OrganisationModel
{
UKPRN = 54675,
ProviderTypeId = 2,
OrganisationTypeId = 2,
StatusId = OrganisationStatusHandler.Active,
StatusDate = DateTime.Today.AddDays(-10),
LegalName = "Provider 2",
Id = Guid.NewGuid(),
CreatedAt = DateTime.Now,
CreatedBy = "Test"
},
new OrganisationModel
{
UKPRN = 79878,
ProviderTypeId = 3,
OrganisationTypeId = 3,
StatusId = OrganisationStatusHandler.ActiveNotTakingOnApprentices,
StatusDate = DateTime.Today.AddDays(-10),
LegalName = "Provider 3",
Id = Guid.NewGuid(),
CreatedAt = DateTime.Now,
CreatedBy = "Test"
},
new OrganisationModel
{
UKPRN = 3784,
ProviderTypeId = 4,
OrganisationTypeId = 4,
StatusId = OrganisationStatusHandler.Onboarding,
StatusDate = DateTime.Today.AddDays(-10),
LegalName = "Provider 4",
Id = Guid.NewGuid(),
CreatedAt = DateTime.Now,
CreatedBy = "Test"
}
};
OrganisationHandler.InsertRecords(organisations);
var dataExportResult = _repository.GetFatDataExport().Result.ToList();
dataExportResult.Count.Should().Be(organisations.Count);
foreach (var organisation in organisations)
{
dataExportResult.Should().Contain(obj =>
obj.ToString().Contains(
$"UKPRN = '{organisation.UKPRN}', " +
$"StatusDate = '{organisation.StatusDate}', " +
$"StatusId = '{organisation.StatusId}', " +
$"OrganisationTypeId = '{organisation.OrganisationTypeId}', " +
$"ProviderTypeId = '{organisation.ProviderTypeId}'"));
}
}
public void SetupOrganisationTests()
{
var databaseConnection = new SqlConnection(_databaseService.WebConfiguration.SqlConnectionString);
var unitOfWork = new UnitOfWork(databaseConnection);
_repository = new RegisterQueryRepository(unitOfWork);
_organisationIdCreated = "EPA0987";
_organisationId1 = "EPA0987";
_organisation1 = new OrganisationModel
{
Id = Guid.NewGuid(),
CreatedAt = DateTime.Now.AddYears(-1).Date,
DeletedAt = null,
EndPointAssessorName = "Name 1",
EndPointAssessorOrganisationId = _organisationId1,
EndPointAssessorUkprn = 876544,
PrimaryContact = null,
Status = "new",
UpdatedAt = null,
OrganisationTypeId = null,
OrganisationData = null
};
_organisationStandard = new OrganisationStandardModel
{
Id = _orgStandardId,
EndPointAssessorOrganisationId = _organisationIdCreated,
StandardCode = _standardCode,
Status = OrganisationStatus.New,
EffectiveFrom = DateTime.Today.AddDays(-7),
EffectiveTo = DateTime.Today.AddDays(10),
DateStandardApprovedOnRegister = DateTime.Today.AddDays(-50),
Comments = "comments go here"
};
_deliveryArea1 = new DeliveryAreaModel {
Id = 10, Status = "Live", Area = "North West"
};
_deliveryArea2 = new DeliveryAreaModel {
Id = 20, Status = "New", Area = "Some Other"
};
var deliveryAreas = new List <DeliveryAreaModel> {
_deliveryArea1, _deliveryArea2
};
DeliveryAreaHandler.InsertRecords(deliveryAreas);
var deliveryArea1 = new OrganisationStandardDeliveryAreaModel
{
Id = _deliveryAreaId1,
Comments = "comments 1",
DeliveryAreaId = _deliveryArea1.Id,
OrganisationStandardId = _orgStandardId,
Status = OrganisationStatus.New,
};
var deliveryArea2 = new OrganisationStandardDeliveryAreaModel
{
Id = _deliveryAreaId2,
Comments = "comments 1",
DeliveryAreaId = _deliveryArea2.Id,
OrganisationStandardId = _orgStandardId,
Status = OrganisationStatus.New
};
var organistionStandardVersion1 = new OrganisationStandardVersionModel
{
OrganisationStandardId = _orgStandardId,
StandardUId = _standardUID1,
EffectiveFrom = DateTime.Now.AddMonths(-12),
EffectiveTo = DateTime.Now.AddMonths(-3),
Version = "1.0",
DateVersionApproved = DateTime.Now.AddMonths(-12),
Status = "Live"
};
var organistionStandardVersion2 = new OrganisationStandardVersionModel
{
OrganisationStandardId = _orgStandardId,
StandardUId = _standardUID2,
EffectiveFrom = DateTime.Now.AddMonths(-3),
EffectiveTo = null,
Version = "1.1",
DateVersionApproved = DateTime.Now.AddMonths(-3),
Status = "Live"
};
var standardModel1 = new StandardModel
{
StandardUId = _standardUID1,
IFateReferenceNumber = "ST0001",
Version = "1.0",
Title = "Standard",
Level = 4,
Status = "Approved for Delivery",
TypicalDuration = 12,
TrailblazerContact = "Contact name",
StandardPageUrl = "www.standard.com",
OverviewOfRole = "Explanation of apprenticeship job role"
};
var standardModel2 = new StandardModel
{
StandardUId = _standardUID2,
IFateReferenceNumber = "ST0001",
Version = "1.1",
Title = "Standard",
Level = 4,
Status = "Approved for Delivery",
TypicalDuration = 12,
TrailblazerContact = "Contact name",
StandardPageUrl = "www.standard.com",
OverviewOfRole = "Explanation of apprenticeship job role"
};
OrganisationHandler.InsertRecords(new List <OrganisationModel> {
_organisation1
});
OrganisationStandardHandler.InsertRecord(_organisationStandard);
OrganisationStandardDeliveryAreaHandler.InsertRecords(new List <OrganisationStandardDeliveryAreaModel> {
deliveryArea1, deliveryArea2
});
OrganisationStandardVersionHandler.InsertRecord(organistionStandardVersion1);
OrganisationStandardVersionHandler.InsertRecord(organistionStandardVersion2);
StandardsHandler.InsertRecords(new List <StandardModel> {
standardModel1, standardModel2
});
}
public async Task SetupCertificateTests()
{
var option = new DbContextOptionsBuilder <AssessorDbContext>();
option.UseSqlServer(_databaseService.WebConfiguration.SqlConnectionString, options => options.EnableRetryOnFailure(3));
_context = new AssessorDbContext(option.Options);
_unitOfWork = new UnitOfWork(new SqlConnection(_databaseService.WebConfiguration.SqlConnectionString));
_repository = new CertificateRepository(_unitOfWork, _context);
OrganisationTypeHandler.InsertRecord(
new OrganisationTypeModel
{
Id = _organisationTypeId,
Status = "Live",
Type = "Organisation Type A"
});
_organisation = new OrganisationModel
{
Id = _organisationId,
CreatedAt = DateTime.Now,
EndPointAssessorName = "Epao Name 1",
EndPointAssessorOrganisationId = "EPA0200",
EndPointAssessorUkprn = 1234567890,
PrimaryContact = null,
OrganisationTypeId = _organisationTypeId,
OrganisationData = null,
Status = OrganisationStatus.New
};
OrganisationHandler.InsertRecords(
new List <OrganisationModel>()
{
_organisation
});
var certData = new CertificateData()
{
LearnerGivenNames = "Test",
LearnerFamilyName = "Person",
LearningStartDate = DateTime.Now,
StandardReference = "ST0100",
StandardName = "Software Tester",
StandardLevel = 1,
StandardPublicationDate = DateTime.Now.AddDays(-356),
FullName = $"Test Person",
ProviderName = _organisation.EndPointAssessorName,
EpaDetails = new EpaDetails {
Epas = new List <EpaRecord>()
}
};
var certificate = new Certificate()
{
Uln = 123456789,
StandardCode = 1,
ProviderUkPrn = _organisation.EndPointAssessorUkprn.Value,
OrganisationId = _organisation.Id,
CreatedBy = "Tester",
CertificateData = JsonConvert.SerializeObject(certData),
Status = CertificateStatus.Draft,
CertificateReference = string.Empty,
LearnRefNumber = "1234567890",
CreateDay = DateTime.UtcNow.Date,
IsPrivatelyFunded = true
};
_createdCertificate = await _repository.NewPrivate(certificate, "EPA0200");
}