/// <summary> /// Returns the most popular Video tags /// </summary> public static List<TagCloudItem> GetVideoTagCloud() { Database db = DatabaseFactory.CreateDatabase(); DbCommand dbcommand = db.GetStoredProcCommand("HG_GetVideoTagCloud"); List<TagCloudItem> Cloud = new List<TagCloudItem>(); using (IDataReader dr = db.ExecuteReader(dbcommand)) { while(dr.Read()) { TagCloudItem item = new TagCloudItem(); item.Count = (int)dr[0]; item.Tag = (string)dr[1]; Cloud.Add(item); } dr.Close(); } return Cloud; }
/// <summary> /// Returns the most popular Video tags /// </summary> public static List <TagCloudItem> GetVideoTagCloud() { Database db = DatabaseFactory.CreateDatabase(); DbCommand dbcommand = db.GetStoredProcCommand("HG_GetVideoTagCloud"); List <TagCloudItem> Cloud = new List <TagCloudItem>(); using (IDataReader dr = db.ExecuteReader(dbcommand)) { while (dr.Read()) { TagCloudItem item = new TagCloudItem(); item.Count = (int)dr[0]; item.Tag = (string)dr[1]; Cloud.Add(item); } dr.Close(); } return(Cloud); }