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