private void PlaceOrder() { // update user balance user.balance += cartTotal; // create order ORDER order = new ORDER(); order.CUSTOMER = user; order.userID = userID; order.date = DateTime.Now; order.total = cartTotal; foreach (KeyValuePair <PRODUCT, int> item in cartItems) { ORDER_ITEM orderItem = new ORDER_ITEM(); orderItem.ORDER = order; orderItem.PRODUCT = item.Key; orderItem.orderID = order.orderID; orderItem.prodID = item.Key.prodID; orderItem.quantity = item.Value; // add products to order order.ORDER_ITEMs.Add(orderItem); // decrease amount in stock var prod = db.PRODUCTs.FirstOrDefault(p => p.prodID == item.Key.prodID); prod.prodStock -= item.Value; } // submit changes to db SubmitOrder(); }
private void detach_ORDER_ITEMs(ORDER_ITEM entity) { this.SendPropertyChanging(); entity.ORDER = null; }
private void attach_ORDER_ITEMs(ORDER_ITEM entity) { this.SendPropertyChanging(); entity.ORDER = this; }
partial void DeleteORDER_ITEM(ORDER_ITEM instance);
partial void UpdateORDER_ITEM(ORDER_ITEM instance);
partial void InsertORDER_ITEM(ORDER_ITEM instance);