public Products UpdateProductQuantity(ProductQuantityUpdate product)
{
var sql = @"update Products
set Quantity = Quantity + @NewQuantity
output inserted.*
where ProductId = @ProductId";
using (var db = new SqlConnection(ConnectionString))
{
var parameters = new
{
NewQuantity = product.Quantity,
ProductId = product.ProductId
};
return(db.QueryFirstOrDefault <Products>(sql, parameters));
}
}
public IActionResult UpdateProductQty(ProductQuantityUpdate products)
{
var updatedProductQty = _repository.UpdateProductQuantity(products);
return(Ok(updatedProductQty));
}
