protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
//If the page is not being loaded in response to a postBack the ShowPage()
CMSDB db = new CMSDB();
// The below section of code is used to get the List of Authors from the Page table and display them in a dropdown box. Similar to CreatePage.aspx.cs
List <HTTP_Page> pageList = new List <HTTP_Page>();
pageList = db.ListPages("select distinct pageauthor from page;");
foreach (HTTP_Page page in pageList)
{
ListItem item = new ListItem();
item.Text = page.GetPageAuthor();
item.Value = page.GetPageAuthor();
page_author_list.Items.Add(item);
}
ListItem newAuthorItem = new ListItem();
newAuthorItem.Text = "-------------- Add a new Author --------------";
newAuthorItem.Value = "New";
page_author_list.Items.Add(newAuthorItem);
//Getting the pageid from the Request object
string pageid = Request.QueryString["pageid"];
//If pageid is empty the custom error message will be written, otherwise the page details will be fetched from the database and shown in the input fields.
if (String.IsNullOrEmpty(pageid))
{
page_update.InnerHtml = "There was an error finding that student.";
}
else
{
HTTP_Page page_record = db.ViewPage(Int32.Parse(pageid));
page_update.InnerHtml = page_record.GetPageTitle();
page_title.Text = page_record.GetPageTitle();
page_content.Text = page_record.GetPageContent();
page_author_list.SelectedValue = page_record.GetPageAuthor();
page_publish_date.Text = page_record.GetPagePublishDate();
}
}
}
public void UpdatePage(int pageid, HTTP_Page new_page)
{
//SQL query to update the PAGE table with the new values.
string query = "update PAGE set PAGETITLE='{0}', PAGEBODY='{1}', PAGEAUTHOR='{2}', PAGESTATUS='{3}' where PAGEID = '{4}'";
//To update values for PAGESTATUS field which is of type boolean. 0 is inserted if PAGESTATUS is false, 1 if true.
int page_publish_value = 0;
if (new_page.GetPagePublishStatus())
{
page_publish_value = 1;
}
//Getting data from 'new_page' object which is passed in the parameter of the function during the function call. ('db.AddPage(new_page)')
query = String.Format(query, new_page.GetPageTitle(), new_page.GetPageContent(), new_page.GetPageAuthor(), page_publish_value, pageid);
//Creating a new connection object using the connection string and Creating an object for a MySqlCommand using query and the connect object.
MySqlConnection Connect = new MySqlConnection(ConnectionString);
MySqlCommand cmd = new MySqlCommand(query, Connect);
try
{
//Opening the connection and executing the query on the database.
Connect.Open();
cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
Debug.WriteLine("Exception in the updatePage(int pageId, HTTP_Page page) method!");
Debug.WriteLine(ex.ToString());
}
finally
{
//Database connection is closed.
Connect.Close();
}
}
public void AddPage(HTTP_Page new_page)
{
//SQL query to insert data into the PAGE table
string query = "insert into PAGE (PAGETITLE,PAGEBODY,PAGEDATE,PAGESTATUS,PAGEAUTHOR) values ('{0}','{1}',now(),'{2}','{3}')";
//To insert values for PAGESTATUS field which is of type boolean. 0 is inserted if PAGESTATUS is false, 1 if true.
int page_publish_value = 0;
if (new_page.GetPagePublishStatus())
{
page_publish_value = 1;
}
//Getting data from 'new_page' object which is passed in the parameter of the function during the function call. ('db.AddPage(new_page)')
query = String.Format(query, new_page.GetPageTitle(), new_page.GetPageContent(), page_publish_value, new_page.GetPageAuthor());
//Creating a new connection object using the connection string and Creating an object for a MySqlCommand using query and the connect object.
MySqlConnection Connect = new MySqlConnection(ConnectionString);
MySqlCommand cmd = new MySqlCommand(query, Connect);
//try catch and finally for exception handling
try
{
Connect.Open();
cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
Debug.WriteLine("Exception in the AddPage(HTTP_Page new_page) method");
Debug.WriteLine(ex.ToString());
}
finally
{
Connect.Close();
}
}