/// <summary>
/// Get article title, author, date, hits, rating and content from the DB matching the Article ID provided.
/// </summary>
public override void fillup()
{
//Instantiate Action Stored Procedure object
Blogic FetchData = new Blogic();
//Instantiate object
Utility Util = new Utility();
//Parameter 1 = we are dealing with the articledetail.aspx not the admin article update which is 2.
IDataReader dr = FetchData.GetArticleDetail(ID, WhatPageID);
dr.Read();
if (WhatPageID == constant.intArticleDetails) //Populate articledetail.aspx
{
try
{
if (dr["Title"] != DBNull.Value)
{
this._Title = (string)dr["Title"];
}
if (dr["Author"] != DBNull.Value)
{
this._Author = (string)dr["Author"];
}
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["Content"] != DBNull.Value)
{
this._Content = (string)dr["Content"];
}
if (dr["CAT_NAME"] != DBNull.Value)
{
this._Category = (string)dr["CAT_NAME"];
}
if (dr["CAT_ID"] != DBNull.Value)
{
this._CatID = (int)dr["CAT_ID"];
}
if (dr["Post_Date"] != DBNull.Value)
{
this._Date = (DateTime)(dr["Post_Date"]);
}
}
catch
{
//Redirect to page not found.
//1 = pagenotfound.aspx
Util.PageRedirect(1);
}
return;
}
else if (WhatPageID == constant.intArticleAdminUpdate) //Populate Admin/updatearticle.aspx
{
try
{
if (dr["Title"] != DBNull.Value)
{
this._Title = (string)dr["Title"];
}
if (dr["Author"] != DBNull.Value)
{
this._Author = (string)dr["Author"];
}
if (dr["CAT_NAME"] != DBNull.Value)
{
this._Category = (string)dr["CAT_NAME"];
}
if (dr["Content"] != DBNull.Value)
{
this._Content = (string)dr["Content"];
}
if (dr["Summary"] != DBNull.Value)
{
this._Summary = (string)dr["Summary"];
}
if (dr["Keyword"] != DBNull.Value)
{
this._Keyword = (string)dr["Keyword"];
}
if (dr["CAT_ID"] != DBNull.Value)
{
this._CatID = (int)dr["CAT_ID"];
}
if (dr["Post_Date"] != DBNull.Value)
{
this._Date = (DateTime)(dr["Post_Date"]);
}
}
catch
{
//Redirect to page not found.
//1 = pagenotfound.aspx
Util.PageRedirect(1);
}
return;
}
else if (WhatPageID == constant.intArticleAdminPreview) //Populate Admin/articlepreview.aspx
{
try
{
if (dr["Title"] != DBNull.Value)
{
this._Title = (string)dr["Title"];
}
if (dr["Content"] != DBNull.Value)
{
this._Content = (string)dr["Content"];
}
}
catch
{
//Redirect to page not found.
//1 = pagenotfound.aspx
Util.PageRedirect(1);
}
return;
}
//Release allocated memory
dr.Close();
dr = null;
FetchData = null;
Util = null;
}
