public ProductDetailsViewModel UpdateProduct(UpdateProductViewModel userModel) { var dalModel = new StoreDALModel(); dalModel.ProductID = userModel.ProductID; dalModel.ProductName = userModel.ProductName; dalModel.Quantity = userModel.Quantity; dalModel.Price = userModel.Price; _inventoryStore.UpdateProduct(dalModel); var cartDAL = new CartDALModel(); cartDAL.ProductID = userModel.ProductID; cartDAL.ProductName = userModel.ProductName; cartDAL.Quantity = userModel.Quantity; cartDAL.Price = userModel.Price; _cartStore.UpdateOtherProperties(cartDAL); var productDetails = new ProductDetailsViewModel(); productDetails.ProductID = dalModel.ProductID; productDetails.ProductName = dalModel.ProductName; productDetails.Quantity = dalModel.Quantity; productDetails.Price = dalModel.Price; return(productDetails); }
public bool DeleteFromCart(CartDALModel dalModel) { var sql = @"DELETE FROM cart WHERE ProductID = @ProductID"; using (var connection = new SqlConnection(_config.ConnectionString)) { var result = connection.Execute(sql, dalModel); if (result == 1) { return(true); } return(false); } }
public bool UpdateQuantityInCart(CartDALModel dalModel) { var sql = @"UPDATE cart SET Quantity = @Quantity"; using (var connection = new SqlConnection(_config.ConnectionString)) { var result = connection.Execute(sql, dalModel); if (result == 1) { return(true); } return(false); } }
public bool UpdateOtherProperties(CartDALModel dalModel) { var sql = @"UPDATE cart SET ProductName = @ProductName, Quantity = @Quantity, Price = @Price"; using (var connection = new SqlConnection(_config.ConnectionString)) { var result = connection.Execute(sql, dalModel); if (result == 1) { return(true); } return(false); } }