public void TearDownOrganisationTests()
{
OrganisationHandler.DeleteRecordByOrganisationId(_organisationIdCreated);
OrganisationTypeHandler.DeleteRecord(_organisationTypeIdBefore);
OrganisationTypeHandler.DeleteRecord(_organisationTypeIdAfter);
}
public void Updated_by_is_correct()
{
var changedOrganisation = OrganisationHandler.GetOrganisationFromId(_organisationId);
Assert.AreEqual(_changedBy, changedOrganisation.UpdatedBy);
}
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");
}
public void TearDownOrganisationTests()
{
OrganisationHandler.DeleteRecordByEndPointAssessorOrganisationId(_organisationIdCreated);
OrganisationTypeHandler.DeleteRecord(_organisationTypeId);
}
public void TearDownCertificateTests()
{
CertificateHandler.DeleteRecord(_createdCertificate.Id);
OrganisationHandler.DeleteRecordByEndPointAssessorOrganisationId("EPA0200");
OrganisationTypeHandler.DeleteRecord(_organisationTypeId);
}
public void SetUpOrganisationTests()
{
_repository = new RegisterRepository(_databaseService.WebConfiguration, new Mock <ILogger <RegisterRepository> >().Object);
_validationRepository = new RegisterValidationRepository(_databaseService.WebConfiguration);
_organisationIdCreated = "EPA0987";
_organisationTypeId = 5;
OrganisationTypeHandler.InsertRecord(new OrganisationTypeModel {
Id = _organisationTypeId, Status = "new", Type = "organisation type 1"
});
_id = Guid.NewGuid();
_organisation = new OrganisationModel
{
Id = _id,
CreatedAt = DateTime.Now,
EndPointAssessorName = "name 2",
EndPointAssessorOrganisationId = _organisationIdCreated,
PrimaryContact = null,
OrganisationTypeId = _organisationTypeId,
OrganisationData = null,
Status = OrganisationStatus.New
};
_username = "******";
OrganisationHandler.InsertRecord(_organisation);
_contactId = Guid.NewGuid();
_contactModel = new OrganisationContactModel
{
Id = _contactId,
EndPointAssessorOrganisationId = _organisationIdCreated,
OrganisationId = _id,
Username = _username,
DisplayName = "Joe Cool",
Email = "*****@*****.**",
PhoneNumber = "555 55555",
Status = OrganisationStatus.Live
};
_contactBeforeChange = new EpaContact
{
Id = _contactId,
EndPointAssessorOrganisationId = _organisationIdCreated,
Username = _username,
DisplayName = "Joe Cool",
Email = "*****@*****.**",
PhoneNumber = "555 55555",
Status = OrganisationStatus.Live
};
_contactUpdated = new EpaContact
{
Id = _contactId,
EndPointAssessorOrganisationId = _organisationIdCreated,
Username = _username,
DisplayName = "Joe Cool changes",
Email = "*****@*****.**",
PhoneNumber = "555 44444",
Status = OrganisationStatus.Live
};
OrganisationContactHandler.InsertRecord(_contactModel);
}
public void TearDownOrganisationTests()
{
OrganisationContactHandler.DeleteRecordByUserName(_username);
OrganisationHandler.DeleteRecordByEndPointAssessorOrganisationId(_organisationIdCreated);
OrganisationTypeHandler.DeleteRecord(_organisationTypeId);
}
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
};
OrganisationHandler.InsertRecords(new List <OrganisationModel> {
_organisation1
});
OrganisationStandardHandler.InsertRecord(_organisationStandard);
OrganisationStandardDeliveryAreaHandler.InsertRecords(new List <OrganisationStandardDeliveryAreaModel> {
deliveryArea1, deliveryArea2
});
}
public void TearDownOrganisationTests()
{
OrganisationHandler.DeleteRecords(new List <Guid> {
_organisation1.Id, _organisation2.Id
});
}
