public void Test_FindFindsRecipeInDatabase() { //Arrange Recipe firstRecipe = new Recipe("Salmon", "Salmon", "Boil", "3"); firstRecipe.Save(); //Act Recipe result = Recipe.Find(firstRecipe.GetId()); //Assert Assert.Equal(firstRecipe, result); }
public void Test_SaveAssignsIdToObject() { //Arrange Recipe firstRecipe = new Recipe("Salmon", "Salmon", "Boil", "3"); firstRecipe.Save(); //Act Recipe savedRecipe = Recipe.GetAll()[0]; int result = savedRecipe.GetId(); int testId = firstRecipe.GetId(); //Assert Assert.Equal(testId, result); }
public override bool Equals(System.Object otherRecipe) { if (!(otherRecipe is Recipe)) { return(false); } else { Recipe newRecipe = (Recipe)otherRecipe; bool idEquality = this.GetId() == newRecipe.GetId(); bool nameEquality = this.GetName() == newRecipe.GetName(); bool ingredientsEquality = this.GetIngredients() == newRecipe.GetIngredients(); bool instructionsEquality = this.GetInstructions() == newRecipe.GetInstructions(); bool ratingEquality = this.GetRating() == newRecipe.GetRating(); return(idEquality && nameEquality && ingredientsEquality && instructionsEquality && ratingEquality); } }
public void AddRecipe(Recipe newRecipe) { SqlConnection conn = DB.Connection(); conn.Open(); SqlCommand cmd = new SqlCommand("INSERT INTO cookbook (recipe_id, category_id) VALUES (@RecipeId, @CategoryId);", conn); SqlParameter idRecipeParam = new SqlParameter("@RecipeId", newRecipe.GetId()); SqlParameter idCategoryParam = new SqlParameter("@CategoryId", this.GetId()); cmd.Parameters.Add(idRecipeParam); cmd.Parameters.Add(idCategoryParam); cmd.ExecuteNonQuery(); if (conn != null) { conn.Close(); } }