internal void Create(BurgerFries newData)
{
BurgerFries exists = _repo.Find(newData);
if (exists != null)
{
throw new Exception("Combo already a thing!");
}
_repo.Create(newData);
}
public ActionResult <String> Edit([FromBody] BurgerFries bfs)
{
try
{
return(Ok(_bfs.Delete(bfs)));
}
catch (Exception e)
{
return(BadRequest(e.Message));
}
}
internal string Delete(BurgerFries bfs)
{
BurgerFries exists = _repo.Find(bfs);
if (exists == null)
{
throw new Exception("Invalid Id Combo!");
}
_repo.Delete(exists.Id);
return("Successfully Deleted");
}
public ActionResult <String> Create([FromBody] BurgerFries newData)
{
try
{
_bfs.Create(newData);
return(Ok("Success"));
}
catch (Exception e)
{
return(BadRequest(e.Message));
}
}
internal BurgerFries Create(BurgerFries newData)
{
string sql = @"
INSERT INTO burgerfries
(burgerId, friesId)
VALUES
(@BurgerId, @FriesId);
SELECT LAST_INSERT_ID();
";
int id = _db.ExecuteScalar <int>(sql, newData);
newData.Id = id;
return(newData);
}
internal BurgerFries Find(BurgerFries bfs)
{
string sql = "SELECT * FROM burgerfries WHERE (burgerId = @BurgerId AND friesId = @FriesId)";
return(_db.QueryFirstOrDefault(sql, bfs));
}
