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