public static void InitializeOrder(CarServiceDbContext context)
{
Random random = new Random();
const string ABC = "ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz0123456789";
int ordersCount = 50;
int[] autoRiaId = { 21352854, 18660881, 20454797, 20709355, 21280512, 21366060, 19454827, 21148041, 21397834, 21396045 };
string[] markName = { "Volkswagen", "Mitsubishi", "Nissan", "Infiniti", "Suzuki", "Opel", "Kia", "Mercedes-Benz", "Audi" };
string[] modelName = { "Touareg", "Lancer X", "Qashqai", "Q30", "Vitara", "Insignia", "Sportage", "E-Class", "Q5" };
string[] city = { "Kyiv", "Odessa", "Lviv", "Kharkiv", "Poltava", "Pryluky", "Stryi", "Zhmerynka" };
string[] photoLink =
{
"https://cdn.riastatic.com/photosnew/auto/photo/audi_q5__208448878sx.jpg",
"https://cdn.riastatic.com/photosnew/auto/photo/mercedes-benz_e-class__189373766sx.jpg",
"https://cdn.riastatic.com/photosnew/auto/photo/kia_sportage__195583415sx.jpg",
"https://cdn.riastatic.com/photosnew/auto/photo/opel_insignia__207299768sx.jpg",
"https://cdn.riastatic.com/photosnew/auto/photo/opel_corsa__207330356sx.jpg",
"https://cdn.riastatic.com/photosnew/auto/photo/suzuki_vitara__208651532sx.jpg",
"https://cdn.riastatic.com/photosnew/auto/photo/infiniti_q30__206379767sx.jpg",
"https://cdn.riastatic.com/photosnew/auto/photo/nissan_qashqai__205340151sx.jpg",
"https://cdn.riastatic.com/photosnew/auto/photo/mitsubishi_lancer-x__209154634sx.jpg",
"https://cdn.riastatic.com/photosnew/auto/photo/volkswagen_touareg__209125093sx.jpg"
};
if (!context.Orders.Any())
{
for (int i = 0; i < ordersCount; i++)
{
var auto = new Auto
{
AutoRiaId = random.Next(1000000, 2000000),
MarkName = markName[random.Next(0, markName.Length)],
ModelName = modelName[random.Next(0, modelName.Length)],
Year = random.Next(2000, 2019),
City = city[random.Next(0, city.Length)],
PhotoLink = photoLink[random.Next(0, photoLink.Length)],
TypeId = random.Next(1, 5),
MarkId = random.Next(1, 50),
ModelId = random.Next(1, 50),
};
context.Autos.Add(auto);
var order = new Order
{
CustomerId = random.Next(1, 2),
AutoId = auto.Id,
Description = ABC.RandomString(random.Next(8, 20)),
Date = DateTime.Now.ToUniversalTime()
};
context.Orders.Add(order);
context.SaveChanges();
}
}
}
public static void Main(string[] args)
{
var db = new CarServiceDbContext();
Database.SetInitializer(new MigrateDatabaseToLatestVersion <CarServiceDbContext, Configuration>());
//var user = new User { Name = "Ivan", Address = "Sofiq", Gender = Gender.Male };
//db.Users.Add(user);
db.SaveChanges();
}
internal static void Seed(IApplicationBuilder app)
{
var scopeFactory = app.ApplicationServices.GetRequiredService <IServiceScopeFactory>();
using (var scope = scopeFactory.CreateScope())
using (CarServiceDbContext ctx
= scope.ServiceProvider.GetRequiredService <CarServiceDbContext>())
{
ctx.Database.EnsureDeleted();
ctx.Database.EnsureCreated();
List <VehicleMake> data = new List <VehicleMake>
{
new VehicleMake {
VehicleModels = new List <VehicleModel> {
new VehicleModel {
Name = "Outlander",
EndYear = 2018,
StartYear = 2011
},
new VehicleModel {
Name = "Lancer",
EndYear = 2018,
StartYear = 2008
},
new VehicleModel {
Name = "Space Star",
EndYear = 2011,
StartYear = 1995
},
},
Name = "Mitsubishi",
},
new VehicleMake {
VehicleModels = new List <VehicleModel> {
new VehicleModel {
Name = "X5",
EndYear = 2018,
StartYear = 2010
},
new VehicleModel {
Name = "X3",
EndYear = 2018,
StartYear = 2015
},
new VehicleModel {
Name = "6",
EndYear = 2009,
StartYear = 1995
},
},
Name = "BMW",
},
new VehicleMake {
VehicleModels = new List <VehicleModel> {
new VehicleModel {
Name = "Cayenne",
EndYear = 2018,
StartYear = 2005
},
new VehicleModel {
Name = "Panamera",
EndYear = 2018,
StartYear = 2010
},
new VehicleModel {
Name = "Cayman",
EndYear = 2015,
StartYear = 1990
},
},
Name = "Porsche",
},
};
foreach (var entry in data)
{
ctx.Add(entry);
}
List <Service> services = new List <Service>
{
new Service
{
Name = "Oil & Filter Change'"
},
new Service
{
Name = "Wiper Blades Change"
},
new Service
{
Name = "Brake Issues"
},
new Service
{
Name = "Wheels Alignment"
},
new Service
{
Name = "Air Filter Change"
},
new Service
{
Name = "Battery Change"
},
new Service
{
Name = "Tire Rotation"
},
new Service
{
Name = "Check Engine Light"
}
};
foreach (var entry in services)
{
ctx.Add(entry);
}
ctx.SaveChanges();
}
}
