// IMyScopedService is injected into Invoke
public async Task Invoke(HttpContext httpContext, DataBaseSeeder seeder)
{
await seeder.SeedData();
await _next(httpContext);
}
protected override void OnModelCreating(ModelBuilder modelBuilder)
{
base.OnModelCreating(modelBuilder);
#region Primary Keys
modelBuilder.Entity <Brand>().HasKey(b => b.Id);
modelBuilder.Entity <Country>().HasKey(c => c.Id);
modelBuilder.Entity <Company>().HasKey(c => c.Id);
modelBuilder.Entity <Corporation>().HasKey(c => c.Id);
modelBuilder.Entity <DoorType>().HasKey(dt => dt.Id);
modelBuilder.Entity <Driver>().HasKey(d => d.Id);
modelBuilder.Entity <FuelCard>().HasKey(fc => fc.Id);
modelBuilder.Entity <Model>().HasKey(m => m.Id);
modelBuilder.Entity <EngineType>().HasKey(mt => mt.Id);
modelBuilder.Entity <Record>().HasKey(r => r.Id);
modelBuilder.Entity <Series>().HasKey(s => s.Id);
modelBuilder.Entity <Supplier>().HasKey(s => s.Id);
modelBuilder.Entity <Vehicle>().HasKey(v => v.Id);
modelBuilder.Entity <ExteriorColor>().HasKey(ec => ec.Id);
modelBuilder.Entity <InteriorColor>().HasKey(ic => ic.Id);
#endregion
#region OneToOne
//Vehicles - FuelCard
modelBuilder.Entity <Vehicle>()
.HasOne(v => v.FuelCard)
.WithOne(fc => fc.Vehicle)
.HasForeignKey <FuelCard>(fc => fc.VehicleId)
.OnDelete(DeleteBehavior.SetNull);
modelBuilder.Entity <FuelCard>()
.HasOne(fc => fc.Vehicle)
.WithOne(v => v.FuelCard)
.HasForeignKey <Vehicle>(v => v.FuelCardId)
.OnDelete(DeleteBehavior.SetNull);
//Driver - FuelCard
modelBuilder.Entity <FuelCard>()
.HasOne(fc => fc.Driver)
.WithOne(d => d.FuelCard)
.HasForeignKey <Driver>(d => d.FuelCardId)
.OnDelete(DeleteBehavior.SetNull);
modelBuilder.Entity <Driver>()
.HasOne(d => d.FuelCard)
.WithOne(fc => fc.Driver)
.HasForeignKey <FuelCard>(fc => fc.DriverId)
.OnDelete(DeleteBehavior.SetNull);
//Record - FuelCard
modelBuilder.Entity <Record>()
.HasOne(r => r.FuelCard)
.WithOne(fc => fc.Record)
.HasForeignKey <FuelCard>(fc => fc.RecordId)
.OnDelete(DeleteBehavior.SetNull);
modelBuilder.Entity <FuelCard>()
.HasOne(fc => fc.Record)
.WithOne(r => r.FuelCard)
.HasForeignKey <Record>(r => r.FuelCardId)
.OnDelete(DeleteBehavior.SetNull);
#endregion
#region OneToMany
//1 brand -> x EngineTypes
modelBuilder.Entity <Brand>()
.HasMany(b => b.EngineTypes)
.WithOne(mt => mt.Brand)
.HasForeignKey(mt => mt.BrandId);
//1 brand -> x series
modelBuilder.Entity <Brand>()
.HasMany(b => b.Series)
.WithOne(s => s.Brand)
.HasForeignKey(s => s.BrandId);
//1 brand -> x models
modelBuilder.Entity <Brand>()
.HasMany(b => b.Models)
.WithOne(m => m.Brand)
.HasForeignKey(m => m.BrandId);
//1 brand -> x vehicles
modelBuilder.Entity <Brand>()
.HasMany(b => b.Vehicles)
.WithOne(v => v.Brand)
.HasForeignKey(v => v.BrandId);
//1 model -> x vehicles
modelBuilder.Entity <Model>()
.HasMany(m => m.Vehicles)
.WithOne(v => v.Model)
.HasForeignKey(v => v.ModelId);
//1 doortype -> x vehicles
modelBuilder.Entity <DoorType>()
.HasMany(d => d.Vehicles)
.WithOne(v => v.DoorType)
.HasForeignKey(v => v.DoorTypeId);
//1 EngineType -> x vehicles
modelBuilder.Entity <EngineType>()
.HasMany(m => m.Vehicles)
.WithOne(v => v.EngineType)
.HasForeignKey(v => v.EngineTypeId);
//1 Fueltype -> x vehicles
modelBuilder.Entity <FuelType>()
.HasMany(f => f.Vehicles)
.WithOne(v => v.FuelType)
.HasForeignKey(v => v.FuelTypeId);
//1 ExteriorColor - x Vehicles
modelBuilder.Entity <Vehicle>()
.HasOne(v => v.ExteriorColor)
.WithMany(ec => ec.Vehicles)
.HasForeignKey(v => v.ExteriorColorId);
//1 InteriorColor - x Vehicles
modelBuilder.Entity <Vehicle>()
.HasOne(v => v.InteriorColor)
.WithMany(ic => ic.Vehicles)
.HasForeignKey(v => v.InteriorColorId);
//1 FuelCard - x Refills
modelBuilder.Entity <Refill>()
.HasOne(f => f.FuelCard)
.WithMany(f => f.Refills)
.HasForeignKey(r => r.FuelCardId);
//1 City - x Refills
modelBuilder.Entity <Refill>()
.HasOne(r => r.City)
.WithMany(c => c.Refills)
.HasForeignKey(r => r.CityId);
//1 Country - x Cities
modelBuilder.Entity <City>()
.HasOne(c => c.Country)
.WithMany(c => c.Cities)
.HasForeignKey(c => c.CountryId);
#endregion
#region config
modelBuilder.Entity <Person>()
.HasIndex(p => p.DriversLicenseNumber)
.IsUnique();
modelBuilder.Entity <Supplier>()
.HasIndex(supplier => supplier.Name)
.IsUnique();
DataBaseSeeder.SeedData(modelBuilder);
modelBuilder.Entity <Supplier>()
.Property(s => s.Types)
.HasConversion(
v => string.Join(",", v.Select(a => a.ToString())),
v => v.Split(',', StringSplitOptions.RemoveEmptyEntries)
.Select(a => (SupplierType)Enum.Parse(typeof(SupplierType), a)).ToArray()
);
#endregion
}