/// <summary> /// List of all content pages /// </summary> /// <returns></returns> public List <ContentPage> ListContentPages() { MySqlConnection Connect = new MySqlConnection(ConnectionString); //Create a blank list of contentpages List <ContentPage> ContentPages_List = new List <ContentPage>(); try { //Query for fetching all data string query = "select * from content_pages order by publishdate desc"; //open the db connection Connect.Open(); //Run out query MySqlCommand cmd = new MySqlCommand(query, Connect); //grab the result set MySqlDataReader resultset = cmd.ExecuteReader(); //read through the result set while (resultset.Read()) { //information that will store a single content page ContentPage Current_ContentPage = new ContentPage(); //Look at each column in the result set row, add both the column name and the column value to our Content page dictionary for (int i = 0; i < resultset.FieldCount; i++) { string key = resultset.GetName(i); string value = resultset.GetString(i); switch (key) { case "page_id": Current_ContentPage.Id = Convert.ToInt32(value); break; case "pagetitle": Current_ContentPage.Title = value; break; case "pagebody": Current_ContentPage.Body = value; break; case "publishdate": Current_ContentPage.PublishDate = Convert.ToDateTime(value); break; case "is_published": Current_ContentPage.Is_Published = Convert.ToBoolean(value); break; } } //Add the content page to the list of content pages ContentPages_List.Add(Current_ContentPage); } } catch (Exception ex) { Debug.WriteLine("Something went wrong in the List Content Pages method!"); Debug.WriteLine(ex.ToString()); } Connect.Close(); return(ContentPages_List); }
/// <summary> /// Get content page detail by id. /// </summary> /// <param name="contentpage_id">Id of content page</param> /// <returns></returns> public ContentPage GetContentPageById(int contentpage_id) { MySqlConnection Connect = new MySqlConnection(ConnectionString); //Create a blank contentpages ContentPage Result_ContentPage = new ContentPage(); try { //Query for fetching data by content page id string query = "select * from content_pages where page_id = {0}"; query = String.Format(query, contentpage_id); //open the db connection Connect.Open(); //Run out query MySqlCommand cmd = new MySqlCommand(query, Connect); //grab the result set MySqlDataReader resultset = cmd.ExecuteReader(); List <ContentPage> ContentPages = new List <ContentPage>(); //read through the result set while (resultset.Read()) { //information that will store a single content page ContentPage Current_ContentPage = new ContentPage(); //Look at each column in the result set row, add both the column name and the column value to our Content page dictionary for (int i = 0; i < resultset.FieldCount; i++) { string key = resultset.GetName(i); string value = resultset.GetString(i); switch (key) { case "page_id": Current_ContentPage.Id = Convert.ToInt32(value); break; case "pagetitle": Current_ContentPage.Title = value; break; case "pagebody": Current_ContentPage.Body = value; break; case "publishdate": Current_ContentPage.PublishDate = Convert.ToDateTime(value); break; } } //Add the content page to the list of content pages ContentPages.Add(Current_ContentPage); } Result_ContentPage = ContentPages[0]; //get the first content page } catch (Exception ex) { Debug.WriteLine("Something went wrong in the GetContentPageById method!"); Debug.WriteLine(ex.ToString()); } Connect.Close(); return(Result_ContentPage); }