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