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