private static IEnumerable <ColorsModelYears> GetModelColorYears(VehicleDbContext vehicleContext)
{
return(new List <ColorsModelYears>()
{
// Ablaze
new ColorsModelYears()
{
Color = vehicleContext.Colors.Where(c => c.Code == "M7Y").FirstOrDefault(),
ModelYear = vehicleContext.Years.Where(y => y.Year == 2016 && y.ModelId == FRS_MODEL_ID).FirstOrDefault()
},
new ColorsModelYears()
{
Color = vehicleContext.Colors.Where(c => c.Code == "M7Y").FirstOrDefault(),
ModelYear = vehicleContext.Years.Where(y => y.Year == 2017 && y.ModelId == GT86_MODEL_ID).FirstOrDefault()
},
// Asphalt
new ColorsModelYears()
{
Color = vehicleContext.Colors.Where(c => c.Code == "61K").FirstOrDefault(),
ModelYear = vehicleContext.Years.Where(y => y.Year == 2013 && y.ModelId == FRS_MODEL_ID).FirstOrDefault()
},
new ColorsModelYears()
{
Color = vehicleContext.Colors.Where(c => c.Code == "61K").FirstOrDefault(),
ModelYear = vehicleContext.Years.Where(y => y.Year == 2014 && y.ModelId == FRS_MODEL_ID).FirstOrDefault()
},
new ColorsModelYears()
{
Color = vehicleContext.Colors.Where(c => c.Code == "61K").FirstOrDefault(),
ModelYear = vehicleContext.Years.Where(y => y.Year == 2015 && y.ModelId == FRS_MODEL_ID).FirstOrDefault()
},
new ColorsModelYears()
{
Color = vehicleContext.Colors.Where(c => c.Code == "61K").FirstOrDefault(),
ModelYear = vehicleContext.Years.Where(y => y.Year == 2016 && y.ModelId == FRS_MODEL_ID).FirstOrDefault()
},
new ColorsModelYears()
{
Color = vehicleContext.Colors.Where(c => c.Code == "61K").FirstOrDefault(),
ModelYear = vehicleContext.Years.Where(y => y.Year == 2017 && y.ModelId == GT86_MODEL_ID).FirstOrDefault()
},
// Argento
new ColorsModelYears()
{
Color = vehicleContext.Colors.Where(c => c.Code == "D6S").FirstOrDefault(),
ModelYear = vehicleContext.Years.Where(y => y.Year == 2013 && y.ModelId == FRS_MODEL_ID).FirstOrDefault()
},
new ColorsModelYears()
{
Color = vehicleContext.Colors.Where(c => c.Code == "D6S").FirstOrDefault(),
ModelYear = vehicleContext.Years.Where(y => y.Year == 2014 && y.ModelId == FRS_MODEL_ID).FirstOrDefault()
},
// Firestorm
new ColorsModelYears()
{
Color = vehicleContext.Colors.Where(c => c.Code == "C7P").FirstOrDefault(),
ModelYear = vehicleContext.Years.Where(y => y.Year == 2013 && y.ModelId == FRS_MODEL_ID).FirstOrDefault()
},
new ColorsModelYears()
{
Color = vehicleContext.Colors.Where(c => c.Code == "C7P").FirstOrDefault(),
ModelYear = vehicleContext.Years.Where(y => y.Year == 2014 && y.ModelId == FRS_MODEL_ID).FirstOrDefault()
},
new ColorsModelYears()
{
Color = vehicleContext.Colors.Where(c => c.Code == "C7P").FirstOrDefault(),
ModelYear = vehicleContext.Years.Where(y => y.Year == 2015 && y.ModelId == FRS_MODEL_ID).FirstOrDefault()
},
// Halo
new ColorsModelYears()
{
Color = vehicleContext.Colors.Where(c => c.Code == "K1X").FirstOrDefault(),
ModelYear = vehicleContext.Years.Where(y => y.Year == 2015 && y.ModelId == FRS_MODEL_ID).FirstOrDefault()
},
new ColorsModelYears()
{
Color = vehicleContext.Colors.Where(c => c.Code == "K1X").FirstOrDefault(),
ModelYear = vehicleContext.Years.Where(y => y.Year == 2016 && y.ModelId == FRS_MODEL_ID).FirstOrDefault()
},
new ColorsModelYears()
{
Color = vehicleContext.Colors.Where(c => c.Code == "K1X").FirstOrDefault(),
ModelYear = vehicleContext.Years.Where(y => y.Year == 2017 && y.ModelId == GT86_MODEL_ID).FirstOrDefault()
},
// Hot Lava
new ColorsModelYears()
{
Color = vehicleContext.Colors.Where(c => c.Code == "H8R").FirstOrDefault(),
ModelYear = vehicleContext.Years.Where(y => y.Year == 2013 && y.ModelId == FRS_MODEL_ID).FirstOrDefault()
},
new ColorsModelYears()
{
Color = vehicleContext.Colors.Where(c => c.Code == "H8R").FirstOrDefault(),
ModelYear = vehicleContext.Years.Where(y => y.Year == 2014 && y.ModelId == FRS_MODEL_ID).FirstOrDefault()
},
new ColorsModelYears()
{
Color = vehicleContext.Colors.Where(c => c.Code == "H8R").FirstOrDefault(),
ModelYear = vehicleContext.Years.Where(y => y.Year == 2015 && y.ModelId == FRS_MODEL_ID).FirstOrDefault()
},
new ColorsModelYears()
{
Color = vehicleContext.Colors.Where(c => c.Code == "H8R").FirstOrDefault(),
ModelYear = vehicleContext.Years.Where(y => y.Year == 2016 && y.ModelId == FRS_MODEL_ID).FirstOrDefault()
},
new ColorsModelYears()
{
Color = vehicleContext.Colors.Where(c => c.Code == "H8R").FirstOrDefault(),
ModelYear = vehicleContext.Years.Where(y => y.Year == 2017 && y.ModelId == GT86_MODEL_ID).FirstOrDefault()
},
// Lunar Storm
new ColorsModelYears()
{
Color = vehicleContext.Colors.Where(c => c.Code == "H6Q").FirstOrDefault(),
ModelYear = vehicleContext.Years.Where(y => y.Year == 2016 && y.ModelId == FRS_MODEL_ID).FirstOrDefault()
},
// Oceanic
new ColorsModelYears()
{
Color = vehicleContext.Colors.Where(c => c.Code == "K3X").FirstOrDefault(),
ModelYear = vehicleContext.Years.Where(y => y.Year == 2016 && y.ModelId == FRS_MODEL_ID).FirstOrDefault()
},
new ColorsModelYears()
{
Color = vehicleContext.Colors.Where(c => c.Code == "K3X").FirstOrDefault(),
ModelYear = vehicleContext.Years.Where(y => y.Year == 2017 && y.ModelId == GT86_MODEL_ID).FirstOrDefault()
},
// Raven
new ColorsModelYears()
{
Color = vehicleContext.Colors.Where(c => c.Code == "D4S").FirstOrDefault(),
ModelYear = vehicleContext.Years.Where(y => y.Year == 2013 && y.ModelId == FRS_MODEL_ID).FirstOrDefault()
},
new ColorsModelYears()
{
Color = vehicleContext.Colors.Where(c => c.Code == "D4S").FirstOrDefault(),
ModelYear = vehicleContext.Years.Where(y => y.Year == 2014 && y.ModelId == FRS_MODEL_ID).FirstOrDefault()
},
new ColorsModelYears()
{
Color = vehicleContext.Colors.Where(c => c.Code == "D4S").FirstOrDefault(),
ModelYear = vehicleContext.Years.Where(y => y.Year == 2015 && y.ModelId == FRS_MODEL_ID).FirstOrDefault()
},
new ColorsModelYears()
{
Color = vehicleContext.Colors.Where(c => c.Code == "D4S").FirstOrDefault(),
ModelYear = vehicleContext.Years.Where(y => y.Year == 2016 && y.ModelId == FRS_MODEL_ID).FirstOrDefault()
},
new ColorsModelYears()
{
Color = vehicleContext.Colors.Where(c => c.Code == "D4S").FirstOrDefault(),
ModelYear = vehicleContext.Years.Where(y => y.Year == 2017 && y.ModelId == GT86_MODEL_ID).FirstOrDefault()
},
// Silver Ignition
new ColorsModelYears()
{
Color = vehicleContext.Colors.Where(c => c.Code == "J8A").FirstOrDefault(),
ModelYear = vehicleContext.Years.Where(y => y.Year == 2013 && y.ModelId == FRS_MODEL_ID).FirstOrDefault()
},
// Steel
new ColorsModelYears()
{
Color = vehicleContext.Colors.Where(c => c.Code == "G1U").FirstOrDefault(),
ModelYear = vehicleContext.Years.Where(y => y.Year == 2015 && y.ModelId == FRS_MODEL_ID).FirstOrDefault()
},
new ColorsModelYears()
{
Color = vehicleContext.Colors.Where(c => c.Code == "G1U").FirstOrDefault(),
ModelYear = vehicleContext.Years.Where(y => y.Year == 2016 && y.ModelId == FRS_MODEL_ID).FirstOrDefault()
},
new ColorsModelYears()
{
Color = vehicleContext.Colors.Where(c => c.Code == "G1U").FirstOrDefault(),
ModelYear = vehicleContext.Years.Where(y => y.Year == 2017 && y.ModelId == GT86_MODEL_ID).FirstOrDefault()
},
// Ultramarine
new ColorsModelYears()
{
Color = vehicleContext.Colors.Where(c => c.Code == "E8H").FirstOrDefault(),
ModelYear = vehicleContext.Years.Where(y => y.Year == 2013 && y.ModelId == FRS_MODEL_ID).FirstOrDefault()
},
new ColorsModelYears()
{
Color = vehicleContext.Colors.Where(c => c.Code == "E8H").FirstOrDefault(),
ModelYear = vehicleContext.Years.Where(y => y.Year == 2014 && y.ModelId == FRS_MODEL_ID).FirstOrDefault()
},
new ColorsModelYears()
{
Color = vehicleContext.Colors.Where(c => c.Code == "E8H").FirstOrDefault(),
ModelYear = vehicleContext.Years.Where(y => y.Year == 2015 && y.ModelId == FRS_MODEL_ID).FirstOrDefault()
},
// Whiteout
new ColorsModelYears()
{
Color = vehicleContext.Colors.Where(c => c.Code == "37J").FirstOrDefault(),
ModelYear = vehicleContext.Years.Where(y => y.Year == 2013 && y.ModelId == FRS_MODEL_ID).FirstOrDefault()
},
new ColorsModelYears()
{
Color = vehicleContext.Colors.Where(c => c.Code == "37J").FirstOrDefault(),
ModelYear = vehicleContext.Years.Where(y => y.Year == 2014 && y.ModelId == FRS_MODEL_ID).FirstOrDefault()
},
// Yuzu
new ColorsModelYears()
{
Color = vehicleContext.Colors.Where(c => c.Code == "C2Z").FirstOrDefault(),
ModelYear = vehicleContext.Years.Where(y => y.Year == 2015 && y.ModelId == FRS_MODEL_ID).FirstOrDefault()
},
// TOYOTA 86
// Supernova Orange
new ColorsModelYears()
{
Color = vehicleContext.Colors.Where(c => c.Code == "NBB").FirstOrDefault(),
ModelYear = vehicleContext.Years.Where(y => y.Year == 2017 && y.ModelId == GT86_MODEL_ID).FirstOrDefault()
},
// Thunder
new ColorsModelYears()
{
Color = vehicleContext.Colors.Where(c => c.Code == "PBA").FirstOrDefault(),
ModelYear = vehicleContext.Years.Where(y => y.Year == 2018 && y.ModelId == GT86_MODEL_ID).FirstOrDefault()
},
// SUBARU
// Charlesite Yellow
new ColorsModelYears()
{
Color = vehicleContext.Colors.Where(c => c.Code == "NAD").FirstOrDefault(),
ModelYear = vehicleContext.Years.Where(y => y.Year == 2017 && y.ModelId == BRZ_MODEL_ID).FirstOrDefault()
},
// Crystal Black Silica
new ColorsModelYears()
{
Color = vehicleContext.Colors.Where(c => c.Name == "Crystal Black Silica").FirstOrDefault(),
ModelYear = vehicleContext.Years.Where(y => y.Year == 2013 && y.ModelId == BRZ_MODEL_ID).FirstOrDefault()
},
new ColorsModelYears()
{
Color = vehicleContext.Colors.Where(c => c.Name == "Crystal Black Silica").FirstOrDefault(),
ModelYear = vehicleContext.Years.Where(y => y.Year == 2014 && y.ModelId == BRZ_MODEL_ID).FirstOrDefault()
},
new ColorsModelYears()
{
Color = vehicleContext.Colors.Where(c => c.Name == "Crystal Black Silica").FirstOrDefault(),
ModelYear = vehicleContext.Years.Where(y => y.Year == 2015 && y.ModelId == BRZ_MODEL_ID).FirstOrDefault()
},
new ColorsModelYears()
{
Color = vehicleContext.Colors.Where(c => c.Name == "Crystal Black Silica").FirstOrDefault(),
ModelYear = vehicleContext.Years.Where(y => y.Year == 2016 && y.ModelId == BRZ_MODEL_ID).FirstOrDefault()
},
new ColorsModelYears()
{
Color = vehicleContext.Colors.Where(c => c.Name == "Crystal Black Silica").FirstOrDefault(),
ModelYear = vehicleContext.Years.Where(y => y.Year == 2017 && y.ModelId == BRZ_MODEL_ID).FirstOrDefault()
},
// Crystal Pearl White
new ColorsModelYears()
{
Color = vehicleContext.Colors.Where(c => c.Name == "Crystal White Pearl").FirstOrDefault(),
ModelYear = vehicleContext.Years.Where(y => y.Year == 2015 && y.ModelId == BRZ_MODEL_ID).FirstOrDefault()
},
new ColorsModelYears()
{
Color = vehicleContext.Colors.Where(c => c.Name == "Crystal White Pearl").FirstOrDefault(),
ModelYear = vehicleContext.Years.Where(y => y.Year == 2016 && y.ModelId == BRZ_MODEL_ID).FirstOrDefault()
},
new ColorsModelYears()
{
Color = vehicleContext.Colors.Where(c => c.Name == "Crystal White Pearl").FirstOrDefault(),
ModelYear = vehicleContext.Years.Where(y => y.Year == 2017 && y.ModelId == BRZ_MODEL_ID).FirstOrDefault()
},
// Dark Gray Metallic
new ColorsModelYears()
{
Color = vehicleContext.Colors.Where(c => c.Name == "Dark Gray Metallic").FirstOrDefault(),
ModelYear = vehicleContext.Years.Where(y => y.Year == 2013 && y.ModelId == BRZ_MODEL_ID).FirstOrDefault()
},
new ColorsModelYears()
{
Color = vehicleContext.Colors.Where(c => c.Name == "Dark Gray Metallic").FirstOrDefault(),
ModelYear = vehicleContext.Years.Where(y => y.Year == 2014 && y.ModelId == BRZ_MODEL_ID).FirstOrDefault()
},
new ColorsModelYears()
{
Color = vehicleContext.Colors.Where(c => c.Name == "Dark Gray Metallic").FirstOrDefault(),
ModelYear = vehicleContext.Years.Where(y => y.Year == 2015 && y.ModelId == BRZ_MODEL_ID).FirstOrDefault()
},
new ColorsModelYears()
{
Color = vehicleContext.Colors.Where(c => c.Name == "Dark Gray Metallic").FirstOrDefault(),
ModelYear = vehicleContext.Years.Where(y => y.Year == 2016 && y.ModelId == BRZ_MODEL_ID).FirstOrDefault()
},
new ColorsModelYears()
{
Color = vehicleContext.Colors.Where(c => c.Name == "Dark Gray Metallic").FirstOrDefault(),
ModelYear = vehicleContext.Years.Where(y => y.Year == 2017 && y.ModelId == BRZ_MODEL_ID).FirstOrDefault()
},
// Galaxy Blue Silica
new ColorsModelYears()
{
Color = vehicleContext.Colors.Where(c => c.Name == "Galaxy Blue Silica").FirstOrDefault(),
ModelYear = vehicleContext.Years.Where(y => y.Year == 2013 && y.ModelId == BRZ_MODEL_ID).FirstOrDefault()
},
// Hyper Blue
new ColorsModelYears()
{
Color = vehicleContext.Colors.Where(c => c.Code == "M3Y").FirstOrDefault(),
ModelYear = vehicleContext.Years.Where(y => y.Year == 2016 && y.ModelId == BRZ_MODEL_ID).FirstOrDefault()
},
// Ice Silver Metallic
new ColorsModelYears()
{
Color = vehicleContext.Colors.Where(c => c.Name == "Ice Silver Metallic").FirstOrDefault(),
ModelYear = vehicleContext.Years.Where(y => y.Year == 2015 && y.ModelId == BRZ_MODEL_ID).FirstOrDefault()
},
new ColorsModelYears()
{
Color = vehicleContext.Colors.Where(c => c.Name == "Ice Silver Metallic").FirstOrDefault(),
ModelYear = vehicleContext.Years.Where(y => y.Year == 2016 && y.ModelId == BRZ_MODEL_ID).FirstOrDefault()
},
new ColorsModelYears()
{
Color = vehicleContext.Colors.Where(c => c.Name == "Ice Silver Metallic").FirstOrDefault(),
ModelYear = vehicleContext.Years.Where(y => y.Year == 2017 && y.ModelId == BRZ_MODEL_ID).FirstOrDefault()
},
// Lightning Red
new ColorsModelYears()
{
Color = vehicleContext.Colors.Where(c => c.Name == "Lightning Red").FirstOrDefault(),
ModelYear = vehicleContext.Years.Where(y => y.Year == 2013 && y.ModelId == BRZ_MODEL_ID).FirstOrDefault()
},
new ColorsModelYears()
{
Color = vehicleContext.Colors.Where(c => c.Name == "Lightning Red").FirstOrDefault(),
ModelYear = vehicleContext.Years.Where(y => y.Year == 2014 && y.ModelId == BRZ_MODEL_ID).FirstOrDefault()
},
new ColorsModelYears()
{
Color = vehicleContext.Colors.Where(c => c.Name == "Lightning Red").FirstOrDefault(),
ModelYear = vehicleContext.Years.Where(y => y.Year == 2015 && y.ModelId == BRZ_MODEL_ID).FirstOrDefault()
},
// Pure Red
new ColorsModelYears()
{
Color = vehicleContext.Colors.Where(c => c.Name == "Pure Red").FirstOrDefault(),
ModelYear = vehicleContext.Years.Where(y => y.Year == 2016 && y.ModelId == BRZ_MODEL_ID).FirstOrDefault()
},
new ColorsModelYears()
{
Color = vehicleContext.Colors.Where(c => c.Name == "Pure Red").FirstOrDefault(),
ModelYear = vehicleContext.Years.Where(y => y.Year == 2017 && y.ModelId == BRZ_MODEL_ID).FirstOrDefault()
},
// Satin white pearl
new ColorsModelYears()
{
Color = vehicleContext.Colors.Where(c => c.Name == "Satin White Pearl").FirstOrDefault(),
ModelYear = vehicleContext.Years.Where(y => y.Year == 2013 && y.ModelId == BRZ_MODEL_ID).FirstOrDefault()
},
new ColorsModelYears()
{
Color = vehicleContext.Colors.Where(c => c.Name == "Satin White Pearl").FirstOrDefault(),
ModelYear = vehicleContext.Years.Where(y => y.Year == 2014 && y.ModelId == BRZ_MODEL_ID).FirstOrDefault()
},
// Sterling Silver Metallic
new ColorsModelYears()
{
Color = vehicleContext.Colors.Where(c => c.Code == "D6S").FirstOrDefault(),
ModelYear = vehicleContext.Years.Where(y => y.Year == 2013 && y.ModelId == BRZ_MODEL_ID).FirstOrDefault()
},
new ColorsModelYears()
{
Color = vehicleContext.Colors.Where(c => c.Code == "D6S").FirstOrDefault(),
ModelYear = vehicleContext.Years.Where(y => y.Year == 2014 && y.ModelId == BRZ_MODEL_ID).FirstOrDefault()
},
// World rally blue (02C)
new ColorsModelYears()
{
Color = vehicleContext.Colors.Where(c => c.Code == "02C").FirstOrDefault(),
ModelYear = vehicleContext.Years.Where(y => y.Year == 2013 && y.ModelId == BRZ_MODEL_ID).FirstOrDefault()
},
new ColorsModelYears()
{
Color = vehicleContext.Colors.Where(c => c.Code == "02C").FirstOrDefault(),
ModelYear = vehicleContext.Years.Where(y => y.Year == 2014 && y.ModelId == BRZ_MODEL_ID).FirstOrDefault()
},
// World rally blue (K7X)
new ColorsModelYears()
{
Color = vehicleContext.Colors.Where(c => c.Code == "K7X").FirstOrDefault(),
ModelYear = vehicleContext.Years.Where(y => y.Year == 2015 && y.ModelId == BRZ_MODEL_ID).FirstOrDefault()
},
new ColorsModelYears()
{
Color = vehicleContext.Colors.Where(c => c.Code == "K7X").FirstOrDefault(),
ModelYear = vehicleContext.Years.Where(y => y.Year == 2016 && y.ModelId == BRZ_MODEL_ID).FirstOrDefault()
},
new ColorsModelYears()
{
Color = vehicleContext.Colors.Where(c => c.Code == "K7X").FirstOrDefault(),
ModelYear = vehicleContext.Years.Where(y => y.Year == 2017 && y.ModelId == BRZ_MODEL_ID).FirstOrDefault()
}
});
}
private static IEnumerable <Vehicle> GetDefaultVehicles(VehicleDbContext vehicleContext, UserManager <ApplicationUser> userManager)
{
List <Vehicle> vehicles = new List <Vehicle>();
var defaultUser = userManager.FindByEmailAsync("*****@*****.**").Result;
var sampleBrz = new Vehicle("JF1ZCAC11E9603184")
{
ModelYearId = 3, // 2014 BRZ
TransmissionId = 1, // 6-Spd Manual
ColorId = 14, // World Rally Blue
ProfilePhotoId = 1,
VehicleLocationId = 1,
UserIdentityGuid = defaultUser.Id,
Description = "This is my first Subaru! I've always wanted a World Rally Blue vehicle and found a great deal on my BRZ. So far, I have a few mods, including Tein Coilovers, Perrin wheel spacers, Greddy axle-back exhaust and Phase2 Motortrend suspension arms.",
Mileage = 57341,
InstagramUri = SeedData.INSTAGRAM_URI,
FacebookUri = SeedData.SUBARU_FACEBOOK_URI,
Status = vehicleContext.VehicleStatuses.First(x => x.Name == Status.Active.ToString())
};
vehicles.Add(sampleBrz);
var frsUser = userManager.FindByEmailAsync("*****@*****.**").Result;
var sampleFrs = new Vehicle("JF1ZNAA13E9709794")
{
ModelYearId = 14, // 2013 FRS
TransmissionId = 1, // 6-Spd Manual
ColorId = 3, // White
VehicleLocationId = 2,
ProfilePhotoId = 2,
UserIdentityGuid = frsUser.Id,
Description = "The FRS is such a fun car. I've been driving mine for 4 years now and still really love it. They're great cars.",
Mileage = 21024,
InstagramUri = SeedData.TOYOTA_INSTAGRAM_URI,
FacebookUri = SeedData.TOYOTA_FACEBOOK_URI,
Status = vehicleContext.VehicleStatuses.First(x => x.Name == Status.Active.ToString())
};
vehicles.Add(sampleFrs);
var gt86User = userManager.FindByEmailAsync("*****@*****.**").Result;
var baseVIN = "JF1ZNAA10H87036";
var randomMileage = new Random();
for (int index = 0; index < 20; index++)
{
var digit = index + 10;
vehicles.Add(new Vehicle($"{baseVIN}{digit}")
{
ModelYearId = 10, // 2017 GT86
TransmissionId = 1, // 6-Spd Manual
ColorId = 1, // Ablaze
VehicleLocationId = 3,
ProfilePhotoId = 3,
UserIdentityGuid = gt86User.Id,
Description = "My GT86 is my first RWD vehicle. I've been taking it to drift events pretty often. My favorite thing about the 86 is the aftermarket selection. There are parts for days!",
Mileage = randomMileage.Next(1, 100000),
InstagramUri = SeedData.TOYOTA_INSTAGRAM_URI,
FacebookUri = SeedData.TOYOTA_FACEBOOK_URI,
Status = vehicleContext.VehicleStatuses.First(x => x.Name == Status.Totaled.ToString())
});
}
return(vehicles);
}
public EFRepository(VehicleDbContext vehicleContext)
{
_vehicleContext = vehicleContext;
}
public static async Task SeedAsync(VehicleDbContext vehicleContext,
UserManager <ApplicationUser> userManager,
ILoggerFactory loggerFactory)
{
// Uncomment these two lines to delete and recreate the database
//vehicleContext.Database.EnsureDeleted();
//vehicleContext.Database.Migrate();
// Create Vehicle Statuses
if (!vehicleContext.VehicleStatuses.Any())
{
vehicleContext.VehicleStatuses.AddRange(GetDefaultVehicleStatuses());
await vehicleContext.SaveChangesAsync();
}
// Create Manufacturers
if (!vehicleContext.Manufacturers.Any())
{
vehicleContext.Manufacturers.AddRange(GetDefaultManufacturers());
await vehicleContext.SaveChangesAsync();
}
// Create Vehicle Models
if (!vehicleContext.VehicleModels.Any())
{
vehicleContext.VehicleModels.AddRange(GetDefaultVehicleModels());
await vehicleContext.SaveChangesAsync();
}
// Create Model Years
if (!vehicleContext.Years.Any())
{
vehicleContext.Years.AddRange(GetDefaultModelYears());
await vehicleContext.SaveChangesAsync();
}
// Create Colors
if (!vehicleContext.Colors.Any())
{
vehicleContext.Colors.AddRange(GetDefaultColors());
await vehicleContext.SaveChangesAsync();
}
// Create ModelColor junction table records
if (!vehicleContext.ColorYears.Any())
{
vehicleContext.ColorYears.AddRange(GetModelColorYears(vehicleContext));
await vehicleContext.SaveChangesAsync();
}
// Create default transmissions
if (!vehicleContext.Transmissions.Any())
{
vehicleContext.Transmissions.AddRange(GetTransmissions());
await vehicleContext.SaveChangesAsync();
}
// Create Model_Transmission junction table records
if (!vehicleContext.ModelTransmissions.Any())
{
vehicleContext.ModelTransmissions.AddRange(GetModelYearTransmissions(vehicleContext));
await vehicleContext.SaveChangesAsync();
}
if (!vehicleContext.VehicleLocations.Any())
{
vehicleContext.VehicleLocations.AddRange(GetDefaultLocations());
await vehicleContext.SaveChangesAsync();
}
if (!vehicleContext.Images.Any())
{
vehicleContext.Images.AddRange(GetDefaultProfilePhotoUri(userManager));
await vehicleContext.SaveChangesAsync();
}
// Combine everything to create some test vehicles
if (!vehicleContext.Vehicles.Any())
{
vehicleContext.Vehicles.AddRange(GetDefaultVehicles(vehicleContext, userManager));
await vehicleContext.SaveChangesAsync();
}
}
public VehicleRepository(VehicleDbContext vehicleContext) : base(vehicleContext)
{
}
