public Frenchfry Post([FromBody] Frenchfry frenchfry) { if (ModelState.IsValid) { frenchfry = new Frenchfry(frenchfry.Name, frenchfry.Description, frenchfry.Price); return(_repo.Create(frenchfry)); } throw new Exception("INVALID Frenchfry"); }
//UPDATE frenchfry public Frenchfry Update(Frenchfry frenchfry) { _db.Execute(@" UPDATE frenchfries SET (name, description, price) VALUES (@Name, @Description, @Price) WHERE id = @Id ", frenchfry); return(frenchfry); }
//CREATE frenchfry public Frenchfry Create(Frenchfry frenchfry) { int id = _db.ExecuteScalar <int>(@" INSERT INTO frenchfries (name, description, price) VALUES (@Name, @Description, @Price); SELECT LAST_INSERT_ID();", frenchfry ); frenchfry.Id = id; return(frenchfry); }
//DELETE frenchfry public Frenchfry Delete(Frenchfry frenchfry) { _db.Execute("DELETE FROM frenchfries WHERE id = @Id", frenchfry); return(frenchfry); }