private static void RegisterCustomerCommand(ShopDbContext db, string[] customerArgs) { string customerName = customerArgs[1]; int salesmanId = int.Parse(customerArgs[2]); Customer customer = new Customer { Name = customerName, SalesmanId = salesmanId }; db.Add(customer); db.SaveChanges(); }
private static void CreateReviewCommand(ShopDbContext db, string[] reviewArgs) { int customerId = int.Parse(reviewArgs[1]); int itemId = int.Parse(reviewArgs[2]); Review review = new Review { CustomerId = customerId, ItemId = itemId }; db.Add(review); db.SaveChanges(); }
private static void CreateSalesmanCommand(ShopDbContext db, string[] salesmanInput) { foreach (string salesmanName in salesmanInput) { Salesman salesman = new Salesman { Name = salesmanName }; db.Add(salesman); db.SaveChanges(); } }
private static void CreateItemCommand(ShopDbContext db, string[] itemArgs) { string itemName = itemArgs[0]; double itemPrice = double.Parse(itemArgs[1]); Item item = new Item { Name = itemName, Price = itemPrice }; db.Add(item); db.SaveChanges(); }
private static void RegisterCustomer(ShopDbContext context, string arguments) { var parts = arguments.Split(';'); var customerName = parts[0]; var salesmanId = int.Parse(parts[1]); context.Add(new Customer { Name = customerName, SalesmanId = salesmanId }); context.SaveChanges(); }
private static void SaveReview(ShopDbContext context, string arguments) { var parts = arguments.Split(';'); var customerId = int.Parse(parts[0]); var itemId = int.Parse(parts[1]); context.Add(new Review { CustomerId = customerId, ItemId = itemId }); context.SaveChanges(); }
private static void CreateOrderCommand(ShopDbContext db, string[] orderArgs) { int customerId = int.Parse(orderArgs[1]); Order order = new Order { CustomerId = customerId }; for (int i = 2; i < orderArgs.Length; i++) { int itemId = int.Parse(orderArgs[i]); order.Items.Add(new OrderItem { ItemId = itemId }); } db.Add(order); db.SaveChanges(); }
private static void SaveItems(ShopDbContext context) { while (true) { var line = Console.ReadLine(); if (line == "END") { break; } var parts = line.Split(';'); var itemName = parts[0]; var itemPrice = decimal.Parse(parts[1]); context.Add(new Item { Name = itemName, Price = itemPrice }); } }
private static void SaveOrder(ShopDbContext context, string arguments) { var parts = arguments.Split(';'); var customerId = int.Parse(parts[0]); var itemIds = new HashSet <int>(); var order = new Order { CustomerId = customerId }; for (int i = 1; i < parts.Length; i++) { var itemId = int.Parse(parts[i]); order.Items.Add(new ItemOrder { ItemId = itemId, }); } context.Add(order); context.SaveChanges(); }