public ExtendedCollection <Recipe> GetSubmitCategory() { string Key = "Submission_RecipeCategory"; ExtendedCollection <Recipe> GetRecipe = new ExtendedCollection <Recipe>(); if (Caching.Cache[Key] != null) { GetRecipe = (ExtendedCollection <Recipe>)Caching.Cache[Key]; } else { IDataReader dr = GetData; while (dr.Read()) { Recipe item = new Recipe(); item.CatID = (int)dr["CAT_ID"]; if (dr["CAT_TYPE"] != DBNull.Value) { item.Category = (string)dr["CAT_TYPE"]; } GetRecipe.Add(item); Caching.CahceData(Key, GetRecipe); } dr.Close(); } return(GetRecipe); }
/// <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; }
/// <summary> /// Returns Most Popular Recipes Side Menu /// </summary> public ExtendedCollection <Recipe> GetPopularRecipe() { //Instantiate Action Stored Procedure object Blogic FetchData = new Blogic(); ExtendedCollection <Recipe> GetRecipe = new ExtendedCollection <Recipe>(); string Key = "MostPopular_RecipesSideMenu_" + CatID.ToString(); if (Caching.Cache[Key] != null) { GetRecipe = (ExtendedCollection <Recipe>)Caching.Cache[Key]; } else { IDataReader dr = FetchData.GetMostpopularRecipesSideMenu(CatID, Top); while (dr.Read()) { Recipe item = new Recipe(); item.ID = (int)dr["ID"]; if (dr["Name"] != DBNull.Value) { item.RecipeName = (string)dr["Name"]; } if (dr["Category"] != DBNull.Value) { item.Category = (string)dr["Category"]; } if (dr["HITS"] != DBNull.Value) { item.Hits = (int)dr["HITS"]; } GetRecipe.Add(item); Caching.CahceData(Key, GetRecipe); } dr.Close(); } return(GetRecipe); FetchData = null; }
public ExtendedCollection <Recipe> GetNewestRecipe() { string Key = "Newest_RecipesSideMenu_" + CatID.ToString(); ExtendedCollection <Recipe> GetRecipe = new ExtendedCollection <Recipe>(); if (Caching.Cache[Key] != null) { GetRecipe = (ExtendedCollection <Recipe>)Caching.Cache[Key]; } else { IDataReader dr = GetData; while (dr.Read()) { Recipe item = new Recipe(); item.ID = (int)dr["ID"]; if (dr["Name"] != DBNull.Value) { item.RecipeName = (string)dr["Name"]; } if (dr["Category"] != DBNull.Value) { item.Category = (string)dr["Category"]; } if (dr["Date"] != DBNull.Value) { item.Date = (DateTime)(dr["Date"]); } if (dr["HITS"] != DBNull.Value) { item.Hits = (int)dr["HITS"]; } GetRecipe.Add(item); Caching.CahceData(Key, GetRecipe); } dr.Close(); } return(GetRecipe); }
/// <summary> /// Return Article Category /// </summary> public static ExtendedCollection <Article> GetArticle() { //Instantiate Action Stored Procedure object Blogic FetchData = new Blogic(); ExtendedCollection <Article> GetArticles = new ExtendedCollection <Article>(); string Key = "ArticleCategory_SideMenu"; if (Caching.Cache[Key] != null) { GetArticles = (ExtendedCollection <Article>)Caching.Cache[Key]; } else { IDataReader dr = FetchData.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"]); } GetArticles.Add(item); Caching.CahceData(Key, GetArticles); } dr.Close(); } return(GetArticles); FetchData = null; }
/// <summary> /// Return Recipe Main Course Category /// </summary> /// <returns></returns> public static ExtendedCollection <Recipe> GetMainCourseCategory() { //Instantiate Action Stored Procedure object Blogic FetchData = new Blogic(); ExtendedCollection <Recipe> GetRecipe = new ExtendedCollection <Recipe>(); string Key = "MainCourse_RecipeCategory"; if (Caching.Cache[Key] != null) { GetRecipe = (ExtendedCollection <Recipe>)Caching.Cache[Key]; } else { IDataReader dr = FetchData.GetHomepageMainCourseCategory; while (dr.Read()) { Recipe item = new Recipe(); item.CatID = (int)dr["CAT_ID"]; if (dr["CAT_TYPE"] != DBNull.Value) { item.Category = (string)dr["CAT_TYPE"]; } if (dr["REC_COUNT"] != DBNull.Value) { item.RecordCount = (int)(dr["REC_COUNT"]); } GetRecipe.Add(item); Caching.CahceData(Key, GetRecipe); } dr.Close(); } return(GetRecipe); FetchData = null; }