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(); }