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); }
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); }
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); }
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); }
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))); }
public void Remove_News_Comments(string NewsID) { MySQL_DataConn myDP = new MySQL_DataConn(ConfigurationManager.ConnectionStrings["e2CMS"].ConnectionString); myDP.Remove_News_Comments(NewsID); }
public void Edit_News_Comment(e2Data[] UpdateData) { MySQL_DataConn myDP = new MySQL_DataConn(ConfigurationManager.ConnectionStrings["e2CMS"].ConnectionString); myDP.Edit_News_Comment(UpdateData); }
public void Add_News_Post(e2Data[] UpdateData) { MySQL_DataConn myDP = new MySQL_DataConn(ConfigurationManager.ConnectionStrings["e2CMS"].ConnectionString); myDP.Add_News_Post(UpdateData); }