protected void Update_Post(object sender, EventArgs e)
{
PagesConfig controller = new PagesConfig();
bool valid = true;
string pageid = Request.QueryString["pageid"];
if (String.IsNullOrEmpty(pageid))
{
valid = false;
}
if (valid)
{
Webpages new_page = new Webpages();
//call post data from form
new_page.SetTitle(post_title.Text);
new_page.SetBody(post_body.Text);
//add the post to the database
try
{
controller.UpdatePage(Int32.Parse(pageid), new_page);
Response.Redirect("ReadPage.aspx?pageid=" + pageid);
}
catch
{
valid = false;
}
}
if (!valid)
{
post.InnerHtml = "Sorry! There was an issue updating this post.";
}
}
protected void ShowPostInfo(PagesConfig controller)
{
bool valid = true;
string pageid = Request.QueryString["page_id"];
if (String.IsNullOrEmpty(pageid))
{
valid = false;
}
if (valid)
{
Webpages page_content = controller.FindPage(Int32.Parse(pageid));
posttitle.InnerHtml = page_content.GetTitle();
postbody.InnerHtml = page_content.GetBody();
}
else
{
valid = false;
}
if (!valid)
{
post.InnerHtml = "There was an error finding that post.";
}
}
public Webpages FindPage(int id)
{
MySqlConnection Connect = new MySqlConnection(ConnectionString);
Webpages show_page = new Webpages();
try
{
string query = "select * from pages where page_id = " + id;
Debug.WriteLine("Connection Initialized...");
Connect.Open();
MySqlCommand cmd = new MySqlCommand(query, Connect);
MySqlDataReader resultset = cmd.ExecuteReader();
List <Webpages> post = new List <Webpages>();
while (resultset.Read())
{
Webpages currentpage = new Webpages();
for (int i = 0; i < resultset.FieldCount; i++)
{
string key = resultset.GetName(i);
string value = resultset.GetString(i);
Debug.WriteLine("Attempting to transfer " + key + " data of " + value);
switch (key)
{
case "page_title":
currentpage.SetTitle(value);
break;
case "page_body":
currentpage.SetBody(value);
break;
}
}
post.Add(currentpage);
}
show_page = post[0];
}
catch (Exception ex)
{
Debug.WriteLine("Something went wrong in the find page method!");
Debug.WriteLine(ex.ToString());
}
Connect.Close();
Debug.WriteLine("Database Connection Terminated.");
return(show_page);
}
protected void AddPost(object sender, EventArgs e)
{
//Connect to PagesConfig class
PagesConfig db = new PagesConfig();
//Create a new post
Webpages new_post = new Webpages();
new_post.SetTitle(page_title.Text);
new_post.SetBody(page_body.Text);
db.AddPost(new_post);
Response.Redirect("ListPosts.aspx");
}
public void AddPost(Webpages new_post)
{
string query = "insert into pages (page_title, page_body) values ('{0}','{1}')";
query = String.Format(query, new_post.GetTitle(), new_post.GetBody());
MySqlConnection Connect = new MySqlConnection(ConnectionString);
MySqlCommand cmd = new MySqlCommand(query, Connect);
try
{
Connect.Open();
cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
Debug.WriteLine("Something went wrong in the add post method!");
Debug.WriteLine(ex.ToString());
}
Connect.Close();
}
protected void ShowPostInfo(PagesConfig controller)
{
bool valid = true;
string pageid = Request.QueryString["pageid"];
if (String.IsNullOrEmpty(pageid))
{
valid = false;
}
if (valid)
{
Webpages new_page = controller.FindPage(Int32.Parse(pageid));
posttitle.InnerHtml = new_page.GetTitle();
post_title.Text = new_page.GetTitle();
post_body.Text = new_page.GetBody();
if (!valid)
{
post.InnerHtml = "Sorry! There was an error finding that post.";
}
}
}
public void UpdatePage(int page_id, Webpages new_page)
{
string query = "update pages set page_title='{0}', page_body='{1}'";
query = String.Format(query, new_page.GetTitle(), new_page.GetBody(), page_id);
MySqlConnection Connect = new MySqlConnection(ConnectionString);
MySqlCommand cmd = new MySqlCommand(query, Connect);
try
{
Connect.Open();
cmd.ExecuteNonQuery();
Debug.WriteLine("Executed query " + query);
}
catch (Exception ex)
{
Debug.WriteLine("Something went wrong in the Update Page method!");
Debug.WriteLine(ex.ToString());
}
Connect.Close();
}
