public FavBreweries GetFav(int id, int breweryId)
        {
            FavBreweries fav = new FavBreweries();

            try
            {
                using (SqlConnection conn = new SqlConnection(connectionString))
                {
                    conn.Open();
                    string     sqlText = "SELECT user_id from users_favBreweries where brewery_id = @breweryId and user_id = @userId";
                    SqlCommand cmd     = new SqlCommand(sqlText, conn);
                    cmd.Parameters.AddWithValue("@breweryId", breweryId);
                    cmd.Parameters.AddWithValue("@userId", id);
                    SqlDataReader reader = cmd.ExecuteReader();

                    while (reader.Read())
                    {
                        fav.UserId = Convert.ToInt32(reader["user_id"]);
                    }
                    return(fav);
                }
            }
            catch (Exception)
            {
                throw;
            }
        }
        public List <FavBreweries> GetFavoriteBreweries(int id)
        {
            List <FavBreweries> favorites = new List <FavBreweries>();

            try
            {
                using (SqlConnection conn = new SqlConnection(connectionString))
                {
                    conn.Open();

                    string     sqlText = "SELECT brewery_id from users_favBreweries where user_id = @userId";
                    SqlCommand cmd     = new SqlCommand(sqlText, conn);
                    cmd.Parameters.AddWithValue("@userId", id);
                    SqlDataReader reader = cmd.ExecuteReader();

                    while (reader.Read())
                    {
                        FavBreweries favBreweries = new FavBreweries();
                        favBreweries.UserId    = id;
                        favBreweries.BreweryID = Convert.ToInt32(reader["brewery_id"]);

                        favorites.Add(favBreweries);
                    }

                    return(favorites);
                }
            }
            catch (Exception)
            {
                throw;
            }
        }
Example #3
0
        public ActionResult <FavBreweries> DeleteFav(int id, int breweryId)
        {
            FavBreweries favBreweries = favBreweryDAO.GetFav(id, breweryId);

            if (favBreweries == null)
            {
                return(NotFound("Id does not exist"));
            }
            favBreweryDAO.DeleteFav(id, breweryId);
            return(NoContent());
        }
 public FavBreweries AddFavoriteBrewery(FavBreweries favBrewery)
 {
     try
     {
         using (SqlConnection conn = new SqlConnection(connectionString))
         {
             conn.Open();
             string     sqlText = "INSERT INTO users_favBreweries(user_id, brewery_id) values (@userId, @breweryId);";
             SqlCommand cmd     = new SqlCommand(sqlText, conn);
             cmd.Parameters.AddWithValue("@userId", favBrewery.UserId);
             cmd.Parameters.AddWithValue("@breweryId", favBrewery.BreweryID);
             cmd.ExecuteNonQuery();
         }
     }
     catch (Exception)
     {
         throw;
     }
     return(favBrewery);
 }
Example #5
0
        public ActionResult <FavBreweries> AddFavoriteBrewrey(FavBreweries favBrewery)
        {
            FavBreweries newFave = favBreweryDAO.AddFavoriteBrewery(favBrewery);

            return(Created($"/beer/{newFave}", newFave));
        }