private void AddOrderItem(OrderClass order, int orderId)
{
int maxId = (int)db.OrderItems.Max(s => s.Id_OrderItem);
foreach (var item in order._productList)
{
maxId += 1;
OrderItem orderItem = new OrderItem()
{
Id_Order = orderId,
Id_Product = item.product.Id_Product,
Id_OrderItem = maxId,
Quantity = item.quantity
};
db.OrderItems.InsertOnSubmit(orderItem);
}
}
public void Add(OrderClass orderClass, int userId, string paySysName)
{
var paySys = db.PaymentSystems.FirstOrDefault(s => s.Payment.Equals(paySysName));
int maxOrderId = (int)db.Orders.Max(s => s.Id_Order);
var dateTime = DateTime.Now;
var date = dateTime.Date;
Order o = new Order()
{
Id_Order = maxOrderId + 1,
Id_User = userId,
Sum = orderClass._sum,
Date = date,
PaymentSystem = paySys.Id_Payment,
Ended = true,
Name = orderClass._name
};
db.Orders.InsertOnSubmit(o);
AddOrderItem(orderClass, maxOrderId + 1);
db.SubmitChanges();
}