//Create
public CartItem Insert(CartItem cartitem)
{
using (OrderTrackEntities ctx = new OrderTrackEntities())
{
ctx.CartItem.Add(cartitem);
ctx.SaveChanges();
return this;
}
}
//checkout
public Boolean Checkout(long OrderID)
{
try
{
using (OrderTrackEntities ctx = new OrderTrackEntities())
{
var items = GetByOrderID(OrderID);
foreach (var item in items)
{
item.IsOrdered = true;
item.DateOrdered = DateTime.Now;
CartItem cartItem = new CartItem().Update(item);
}
}
return true;
}
catch (Exception)
{
return false;
}
}
public Object GetByOrderID(long orderId)
{
List<CartItem> data = new CartItem().GetByOrderID(orderId);
var collection =
data.Select(
x =>
new
{
x.CartItemID,
x.ItemID,
x.Quantity,
x.Price,
x.AppUserID,
x.OrderID,
x.DateAdded,
x.IsOrdered,
x.DateOrdered,
Item = x.Item.Name,
UnitPrice = x.Item.Price
});
return collection;
}
//Update
public CartItem Update(CartItem cartitem)
{
using (OrderTrackEntities ctx = new OrderTrackEntities())
{
CartItem CartItem = ctx.CartItem.First(x => x.CartItemID == this.CartItemID);
CartItem = cartitem;
ctx.SaveChanges();
return CartItem;
}
}
public CartItem Put(CartItem cartitem)
{
cartitem.DateAdded = DateTime.Now;
cartitem.IsOrdered = false;
cartitem.Quantity = 0;
cartitem.Price = 0;
cartitem.DateOrdered = Convert.ToDateTime("1 Jan 1900");
return new CartItem().Insert(cartitem);
}
public CartItem Post(CartItem cartitem)
{
return new CartItem().Update(cartitem);
}