//GetLibrariesByBookId
// public IEnumerable<Burger> GetBurgersByCustomerId(int id)
// {
// return _db.Query<Burger>($@"
// SELECT * FROM customerburgers cb
// INNER JOIN burgers b ON b.id = cb.burgerId
// WHERE (burgerId = @id);
// ", new { id });
// }
//AddLibraryBook
public CustomerBurger AddCustomerBurger(CustomerBurger cb)
{
int id = _db.ExecuteScalar <int>(@"
INSERT INTO CustomerBurgers(customerId, burgerId)
VALUES(@CustomerId, @BurgerId);
SELECT LAST_INSERT_ID();
", cb);
cb.Id = id;
return(cb);
}
public ActionResult <string> Post([FromBody] CustomerBurger cb)
{
CustomerBurger result = _custBurgRepo.AddCustomerBurger(cb);
return(Created("/api/customerburger/" + result.Id, result));
}
