public void Ingredient_Update_UpdateDatabaseAndLocalObject() { Ingredient testIngredient = new Ingredient("Pepper"); testIngredient.Save(); testIngredient.Update("Ketchup"); Ingredient expectedIngredient = new Ingredient("Ketchup", testIngredient.GetId()); Assert.Equal(expectedIngredient, Ingredient.Find(testIngredient.GetId())); }
public void Find_OneIngredientId_ReturnIngredientFromDatabase() { //Arrange Ingredient testIngredient = new Ingredient("Pepper"); testIngredient.Save(); //Act Ingredient foundIngredient = Ingredient.Find(testIngredient.GetId()); //Assert Assert.Equal(testIngredient, foundIngredient); }
public void AddIngredient(Ingredient newIngredient, string amount) { SqlConnection conn = DB.Connection(); conn.Open(); SqlCommand cmd = new SqlCommand("INSERT INTO recipes_ingredients (recipe_id, ingredient_id, amount) VALUES (@RecipeId, @IngredientId,@Amount);", conn); cmd.Parameters.Add(new SqlParameter("@RecipeId", this.GetId().ToString())); cmd.Parameters.Add(new SqlParameter("@IngredientId", newIngredient.GetId().ToString())); cmd.Parameters.Add(new SqlParameter("@Amount", amount)); cmd.ExecuteNonQuery(); DB.CloseSqlConnection(conn); }
public void Save_OneIngredient_IngredientSavedWithCorrectID() { //Arrange Ingredient testIngredient = new Ingredient("Pepper"); testIngredient.Save(); Ingredient savedIngredient = Ingredient.GetAll()[0]; //Act int output = savedIngredient.GetId(); int verify = testIngredient.GetId(); //Assert Assert.Equal(verify, output); }
public override bool Equals(System.Object randomIngredient) { if (!(randomIngredient is Ingredient)) { return(false); } else { Ingredient newIngredient = (Ingredient)randomIngredient; bool idEquality = (this.GetId() == newIngredient.GetId()); bool nameEquality = (this.GetName() == newIngredient.GetName()); bool amountEquality = (this.GetAmount() == newIngredient.GetAmount()); return(idEquality && nameEquality && amountEquality); } }
public void UpdateAmount(Ingredient targetIngredient, string newAmount) { SqlConnection conn = DB.Connection(); conn.Open(); SqlCommand cmd = new SqlCommand("UPDATE recipes_ingredients SET amount = @NewAmount WHERE recipe_id = @TargetId AND ingredient_id= @TargetIngredientId; ", conn); cmd.Parameters.Add(new SqlParameter("@NewAmount", newAmount)); cmd.Parameters.Add(new SqlParameter("@TargetId", this.GetId())); cmd.Parameters.Add(new SqlParameter("@TargetIngredientId", targetIngredient.GetId())); cmd.ExecuteNonQuery(); targetIngredient.SetAmount(newAmount); DB.CloseSqlConnection(conn); }