/// <summary>
 /// Deprecated Method for adding a new object to the Orders EntitySet. Consider using the .Add method of the associated ObjectSet&lt;T&gt; property instead.
 /// </summary>
 public void AddToOrders(Order order)
     base.AddObject("Orders", order);
 /// <summary>
 /// Create a new Order object.
 /// </summary>
 /// <param name="orderId">Initial value of the OrderId property.</param>
 /// <param name="orderDate">Initial value of the OrderDate property.</param>
 /// <param name="total">Initial value of the Total property.</param>
 public static Order CreateOrder(global::System.Int32 orderId, global::System.DateTime orderDate, global::System.Decimal total)
     Order order = new Order();
     order.OrderId = orderId;
     order.OrderDate = orderDate;
     order.Total = total;
     return order;
        public int CreateOrder(Order order)
            decimal orderTotal = 0;

            var cartItems = GetCartItems();

            //Iterate the items in the cart, adding Order Details for each
            foreach (var cartItem in cartItems)
                var orderDetails = new OrderDetail
                    AlbumId = cartItem.AlbumId,
                    OrderId = order.OrderId,
                    UnitPrice = cartItem.Album.Price


                orderTotal += (cartItem.Count * cartItem.Album.Price);

            //Save the order

            //Empty the shopping cart

            //Return the OrderId as a confirmation number
            return order.OrderId;