public void Test_SaveAssignsIdToObject() { //Arrange firstIngredient.Save(); //Act Ingredient testIngredient = Ingredient.GetAllIngredients()[0]; int result = firstIngredient.GetIngredientId(); int testId = testIngredient.GetIngredientId(); //Assert Assert.Equal(testId, result); }
public void AddIngredient(Ingredient newIngredient) { SqlConnection conn = DB.Connection(); conn.Open(); SqlCommand cmd = new SqlCommand("INSERT INTO ingredients_recipes (recipes_id, ingredients_id) VALUES (@RecipeId, @IngredientId);", conn); SqlParameter ingredientIdParameter = new SqlParameter("@IngredientId", newIngredient.GetIngredientId()); cmd.Parameters.Add(ingredientIdParameter); SqlParameter recipeIdParameter = new SqlParameter("@RecipeId", this.GetRecipeId()); cmd.Parameters.Add(recipeIdParameter); cmd.ExecuteNonQuery(); if (conn != null) { conn.Close(); } }