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
};
storeDB.OrderDetails.AddObject(orderDetails);
orderTotal += (cartItem.Count * cartItem.Album.Price);
}
//Save the order
storeDB.SaveChanges();
//Empty the shopping cart
EmptyCart();
//Return the OrderId as a confirmation number
return order.OrderId;
}
public int CreateOrder(Order order)
{
decimal orderTotal = 0;
var cartItems = GetCartItems();
// Iterate over the items in the cart, adding the order details for each
foreach (var item in cartItems)
{
var orderDetail = new OrderDetail
{
AlbumId = item.AlbumId,
OrderId = order.OrderId,
UnitPrice = item.Album.Price,
Quantity = item.Count
};
// Set the order total of the shopping cart
orderTotal += (item.Count * item.Album.Price);
storeDB.OrderDetails.Add(orderDetail);
}
// Set the order's total to the orderTotal count
order.Total = orderTotal;
// Save the order
storeDB.SaveChanges();
// Empty the shopping cart
EmptyCart();
// Return the OrderId as the confirmation number
return order.OrderId;
}
public int CreateOrder(Order order)
{
decimal orderTotal = 0;
var cartItems = GetCartItems();
//add order details for each item in cart
foreach (var item in cartItems)
{
var orderDetail = new OrderDetail
{
AlbumId = item.AlbumId,
OrderId = order.OrderId,
UnitPrice = item.Album.Price,
Quantity = item.Count
};
//set the order total of the shopping cart
orderTotal += (item.Count * item.Album.Price);
storeDB.OrderDetails.Add(orderDetail);
}
// set the order's total to the orderTotal count
order.Total = orderTotal;
//save the order and finish up
storeDB.SaveChanges();
EmptyCart();
return order.OrderId;
}
public int CreateOrder(Order order)
{
decimal orderTotal = 0;
foreach (var item in GetCartItems())
{
var orderDetail = new OrderDetail
{
AlbumId = item.AlbumId,
OrderId = order.OrderId,
UnitPrice = item.Album.Price,
Quantity = item.Count
};
orderTotal += (item.Count * item.Album.Price);
storeDB.OrderDetails.Add(orderDetail);
}
order.Total = orderTotal;
storeDB.SaveChanges();
EmptyCart();
return order.OrderId;
}
public ActionResult Edit(OrderDetail item)
{
if (ModelState.IsValid)
{
db.Entry(item).State = EntityState.Modified;
var order = db.Orders.Find(item.OrderId);
order.Notes.Add(new OrderNote { Note = "Order item " + item.Sku + " changed by " + User.Identity.Name });
return RedirectToAction("edit", "orders", new { id = order.OrderId });
}
return View(item);
}
public ActionResult Create(OrderDetail item)
{
if (ModelState.IsValid)
{
db.OrderDetails.Add(item);
return RedirectToAction("Index");
}
else
{
return View();
}
}
public ActionResult Create(OrderDetail orderdetail)
{
if (ModelState.IsValid)
{
db.OrderDetails.Add(orderdetail);
db.SaveChanges();
return RedirectToAction("Index");
}
ViewBag.AlbumId = new SelectList(db.Albums, "AlbumId", "Title", orderdetail.AlbumId);
ViewBag.OrderId = new SelectList(db.Orders, "OrderId", "Username", orderdetail.OrderId);
return View(orderdetail);
}
private void CreateOrder(Order order, List<Cart> cartItems)
{
decimal orderTotal = 0;
foreach (var item in cartItems)
{
var album = storeDB.Albums.Find(item.AlbumId);
var orderDetail = new OrderDetail
{
AlbumId = item.AlbumId,
OrderId = order.OrderId,
UnitPrice = album.Price,
Quantity = item.Count,
};
orderTotal += (item.Count * album.Price);
storeDB.OrderDetails.Add(orderDetail);
}
order.Total = orderTotal;
}
/// <summary>
/// Deprecated Method for adding a new object to the OrderDetails EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead.
/// </summary>
public void AddToOrderDetails(OrderDetail orderDetail)
{
base.AddObject("OrderDetails", orderDetail);
}
/// <summary>
/// Create a new OrderDetail object.
/// </summary>
/// <param name="orderDetailId">Initial value of the OrderDetailId property.</param>
/// <param name="orderId">Initial value of the OrderId property.</param>
/// <param name="albumId">Initial value of the AlbumId property.</param>
/// <param name="quantity">Initial value of the Quantity property.</param>
/// <param name="unitPrice">Initial value of the UnitPrice property.</param>
public static OrderDetail CreateOrderDetail(global::System.Int32 orderDetailId, global::System.Int32 orderId, global::System.Int32 albumId, global::System.Int32 quantity, global::System.Decimal unitPrice)
{
OrderDetail orderDetail = new OrderDetail();
orderDetail.OrderDetailId = orderDetailId;
orderDetail.OrderId = orderId;
orderDetail.AlbumId = albumId;
orderDetail.Quantity = quantity;
orderDetail.UnitPrice = unitPrice;
return orderDetail;
}
public ActionResult Edit(OrderDetail orderdetail)
{
if (ModelState.IsValid)
{
db.Entry(orderdetail).State = EntityState.Modified;
db.SaveChanges();
return RedirectToAction("Index");
}
ViewBag.AlbumId = new SelectList(db.Albums, "AlbumId", "Title", orderdetail.AlbumId);
ViewBag.OrderId = new SelectList(db.Orders, "OrderId", "Username", orderdetail.OrderId);
return View(orderdetail);
}
public int CreateOrder(Order order, List<Cart> cartItems)
{
decimal orderTotal = 0;
// Iterate over the items in the cart, adding the order details for each
foreach (var item in cartItems) {
var album = _db.Albums.Find(item.AlbumId);
var orderDetail = new OrderDetail
{
AlbumId = item.AlbumId,
OrderId = order.OrderId,
UnitPrice = album.Price,
Quantity = item.Count,
};
// Set the order total of the shopping cart
orderTotal += (item.Count * album.Price);
_db.OrderDetails.Add(orderDetail);
}
// Set the order's total to the orderTotal count
order.Total = orderTotal;
// Empty the shopping cart
EmptyCart();
// Return the OrderId as the confirmation number
return order.OrderId;
}
public int CreateOrder(Order order)
{
decimal orderTotal = 0;
var cartItems = GetCartItems();
// Iterate over the items in the cart, adding the order details for each
foreach (var item in cartItems)
{
var album = _db.Albums.Find(item.AlbumId);
var orderDetail = new OrderDetail
{
Sku = album.Title.ToLower().Replace(" ","-"),
Name = album.Title,
Discount =0,
UnitPrice = album.Price,
Quantity = item.Count,
};
// Set the order total of the shopping cart
orderTotal += (orderDetail.LineTotal);
_db.OrderDetails.Add(orderDetail);
}
// Set the order's total to the orderTotal count
order.Total = orderTotal;
// Empty the shopping cart
EmptyCart();
// Return the OrderId as the confirmation number
return order.OrderId;
}
public int CreateOrder(Order order)
{
using (var tx = storeContext.Session.BeginTransaction())
{
var cartItems = GetCartItems();
//Iterate the items in the cart, adding Order Details for each
foreach (var cartItem in cartItems)
{
var orderDetail = new OrderDetail
{
Album = cartItem.Album,
Order = order,
UnitPrice = cartItem.Album.Price
};
order.OrderDetails.Add(orderDetail);
}
//Save the order
storeContext.Session.Save(order);
tx.Commit();
}
//Empty the shopping cart
EmptyCart();
//Return the OrderId as a confirmation number
return order.OrderId;
}
