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