public void Recipe_Update_UpdateDatabaseAndLocalObject()
{
Recipe testRecipe = new Recipe("Pot Pie", "Microwave it");
testRecipe.Save();
testRecipe.Update("Chicken Pot Pie", "Boil it", 4);
Recipe expectedRecipe = new Recipe("Chicken Pot Pie", "Boil it", 4, testRecipe.GetId());
Assert.Equal(expectedRecipe, Recipe.Find(testRecipe.GetId()));
}
public void AddRecipe(Recipe newRecipe)
{
SqlConnection conn = DB.Connection();
conn.Open();
SqlCommand cmd = new SqlCommand("INSERT INTO recipes_categories (recipe_id, category_id) VALUES (@RecipeId, @CategoryId);", conn);
cmd.Parameters.Add(new SqlParameter("@RecipeId", newRecipe.GetId().ToString()));
cmd.Parameters.Add(new SqlParameter("@CategoryId", this.GetId().ToString()));
cmd.ExecuteNonQuery();
DB.CloseSqlConnection(conn);
}
public void Find_OneRecipeId_ReturnRecipeFromDatabase()
{
//Arrange
Recipe testRecipe = new Recipe("Pot Pie", "Microwave it");
testRecipe.Save();
//Act
Recipe foundRecipe = Recipe.Find(testRecipe.GetId());
//Assert
Assert.Equal(testRecipe, foundRecipe);
}
public void Save_OneRecipe_RecipeSavedWithCorrectID()
{
//Arrange
Recipe testRecipe = new Recipe("Pot Pie", "Microwave it");
testRecipe.Save();
Recipe savedRecipe = Recipe.GetAll()[0];
//Act
int output = savedRecipe.GetId();
int verify = testRecipe.GetId();
//Assert
Assert.Equal(verify, output);
}
public override bool Equals(System.Object randomRecipe)
{
if (!(randomRecipe is Recipe))
{
return(false);
}
else
{
Recipe newRecipe = (Recipe)randomRecipe;
bool idEquality = (this.GetId() == newRecipe.GetId());
bool nameEquality = (this.GetName() == newRecipe.GetName());
bool instructionEquality = (this.GetInstruction() == newRecipe.GetInstruction());
bool ratingEquality = (this.GetRating() == newRecipe.GetRating());
return(idEquality && nameEquality && instructionEquality && ratingEquality);
}
}