// THIS FUNCTION IS TO SHOW THE PLANET INFORMATION WHICH IS STORED BY ADD PAGE .
// HERE WE TAKING VALUES FROM DATABASE FOR PLANET TITLE AND PLANET DETAILS.
protected void ShowplanetInfo(PLANETSDB db)
{
bool valid = true;
string planetsid = Request.QueryString["planets_id"];
if (String.IsNullOrEmpty(planetsid))
{
valid = false;
}
if (valid)
{
planet planets_record = db.Findplanet(Int32.Parse(planetsid));
planets_title.InnerHtml += planets_record.GetPtitle();
planets_body.InnerHtml += planets_record.GetPbody();
}
else
{
valid = false;
}
if (!valid)
{
planet.InnerHtml = "There was an error finding that planet.";
}
}
// HERE IS THE FUNCTIONALITY TO ADD PLANET INTO THE DATABASE .
public void Addplanet(planet new_planet)
{
string query = "insert into planets (planets_title,planets_body) values ('{0}','{1}')";
query = String.Format(query, new_planet.GetPtitle(), new_planet.GetPbody());
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 planet Method!");
Debug.WriteLine(ex.ToString());
}
Connect.Close();
}
// THIS IS TO UPDATE NEW ENTERIES INTO THE DATABASE.
public void Updateplanet(int planetid, planet new_planet)
{
string query = "update planets set planets_title='{0}', planets_body='{1}' where planets_id='{2}'";
query = String.Format(query, new_planet.GetPtitle(), new_planet.GetPbody(), planetid);
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 Updateplanet Method!");
Debug.WriteLine(ex.ToString());
}
Connect.Close();
}
