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); }