public Vuetiman Put(int id, [FromBody] Vuetiman Vuetiman)
{
if (ModelState.IsValid)
{
return(db.GetOneByIdAndUpdate(id, Vuetiman));
}
return(null);
}
public Vuetiman GetOneByIdAndUpdate(int id, Vuetiman Vuetiman)
{
return(_db.QueryFirstOrDefault <Vuetiman>($@"
UPDATE Vuetimans SET
Name = @Name,
Description = @Description,
Price = @Price
WHERE Id = {id};
SELECT * FROM Vuetimans WHERE id = {id};", Vuetiman));
}
public Vuetiman Add(Vuetiman Vuetiman)
{
int id = _db.ExecuteScalar <int>("INSERT INTO Vuetimans (Name, Description, Price)"
+ " VALUES(@Name, @Description, @Price); SELECT LAST_INSERT_ID()", new
{
Vuetiman.Name,
Vuetiman.Description,
Vuetiman.Price
});
Vuetiman.Id = id;
return(Vuetiman);
}
public Vuetiman Post([FromBody] Vuetiman Vuetiman)
{
return(db.Add(Vuetiman));
}
