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)); }