public void Test_SaveAssignsIdToObject()
{
//Arrange
firstRecipe.Save();
//Act
Recipe testRecipe = Recipe.GetAllRecipes()[0];
int result = firstRecipe.GetRecipeId();
int testId = testRecipe.GetRecipeId();
//Assert
Assert.Equal(testId, result);
}
public void AddRecipe(Recipe newRecipe)
{
SqlConnection conn = DB.Connection();
conn.Open();
SqlCommand cmd = new SqlCommand("INSERT INTO categories_recipes (categories_id, recipes_id) VALUES (@CategoryId, @RecipeId);", conn);
SqlParameter recipeIdParameter = new SqlParameter("@RecipeId", newRecipe.GetRecipeId());
cmd.Parameters.Add(recipeIdParameter);
SqlParameter categoryIdParameter = new SqlParameter("@CategoryId", this.GetCategoryId());
cmd.Parameters.Add(categoryIdParameter);
cmd.ExecuteNonQuery();
if (conn != null)
{
conn.Close();
}
}
