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