public bool IsUserAllTicketsReserved(int customerID) { IEnumerable <ShoppingCarts> tempInfo = CartInfo.Where(x => x.UserID == customerID && x.CheckOutTime == null).ToList(); return(!(tempInfo.Count() == 0)); }
public IQueryable <ShoppingCarts> RemoveAllFromCart(int customerID) { var temp = context.CartInformation.RemoveRange(CartInfo.Where(x => x.UserID == customerID)).AsQueryable(); context.SaveChanges(); return(temp); }
public void ClearCart(int customerID) { var customerCartToClear = CartInfo.Where(x => x.UserID == customerID); foreach (var i in customerCartToClear) { if (i.CheckOutTime != null) { i.Ticket.AmountRemaining += i.Quantity; } } context.CartInformation.RemoveRange(CartInfo.Where(x => x.UserID == customerID)); context.SaveChanges(); }
private List <string> TryReserveTickets(int customerID) { List <string> result = new List <string>(); IEnumerable <ShoppingCarts> customerCart = CartInfo.Where(x => x.UserID == customerID).ToList(); string returnedMessage = ""; foreach (var tempLine in customerCart) { returnedMessage = SubtractTicket(tempLine); if (returnedMessage != "") { result.Add(returnedMessage); } } context.SaveChanges(); return(result); }
public void CheckoutUser(int customerID) { Guid TransactionID = Guid.NewGuid(); IQueryable <ShoppingCarts> customerCart = CartInfo.Where(m => m.UserID == customerID); foreach (var line in customerCart) { Transaction tempTrans = new Transaction() { TicketID = line.TicketID, DateMade = DateTime.UtcNow, DealID = TransactionID.ToString(), UserID = line.UserID, PricePaid = TicketInfo.First(x => x.TicketID == line.TicketID).Price *line.Quantity }; context.Transactions.Add(tempTrans); } context.SaveChanges(); RemoveAllFromCart(customerID); }
public IQueryable <ShoppingCarts> GetUserCart(int customerID) { return(CartInfo.Where(x => x.UserID == customerID)); }