public void CreateOrder(string Email)
{
ModelAW db = new ModelAW();
int UserID = db.EmailAddresses
.Where(m => m.EmailAddress1 == Email)
.First().BusinessEntityID;
var orders = db.ShoppingCartItems
.Include(m => m.Product.ProductInventories)
.Where(m => m.Product.ProductInventories.Sum(c => c.Quantity) > 1 && UserID.ToString() == m.ShoppingCartID)
.Select(m => new OrderDTO
{
ProductID = m.ProductID,
Quantity = m.Quantity,
CartID = m.ShoppingCartItemID
}).ToArray();
//var orders = (from ShoppingCartItem Cart in db.ShoppingCartItems
// where Cart.ShoppingCartID == UserID.ToString()
// select new OrderDTO
// {
// ProductID = Cart.ProductID,
// Quantity = Cart.Quantity,
// CartID = Cart.ShoppingCartItemID
// }).ToArray();
foreach (var order in orders)
{
GetVendor(order);
GetPrice(order);
}
var ord = orders.GroupBy(m => m.Vendor);
foreach (var O in ord)
{
PurchaseOrderHeader newOrder = new PurchaseOrderHeader()
{
PersonID = UserID,
VendorID = O.Key,
ModifiedDate = DateTime.Now,
OrderDate = DateTime.Now,
ShipMethodID = 1,
Status = 1
};
db.PurchaseOrderHeaders.Add(newOrder);
db.SaveChanges();
db.Entry(newOrder).Reload();
foreach (var i in O)
{
int id = newOrder.PurchaseOrderID;
PurchaseOrderDetail Order = new PurchaseOrderDetail()
{
PurchaseOrderID = id,
OrderQty = (short)i.Quantity,
ProductID = i.ProductID,
DueDate = DateTime.Now,
ReceivedQty = 0,
RejectedQty = 0,
UnitPrice = i.UnitPrice,
ModifiedDate = DateTime.Now
};
db.PurchaseOrderDetails.Add(Order);
ShoppingCartItemRep cartItemRep = new ShoppingCartItemRep();
cartItemRep.Delete(i.CartID);
DataLog.Info("Добавлен Заказ: OrderID - " + id);
}
db.SaveChanges();
}
}
public void Update(T item)
{
db.Entry(item).State = EntityState.Modified;
}
public void Update(ProductCategory item)
{
db.Entry(item).State = EntityState.Modified;
}
