public ProductsPriceUpdate UpdateProductPrice(ProductsPriceUpdate productsPriceUpdate)
{
using (SqlConnection connection = new SqlConnection(connectionString))
{
using (SqlCommand command = new SqlCommand("ProcedureUpdateProductsPrice", connection))
{
command.CommandType = CommandType.StoredProcedure;
command.Parameters.AddWithValue("@PriceIDUpdate", productsPriceUpdate.ProductPriceID);
command.Parameters.AddWithValue("@PriceValueUpdate", productsPriceUpdate.ProductPrice);
connection.Open();
command.ExecuteNonQuery();
}
return(productsPriceUpdate);
}
}
public IActionResult Put([FromBody] ProductsPriceUpdate productsPriceUpdate)
{
return(Ok(new ProductPricesDataLayer(_configuration).UpdateProductPrice(productsPriceUpdate)));
}
