// 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(); }