internal async Task SeedKnownFranchises()
{
if (franchiseCollectionFactory.Initialized)
{
return;
}
var existingFranchises = await dbContext.Franchises.Where(x => KnownFranchises.Contains(x.Name)).ToListAsync();
var missingFranchises = KnownFranchises.Except(existingFranchises.Select(x => x.Name))
.Select(name =>
{
var franchise = new Franchise(name, true);
auditMetadataProvider.AddAuditMetadataToNewEntity(franchise);
return(franchise);
})
.ToList();
if (missingFranchises.Any())
{
logger.LogInitializationProcess($"Creating franchises: { String.Join(", ", missingFranchises) }");
dbContext.AddRange(missingFranchises);
await dbContext.SaveChangesAsync();
}
var franchises = existingFranchises.Concat(missingFranchises).ToDictionary(x => x.Name, x => x.Id);
franchiseCollectionFactory.Lotos = franchises["Lotos"];
franchiseCollectionFactory.Orlen = franchises["Orlen"];
franchiseCollectionFactory.Bp = franchises["Bp"];
franchiseCollectionFactory.Auchan = franchises["Auchan"];
franchiseCollectionFactory.Initialized = true;
}
public async Task UpdateGasStations()
{
var gasStations = await gasStationsFetcher.GetAuchanGasStations();
var gasStationsQueryValues = string.Join(",", gasStations.Select((x, n) => $"({n}, '{x.Name}')"));
var franchiseId = franchiseCollection.Auchan;
var missingGasStations = await dbContext.Database.GetDbConnection().QueryAsync <int>($@"
SELECT n FROM (VALUES { gasStationsQueryValues }) as request (n, name)
LEFT JOIN ""{ nameof(GasStation) }s"" stations
ON stations.""{ nameof(GasStation.Name) }"" = request.name
AND stations.""{ nameof(GasStation.FranchiseId) }"" = { franchiseId }
WHERE stations.""{ nameof(GasStation.Id) }"" IS NULL");
foreach (var index in missingGasStations)
{
var missingGasStation = gasStations[index];
var gasStation = new GasStation(
name: missingGasStation.Name,
addressLine1: missingGasStation.AddressLine1,
addressLine2: missingGasStation.AddressLine2,
franchiseId: franchiseId,
maintainedBySystem: true,
websiteAddress: missingGasStation.WebsiteAddress);
auditMetadataProvider.AddAuditMetadataToNewEntity(gasStation);
dbContext.Add(gasStation);
}
await dbContext.SaveChangesAsync();
}
public async Task SeedSchedulers()
{
var franchiseCollection = franchiseCollectionFactory();
var existingSchedulers = await dbContext.Schedulers.AsNoTracking().Select(x => x.Id).ToListAsync();
var missingSchedulers = AllSchedulers.Except(existingSchedulers).ToList();
if (missingSchedulers.Any())
{
logger.LogInitializationProcess($"Seeding schedulers: { string.Join(",", missingSchedulers) }.");
foreach (var schedulerId in missingSchedulers)
{
var scheduler = schedulerId switch
{
0 => CreateForWholesalePrices(schedulerId, franchiseCollection.Lotos),
1 => CreateForWholesalePrices(schedulerId, franchiseCollection.Orlen),
2 => CreateForWholesalePrices(schedulerId, franchiseCollection.Bp),
3 => CreateForGasStations(schedulerId, franchiseCollection.Lotos),
4 => CreateForGasStations(schedulerId, franchiseCollection.Auchan),
5 => CreateForGasStationPrices(schedulerId, franchiseCollection.Auchan),
_ => null
};
auditMetadataProvider.AddAuditMetadataToNewEntity(scheduler);
dbContext.Add(scheduler);
}
await dbContext.SaveChangesAsync();
}
}
public async Task <long> Create(AddFranchiseModel model)
{
var franchise = new Entities.Franchise(model.Name, false);
auditMetadataProvider.AddAuditMetadataToNewEntity(franchise);
dbContext.Franchises.Add(franchise);
await dbContext.SaveChangesAsync();
return(franchise.Id);
}
public async Task <long> Create(AddCommentModel model)
{
var comment = new Entities.Comment(
content: model.Content,
createdAt: DateTime.UtcNow,
tag: model.Tag,
subjectId: model.SubjectId);
auditMetadataProvider.AddAuditMetadataToNewEntity(comment);
dbContext.Add(comment);
await dbContext.SaveChangesAsync();
return(comment.Id);
}
public async Task <long> SubmitPrice(SubmitPriceModel model)
{
var submission = new Entities.PriceSubmission(
gasStationId: model.GasStationId,
submissionDate: DateTime.UtcNow.Date,
amount: model.Amount,
fuelType: model.FuelType);
auditMetadataProvider.AddAuditMetadataToNewEntity(submission);
dbContext.PriceSubmissions.Add(submission);
await dbContext.SaveChangesAsync();
return(submission.Id);
}
public async Task <long> Create(AddGasStationModel model)
{
var gasStation = new Entities.GasStation(
name: model.Name,
addressLine1: model.AddressLine1,
addressLine2: model.AddressLine2,
franchiseId: model.FranchiseId,
maintainedBySystem: false,
websiteAddress: model.WebsiteAddress);
auditMetadataProvider.AddAuditMetadataToNewEntity(gasStation);
dbContext.GasStations.Add(gasStation);
await dbContext.SaveChangesAsync();
return(gasStation.Id);
}