// add fav burger public CustomerFavorite AddCustomerFavorite(CustomerFavorite cf) { int id = _db.ExecuteScalar <int>(@" INSERT INTO CustomerFavorite(burgerId, customerId) Values(@BurgerId, @CustomerId); SELECT LAST_INSER_ID(); ", cf); cf.Id = id; return(cf); }
public ActionResult <Burger> Post([FromBody] CustomerFavorite burger) { CustomerFavorite result = _custFavRepo.AddCustomerFavorite(burger); return(Created("/api/customerfavorite" + result.Id, result)); }
public bool DeleteCustomerFavorite(CustomerFavorite cf) { int success = _db.Execute(@"DELETE FROM CustomerFavorite WHERE burgerId = @BurgerId AND customerId = @CustomerId", cf); return(success != 0); }