public async Task ImportAddressData()
{
var importStartTime = DateTime.UtcNow;
var providers = (await _providerRepository.GetAllRegistered()).Select(c => c.Ukprn).ToList();
var skip = 0;
var providersToProcess = providers.Skip(skip).Take(100).ToList();
while (providersToProcess.Any())
{
var registrationData = await _roatpApiService.GetProviderRegistrationLookupData(providersToProcess);
var postCodeData = (await _postcodeApiService.GetPostcodeData(new PostcodeLookupRequest
{
Postcodes = registrationData.Results.SelectMany(c => c.ContactDetails)
.Where(c => c.ContactType == "P" && c.ContactAddress != null).Select(x => x.ContactAddress.PostCode).ToList()
})).Result.ToList();
foreach (var provider in registrationData.Results.Where(c => c.ContactDetails != null))
{
var providerAddress = provider.ContactDetails.Where(x => x.ContactType.Equals("P"))
.Select(c => c.ContactAddress).FirstOrDefault();
if (providerAddress == null)
{
continue;
}
var providerAddressData = postCodeData
.FirstOrDefault(x => x.Query == providerAddress?.PostCode);
var lat = providerAddressData?.Result?.Latitude ?? 0;
var lon = providerAddressData?.Result?.Longitude ?? 0;
await _providerRegistrationImportRepository.UpdateAddress(provider.Ukprn,
providerAddress,
lat, lon);
}
skip += 100;
providersToProcess = providers.Skip(skip).Take(100).ToList();
}
await _providerRegistrationRepository.UpdateAddressesFromImportTable();
await _importAuditRepository.Insert(new ImportAudit(
importStartTime,
providers.Count,
ImportType.ProviderAddressData));
}
public async Task <PostcodeData> GetPostcodeByFullPostcode(string query)
{
var result = await _postcodeApiService.GetPostcodeData(query);
return(result);
}