private static string GetCacheKey(Country country,
Institution institution,
LocalAuthority localAuthority,
LocalAuthorityDistrict localAuthorityDistrict,
LocalEnterprisePartnership localEnterprisePartnership,
MayoralCombinedAuthority mayoralCombinedAuthority,
Mat multiAcademyTrust,
OpportunityArea opportunityArea,
ParliamentaryConstituency parliamentaryConstituency,
Region region,
RscRegion rscRegion,
Sponsor sponsor,
Ward ward,
PlanningArea planningArea)
{
var observationalUnits = new IObservationalUnit[]
{
country, institution, localAuthority, localAuthorityDistrict, localEnterprisePartnership,
mayoralCombinedAuthority, multiAcademyTrust, parliamentaryConstituency, opportunityArea, region,
rscRegion, sponsor, ward, planningArea
};
const string separator = "_";
return(string.Join(separator, observationalUnits
.Where(unit => unit != null)
.Select(unit => $"{unit.GetType()}:{(unit is LocalAuthority la ? la.GetCodeOrOldCodeIfEmpty() : unit.Code )}:{unit.Name}")));
}
private Location LookupOrCreate(
StatisticsDbContext context,
Country country,
Institution institution = null,
LocalAuthority localAuthority = null,
LocalAuthorityDistrict localAuthorityDistrict = null,
LocalEnterprisePartnership localEnterprisePartnership = null,
MayoralCombinedAuthority mayoralCombinedAuthority = null,
Mat multiAcademyTrust = null,
OpportunityArea opportunityArea = null,
ParliamentaryConstituency parliamentaryConstituency = null,
Region region = null,
RscRegion rscRegion = null,
Sponsor sponsor = null,
Ward ward = null,
PlanningArea planningArea = null)
{
var location = Lookup(
context,
country,
institution,
localAuthority,
localAuthorityDistrict,
localEnterprisePartnership,
mayoralCombinedAuthority,
multiAcademyTrust,
opportunityArea,
parliamentaryConstituency,
region,
rscRegion,
sponsor,
ward,
planningArea);
if (location == null)
{
var entityEntry = context.Location.Add(new Location
{
Id = _guidGenerator.NewGuid(),
Country = country ?? Country.Empty(),
Institution = institution ?? Institution.Empty(),
LocalAuthority = localAuthority ?? LocalAuthority.Empty(),
LocalAuthorityDistrict = localAuthorityDistrict ?? LocalAuthorityDistrict.Empty(),
LocalEnterprisePartnership = localEnterprisePartnership ?? LocalEnterprisePartnership.Empty(),
MayoralCombinedAuthority = mayoralCombinedAuthority ?? MayoralCombinedAuthority.Empty(),
MultiAcademyTrust = multiAcademyTrust ?? Mat.Empty(),
OpportunityArea = opportunityArea ?? OpportunityArea.Empty(),
ParliamentaryConstituency = parliamentaryConstituency ?? ParliamentaryConstituency.Empty(),
Region = region ?? Region.Empty(),
RscRegion = rscRegion ?? RscRegion.Empty(),
Sponsor = sponsor ?? Sponsor.Empty(),
Ward = ward ?? Ward.Empty(),
PlanningArea = planningArea ?? PlanningArea.Empty()
});
return(entityEntry.Entity);
}
return(location);
}
public Location Find(
StatisticsDbContext context,
Country country,
Institution institution = null,
LocalAuthority localAuthority = null,
LocalAuthorityDistrict localAuthorityDistrict = null,
LocalEnterprisePartnership localEnterprisePartnership = null,
MayoralCombinedAuthority mayoralCombinedAuthority = null,
Mat multiAcademyTrust = null,
OpportunityArea opportunityArea = null,
ParliamentaryConstituency parliamentaryConstituency = null,
Region region = null,
RscRegion rscRegion = null,
Sponsor sponsor = null,
Ward ward = null,
PlanningArea planningArea = null)
{
var cacheKey = GetCacheKey(country, institution, localAuthority, localAuthorityDistrict,
localEnterprisePartnership, mayoralCombinedAuthority, multiAcademyTrust, opportunityArea,
parliamentaryConstituency, region, rscRegion, sponsor, ward, planningArea);
if (GetCache().TryGetValue(cacheKey, out Location location))
{
return(location);
}
location = LookupOrCreate(context, country, institution, localAuthority, localAuthorityDistrict,
localEnterprisePartnership, mayoralCombinedAuthority, multiAcademyTrust, opportunityArea,
parliamentaryConstituency, region, rscRegion, sponsor, ward, planningArea);
GetCache().Set(cacheKey, location);
return(location);
}
protected override void OnReadFields(IList <HousePrice> ks, string[] fields)
{
var localAuthorityDistrictCode = fields[0];
var localAuthorityDistrictName = fields[1];
var localAuthorityDistrict = new LocalAuthorityDistrict
{
Code = localAuthorityDistrictCode,
Name = localAuthorityDistrictName,
};
var wardCode = fields[2];
var wardName = fields[3];
var ward = new Ward
{
Code = wardCode,
Name = wardName,
};
var priceEndingSept2019 = fields[99];
if (priceEndingSept2019 == ":")
{
return;
}
var housePrice = new HousePrice
{
LocalAuthorityDistrict = localAuthorityDistrict,
Ward = ward,
AverageHousePrice = double.Parse(priceEndingSept2019.Replace(",", "")),
};
ks.Add(housePrice);
}
protected override void OnReadFields(IList <LowerLayerSuperOutputArea> ts, string[] fields)
{
var lowerLayerSuperOutputAreaCode = fields[0];
var lowerLayerSuperOutputAreaName = fields[1];
var localAuthorityDistrictCode = fields[2];
var localAuthorityDistrictName = fields[3];
var localAuthorityDistrict = new LocalAuthorityDistrict
{
Code = localAuthorityDistrictCode,
Name = localAuthorityDistrictName
};
var indexOfMultipleDeprivationRank = fields[4];
var indexOfMultipleDeprivationDecile = fields[5];
var indexOfMultipleDeprivation = new IndexOfMultipleDeprivation
{
Rank = int.Parse(indexOfMultipleDeprivationRank.Replace(",", "")),
Decile = int.Parse(indexOfMultipleDeprivationDecile.Replace(",", "")),
};
var lowerLayerSuperOutputArea = new LowerLayerSuperOutputArea
{
Code = lowerLayerSuperOutputAreaCode,
Name = lowerLayerSuperOutputAreaName,
LocalAuthorityDistrict = localAuthorityDistrict,
IndexOfMultipleDeprivation = indexOfMultipleDeprivation,
};
ts.Add(lowerLayerSuperOutputArea);
}
private Location Lookup(
StatisticsDbContext context,
Country country,
Institution institution = null,
LocalAuthority localAuthority = null,
LocalAuthorityDistrict localAuthorityDistrict = null,
LocalEnterprisePartnership localEnterprisePartnership = null,
MayoralCombinedAuthority mayoralCombinedAuthority = null,
Mat multiAcademyTrust = null,
OpportunityArea opportunityArea = null,
ParliamentaryConstituency parliamentaryConstituency = null,
Region region = null,
RscRegion rscRegion = null,
Sponsor sponsor = null,
Ward ward = null,
PlanningArea planningArea = null)
{
var predicateBuilder = PredicateBuilder.True <Location>()
.And(location => location.Country.Code == country.Code && location.Country.Name == country.Name);
predicateBuilder = predicateBuilder
.And(location => location.Institution.Code == (institution != null ? institution.Code : null) &&
location.Institution.Name == (institution != null ? institution.Name : null));
// Also match the old LA code even if blank
predicateBuilder = predicateBuilder
.And(location =>
location.LocalAuthority.Code == (localAuthority != null && localAuthority.Code != null ? localAuthority.Code : null) &&
location.LocalAuthority.OldCode == (localAuthority != null && localAuthority.OldCode != null ? localAuthority.OldCode : null) &&
location.LocalAuthority.Name == (localAuthority != null ? localAuthority.Name : null));
predicateBuilder = predicateBuilder
.And(location => location.LocalAuthorityDistrict.Code == (localAuthorityDistrict != null ? localAuthorityDistrict.Code : null) &&
location.LocalAuthorityDistrict.Name == (localAuthorityDistrict != null ? localAuthorityDistrict.Name : null));
predicateBuilder = predicateBuilder
.And(location => location.LocalEnterprisePartnership.Code == (localEnterprisePartnership != null ? localEnterprisePartnership.Code : null) &&
location.LocalEnterprisePartnership.Name == (localEnterprisePartnership != null ? localEnterprisePartnership.Name : null));
predicateBuilder = predicateBuilder
.And(location => location.MayoralCombinedAuthority.Code == (mayoralCombinedAuthority != null ? mayoralCombinedAuthority.Code : null) &&
location.MayoralCombinedAuthority.Name == (mayoralCombinedAuthority != null ? mayoralCombinedAuthority.Name : null));
predicateBuilder = predicateBuilder
.And(location => location.MultiAcademyTrust.Code == (multiAcademyTrust != null ? multiAcademyTrust.Code : null) &&
location.MultiAcademyTrust.Name == (multiAcademyTrust != null ? multiAcademyTrust.Name : null));
predicateBuilder = predicateBuilder
.And(location => location.OpportunityArea.Code == (opportunityArea != null ? opportunityArea.Code : null) &&
location.OpportunityArea.Name == (opportunityArea != null ? opportunityArea.Name : null));
predicateBuilder = predicateBuilder
.And(location => location.ParliamentaryConstituency.Code == (parliamentaryConstituency != null ? parliamentaryConstituency.Code : null) &&
location.ParliamentaryConstituency.Name == (parliamentaryConstituency != null ? parliamentaryConstituency.Name : null));
predicateBuilder = predicateBuilder
.And(location => location.Region.Code == (region != null ? region.Code : null) &&
location.Region.Name == (region != null ? region.Name : null));
// Note that Name is not included in the predicate here as it is the same as the code
predicateBuilder = predicateBuilder
.And(location => location.RscRegion.Code == (rscRegion != null ? rscRegion.Code : null));
predicateBuilder = predicateBuilder
.And(location => location.Sponsor.Code == (sponsor != null ? sponsor.Code : null) &&
location.Sponsor.Name == (sponsor != null ? sponsor.Name : null));
predicateBuilder = predicateBuilder
.And(location => location.Ward.Code == (ward != null ? ward.Code : null) &&
location.Ward.Name == (ward != null ? ward.Name : null));
predicateBuilder = predicateBuilder
.And(location => location.PlanningArea.Code == (planningArea != null ? planningArea.Code : null) &&
location.PlanningArea.Name == (planningArea != null ? planningArea.Name : null));
return(context.Location.AsNoTracking().FirstOrDefault(predicateBuilder));
}
protected bool Equals(LocalAuthorityDistrict other)
{
return(string.Equals(Code, other.Code));
}
