public Webpage FindWebPage(int id)
{
MySqlConnection sqlCon = new MySqlConnection(ConnectionString);
Webpage result_page = new Webpage();
try
{
string query = "select * from PAGES where page_id = " + id;
sqlCon.Open();
MySqlCommand cmd = new MySqlCommand(query, sqlCon);
MySqlDataReader resultset = cmd.ExecuteReader();
List <Webpage> page = new List <Webpage>();
while (resultset.Read())
{
Webpage currentpage = new Webpage();
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.set_W_title(value);
break;
case "page_body":
currentpage.set_W_body(value);
break;
case "publish_author":
currentpage.set_W_author(value);
break;
case "publish_state":
currentpage.set_W_publish_state(value);
break;
case "publish_date":
currentpage.set_W_publish_date(value);
break;
}
}
page.Add(currentpage);
}
result_page = page[0];
}
catch (Exception ex)
{
Debug.WriteLine("Check the findWebpage()");
Debug.WriteLine(ex.ToString());
}
sqlCon.Close();
Debug.WriteLine("Database Connection Terminated.");
return(result_page);
}
