Ejemplo n.º 1
0
        /// <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;      
        }
Ejemplo n.º 2
0
        /// <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);
        }