Exemple #1
0
        /// <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;
        }