public List<Recipe> GetRelatedRecipes()
        {
            List<Recipe> newRec = new List<Recipe>();
            try
            {
                conn.Open();

                SqlCommand sqlcmd = new SqlCommand("GetRecipeTypes", conn);
                sqlcmd.CommandType = CommandType.StoredProcedure;
                DataTable table = new DataTable();

                SqlDataAdapter adapter = new SqlDataAdapter(sqlcmd);
                adapter.Fill(table);

                SqlDataReader reader = sqlcmd.ExecuteReader();
                reader.Read();


                foreach (DataRow row in table.Rows)
                {
                    Recipe rec = new Recipe(
                        row["RecipeName"].ToString(),
                        int.Parse(row["FK_Quality"].ToString()),
                        bool.Parse(row["IsApproved"].ToString()));
                        newRec.Add(rec);
                }

                conn.Close();
            }
            catch (Exception)
            {
                throw new ArgumentException("GetRecipeType failed!");
            }
            return newRec;
        }
 public List<Recipe> ReadRecipe()
 {
     // Instantiate List of Recipes newRec.
     List <Recipe> newRec = new List<Recipe>();
     //open connection
     conn.Open();
         SqlCommand sqlcmd = new SqlCommand("RetrieveRecipe", conn);
     // Define sqlcmd as a StoredProcedure.
     sqlcmd.CommandType = CommandType.StoredProcedure;
     // Datatable recipeTable is created.
     DataTable recipeTable = new DataTable();
     // sqlDataAdapter adapter is instantiated and sql is used as input parameter
     SqlDataAdapter adapter = new SqlDataAdapter(sqlcmd);
     // Adapter is filled with recipeTable DataTable as param.
     adapter.Fill(recipeTable);
     // Datareader reader instantiated
     SqlDataReader reader = sqlcmd.ExecuteReader();
     reader.Read();
     // Foreach loop that loops through all rows in our DataTable and adds to newRec (list of recipes)
     foreach (DataRow row in recipeTable.Rows)
     {
         Recipe recipe = new Recipe(
             int.Parse(row["Recipe_ID"].ToString()),
             row["RecipeName"].ToString(),
             int.Parse(row["FK_Quality"].ToString()),
             bool.Parse(row["IsApproved"].ToString()));
             //row["Description"].ToString());
         newRec.Add(recipe);       
     }
     // Connection is closed
     conn.Close();
     return newRec;
 }