public async Task <IEnumerable <IApprenticeship> > GetApprenticeshipCollection()
{
using (var client = _cosmosDbHelper.GetTcpClient())
{
await _cosmosDbHelper.CreateDatabaseIfNotExistsAsync(client);
await _cosmosDbHelper.CreateDocumentCollectionIfNotExistsAsync(client, _cosmosSettings.ApprenticeshipCollectionId);
return(_cosmosDbHelper.GetApprenticeshipCollection(client, _cosmosSettings.ApprenticeshipCollectionId));
}
}
public async Task <IApprenticeship> AddApprenticeship(IApprenticeship apprenticeship)
{
Throw.IfNull(apprenticeship, nameof(apprenticeship));
Apprenticeship persisted;
var client = _cosmosDbHelper.GetClient();
await _cosmosDbHelper.CreateDatabaseIfNotExistsAsync(client);
var doc = await _cosmosDbHelper.CreateDocumentAsync(client, _settings.ApprenticeshipCollectionId, apprenticeship);
persisted = _cosmosDbHelper.DocumentTo <Apprenticeship>(doc);
return(persisted);
}
public async Task <ICourse> AddCourse(ICourse course)
{
Throw.IfNull(course, nameof(course));
Course persisted;
using (var client = _cosmosDbHelper.GetClient())
{
await _cosmosDbHelper.CreateDatabaseIfNotExistsAsync(client);
await _cosmosDbHelper.CreateDocumentCollectionIfNotExistsAsync(client, _settings.CoursesCollectionId);
var doc = await _cosmosDbHelper.CreateDocumentAsync(client, _settings.CoursesCollectionId, course);
persisted = _cosmosDbHelper.DocumentTo <Course>(doc);
}
return(persisted);
}
public async Task CreateApprenticeshipReport(ApprenticeshipMigrationReport report)
{
var client = _cosmosDbHelper.GetClient();
await _cosmosDbHelper.CreateDatabaseIfNotExistsAsync(client);
await _cosmosDbHelper.CreateDocumentCollectionIfNotExistsAsync(client,
_settings.ApprenticeshipReportCollectionId);
var result = _cosmosDbHelper.GetDocumentsByUKPRN <ApprenticeshipMigrationReport>(client, _settings.ApprenticeshipReportCollectionId,
report.ProviderUKPRN);
if (result.Any())
{
report.Id = result.FirstOrDefault().Id;
await _cosmosDbHelper.UpdateDocumentAsync(client, _settings.ApprenticeshipReportCollectionId,
report);
}
else
{
var doc = await _cosmosDbHelper.CreateDocumentAsync(client, _settings.ApprenticeshipReportCollectionId, report);
}
}