public void AddToCart(Item item) { // Get the matching cart and item instances var cartItem = storeDB.Cart.SingleOrDefault( c => c.CartId == ShoppingCartId && c.ItemId == item.Id); if (cartItem == null) { using (var db = new GroceryDBEntities()) { // Create a new cart item if no cart item exists cartItem = new Cart { ItemId = item.Id, CartId = ShoppingCartId, Count = 1, DateCreated = DateTime.Now }; storeDB.Cart.Add(cartItem); } } else { // If the item does exist in the cart, // then add one to the quantity cartItem.Count++; } // Save changes storeDB.SaveChanges(); }
public override string[] GetRolesForUser(string username) { GroceryDBEntities db = new GroceryDBEntities(); var account = db.User.FirstOrDefault(x => x.Username == username); return(new string[] { account.Role }); }