Exemple #1
0
        public UpdateOrderProductQuantity UpdateQuantity(UpdateOrderProductQuantity updatedOrderQuantity)
        {
            using (var connection = new SqlConnection(ConnectionString))
            {
                var queryString    = @"Update OrderProduct
                                    Set quantity = @quantity
                                    output inserted.*
                                    Where id = @id";
                var updatedProduct = connection.QueryFirstOrDefault <UpdateOrderProductQuantity>(queryString, new { quantity = updatedOrderQuantity.Quantity, id = updatedOrderQuantity.Id });
                return(updatedProduct);
            }

            throw new Exception("Could not update product quantity");
        }
Exemple #2
0
        public ActionResult updateQuantity(UpdateOrderProductQuantity updatedOrderProduct)
        {
            var product = _connections.UpdateQuantity(updatedOrderProduct);

            return(Accepted(product));
        }