protected void ShowAuthorInfo(Pagedb db)
{
bool valid = true;
string authorid = Request.QueryString["authorid"];
if (String.IsNullOrEmpty(authorid))
{
valid = false;
}
show_authorfname.InnerHtml = "";
show_authorlname.InnerHtml = "";
if (valid)
{
Authors author_record = db.FindAuthor(Int32.Parse(authorid));
show_authorfname.InnerHtml = author_record.GetAuthorfname();
show_authorlname.InnerHtml = author_record.GetAuthorlname();
show_authorfullname.InnerHtml = show_authorfname.InnerHtml + " " + show_authorlname.InnerHtml;
}
else
{
valid = false;
}
}
public void Update_Author(int authorid, Authors new_author)
{
string query = "update authors set authorfname='{0}', authorlname='{1}' where authorid={2}";
query = String.Format(query, new_author.GetAuthorfname(), new_author.GetAuthorlname(), authorid);
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_Author Method!");
Debug.WriteLine(ex.ToString());
}
Connect.Close();
}
//adding a new author
public void Add_Author(Authors new_author)
{
string query = "insert into authors (authorfname, authorlname) values('{0}', '{1}')";
query = String.Format(query, new_author.GetAuthorfname(), new_author.GetAuthorlname());
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_Author Method!");
Debug.WriteLine(ex.ToString());
}
Connect.Close();
}