protected void ShowPageInfo(PageDB db)
{
Debug.WriteLine("i am trying to show the page");
bool valid = true;
string pageid = Request.QueryString["pageid"];
if (String.IsNullOrEmpty(pageid))
{
valid = false;
}
Debug.WriteLine("the page validitiy is " + valid + " and the page id is " + pageid);
if (valid)
{
Page_Class page_record = db.FindPage(Int32.Parse(pageid));
page_header_title.InnerHtml += page_record.GetTitle();
page_title.InnerHtml += page_record.GetTitle();
page_body.InnerHtml += page_record.GetBody();
author_number.InnerHtml += page_record.GetAuthorNumber();
created_date.InnerHtml += page_record.GetCreatedDate().ToString("yyyy/mm/dd");
}
if (!valid)
{
}
}
public void UpdatePage(int pageid, Page_Class new_page)
{
string query = "update HTTP_PAGE set TITLE='{0}', BODY='{1}',AUTHOR_ID='{2}' WHERE PAGE_ID='{3}' ";
query = String.Format(query, new_page.GetTitle(), new_page.GetBody(), new_page.GetAuthorNumber(), pageid);
MySqlConnection Connect = new MySqlConnection(ConnectionString);
MySqlCommand cmd = new MySqlCommand(query, Connect);
try
{
Connect.Open();
cmd.ExecuteNonQuery();
Debug.WriteLine("Excueted query " + query);
}
catch (Exception ex)
{
Debug.WriteLine("something went wrong in update method");
Debug.WriteLine(ex.ToString());
}
Connect.Close();
}
//this is function for show the information in our filed so that they can update it/
protected void ShowPageInfo(PageDB db)
{
bool valid = true;
string pageid = Request.QueryString["pageid"];
if (String.IsNullOrEmpty(pageid))
{
valid = false;
}
if (valid)
{
Page_Class page_record = db.FindPage(Int32.Parse(pageid));
page_title.InnerHtml += page_record.GetTitle();
pageTitle.Text += page_record.GetTitle();
page_body.Text += page_record.GetBody();
author_number.Text += page_record.GetAuthorNumber();
}
if (!valid)
{
Debug.WriteLine("may b check here" + pageid);
}
}
public void AddPage(Page_Class new_http_page)
{
string query = "insert into HTTP_PAGE(TITLE,BODY,AUTHOR_ID,CREATED_DATE) VALUES ('{0}','{1}','{2}','{3}')";
//UPPER STRING FOR QUERY AND VALUES IN CURLY BRACES TO REFER THESE VALUES;
query = String.Format(query, new_http_page.GetTitle(), new_http_page.GetBody(), new_http_page.GetAuthorNumber(), new_http_page.GetCreatedDate().ToString("yyyy/mm/dd"));
//now for sql connection
MySqlConnection Connect = new MySqlConnection(ConnectionString);
MySqlCommand cmd = new MySqlCommand(query, Connect);
try
{
Connect.Open();
cmd.ExecuteNonQuery();
//here excute non query for creating updating and delete
//other then this we are using excute reder for read the things
}
catch (Exception ex)
{
Debug.WriteLine("something is wrong here");
Debug.WriteLine(ex.ToString());
}
Connect.Close();
}