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