/// <summary>
/// Get recipe name, author, date, hits, rating, ingredients, instructions and other field from the DB matching the Recipe ID provided.
/// </summary>
public override void fillup()
{
//Instantiate Action Stored Procedure object
Blogic FetchData = new Blogic();
try
{
IDataReader dr = FetchData.GetRandomRecipeSideMenu(CatID);
dr.Read();
if (dr["ID"] != DBNull.Value)
{
this._ID = (int)dr["ID"];
}
if (dr["Name"] != DBNull.Value)
{
this._RecipeName = (string)dr["Name"];
}
if (dr["CAT_ID"] != DBNull.Value)
{
this._CatID = (int)dr["CAT_ID"];
}
if (dr["NO_RATES"] != DBNull.Value)
{
this._NoRates = dr["NO_RATES"].ToString();
}
if (dr["HITS"] != DBNull.Value)
{
this._Hits = (int)dr["HITS"];
}
if (dr["Rates"] != DBNull.Value)
{
this._Rating = dr["Rates"].ToString();
}
if (dr["Category"] != DBNull.Value)
{
this._Category = (string)dr["Category"];
}
//Release allocated memory
dr.Close();
dr = null;
}
catch (Exception ex)
{
throw ex;
}
FetchData = null;
}
