private XmlNode GetNode(int CategoryID, XmlDocument xdoc)
        {
            XmlNode TempNode = xdoc.CreateElement("categorynode");

            NewsModelBll bll = new NewsModelBll();
            NewsCategoryModel CategoryModel = new NewsCategoryModelBll().GetModel(CategoryID);
            DataTable dt = bll.GetTopCategoryNews(6, CategoryID);

            XmlNode NewsCategoryNode = XmlUtility.AddNewNode(TempNode, "category", null);

            if (CategoryModel != null)
            {
                XmlUtility.AddNewNode(NewsCategoryNode, "categoryid", CategoryModel.CateID.ToString());
                XmlUtility.AddNewNode(NewsCategoryNode, "categoryname", CategoryModel.CateName);

                XmlNode NewsListNode = XmlUtility.AddNewNode(TempNode, "newslist", null);
                foreach (DataRow row in dt.Rows)
                {
                    XmlNode NewsNode = XmlUtility.AddNewNode(NewsListNode, "news", null);

                    XmlUtility.AddNewNode(NewsNode, "newsid", row["newsid"].ToString());
                    XmlUtility.AddNewNode(NewsNode, "title", row["title"].ToString());
                    XmlUtility.AddNewNode(NewsNode, "image", NewsImageRule.GetImageUrl(row["imageurl"].ToString()));
                    XmlUtility.AddNewNode(NewsNode, "video", NewsVideoRule.GetVideoUrl(row["videourl"].ToString()));
                }
            }

            return TempNode;
        }
        public XmlDocument GetData(NameValueCollection TagParameter)
        {
            XmlDocument xdoc = new XmlDocument();
            xdoc.LoadXml("<?xml version=\"1.0\" encoding=\"utf-8\"?><tag />");
            XmlNode rootNode = xdoc.SelectSingleNode("/tag");

            int CategoryID = 43;

            NewsModelBll bll = new NewsModelBll();
            NewsCategoryModel CategoryModel = new NewsCategoryModelBll().GetModel(CategoryID);
            DataTable dt = bll.GetTopCategoryNews(6, CategoryID);

            XmlNode NewsCategoryNode = XmlUtility.AddNewNode(rootNode, "category", null);

            if (CategoryModel != null)
            {

                XmlUtility.AddNewNode(NewsCategoryNode, "categoryid", CategoryModel.CateID.ToString());
                XmlUtility.AddNewNode(NewsCategoryNode, "categoryname", CategoryModel.CateName);

                XmlNode NewsListNode = XmlUtility.AddNewNode(rootNode, "newslist", null);
                foreach (DataRow row in dt.Rows)
                {
                    XmlNode NewsNode = XmlUtility.AddNewNode(NewsListNode, "news", null);

                    XmlUtility.AddNewNode(NewsNode, "newsid", row["newsid"].ToString());
                    XmlUtility.AddNewNode(NewsNode, "title", row["title"].ToString());
                    XmlUtility.AddNewNode(NewsNode, "image", NewsImageRule.GetImageUrl(row["imageurl"].ToString()));
                    XmlUtility.AddNewNode(NewsNode, "video", NewsVideoRule.GetVideoUrl(row["videourl"].ToString()));
                }
            }

            return xdoc;
        }
        public XmlDocument GetData(NameValueCollection TagParameter)
        {
            XmlDocument xdoc = new XmlDocument();
            xdoc.LoadXml("<?xml version=\"1.0\" encoding=\"utf-8\"?><tag />");
            XmlNode rootNode = xdoc.SelectSingleNode("/tag");

            NewsModelBll bll = new NewsModelBll();

            XmlNode CategoryNodel1 = XmlUtility.AddNewNode(rootNode, "category1", null);

            NewsCategoryModel Category1Model = new NewsCategoryModelBll().GetModel(3);
            DataTable dt1 = bll.GetTopCategoryNews(6, 3);

            XmlNode NewsCategoryNode1 = XmlUtility.AddNewNode(CategoryNodel1, "category", null);
            XmlNode NewsListNode1 = XmlUtility.AddNewNode(CategoryNodel1, "newslist", null);

            if (Category1Model != null)
            {
                XmlUtility.AddNewNode(NewsCategoryNode1, "categoryid", Category1Model.CateID.ToString());
                XmlUtility.AddNewNode(NewsCategoryNode1, "categoryname", Category1Model.CateName);

                foreach (DataRow row in dt1.Rows)
                {
                    XmlNode NewsNode = XmlUtility.AddNewNode(NewsListNode1, "news", null);

                    XmlUtility.AddNewNode(NewsNode, "newsid", row["newsid"].ToString());
                    XmlUtility.AddNewNode(NewsNode, "title", row["title"].ToString().Length > 15 ? row["title"].ToString().Substring(0, 14) + "..." : row["title"].ToString());
                    XmlUtility.AddNewNode(NewsNode, "image", NewsImageRule.GetImageUrl(row["imageurl"].ToString()));
                    XmlUtility.AddNewNode(NewsNode, "video", NewsVideoRule.GetVideoUrl(row["videourl"].ToString()));
                }
            }

            XmlNode CategoryNode2 = XmlUtility.AddNewNode(rootNode, "category2", null);

            NewsCategoryModel CategoryModel2 = new NewsCategoryModelBll().GetModel(6);
            DataTable dt2 = bll.GetTopCategoryNews(6, 6);

            XmlNode NewsCategoryNode2 = XmlUtility.AddNewNode(CategoryNode2, "category", null);
            XmlNode NewsListNode2 = XmlUtility.AddNewNode(CategoryNode2, "newslist", null);

            if (CategoryModel2 != null)
            {
                XmlUtility.AddNewNode(NewsCategoryNode2, "categoryid", CategoryModel2.CateID.ToString());
                XmlUtility.AddNewNode(NewsCategoryNode2, "categoryname", CategoryModel2.CateName);

                foreach (DataRow row in dt2.Rows)
                {
                    XmlNode NewsNode = XmlUtility.AddNewNode(NewsListNode2, "news", null);

                    XmlUtility.AddNewNode(NewsNode, "newsid", row["newsid"].ToString());
                    XmlUtility.AddNewNode(NewsNode, "title", row["title"].ToString().Length > 17 ? row["title"].ToString().Substring(0, 16) + "..." : row["title"].ToString());
                    XmlUtility.AddNewNode(NewsNode, "image", NewsImageRule.GetImageUrl(row["imageurl"].ToString()));
                    XmlUtility.AddNewNode(NewsNode, "video", NewsVideoRule.GetVideoUrl(row["videourl"].ToString()));
                }
            }

            return xdoc;
        }
        public XmlDocument GetData(NameValueCollection TagParameter)
        {
            XmlDocument xdoc = new XmlDocument();
            xdoc.LoadXml("<?xml version=\"1.0\" encoding=\"utf-8\"?><tag />");
            XmlNode rootNode = xdoc.SelectSingleNode("/tag");

            NewsModelBll bll = new NewsModelBll();

            DataTable dt = bll.GetTopViewedNews(15);

            foreach(DataRow row in dt.Rows)
            {
                XmlNode NewsNode = XmlUtility.AddNewNode(rootNode, "news", null);

                XmlUtility.AddNewNode(NewsNode, "newsid", row["newsid"].ToString());
                XmlUtility.AddNewNode(NewsNode, "title", row["title"].ToString());
            }

            return xdoc;
        }