public ProductQuantitiesUpdate UpdateProductQuantitiy(ProductQuantitiesUpdate productQuantitiesUpdate)
{
using (SqlConnection connection = new SqlConnection(connectionString))
{
using (SqlCommand command = new SqlCommand("ProcedureUpdateProductsQuantity", connection))
{
command.CommandType = CommandType.StoredProcedure;
command.Parameters.AddWithValue("@ProductIDUpdate", productQuantitiesUpdate.ProductID);
command.Parameters.AddWithValue("@QuantityUpdate", productQuantitiesUpdate.ProductQuantity);
connection.Open();
command.ExecuteNonQuery();
}
return(productQuantitiesUpdate);
}
}
public IActionResult Put([FromBody] ProductQuantitiesUpdate productQuantitiesUpdate)
{
return(Ok(new ProductQuantitiesDataLayer(_configuration).UpdateProductQuantitiy(productQuantitiesUpdate)));
}
