public void DeleteItem(string Email, int ProductID) { ModelAW db = new ModelAW(); string UserID = db.EmailAddresses .Where(m => m.EmailAddress1 == Email) .First().BusinessEntityID.ToString(); var Product = db.ShoppingCartItems .Where(m => m.ShoppingCartID == UserID && m.ProductID == ProductID).FirstOrDefault(); db.ShoppingCartItems.Remove(Product); db.SaveChangesAsync(); }
public void DeleteCart(string Email) { ModelAW db = new ModelAW(); string UserID = db.EmailAddresses .Where(m => m.EmailAddress1 == Email) .FirstOrDefault() .BusinessEntityID.ToString(); var cart = db.ShoppingCartItems .Where(m => m.ShoppingCartID == UserID.ToString()); db.ShoppingCartItems.RemoveRange(cart); db.SaveChangesAsync(); }