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