public IActionResult UpdateCandy(UpdateCandyDto updatedCandyCommand, Guid id)
{
var updatedCandy = new Candy()
{
Name = updatedCandyCommand.Name,
ImgUrl = updatedCandyCommand.ImgUrl,
TypeId = updatedCandyCommand.TypeId,
Size = updatedCandyCommand.Size
};
var candyThatGotUpdated = _repo.UpdateCandy(id, updatedCandy);
return(Ok(candyThatGotUpdated));
}
public Candy UpdateCandy(UpdateCandyDto updatedCandy, int id)
{
using (var db = new SqlConnection(_connectionString))
{
var sql = @"UPDATE [Candy]
SET [Name] = @name
,[Flavor] = @flavor
,[Price] = @price
output inserted.*
WHERE id = @id";
updatedCandy.Id = id;
var candy = db.QueryFirst <Candy>(sql, updatedCandy);
return(candy);
}
}
