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