Exemplo n.º 1
0
        public XmlDocument Get_News_Post_XML(string NewsID)
        {
            MySQL_DataConn myDP = new MySQL_DataConn(ConfigurationManager.ConnectionStrings["e2CMS"].ConnectionString);

            DataSet myDS = myDP.Get_News_Post_XML(NewsID);

            XmlDocument myXmlDocument = new XmlDocument();

            myXmlDocument.LoadXml(myDS.GetXml());

            return(myXmlDocument);
        }
Exemplo n.º 2
0
        public XmlDocument Get_News_Posts_XML(string CategoryID, string News_Status, string SortOrder, string Orientation, int TotalNumber)
        {
            MySQL_DataConn myDP = new MySQL_DataConn(ConfigurationManager.ConnectionStrings["e2CMS"].ConnectionString);

            DataSet myDS = myDP.Get_News_Posts(CategoryID, News_Status, SortOrder, Orientation, TotalNumber);

            XmlDocument myXmlDocument = new XmlDocument();

            myXmlDocument.LoadXml(myDS.GetXml());

            return(myXmlDocument);
        }
Exemplo n.º 3
0
        public List <News_Post> Get_News_Posts(string CategoryID, string News_Status, string SortOrder, string Orientation, int TotalNumber, string NewsDetail_URL)
        {
            MySQL_DataConn myDP = new MySQL_DataConn(ConfigurationManager.ConnectionStrings["e2CMS"].ConnectionString);

            DataSet myDS = myDP.Get_News_Posts(CategoryID, News_Status, SortOrder, Orientation, TotalNumber);

            List <News_Post> list = new List <News_Post>();

            foreach (DataRow myDR in myDS.Tables[0].Rows)
            {
                list.Add(new News_Post(myDR, NewsDetail_URL));
            }

            return(list);
        }
Exemplo n.º 4
0
        public List <News_Comment> Get_News_Comments(string NewsID, string Comment_Approved)
        {
            MySQL_DataConn myDP = new MySQL_DataConn(ConfigurationManager.ConnectionStrings["e2CMS"].ConnectionString);

            DataSet myDS = myDP.Get_News_Comments(NewsID, Comment_Approved);

            List <News_Comment> list = new List <News_Comment>();

            foreach (DataRow myDR in myDS.Tables[0].Rows)
            {
                list.Add(new News_Comment(myDR));
            }

            return(list);
        }
Exemplo n.º 5
0
        public News_Post Get_News_Post(string NewsID)
        {
            MySQL_DataConn myDP = new MySQL_DataConn(ConfigurationManager.ConnectionStrings["e2CMS"].ConnectionString);

            return(new News_Post(myDP.Get_News_Post(NewsID)));
        }
Exemplo n.º 6
0
        public void Remove_News_Comments(string NewsID)
        {
            MySQL_DataConn myDP = new MySQL_DataConn(ConfigurationManager.ConnectionStrings["e2CMS"].ConnectionString);

            myDP.Remove_News_Comments(NewsID);
        }
Exemplo n.º 7
0
        public void Edit_News_Comment(e2Data[] UpdateData)
        {
            MySQL_DataConn myDP = new MySQL_DataConn(ConfigurationManager.ConnectionStrings["e2CMS"].ConnectionString);

            myDP.Edit_News_Comment(UpdateData);
        }
Exemplo n.º 8
0
        public void Add_News_Post(e2Data[] UpdateData)
        {
            MySQL_DataConn myDP = new MySQL_DataConn(ConfigurationManager.ConnectionStrings["e2CMS"].ConnectionString);

            myDP.Add_News_Post(UpdateData);
        }