public bool CreateFavorite(int userId, BreweryFavorite favorite)
{
try
{
using (SqlConnection conn = new SqlConnection(connectionString))
{
conn.Open();
SqlCommand cmd = new SqlCommand(SQL_CREATE_FAVORITE, conn);
cmd.Parameters.AddWithValue("@userId", userId);
cmd.Parameters.AddWithValue("@breweryId", favorite.BreweryId);
int rowsAffected = cmd.ExecuteNonQuery();
if (rowsAffected == 1)
{
return(true);
}
else
{
return(false);
}
}
}
catch (SqlException ex)
{
throw;
}
}
public ActionResult CreateFavorite(int userId, BreweryFavorite favorite)
{
bool addedToFavorites = userDAO.CreateFavorite(userId, favorite);
if (addedToFavorites)
{
return(NoContent());
}
else
{
return(BadRequest());
}
}
