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