public void Before_the_tests()
{
_organisationTypeId1 = 1;
_repository = new OrganisationRepository(_databaseService.WebConfiguration);
_statusActive = new OrganisationStatusModel {
Id = _organisationStatusIdActive, Status = "Live", CreatedAt = DateTime.Now, CreatedBy = "TestSystem"
};
_statusOnboarding = new OrganisationStatusModel {
Id = _organisationStatusIdOnboarding, Status = "Live", CreatedAt = DateTime.Now, CreatedBy = "TestSystem"
};
OrganisationStatusHandler.InsertRecord(_statusActive);
OrganisationStatusHandler.InsertRecord(_statusOnboarding);
_providerType1 = new ProviderTypeModel {
Id = _providerTypeIdMainProvider, ProviderType = "Main Provider", Description = "provider type description 1", CreatedAt = DateTime.Now, CreatedBy = "TestSystem", Status = "Live"
};
_providerType2 = new ProviderTypeModel {
Id = _providerTypeIdEmployerProvider, ProviderType = "Employer Provider", Description = "provider type description 2", CreatedAt = DateTime.Now, CreatedBy = "TestSystem", Status = "Live"
};
_providerType3 = new ProviderTypeModel {
Id = _providerTypeIdSupportingProvider, ProviderType = "Supporting Provider", Description = "provider type description 3", CreatedAt = DateTime.Now, CreatedBy = "TestSystem", Status = "Live"
};
ProviderTypeHandler.InsertRecords(new List <ProviderTypeModel> {
_providerType1, _providerType2, _providerType3
});
_organisationTypeModel1 = new OrganisationTypeModel {
Id = _organisationTypeId1, Type = "organisation type 10", Description = "organisation type description", CreatedAt = DateTime.Now, CreatedBy = "TestSystem", Status = "Live"
};
OrganisationTypeHandler.InsertRecord(_organisationTypeModel1);
}
public void setup_organisation_subtables_are_added()
{
_providerTypeId1 = 10;
_organisationTypeId1 = 100;
_organisationUkprn = 11114433;
_organisationUkprn2 = 11114432;
_legalName = "Legal name 1";
_organisationId = Guid.NewGuid();
_organisationId2 = Guid.NewGuid();
_repository = new DownloadRegisterRepository(_databaseService.DbConnectionHelper);
OrganisationStatusHandler.InsertRecords(
new List <OrganisationStatusModel>
{
new OrganisationStatusModel {
Id = OrganisationStatusHandler.Active, Status = "Active", CreatedAt = DateTime.Now, CreatedBy = "TestSystem"
},
new OrganisationStatusModel {
Id = OrganisationStatusHandler.Removed, Status = "Removed", CreatedAt = DateTime.Now, CreatedBy = "TestSystem"
},
new OrganisationStatusModel {
Id = OrganisationStatusHandler.ActiveNotTakingOnApprentices, Status = "Active - but not taking on apprentices", CreatedAt = DateTime.Now, CreatedBy = "TestSystem"
},
new OrganisationStatusModel {
Id = OrganisationStatusHandler.Onboarding, Status = "On-boarding", CreatedAt = DateTime.Now, CreatedBy = "TestSystem"
}
});
_providerType1 = new ProviderTypeModel {
Id = _providerTypeId1, ProviderType = "provider type 10", Description = "provider type description", CreatedAt = DateTime.Now, CreatedBy = "TestSystem", Status = "Live"
};
ProviderTypeHandler.InsertRecord(_providerType1);
_organisationTypeModel1 = new OrganisationTypeModel {
Id = _organisationTypeId1, Type = "organisation type 10", Description = "organisation type description", CreatedAt = DateTime.Now, CreatedBy = "TestSystem", Status = "Live"
};
OrganisationTypeHandler.InsertRecord(_organisationTypeModel1);
}
public void setup_organisation_is_added()
{
_organisationStatusId1 = 1;
_providerTypeId1 = 10;
_organisationTypeId1 = 100;
_organisationUkprn = 11114433;
_legalName = "Legal name 1";
_organisationId = Guid.NewGuid();
_repository = new OrganisationRepository(_databaseService.WebConfiguration);
_status1 = new OrganisationStatusModel {
Id = _organisationStatusId1, Status = "Live", CreatedAt = DateTime.Now, CreatedBy = "TestSystem"
};
OrganisationStatusHandler.InsertRecord(_status1);
_providerType1 = new ProviderTypeModel {
Id = _providerTypeId1, ProviderType = "provider type 10", Description = "provider type description", CreatedAt = DateTime.Now, CreatedBy = "TestSystem", Status = "Live"
};
ProviderTypeHandler.InsertRecord(_providerType1);
_organisationTypeModel1 = new OrganisationTypeModel {
Id = _organisationTypeId1, Type = "organisation type 10", Description = "organisation type description", CreatedAt = DateTime.Now, CreatedBy = "TestSystem", Status = "Live"
};
OrganisationTypeHandler.InsertRecord(_organisationTypeModel1);
_organisation = new OrganisationModel
{
UKPRN = _organisationUkprn,
OrganisationTypeId = _organisationTypeId1,
ProviderTypeId = _providerTypeId1,
StatusId = _organisationStatusId1,
StatusDate = DateTime.Today.AddDays(5),
LegalName = _legalName,
Id = _organisationId,
CreatedAt = DateTime.Now,
CreatedBy = "Test"
};
OrganisationHandler.InsertRecord(_organisation);
}
public void SetUpOrganisationTests()
{
var databaseConnection = new SqlConnection(_databaseService.WebConfiguration.SqlConnectionString);
var unitOfWork = new UnitOfWork(databaseConnection);
_repository = new RegisterRepository(unitOfWork, new Mock <ILogger <RegisterRepository> >().Object);
_validationRepository = new RegisterValidationRepository(unitOfWork);
_organisationIdCreated = "EPA0987";
_ukprnCreated = 123321;
_org2IdCreated = "EPA0001";
_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,
EndPointAssessorUkprn = _ukprnCreated,
PrimaryContact = null,
OrganisationTypeId = _organisationTypeId,
OrganisationData = null,
Status = OrganisationStatus.New
};
_organisation2 = new OrganisationModel
{
Id = Guid.NewGuid(),
CreatedAt = DateTime.Now,
EndPointAssessorName = "name 1",
EndPointAssessorOrganisationId = _org2IdCreated,
OrganisationTypeId = null,
Status = OrganisationStatus.New
};
_username = "******";
OrganisationHandler.InsertRecord(_organisation);
OrganisationHandler.InsertRecord(_organisation2);
_contactId = Guid.NewGuid();
_contact = new EpaContact
{
Id = _contactId,
EndPointAssessorOrganisationId = _organisationIdCreated,
Username = _username,
DisplayName = "Joe Cool",
Email = "*****@*****.**",
PhoneNumber = "555 55555",
Status = OrganisationStatus.New,
SigninType = "",
FirstName = "zzz",
LastName = "Ftagn"
};
}
public void Tear_down()
{
OrganisationCategoryOrgTypeProviderTypeHandler.DeleteAllRecords();
OrganisationCategoryHandler.DeleteAllRecords();
ProviderTypeHandler.DeleteAllRecords();
OrganisationTypeHandler.DeleteAllRecords();
}
public void TearDownOrganisationTests()
{
OrganisationContactHandler.DeleteRecordByUserName(_username);
OrganisationHandler.DeleteRecordByEndPointAssessorOrganisationId(_organisationIdCreated);
OrganisationHandler.DeleteRecordByEndPointAssessorOrganisationId(_org2IdCreated);
OrganisationTypeHandler.DeleteRecord(_organisationTypeId);
}
public void tear_down()
{
OrganisationHandler.DeleteAllRecords();
OrganisationTypeHandler.DeleteRecord(_organisationTypeId1);
ProviderTypeHandler.DeleteAllRecords();
OrganisationStatusHandler.DeleteAllRecords();
}
public void TearDownCertificateTests()
{
CertificateLogsHandler.DeleteRecord(_createdCertificate.Id);
CertificateHandler.DeleteRecord(_createdCertificate.Id);
OrganisationHandler.DeleteRecordByEndPointAssessorOrganisationId("EPA0200");
OrganisationTypeHandler.DeleteRecord(_organisationTypeId);
}
public void Set_up_and_run_update()
{
_organisationStatusId1 = 1;
_organisationStatusId0 = 0;
_providerTypeId1 = 10;
_organisationTypeId1 = 100;
_organisationUkprn = 11114433;
_legalName = "Legal name 1";
_organisationId = Guid.NewGuid();
_updateOrganisationRepository = new UpdateOrganisationRepository(_databaseService.DbConnectionHelper);
_repository = new OrganisationRepository(_databaseService.DbConnectionHelper);
_status1 = new OrganisationStatusModel {
Id = _organisationStatusId1, Status = "Live", CreatedAt = DateTime.Now, CreatedBy = "TestSystem"
};
OrganisationStatusHandler.InsertRecord(_status1);
_status2 = new OrganisationStatusModel {
Id = _organisationStatusId0, Status = "Live", CreatedAt = DateTime.Now, CreatedBy = "TestSystem"
};
OrganisationStatusHandler.InsertRecord(_status2);
_reason1 = new RemovedReasonModel {
Id = 1, CreatedBy = "System", Reason = "Test reason", Status = "Live"
};
RemovedReasonHandler.InsertRecord(_reason1);
_reason2 = new RemovedReasonModel {
Id = 2, CreatedBy = "System", Reason = "Test reason 2", Status = "Live"
};
RemovedReasonHandler.InsertRecord(_reason2);
_providerType1 = new ProviderTypeModel {
Id = _providerTypeId1, ProviderType = "provider type 10", Description = "provider type description", CreatedAt = DateTime.Now, CreatedBy = "TestSystem", Status = "Live"
};
ProviderTypeHandler.InsertRecord(_providerType1);
_organisationTypeModel1 = new OrganisationTypeModel {
Id = _organisationTypeId1, Type = "organisation type 10", Description = "organisation type description", CreatedAt = DateTime.Now, CreatedBy = "TestSystem", Status = "Live"
};
OrganisationTypeHandler.InsertRecord(_organisationTypeModel1);
var json = "{ \"CompanyNumber\":\"12345678\",\"CharityNumber\":\"1234567\",\"ParentCompanyGuarantee\":false,\"FinancialTrackRecord\":true,\"NonLevyContract\":false,\"StartDate\":\"2019-03-27 00:00:00\",\"RemovedReason\":{\"Id\":1,\"Reason\":\"Test reason\",\"Description\":null,\"CreatedBy\":\"System\",\"CreatedAt\":\"2019-02-11 15:47:23\",\"UpdatedBy\":null,\"UpdatedAt\":null,\"Status\":\"Live\"}}";
_organisation = new OrganisationModel
{
UKPRN = _organisationUkprn,
OrganisationTypeId = _organisationTypeId1,
ProviderTypeId = _providerTypeId1,
StatusId = _organisationStatusId1,
StatusDate = DateTime.Today.AddDays(5),
LegalName = _legalName,
Id = _organisationId,
CreatedAt = DateTime.Now,
CreatedBy = "Test",
OrganisationData = json
};
OrganisationHandler.InsertRecord(_organisation);
_changedBy = "SystemChange";
var _updatedReason = _updateOrganisationRepository.UpdateStatusWithRemovedReason(_organisationId, _organisationStatusId0, _reason2.Id, _changedBy).Result;
_successfulUpdate = (_updatedReason != null);
_newOrganisationStatusId = _repository.GetOrganisationStatus(_organisationId).Result;
}
public void Tear_down()
{
OrganisationHandler.DeleteAllRecords();
OrganisationTypeHandler.DeleteRecord(_organisationTypeId1);
ProviderTypeHandler.DeleteAllRecords();
OrganisationStatusHandler.DeleteRecords(new List <int> {
_status1.Id
});
}
public void Before_the_tests()
{
_lookupRepository = new LookupDataRepository(_databaseService.WebConfiguration, _cacheHelper);
_providerTypeId1 = 1;
_providerTypeId2 = 2;
_organisationTypeId1WithProviderTypeId1CategoryId1 = 10;
_organisationTypeId2WithProviderTypeId1CategoryId1 = 20;
_organisationTypeId3WithProviderTypeId1CategoryId1 = 30;
_organisationTypeId3WithProviderTypeId2CategoryId1 = 40;
_organisationTypeId4WithProviderTypeId2 = 100;
_cacheHelper.PurgeAllCaches();
_categoryId1 = 1;
_categoryId2 = 2;
OrganisationTypeHandler.InsertRecord(new OrganisationTypeModel {
Id = _organisationTypeId1WithProviderTypeId1CategoryId1, CreatedAt = DateTime.Now, CreatedBy = "system", Status = "x", Type = "a"
});
OrganisationTypeHandler.InsertRecord(new OrganisationTypeModel {
Id = _organisationTypeId2WithProviderTypeId1CategoryId1, CreatedAt = DateTime.Now, CreatedBy = "system", Status = "x", Type = "b"
});
OrganisationTypeHandler.InsertRecord(new OrganisationTypeModel {
Id = _organisationTypeId3WithProviderTypeId1CategoryId1, CreatedAt = DateTime.Now, CreatedBy = "system", Status = "x", Type = "c"
});
OrganisationTypeHandler.InsertRecord(new OrganisationTypeModel {
Id = _organisationTypeId3WithProviderTypeId2CategoryId1, CreatedAt = DateTime.Now, CreatedBy = "system", Status = "x", Type = "c"
});
OrganisationTypeHandler.InsertRecord(new OrganisationTypeModel {
Id = _organisationTypeId4WithProviderTypeId2, CreatedAt = DateTime.Now, CreatedBy = "system", Status = "x", Type = "d"
});
ProviderTypeHandler.InsertRecord(new ProviderTypeModel {
Id = _providerTypeId1, CreatedAt = DateTime.Now, CreatedBy = "system", Status = "x", ProviderType = "a"
});
ProviderTypeHandler.InsertRecord(new ProviderTypeModel {
Id = _providerTypeId2, CreatedAt = DateTime.Now, CreatedBy = "system", Status = "x", ProviderType = "b"
});
OrganisationCategoryHandler.InsertRecord(new OrganisationCategoryModel {
Id = _categoryId1, Category = "category 1", CreatedAt = DateTime.Now, CreatedBy = "system", Status = "x"
});
OrganisationCategoryHandler.InsertRecord(new OrganisationCategoryModel {
Id = _categoryId2, Category = "category 2", CreatedAt = DateTime.Now, CreatedBy = "system", Status = "x"
});
OrganisationCategoryOrgTypeProviderTypeHandler.InsertRecord(new OrganisationCategoryOrgTypeProviderTypeModel {
Id = 1, OrganisationTypeId = _organisationTypeId1WithProviderTypeId1CategoryId1, ProviderTypeId = _providerTypeId1, OrganisationCategoryId = _categoryId1, CreatedAt = DateTime.Now, CreatedBy = "system", Status = "x"
});
OrganisationCategoryOrgTypeProviderTypeHandler.InsertRecord(new OrganisationCategoryOrgTypeProviderTypeModel {
Id = 2, OrganisationTypeId = _organisationTypeId2WithProviderTypeId1CategoryId1, ProviderTypeId = _providerTypeId1, OrganisationCategoryId = _categoryId1, CreatedAt = DateTime.Now, CreatedBy = "system", Status = "x"
});
OrganisationCategoryOrgTypeProviderTypeHandler.InsertRecord(new OrganisationCategoryOrgTypeProviderTypeModel {
Id = 3, OrganisationTypeId = _organisationTypeId3WithProviderTypeId1CategoryId1, ProviderTypeId = _providerTypeId1, OrganisationCategoryId = _categoryId1, CreatedAt = DateTime.Now, CreatedBy = "system", Status = "x"
});
OrganisationCategoryOrgTypeProviderTypeHandler.InsertRecord(new OrganisationCategoryOrgTypeProviderTypeModel {
Id = 4, OrganisationTypeId = _organisationTypeId3WithProviderTypeId2CategoryId1, ProviderTypeId = _providerTypeId2, OrganisationCategoryId = _categoryId1, CreatedAt = DateTime.Now, CreatedBy = "system", Status = "x"
});
}
public void setup()
{
OrganisationStatusHandler.InsertRecords(
new List <OrganisationStatusModel>
{
new OrganisationStatusModel {
Id = OrganisationStatusHandler.Active, Status = "Active", CreatedAt = DateTime.Now, CreatedBy = "TestSystem"
},
new OrganisationStatusModel {
Id = OrganisationStatusHandler.Removed, Status = "Removed", CreatedAt = DateTime.Now, CreatedBy = "TestSystem"
},
new OrganisationStatusModel {
Id = OrganisationStatusHandler.ActiveNotTakingOnApprentices, Status = "Active - but not taking on apprentices", CreatedAt = DateTime.Now, CreatedBy = "TestSystem"
},
new OrganisationStatusModel {
Id = OrganisationStatusHandler.Onboarding, Status = "On-boarding", CreatedAt = DateTime.Now, CreatedBy = "TestSystem"
}
});
OrganisationTypeHandler.InsertRecords(
new List <OrganisationTypeModel>
{
new OrganisationTypeModel {
Id = 1, Status = "1", Type = "1", CreatedAt = DateTime.Now, CreatedBy = "TestSystem"
},
new OrganisationTypeModel {
Id = 2, Status = "2", Type = "2", CreatedAt = DateTime.Now, CreatedBy = "TestSystem"
},
new OrganisationTypeModel {
Id = 3, Status = "3", Type = "3", CreatedAt = DateTime.Now, CreatedBy = "TestSystem"
},
new OrganisationTypeModel {
Id = 4, Status = "4", Type = "4", CreatedAt = DateTime.Now, CreatedBy = "TestSystem"
}
});
ProviderTypeHandler.InsertRecords(
new List <ProviderTypeModel>
{
new ProviderTypeModel {
Id = 1, Status = "1", ProviderType = "1", CreatedAt = DateTime.Now, CreatedBy = "TestSystem"
},
new ProviderTypeModel {
Id = 2, Status = "2", ProviderType = "2", CreatedAt = DateTime.Now, CreatedBy = "TestSystem"
},
new ProviderTypeModel {
Id = 3, Status = "3", ProviderType = "3", CreatedAt = DateTime.Now, CreatedBy = "TestSystem"
},
new ProviderTypeModel {
Id = 4, Status = "4", ProviderType = "4", CreatedAt = DateTime.Now, CreatedBy = "TestSystem"
}
});
_repository = new FatDataExportRepository(new DatabaseService().DbConnectionHelper);
}
public void Set_up_and_run_update()
{
_organisationStatusId1 = 1;
_providerTypeId1 = 10;
_providerTypeId2 = 20;
_organisationTypeId1 = 100;
_organisationTypeId2 = 111;
_organisationUkprn = 11114433;
_legalName = "Legal name 1";
_organisationId = Guid.NewGuid();
_updateOrganisationRepository = new UpdateOrganisationRepository(_databaseService.DbConnectionHelper);
_repository = new OrganisationRepository(_databaseService.DbConnectionHelper);
_status1 = new OrganisationStatusModel {
Id = _organisationStatusId1, Status = "Live", CreatedAt = DateTime.Now, CreatedBy = "TestSystem"
};
OrganisationStatusHandler.InsertRecord(_status1);
_providerType1 = new ProviderTypeModel {
Id = _providerTypeId1, ProviderType = "provider type 10", Description = "provider type description", CreatedAt = DateTime.Now, CreatedBy = "TestSystem", Status = "Live"
};
ProviderTypeHandler.InsertRecord(_providerType1);
_providerType2 = new ProviderTypeModel {
Id = _providerTypeId2, ProviderType = "provider type 12", Description = "provider type description", CreatedAt = DateTime.Now, CreatedBy = "TestSystem", Status = "Live"
};
ProviderTypeHandler.InsertRecord(_providerType2);
_organisationTypeModel1 = new OrganisationTypeModel {
Id = _organisationTypeId1, Type = "organisation type 10", Description = "organisation type description", CreatedAt = DateTime.Now, CreatedBy = "TestSystem", Status = "Live"
};
OrganisationTypeHandler.InsertRecord(_organisationTypeModel1);
_organisationTypeModel2 = new OrganisationTypeModel {
Id = _organisationTypeId2, Type = "organisation type 22", Description = "organisation type description", CreatedAt = DateTime.Now, CreatedBy = "TestSystem", Status = "Live"
};
OrganisationTypeHandler.InsertRecord(_organisationTypeModel2);
_organisation = new OrganisationModel
{
UKPRN = _organisationUkprn,
OrganisationTypeId = _organisationTypeId1,
ProviderTypeId = _providerTypeId1,
StatusId = _organisationStatusId1,
StatusDate = DateTime.Today.AddDays(5),
LegalName = _legalName,
Id = _organisationId,
CreatedAt = DateTime.Now,
CreatedBy = "Test"
};
OrganisationHandler.InsertRecord(_organisation);
_changedBy = "SystemChange";
_successfulUpdate = _updateOrganisationRepository.UpdateProviderTypeAndOrganisationType(_organisationId, _providerTypeId2, _organisationTypeId2, _changedBy).Result;
_newProviderType = _repository.GetProviderType(_organisationId).Result;
_newOrganisationType = _repository.GetOrganisationType(_organisationId).Result;
}
public void SetupOrganisationTypesTests()
{
_repository = new RegisterQueryRepository(_databaseService.WebConfiguration);
_organisationType1 = new OrganisationTypeModel {
Id = 10, Status = "Live", Type = "Award Organisation"
};
_organisationType2 = new OrganisationTypeModel {
Id = 20, Status = "New", Type = "Some Other"
};
var organisationTypes = new List <OrganisationTypeModel> {
_organisationType1, _organisationType2
};
OrganisationTypeHandler.InsertRecords(organisationTypes);
}
public void Set_up_and_run_update()
{
_organisationStatusId = 1;
_providerTypeId = 10;
_organisationTypeId = 100;
_applicationDeterminedate = DateTime.Today;
_newApplicationDeterminedDate = DateTime.Today.AddDays(-1);
_organisationUkprn = 11114433;
_organisationId = Guid.NewGuid();
_updateOrganisationRepository = new UpdateOrganisationRepository(_databaseService.DbConnectionHelper);
_repository = new OrganisationRepository(_databaseService.DbConnectionHelper);
_status = new OrganisationStatusModel {
Id = _organisationStatusId, Status = "Live", CreatedAt = DateTime.Now, CreatedBy = "TestSystem"
};
OrganisationStatusHandler.InsertRecord(_status);
_providerType = new ProviderTypeModel {
Id = _providerTypeId, ProviderType = "provider type 10", Description = "provider type description", CreatedAt = DateTime.Now, CreatedBy = "TestSystem", Status = "Live"
};
ProviderTypeHandler.InsertRecord(_providerType);
_organisationTypeModel = new OrganisationTypeModel {
Id = _organisationTypeId, Type = "organisation type 10", Description = "organisation type description", CreatedAt = DateTime.Now, CreatedBy = "TestSystem", Status = "Live"
};
OrganisationTypeHandler.InsertRecord(_organisationTypeModel);
var organisationData = new OrganisationData {
ApplicationDeterminedDate = _applicationDeterminedate
};
_organisation = new OrganisationModel
{
UKPRN = _organisationUkprn,
OrganisationTypeId = _organisationTypeId,
ProviderTypeId = _providerTypeId,
StatusId = _organisationStatusId,
StatusDate = DateTime.Today.AddDays(5),
LegalName = "legal name",
Id = _organisationId,
CreatedAt = DateTime.Now,
CreatedBy = "Test",
OrganisationData = JsonConvert.SerializeObject(organisationData)
};
OrganisationHandler.InsertRecord(_organisation);
_originalDeterminedDate = _repository.GetApplicationDeterminedDate(_organisationId).Result;
_changedBy = "SystemChange";
_successfulUpdate = _updateOrganisationRepository.UpdateApplicationDeterminedDate(_organisationId, _newApplicationDeterminedDate.Value, _changedBy).Result;
_newApplicationDeterminedDate = _repository.GetApplicationDeterminedDate(_organisationId).Result;
}
public void Set_up_and_run_update()
{
_organisationStatusId1 = 1;
_providerTypeId1 = 10;
_organisationTypeId1 = 100;
_organisationUkprn = 11114433;
_organisationId = Guid.NewGuid();
_parentCompanyGuarantee = true;
_parentCompanyGuaranteeAfterChange = false;
_updateOrganisationRepository = new UpdateOrganisationRepository(_databaseService.WebConfiguration);
_repository = new OrganisationRepository(_databaseService.WebConfiguration);
_status1 = new OrganisationStatusModel {
Id = _organisationStatusId1, Status = "Live", CreatedAt = DateTime.Now, CreatedBy = "TestSystem"
};
OrganisationStatusHandler.InsertRecord(_status1);
_providerType1 = new ProviderTypeModel {
Id = _providerTypeId1, ProviderType = "provider type 10", Description = "provider type description", CreatedAt = DateTime.Now, CreatedBy = "TestSystem", Status = "Live"
};
ProviderTypeHandler.InsertRecord(_providerType1);
_organisationTypeModel1 = new OrganisationTypeModel {
Id = _organisationTypeId1, Type = "organisation type 10", Description = "organisation type description", CreatedAt = DateTime.Now, CreatedBy = "TestSystem", Status = "Live"
};
OrganisationTypeHandler.InsertRecord(_organisationTypeModel1);
var organisationData = new OrganisationData {
ParentCompanyGuarantee = _parentCompanyGuarantee
};
_organisation = new OrganisationModel
{
UKPRN = _organisationUkprn,
OrganisationTypeId = _organisationTypeId1,
ProviderTypeId = _providerTypeId1,
StatusId = _organisationStatusId1,
StatusDate = DateTime.Today.AddDays(5),
LegalName = "legal name",
Id = _organisationId,
CreatedAt = DateTime.Now,
CreatedBy = "Test",
OrganisationData = JsonConvert.SerializeObject(organisationData)
};
OrganisationHandler.InsertRecord(_organisation);
_originalParentCompanyGuarantee = _repository.GetParentCompanyGuarantee(_organisationId).Result;
_changedBy = "SystemChange";
_successfulUpdate = _updateOrganisationRepository.UpdateParentCompanyGuarantee(_organisationId, _parentCompanyGuaranteeAfterChange, _changedBy).Result;
_newParentCompanyGuarantee = _repository.GetParentCompanyGuarantee(_organisationId).Result;
}
public void SetUpOrganisationTests()
{
_repository = new RegisterRepository(_databaseService.WebConfiguration, new Mock <ILogger <RegisterRepository> >().Object);
_validationRepository = new RegisterValidationRepository(_databaseService.WebConfiguration);
_queryRepository = new RegisterQueryRepository(_databaseService.WebConfiguration);
_organisationIdCreated = "EPA0987";
_ukprnCreated = 123321;
var org2IdCreated = "EPA0001";
_organisationTypeId = 5;
OrganisationTypeHandler.InsertRecord(new OrganisationTypeModel {
Id = _organisationTypeId, Status = "new", Type = "organisation type 1"
});
_id = Guid.NewGuid();
_organisation = new EpaOrganisation
{
Id = _id,
CreatedAt = DateTime.Now,
Name = "name 2",
OrganisationId = _organisationIdCreated,
Ukprn = _ukprnCreated,
PrimaryContact = null,
PrimaryContactName = null,
Status = OrganisationStatus.New,
OrganisationTypeId = _organisationTypeId,
OrganisationData = new OrganisationData
{
LegalName = " legal name",
TradingName = "trading name",
Address1 = "address 1",
Address2 = "address 2",
Address3 = "address 3",
Address4 = "address 4",
Postcode = "postcode"
}
};
_organisation2 = new EpaOrganisation
{
Id = Guid.NewGuid(),
Name = "name 1",
OrganisationId = org2IdCreated,
Status = OrganisationStatus.New,
OrganisationTypeId = null
};
}
public void Before_the_tests()
{
_organisationStatusId1 = 1;
_providerTypeId1 = ProviderType.MainProvider;
_organisationTypeId1 = 100;
_repository = new CreateOrganisationRepository(_databaseService.DbConnectionHelper);
_status1 = new OrganisationStatusModel {
Id = _organisationStatusId1, Status = "Live", CreatedAt = DateTime.Now, CreatedBy = "TestSystem"
};
OrganisationStatusHandler.InsertRecord(_status1);
_providerType1 = new ProviderTypeModel {
Id = _providerTypeId1, ProviderType = "provider type 10", Description = "provider type description", CreatedAt = DateTime.Now, CreatedBy = "TestSystem", Status = "Live"
};
ProviderTypeHandler.InsertRecord(_providerType1);
_organisationTypeModel1 = new OrganisationTypeModel {
Id = _organisationTypeId1, Type = "organisation type 10", Description = "organisation type description", CreatedAt = DateTime.Now, CreatedBy = "TestSystem", Status = "Live"
};
OrganisationTypeHandler.InsertRecord(_organisationTypeModel1);
}
public void SetupOrganisationTypesTests()
{
var databaseConnection = new SqlConnection(_databaseService.WebConfiguration.SqlConnectionString);
var unitOfWork = new UnitOfWork(databaseConnection);
_repository = new RegisterQueryRepository(unitOfWork);
_organisationType1 = new OrganisationTypeModel {
Id = 20, Status = "Live", Type = "Award Organisation"
};
_organisationType2 = new OrganisationTypeModel {
Id = 21, Status = "New", Type = "Some Other"
};
var organisationTypes = new List <OrganisationTypeModel> {
_organisationType1, _organisationType2
};
OrganisationTypeHandler.InsertRecords(organisationTypes);
}
public void Set_up_and_run_update()
{
_organisationStatusId1 = 1;
_providerTypeId1 = 10;
_organisationTypeId1 = 100;
_organisationUkprn = 11114433;
_tradingName = "Trading name 1";
_tradingNameAfterChange = "Trading Name Version 2";
_organisationId = Guid.NewGuid();
_updateRepository = new UpdateOrganisationRepository(_databaseService.WebConfiguration);
_repository = new OrganisationRepository(_databaseService.WebConfiguration);
_status1 = new OrganisationStatusModel {
Id = _organisationStatusId1, Status = "Live", CreatedAt = DateTime.Now, CreatedBy = "TestSystem"
};
OrganisationStatusHandler.InsertRecord(_status1);
_providerType1 = new ProviderTypeModel {
Id = _providerTypeId1, ProviderType = "provider type 10", Description = "provider type description", CreatedAt = DateTime.Now, CreatedBy = "TestSystem", Status = "Live"
};
ProviderTypeHandler.InsertRecord(_providerType1);
_organisationTypeModel1 = new OrganisationTypeModel {
Id = _organisationTypeId1, Type = "organisation type 10", Description = "organisation type description", CreatedAt = DateTime.Now, CreatedBy = "TestSystem", Status = "Live"
};
OrganisationTypeHandler.InsertRecord(_organisationTypeModel1);
_organisation = new OrganisationModel
{
UKPRN = _organisationUkprn,
OrganisationTypeId = _organisationTypeId1,
ProviderTypeId = _providerTypeId1,
StatusId = _organisationStatusId1,
StatusDate = DateTime.Today.AddDays(5),
TradingName = _tradingName,
LegalName = "Legal Name 1",
Id = _organisationId,
CreatedAt = DateTime.Now,
CreatedBy = "Test"
};
OrganisationHandler.InsertRecord(_organisation);
_originalTradingName = _repository.GetTradingName(_organisationId).Result;
_changedBy = "SystemChange";
_successfulUpdate = _updateRepository.UpdateTradingName(_organisationId, _tradingNameAfterChange, _changedBy).Result;
_newTradingName = _repository.GetTradingName(_organisationId).Result;
}
public void setup_organisation_is_added()
{
_organisationStatusId1 = 1;
_providerTypeId1 = 10;
_organisationTypeId1 = 100;
_organisationUkprn = 11114433;
_organisationId = Guid.NewGuid();
_parentCompanyGuarantee = true;
_repository = new OrganisationRepository(_databaseService.DbConnectionHelper);
_status1 = new OrganisationStatusModel {
Id = _organisationStatusId1, Status = "Live", CreatedAt = DateTime.Now, CreatedBy = "TestSystem"
};
OrganisationStatusHandler.InsertRecord(_status1);
_providerType1 = new ProviderTypeModel {
Id = _providerTypeId1, ProviderType = "provider type 10", Description = "provider type description", CreatedAt = DateTime.Now, CreatedBy = "TestSystem", Status = "Live"
};
ProviderTypeHandler.InsertRecord(_providerType1);
_organisationTypeModel1 = new OrganisationTypeModel {
Id = _organisationTypeId1, Type = "organisation type 10", Description = "organisation type description", CreatedAt = DateTime.Now, CreatedBy = "TestSystem", Status = "Live"
};
OrganisationTypeHandler.InsertRecord(_organisationTypeModel1);
var organisationData = new OrganisationData {
ParentCompanyGuarantee = _parentCompanyGuarantee
};
_organisation = new OrganisationModel
{
UKPRN = _organisationUkprn,
OrganisationTypeId = _organisationTypeId1,
ProviderTypeId = _providerTypeId1,
StatusId = _organisationStatusId1,
StatusDate = DateTime.Today.AddDays(5),
LegalName = "legal name 1",
Id = _organisationId,
CreatedAt = DateTime.Now,
CreatedBy = "Test",
OrganisationData = JsonConvert.SerializeObject(organisationData)
};
OrganisationHandler.InsertRecord(_organisation);
}
public void Before_the_tests()
{
_lookupRepository = new LookupDataRepository(_databaseService.WebConfiguration, _cacheHelper);
_organisationValidator = new OrganisationValidator(null, _lookupRepository, null);
_organisationTypeId1 = 10;
_organisationTypeId2 = 20;
_organisationTypeId3 = 30;
_organisationTypeIdNonExistent = 100;
_numberOfExpectedResults = 3;
_cacheHelper.PurgeAllCaches();
OrganisationTypeHandler.InsertRecord(new OrganisationTypeModel {
Id = _organisationTypeId1, CreatedAt = DateTime.Now, CreatedBy = "system", Status = "x", Type = "a"
});
OrganisationTypeHandler.InsertRecord(new OrganisationTypeModel {
Id = _organisationTypeId2, CreatedAt = DateTime.Now, CreatedBy = "system", Status = "x", Type = "b"
});
OrganisationTypeHandler.InsertRecord(new OrganisationTypeModel {
Id = _organisationTypeId3, CreatedAt = DateTime.Now, CreatedBy = "system", Status = "x", Type = "c"
});
}
public void SetUpOrganisationTests()
{
_repository = new RegisterRepository(_databaseService.WebConfiguration, new Mock <ILogger <RegisterRepository> >().Object);
_organisationIdCreated = "EPA987";
_ukprnBefore = 123321;
_ukprnAfter = 124421;
_organisationTypeIdBefore = 5;
_organisationTypeIdAfter = 6;
_updatedAt = DateTime.Today.Date.AddHours(9);
OrganisationTypeHandler.InsertRecord(new OrganisationTypeModel {
Id = _organisationTypeIdBefore, Status = "new", Type = "organisation type 1"
});
OrganisationTypeHandler.InsertRecord(new OrganisationTypeModel {
Id = _organisationTypeIdAfter, Status = "new", Type = "organisation type 2"
});
_nameUpdated = "name 2";
_createdAt = DateTime.Today.Date.AddHours(8);
_initialOrganisationDetails = new EpaOrganisation
{
Id = Guid.NewGuid(),
CreatedAt = _createdAt,
Name = "name 1",
OrganisationId = _organisationIdCreated,
Ukprn = _ukprnBefore,
PrimaryContact = null,
PrimaryContactName = null,
Status = OrganisationStatus.New,
OrganisationTypeId = _organisationTypeIdBefore,
OrganisationData = new OrganisationData
{
LegalName = " legal name",
TradingName = "trading name",
Address1 = "address 1",
Address2 = "address 2",
Address3 = "address 3",
Address4 = "address 4",
Postcode = "postcode"
}
};
_updatedOrgData = new OrganisationData
{
LegalName = " legal name 2",
TradingName = "trading name 2",
Address1 = "address 1b",
Address2 = "address 2b",
Address3 = "address 3b",
Address4 = "address 4b",
Postcode = "postcodeb"
};
_expectedOrganisationDetails = new EpaOrganisation
{
Id = _initialOrganisationDetails.Id,
CreatedAt = _createdAt,
Name = _nameUpdated,
OrganisationId = _organisationIdCreated,
Ukprn = _ukprnAfter,
PrimaryContact = null,
PrimaryContactName = null,
Status = OrganisationStatus.New,
UpdatedAt = _updatedAt,
OrganisationTypeId = _organisationTypeIdAfter,
OrganisationData = _updatedOrgData
};
}
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.DeleteRecordByOrganisationId(_organisationIdCreated);
OrganisationTypeHandler.DeleteRecord(_organisationTypeIdBefore);
OrganisationTypeHandler.DeleteRecord(_organisationTypeIdAfter);
}
public void Tear_down()
{
OrganisationTypeHandler.DeleteAllRecords();
}
public void TearDownOrganisationTypesTests()
{
OrganisationTypeHandler.DeleteRecords(new List <int> {
_organisationType1.Id, _organisationType2.Id
});
}
public void Tear_down()
{
ProviderTypeOrganisationTypeHandler.DeleteAllRecords();
ProviderTypeHandler.DeleteAllRecords();
OrganisationTypeHandler.DeleteAllRecords();
}
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()
{
OrganisationHandler.DeleteRecordByEndPointAssessorOrganisationId(_organisationIdCreated);
OrganisationTypeHandler.DeleteRecord(_organisationTypeId);
}
