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;
}
public static ExtendedCollection<Recipe> GetRelatedRecipes(int CatId)
{
ExtendedCollection<Recipe> GetRecipe = new ExtendedCollection<Recipe>();
IDataReader dr = GetData(CatId);
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);
}
dr.Close();
return GetRecipe;
}
/// <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;
}
/// <summary>
/// Return Recipe Category
/// </summary>
public static ExtendedCollection<Recipe> GetRecipeCategoryMenu()
{
//Instantiate Action Stored Procedure object
Blogic FetchData = new Blogic();
ExtendedCollection<Recipe> GetRecipe = new ExtendedCollection<Recipe>();
string Key = "RecipeCategory_SideMenu";
if (Caching.Cache[Key] != null)
{
GetRecipe = (ExtendedCollection<Recipe>)Caching.Cache[Key];
}
else
{
IDataReader dr = FetchData.GetRecipeCategoryList_SideMenu;
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;
}
/// <summary>
/// Return Recipe Category Data
/// </summary>
public static ExtendedCollection<Recipe> GetCategories()
{
//Instantiate Action Stored Procedure object
Blogic FetchData = new Blogic();
ExtendedCollection<Recipe> GetCategory = new ExtendedCollection<Recipe>();
IDataReader dr = FetchData.AdminGetRecipeCategoryManager;
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["GROUPCAT"] != DBNull.Value)
{
item.Group = (string)dr["GROUPCAT"];
}
if (dr["REC_COUNT"] != DBNull.Value)
{
item.RecordCount = (int)(dr["REC_COUNT"]);
}
GetCategory.Add(item);
}
dr.Close();
return GetCategory;
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;
}