private static void SaveSalesmen(ShopHierarchyDbContext db) { string[] salesmen = Console.ReadLine().Split(';'); foreach (var salesman in salesmen) { db.Salesmen.Add(new Salesman { Name = salesman }); } db.SaveChanges(); }
private static void SaveReview(ShopHierarchyDbContext db, string args) { string[] reviewArgs = args.Split(';'); int customerId = int.Parse(reviewArgs[0]); int itemId = int.Parse(reviewArgs[1]); db.Reviews.Add(new Review() { CustomerId = customerId, ItemId = itemId }); db.SaveChanges(); }
private static void SaveCustomer(ShopHierarchyDbContext db, string args) { string[] customerArgs = args.Split(';'); string name = customerArgs[0]; int salesmanId = int.Parse(customerArgs[1]); db.Customers.Add(new Customer() { Name = name, SalesmanId = salesmanId }); db.SaveChanges(); }
private static void SaveOrder(ShopHierarchyDbContext db, string args) { string[] orderArgs = args.Split(';'); int customerId = int.Parse(orderArgs[0]); Order order = new Order() { CustomerId = customerId }; db.Orders.Add(order); db.SaveChanges(); for (int i = 1; i < orderArgs.Length; i++) { int itemId = int.Parse(orderArgs[i]); order.ItemOrders.Add(new ItemOrder() { ItemId = itemId, OrderId = order.Id }); } db.SaveChanges(); }
private static void SaveItems(ShopHierarchyDbContext db) { string line = Console.ReadLine(); while (line.ToLower() != "end") { string[] args = line.Split(';'); string name = args[0]; decimal price = decimal.Parse(args[1]); db.Items.Add(new Item { Name = name, Price = price }); line = Console.ReadLine(); } db.SaveChanges(); }