public void ParseCategories(ProductShopContext ctx) { var categories = FileOperations.ParseCategories(Constants.CategoryXml); var products = ctx.Products.ToArray(); int i = 0; foreach (var c in categories) { c.Id = i++; int rndNumberOfProducts = random.Next(5, 20); for (int j = 0; j < rndNumberOfProducts; j++) { var rndProduct = products[random.Next(0, products.Length - 1)]; if (!c.Products.Contains(rndProduct)) { c.Products.Add(rndProduct); } else { j--; } } ctx.Categories.Add(c); } DbOperationExtentions.ExecTranOnContext(ctx, "Could not add categories."); }
private void ParseProducts() { var products = FileOperations.DeserializeJson <Product>(Constants.ProductJson); var users = context.Users.ToArray(); var categories = context.Categories.ToArray(); int categoriesCount = context.Categories.Count(); int i = 0; foreach (var p in products) { p.Id = i++; p.Seller = users[random.Next(0, users.Length - 1)]; if (random.Next() % 2 == 0) { p.Buyer = users[random.Next(0, users.Length - 1)]; } int rndCategoryCount = random.Next(0, categoriesCount - 1); for (int j = 0; j < rndCategoryCount; j++) { var rndCategory = categories[random.Next(0, categoriesCount - 1)]; if (!p.Categories.Contains(rndCategory)) { p.Categories.Add(rndCategory); } } this.context.Products.Add(p); } DbOperationExtentions.ExecTranOnContext(this.context, "Could not add products."); }
private void ParseCars() { var cars = FileOperations.DeserializeJson <Car>(Constants.CarJson); var parts = this.context.Parts.ToArray(); int i = 0; foreach (var c in cars) { c.Id = i++; int rndNumberOfParts = random.Next(10, 20); for (int j = 0; j < rndNumberOfParts; j++) { var rndPart = parts[random.Next(0, parts.Length - 1)]; if (!c.Parts.Contains(rndPart)) { c.Parts.Add(rndPart); } else { j--; } } this.context.Cars.Add(c); } DbOperationExtentions.ExecTranOnContext(this.context, "Could not add cars"); }
public void ParseUsers(ProductShopContext ctx) { var users = FileOperations.ParseUsers(Constants.UserXml); int i = 0; foreach (var u in users) { u.Id = i++; ctx.Users.Add(u); } DbOperationExtentions.ExecTranOnContext(ctx, "Could not add users."); }
private void ParseSuppliers() { var suppliers = FileOperations.DeserializeJson <Supplier>(Constants.SupplierJson); int i = 0; foreach (var s in suppliers) { s.Id = i++; this.context.Supliers.Add(s); } DbOperationExtentions.ExecTranOnContext(this.context, "Could not add suppliers"); }
private void ParseCustomers() { var customers = FileOperations.DeserializeJson <Customer>(Constants.CustomerJson); int i = 0; foreach (var c in customers) { c.Id = i++; this.context.Customers.Add(c); } DbOperationExtentions.ExecTranOnContext(this.context, "Could not add customers"); }
private void ParseUsers() { var users = FileOperations.DeserializeJson <User>(Constants.UserJson); int i = 0; foreach (var u in users) { u.Id = i++; this.context.Users.Add(u); } DbOperationExtentions.ExecTranOnContext(this.context, "Could not add users."); }
private void ParseCategories() { var categories = FileOperations.DeserializeJson <Category>(Constants.CategoryJson); int i = 0; foreach (var c in categories) { c.Id = i++; this.context.Categories.Add(c); } DbOperationExtentions.ExecTranOnContext(this.context, "Could not add categories."); }
private void ParseCustomers(CarDealerContext ctx) { var customers = FileOperations.ParseCustomers(Constants.CustomerXml); int i = 0; foreach (var c in customers) { c.Id = i++; ctx.Customers.Add(c); } DbOperationExtentions.ExecTranOnContext(ctx, "Could not parse customers."); }
private void ParseSuppliers(CarDealerContext ctx) { var suppliers = FileOperations.ParseSuppliers(Constants.SupplierXml); int i = 0; foreach (var s in suppliers) { s.Id = i++; ctx.Suppliers.Add(s); } DbOperationExtentions.ExecTranOnContext(ctx, "Could not parse suppliers."); }
private void ParseParts() { var parts = FileOperations.DeserializeJson <Part>(Constants.PartJson); var suppliers = this.context.Supliers.ToArray(); int i = 0; foreach (var p in parts) { p.Id = i++; p.Supplier = suppliers[random.Next(0, suppliers.Length - 1)]; this.context.Parts.Add(p); } DbOperationExtentions.ExecTranOnContext(this.context, "Could not add parts"); }
private void ParseParts(CarDealerContext ctx) { var parts = FileOperations.ParseParts(Constants.PartsXml); var suppliers = ctx.Suppliers.ToArray(); int i = 0; foreach (var p in parts) { p.Id = i++; p.Supplier = suppliers[random.Next(0, suppliers.Length - 1)]; ctx.Parts.Add(p); } DbOperationExtentions.ExecTranOnContext(ctx, "Could not parse suppliers."); }
private void ParseSales() { var sales = new Sale[random.Next(50, 200)]; var cars = this.context.Cars.ToArray(); var customers = this.context.Customers.ToArray(); decimal[] discountRanges = { 0m, 0.05m, 0.10m, 0.15m, 0.20m, 0.30m, 0.40m, 0.50m }; for (int i = 0; i < sales.Length; i++) { sales[i] = new Sale(); var s = sales[i]; s.Id = i++; s.Car = cars[random.Next(0, cars.Length - 1)]; s.Customer = customers[random.Next(0, customers.Length - 1)]; s.Discount = discountRanges[random.Next(0, discountRanges.Length - 1)]; this.context.Sales.Add(s); } DbOperationExtentions.ExecTranOnContext(this.context, "Could not add sales"); }
private void ParseSales(CarDealerContext ctx) { int saleCount = 500; var cars = ctx.Cars.ToArray(); var customers = ctx.Customers.ToArray(); decimal[] discountRanges = { 0m, 0.5m, 0.10m, 0.15m, 0.20m, 0.30m, 0.40m, 0.50m }; for (int i = 0; i < saleCount; i++) { var s = new Sale(); s.Id = i; s.Car = cars[random.Next(0, cars.Length - 1)]; s.Customer = customers[random.Next(0, customers.Length - 1)]; s.Discount = discountRanges[random.Next(0, discountRanges.Length - 1)]; ctx.Sales.Add(s); } DbOperationExtentions.ExecTranOnContext(ctx, "Could not parse sales."); }
public void ParseProducts(ProductShopContext ctx) { var products = FileOperations.ParseProducts(Constants.ProductXml); var users = ctx.Users.ToArray(); int i = 0; foreach (var p in products) { p.Id = i++; p.Seller = users[random.Next(0, users.Length - 1)]; if (random.Next() % 2 == 0) { p.Buyer = users[random.Next(0, users.Length - 1)]; } ctx.Products.Add(p); } DbOperationExtentions.ExecTranOnContext(ctx, "Could not add products."); }
private void ParseCars(CarDealerContext ctx) { var cars = FileOperations.ParseCars(Constants.CarXml); var parts = ctx.Parts.ToArray(); int i = 0; foreach (var c in cars) { c.Id = i++; int rndCarCount = random.Next(10, 20); for (int j = 0; j < rndCarCount; j++) { var rndPart = parts[random.Next(0, parts.Length - 1)]; c.Parts.Add(rndPart); } ctx.Cars.Add(c); } DbOperationExtentions.ExecTranOnContext(ctx, "Could not parse cars."); }