public static List <RecipeIngredients> GetAll()
{
List <RecipeIngredients> allRecipeIngredients = new List <RecipeIngredients> {
};
MySqlConnection conn = DB.Connection();
conn.Open();
MySqlCommand cmd = conn.CreateCommand() as MySqlCommand;
cmd.CommandText = @"SELECT * FROM recipe_ingredients;";
MySqlDataReader rdr = cmd.ExecuteReader() as MySqlDataReader;
while (rdr.Read())
{
int id = rdr.GetInt32(0);
int recipeID = rdr.GetInt32(1);
int ingredientID = rdr.GetInt32(2);
RecipeIngredients newRecipeIngredient = new RecipeIngredients(recipeID, ingredientID, id);
allRecipeIngredients.Add(newRecipeIngredient);
}
conn.Close();
if (conn != null)
{
conn.Dispose();
}
return(allRecipeIngredients);
}
public static RecipeIngredients FindRecipeIngredientsById(int searchId)
{
int id = 0;
int recipeID = 0;
int ingredientID = 0;
MySqlConnection conn = DB.Connection();
conn.Open();
MySqlCommand cmd = conn.CreateCommand() as MySqlCommand;
cmd.CommandText = @"SELECT * FROM recipe_ingredients WHERE id = @MatchId;";
MySqlParameter newMatchId = new MySqlParameter();
newMatchId.ParameterName = "@MatchId";
newMatchId.Value = searchId;
cmd.Parameters.Add(newMatchId);
MySqlDataReader rdr = cmd.ExecuteReader() as MySqlDataReader;
while (rdr.Read())
{
id = rdr.GetInt32(0);
recipeID = rdr.GetInt32(1);
ingredientID = rdr.GetInt32(2);
}
RecipeIngredients foundRecipeingredients = new RecipeIngredients(recipeID, ingredientID, id);
conn.Close();
if (conn != null)
{
conn.Dispose();
}
return(foundRecipeingredients);
}
public override bool Equals(System.Object otherRecipeIngredients)
{
if (!(otherRecipeIngredients is RecipeIngredients))
{
return(false);
}
else
{
RecipeIngredients newRecipeIngredients = (RecipeIngredients)otherRecipeIngredients;
bool recipeIDEquality = (this.GetRecipeID() == newRecipeIngredients.GetRecipeID());
bool ingredientIDEquality = (this.GetIngredientID() == newRecipeIngredients.GetIngredientID());
bool idEquality = (this.GetId() == newRecipeIngredients.GetId());
return(recipeIDEquality && ingredientIDEquality && idEquality);
}
}
