/// <summary> /// Return Newest Recipe Side Panel /// </summary> public static ExtendedCollection<Article> GetArticle(int Top) { //Instantiate Action Stored Procedure object Blogic FetchData = new Blogic(); ExtendedCollection<Article> GetArticles = new ExtendedCollection<Article>(); string Key = "Newest_Articles"; if (Caching.Cache[Key] != null) { GetArticles = (ExtendedCollection<Article>)Caching.Cache[Key]; } else { IDataReader dr = FetchData.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"]; } GetArticles.Add(item); Caching.CahceData(Key, GetArticles); } dr.Close(); } return GetArticles; FetchData = null; }