public AccidentsServiceShould()
{
var logger = Logger.Create();
_dbContext = new AccidentStatisticDbContext(logger);
_repository = new AccidentStatisticRepository(_dbContext);
_subject = new AccidentsService(_repository);
}
static void Main(string[] args)
{
using (var logger = Logger.Create())
{
using (var accidentStatisticDbContext = new AccidentStatisticDbContext(logger))
{
var accidentStatisticRepository = new AccidentStatisticRepository(accidentStatisticDbContext);
var accidentCount = accidentStatisticRepository.Count().GetAwaiter().GetResult();
logger.Information($"{accidentCount} Accident Statistic records found");
logger.Information($"{accidentStatisticDbContext.Vehicles.LongCountAsync().GetAwaiter().GetResult()} Vehicle records found");
logger.Information($"{accidentStatisticDbContext.Casualties.LongCountAsync().GetAwaiter().GetResult()} Casualty records found");
LoadAllCyclingAccidents(accidentStatisticDbContext, new DateTime(2005, 01, 01, 1, 1, 1), new DateTime(2017, 12, 31, 1, 1, 1), logger).GetAwaiter().GetResult();
logger.Warning("Hit enter to close");
Console.Read();
}
}
}
private static async Task LoadAllCyclingAccidents(AccidentStatisticDbContext accidentStatisticDbContext,
DateTime from, DateTime to, ILogger logger)
{
var repository = new AccidentStatisticRepository(accidentStatisticDbContext);
int?nextPage = 1;
do
{
var result = await repository.Get(filter =>
filter.Date >= from && filter.Date <= to &&
filter.Severity == Severity.Fatal &&
filter.Casualties.Any(casualty =>
casualty.Mode.Equals("PedalCycle") && casualty.Severity == Severity.Fatal),
OrderBy(x => x.Borough, false),
nextPage.Value);
logger.Information($"Displaying Page {nextPage} returning '{result.PageSize}' records of '{result.Total}' cycling fatalities in total from {from.ToLongDateString()} to {to.ToLongDateString()} ...");
foreach (var cyclingAccident in result.Data)
{
logger.Information($"Cycling accident occured in the borough of {cyclingAccident.Borough.ToUpper()} involving '{cyclingAccident.Casualties.Count}' casualties and '{cyclingAccident.Vehicles.Count}' vehicles.");
}
nextPage = result.NextPage;
} while (nextPage.HasValue);
}
protected override void Seed(AccidentStatisticDbContext context)
{
// NOTE: This seed method could have been used but I preferred the bespoke initializer,
// see AccidentStatisticDbInitializer for more detail
base.Seed(context);
}
