/// <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(); //Instantiate object Utility Util = new Utility(); /* The reason why we have to use a conditional statement is because we are dealing with 3 diffrent * stored procedures to return the data. Each sproc has its number of columns declared and diffrent where clauses. */ if (WhatPageID == constant.intRecipeDetails) //Populate Recipedetail.aspx database fields { try { IDataReader dr = FetchData.GetRecipeDetail(ID); dr.Read(); if (dr["Name"] != DBNull.Value) { this._RecipeName = (string)dr["Name"]; } if (dr["Author"] != DBNull.Value) { this._Author = (string)dr["Author"]; } 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"]; } if (dr["Ingredients"] != DBNull.Value) { this._Ingredients = (string)dr["Ingredients"]; } if (dr["Instructions"] != DBNull.Value) { this._Instructions = (string)dr["Instructions"]; } if (dr["Date"] != DBNull.Value) { this._Date = (DateTime)(dr["Date"]); } if (dr["TOTAL_COMMENTS"] != DBNull.Value) { this._CountComments = (int)dr["TOTAL_COMMENTS"]; } if (dr["LINK_APPROVED"] != DBNull.Value) { this._Approved = (int)dr["LINK_APPROVED"]; } if (dr["RecipeImage"] != DBNull.Value) { this._RecipeImage = (string)dr["RecipeImage"]; } //Release allocated memory dr.Close(); dr = null; } catch { //Redirect to page not found. //1 = pagenotfound.aspx Util.PageRedirect(1); } return; } else if (WhatPageID == constant.intRecipeAdminViewing) //Populate Admin/viewing.aspx database fields { try { IDataReader dr = FetchData.AdminRecipeApprovalReview(ID); dr.Read(); if (dr["Name"] != DBNull.Value) { this._RecipeName = (string)dr["Name"]; } if (dr["Author"] != DBNull.Value) { this._Author = (string)dr["Author"]; } if (dr["HITS"] != DBNull.Value) { this._Hits = (int)dr["HITS"]; } if (dr["Category"] != DBNull.Value) { this._Category = (string)dr["Category"]; } if (dr["Ingredients"] != DBNull.Value) { this._Ingredients = (string)dr["Ingredients"]; } if (dr["Instructions"] != DBNull.Value) { this._Instructions = (string)dr["Instructions"]; } if (dr["Date"] != DBNull.Value) { this._Date = (DateTime)(dr["Date"]); } if (dr["LINK_APPROVED"] != DBNull.Value) { this._Approved = (int)dr["LINK_APPROVED"]; } if (dr["HIT_DATE"] != DBNull.Value) { this._HitDate = (DateTime)dr["HIT_DATE"]; } //Release allocated memory dr.Close(); dr = null; } catch { //Redirect to page not found. //1 = pagenotfound.aspx Util.PageRedirect(1); } return; } else if (WhatPageID == constant.intRecipeAdminEditing) //Populate Admin/editing.aspx database fields { try { IDataReader dr = FetchData.GetRecipeDetailForUpdate(ID); dr.Read(); if (dr["Name"] != DBNull.Value) { this._RecipeName = (string)dr["Name"]; } if (dr["Author"] != DBNull.Value) { this._Author = (string)dr["Author"]; } if (dr["HITS"] != DBNull.Value) { this._Hits = (int)dr["HITS"]; } if (dr["Ingredients"] != DBNull.Value) { this._Ingredients = (string)dr["Ingredients"]; } if (dr["Instructions"] != DBNull.Value) { this._Instructions = (string)dr["Instructions"]; } //Release allocated memory dr.Close(); dr = null; } catch { //Redirect to page not found. //1 = pagenotfound.aspx Util.PageRedirect(1); } return; } //Release allocated memory FetchData = null; Util = null; }