private static void ImportCarsWithParts(CarDealershipContext context)
{
Console.WriteLine("Importing cars..");
string jsnoFile = File.ReadAllText(@"..\..\Import\cars.json");
List <Car> cars = JsonConvert.DeserializeObject <List <Car> >(jsnoFile);
int partCap = context.Parts.Count() + 1;
foreach (var car in cars)
{
Random rnd1 = new Random();
System.Threading.Thread.Sleep(15);
for (int i = 0; i < rnd1.Next(10, 20); i++)
{
// 10-20 parts
Random rnd2 = new Random();
System.Threading.Thread.Sleep(15);
int partId = rnd2.Next(1, partCap);
var part = context.Parts.FirstOrDefault(p => p.Id == partId);
car.Parts.Add(part);
}
Console.WriteLine($"Adding car: {car.Model}, {car.Make} with parts..");
context.Cars.Add(car);
context.SaveChanges();
}
}
private static void ImportSales(CarDealershipContext context)
{
Console.WriteLine("Importing sales..");
var carsCount = context.Cars.Count();
var customersCount = context.Customers.Count();
List <Sale> sales = new List <Sale>();
for (int i = 0; i < carsCount - 30; i++)
{
Random rnd1 = new Random();
System.Threading.Thread.Sleep(8);
int carId = rnd1.Next(1, carsCount);
Random rnd2 = new Random();
System.Threading.Thread.Sleep(8);
int customerId = rnd1.Next(1, customersCount);
int discount = GenerateDiscount(i, carId, customerId);
Sale sale = new Sale
{
CarId = carId,
CustomerId = customerId,
DiscountPercentage = discount
};
sales.Add(sale);
}
context.Sales.AddRange(sales);
context.SaveChanges();
}
private static void ImportSuppliers(CarDealershipContext context)
{
Console.WriteLine("Importing suppliers..");
string jsnoFile = File.ReadAllText(@"..\..\Import\suppliers.json");
List <Supplier> suppliers = JsonConvert.DeserializeObject <List <Supplier> >(jsnoFile);
context.Suppliers.AddRange(suppliers);
context.SaveChanges();
}
private static void ImportParts(CarDealershipContext context)
{
Console.WriteLine("Importing parts..");
string jsnoFile = File.ReadAllText(@"..\..\Import\parts.json");
List <Part> parts = JsonConvert.DeserializeObject <List <Part> >(jsnoFile);
var suppliersCount = context.Suppliers.Count();
foreach (var part in parts)
{
Random rnd1 = new Random();
System.Threading.Thread.Sleep(15);
//Console.WriteLine(rnd1.Next(1, suppliersCount));
part.SupplierId = rnd1.Next(1, suppliersCount);
}
context.Parts.AddRange(parts);
context.SaveChanges();
}
