public ExtendedCollection<article> GetArticle()
{
ExtendedCollection<article> list = new ExtendedCollection<article>();
IDataReader dr = GetData;
while (dr.Read())
{
article item = new article();
item.ID = (int)dr["ID"];
if (dr["Title"] != DBNull.Value)
{
item.Title = (string)dr["Title"];
}
if (dr["CAT_NAME"] != DBNull.Value)
{
item.Category = (string)dr["CAT_NAME"];
}
if (dr["Author"] != DBNull.Value)
{
item.Author = (string)dr["Author"];
}
if (dr["Summary"] != DBNull.Value)
{
item.Summary = (string)dr["Summary"];
}
if (dr["Rates"] != DBNull.Value)
{
item.Rating = dr["Rates"].ToString();
}
if (dr["No_Rates"] != DBNull.Value)
{
item.NoRates = dr["No_Rates"].ToString();
}
if (dr["Post_Date"] != DBNull.Value)
{
item.Date = (DateTime)(dr["Post_Date"]);
}
if (dr["HITS"] != DBNull.Value)
{
item.Hits = (int)dr["HITS"];
}
if (dr["UID"] != DBNull.Value)
{
item.UID = (int)dr["UID"];
}
if (dr["Total_Comments"] != DBNull.Value)
{
item.CountComments = (int)dr["Total_Comments"];
}
list.Add(item);
}
dr.Close();
return list;
}
public ExtendedCollection<article> GetArticle()
{
ExtendedCollection<article> list = new ExtendedCollection<article>();
IDataReader dr = GetData;
while (dr.Read())
{
article item = new article();
item.ID = (int)dr["ID"];
if (dr["Title"] != DBNull.Value)
{
item.Title = (string)dr["Title"];
}
if (dr["CAT_NAME"] != DBNull.Value)
{
item.Category = (string)dr["CAT_NAME"];
}
if (dr["HITS"] != DBNull.Value)
{
item.Hits = (int)dr["HITS"];
}
list.Add(item);
}
dr.Close();
return list;
}
/// <summary>
/// Return Newest Lyric Side Panel
/// </summary>
public static ExtendedCollection<article> GetArticle(int Top)
{
ExtendedCollection<article> list = new ExtendedCollection<article>();
string Key = "Newest_Articles";
if (Caching.Cache[Key] != null)
{
list = (ExtendedCollection<article>)Caching.Cache[Key];
}
else
{
IDataReader dr = Blogic.ActionProcedureDataProvider.GetNewestArticleSidePanel(Top);
while (dr.Read())
{
article item = new article();
item.ID = (int)dr["ID"];
if (dr["Title"] != DBNull.Value)
{
item.Title = (string)dr["Title"];
}
if (dr["CAT_NAME"] != DBNull.Value)
{
item.Category = (string)dr["CAT_NAME"];
}
if (dr["Post_Date"] != DBNull.Value)
{
item.Date = (DateTime)(dr["Post_Date"]);
}
if (dr["HITS"] != DBNull.Value)
{
item.Hits = (int)dr["HITS"];
}
list.Add(item);
Caching.CahceData(Key, list);
}
dr.Close();
}
return list;
}
public ExtendedCollection<article> GetArticle()
{
ExtendedCollection<article> list = new ExtendedCollection<article>();
string Key = "Last5_ArticlePublishedByUser_" + UID;
if (Caching.Cache[Key] != null)
{
list = (ExtendedCollection<article>)Caching.Cache[Key];
}
else
{
IDataReader dr = GetData;
while (dr.Read())
{
article item = new article();
item.ID = (int)dr["ID"];
if (dr["Title"] != DBNull.Value)
{
item.Title = (string)dr["Title"];
}
if (dr["ShortTitle"] != DBNull.Value)
{
item.ShortTitle = (string)dr["ShortTitle"];
}
if (dr["CAT_NAME"] != DBNull.Value)
{
item.Category = (string)dr["CAT_NAME"];
}
list.Add(item);
Caching.CahceData(Key, list);
}
dr.Close();
}
return list;
}
/// <summary>
/// Return unapproved articles
/// </summary>
public static ExtendedCollection<article> GetUnApprovedArticles()
{
ExtendedCollection<article> list = new ExtendedCollection<article>();
IDataReader dr = GetData;
while (dr.Read())
{
article item = new article();
if (dr["ID"] != DBNull.Value)
{
item.ID = (int)(dr["ID"]);
}
if (dr["CAT_NAME"] != DBNull.Value)
{
item.Category = (string)dr["CAT_NAME"];
}
if (dr["Title"] != DBNull.Value)
{
item.Title = (string)dr["Title"];
}
if (dr["Post_Date"] != DBNull.Value)
{
item.Date = (DateTime)dr["Post_Date"];
}
if (dr["Author"] != DBNull.Value)
{
item.Author = (string)dr["Author"];
}
if (dr["UID"] != DBNull.Value)
{
item.UID = (int)dr["UID"];
}
list.Add(item);
}
dr.Close();
return list;
}
/// <summary>
/// Return Article Category
/// </summary>
public static ExtendedCollection<article> GetArticle()
{
ExtendedCollection<article> list = new ExtendedCollection<article>();
string Key = "ArticleCategory_SideMenu";
if (Caching.Cache[Key] != null)
{
list = (ExtendedCollection<article>)Caching.Cache[Key];
}
else
{
IDataReader dr = Blogic.ActionProcedureDataProvider.GetArticleCategoryList;
while (dr.Read())
{
article item = new article();
item.CatID = (int)dr["CAT_ID"];
if (dr["CAT_NAME"] != DBNull.Value)
{
item.Category = (string)dr["CAT_NAME"];
}
if (dr["REC_COUNT"] != DBNull.Value)
{
item.RecordCount = (int)(dr["REC_COUNT"]);
}
list.Add(item);
Caching.CahceData(Key, list);
}
dr.Close();
}
return list;
}
/// <summary>
/// Perform Insert to Database
/// </summary>
/// <returns></returns>
public override int AddCategory(article category)
{
return Blogic.ActionProcedureDataProvider.AdminAddNewArticleCategory(category);
}
/// <summary>
/// Update a users article
/// </summary>
/// <returns></returns>
public int UpdateArticle(article article)
{
SqlParameter prmUserID = new SqlParameter("@UserID", SqlDbType.Int, 4);
prmUserID.Value = article.UID;
SqlParameter prmID = new SqlParameter("@AID", SqlDbType.Int, 4);
prmID.Value = article.ID;
SqlParameter prmTitle = new SqlParameter("@Title", SqlDbType.NVarChar, 200);
prmTitle.Value = article.Title;
SqlParameter prmContent = new SqlParameter("@Content", SqlDbType.NText);
prmContent.Value = article.Content;
SqlParameter prmCatID = new SqlParameter("@CAT_ID", SqlDbType.Int, 4);
prmCatID.Value = article.CatID;
SqlParameter prmKeyword = new SqlParameter("@Keyword", SqlDbType.NVarChar, 100);
prmKeyword.Value = article.Keyword;
SqlParameter prmSummary = new SqlParameter("@Summary", SqlDbType.NVarChar, 800);
prmSummary.Value = article.Summary;
return DataAccess.Execute("spUpdateArticle", prmUserID, prmID, prmTitle, prmContent, prmCatID, prmKeyword, prmSummary);
}
/// <summary>
/// Admin Lyric Manager Delete Lyric
/// </summary>
/// <returns></returns>
public int AdminDeleteArticle(article article)
{
SqlParameter prmID = new SqlParameter("@ID", SqlDbType.Int, 4);
prmID.Value = article.ID;
return DataAccess.Execute("ArticleDelete", prmID);
}
public virtual int AddCategory(article category)
{
return 0;
}
public virtual int Add(article article)
{
return 0;
}
/// <summary>
/// Perform Update
/// </summary>
/// <returns></returns>
public override int UpdateCategory(article category)
{
return Blogic.ActionProcedureDataProvider.UpdateArticleCategory(category);
}
/// <summary>
/// Perform Update
/// </summary>
/// <returns></returns>
public override int Update(article article)
{
return Blogic.ActionProcedureDataProvider.UpdateArticle(article);
}
/// <summary>
/// Perform Delete
/// </summary>
/// <returns></returns>
public override int Delete(article article)
{
return Blogic.ActionProcedureDataProvider.AdminDeleteArticle(article);
}
/// <summary>
/// Insert article
/// </summary>
/// <returns></returns>
public int AddArticle(article article)
{
SqlParameter prmUserID = new SqlParameter("@UserID", SqlDbType.Int, 4);
prmUserID.Value = article.UID;
SqlParameter prmTitle = new SqlParameter("@Title", SqlDbType.VarChar, 200);
prmTitle.Value = article.Title;
SqlParameter prmContent = new SqlParameter("@Content", SqlDbType.NText);
prmContent.Value = article.Content;
SqlParameter prmAuthor = new SqlParameter("@Author", SqlDbType.VarChar, 50);
prmAuthor.Value = article.Author;
SqlParameter prmCatID = new SqlParameter("@CAT_ID", SqlDbType.Int, 4);
prmCatID.Value = article.CatID;
SqlParameter prmKeyword = new SqlParameter("@Keyword", SqlDbType.VarChar, 255);
prmKeyword.Value = article.Keyword;
SqlParameter prmSummary = new SqlParameter("@Summary", SqlDbType.VarChar, 500);
prmSummary.Value = article.Summary;
return DataAccess.Execute("spInsertArticle", prmUserID, prmTitle, prmContent, prmAuthor, prmCatID, prmKeyword, prmSummary);
}
public virtual int Delete(article article)
{
return 0;
}
/// <summary>
/// Add New Article Category
/// </summary>
/// <returns></returns>
public int AdminAddNewArticleCategory(article category)
{
SqlParameter prmCatName = new SqlParameter("@CatName", SqlDbType.VarChar, 100);
prmCatName.Value = category.Category;
return DataAccess.Execute("AdminAddNewArticleCategory", prmCatName);
}
public virtual int Update(article article)
{
return 0;
}
/// <summary>
/// Delete Article Category
/// </summary>
/// <returns></returns>
public int AdminDeleteArticleCategory(article category)
{
SqlParameter prmCatId = new SqlParameter("@Catid", SqlDbType.Int, 4);
prmCatId.Value = category.CatID;
return DataAccess.Execute("AdminDeleteArticleCategory", prmCatId);
}
public virtual int UpdateCategory(article category)
{
return 0;
}
/// <summary>
/// Update Lyric Comment
/// </summary>
/// <returns></returns>
public int UpdateArticleCategory(article category)
{
SqlParameter prmCatId = new SqlParameter("@Catid", SqlDbType.Int, 4);
prmCatId.Value = category.CatID;
SqlParameter prmCatName = new SqlParameter("@CatName", SqlDbType.NVarChar, 100);
prmCatName.Value = category.Category;
return DataAccess.Execute("UpdateArticleCategory", prmCatId, prmCatName);
}
/// <summary>
/// Perform Insert to Database
/// </summary>
/// <returns></returns>
public override int Add(article article)
{
return Blogic.ActionProcedureDataProvider.AddArticle(article);
}
