public void SearchIDS() { ZJX_Application x = new ZJX_Application(); try { string strCon = "datasource=167.114.146.160;port=3306;username=zjxartcc_app;password=rE2f86DNT9U74s43"; MySqlConnection myConn = new MySqlConnection(strCon); string query = "select * from zjxartcc_laravel.ids_airports where id ='" + x.txt_sqlicao.Text + "';"; MySqlCommand MyCommand2 = new MySqlCommand(query, myConn); myConn.Open(); MySqlDataReader myReader; myReader = MyCommand2.ExecuteReader(); while (myReader.Read()) { x.txt_sqlicao.Text = myReader["id"].ToString(); x.combo_sqlatis.Text = myReader["atis"].ToString(); x.txt_sqldep.Text = myReader["departure"].ToString(); x.txt_sqlarr.Text = myReader["arrival"].ToString(); x.combo_sqlapp.Text = myReader["approach"].ToString(); } myConn.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
public void getMetar() { ZJX_Application x = new ZJX_Application(); string icao = x.text_entermetaricao.Text; string urlleft = "https://www.aviationweather.gov/adds/dataserver_current/httpparam?dataSource=metars&requestType=retrieve&format=xml&hoursBeforeNow=2&mostRecentForEachStation=true&stationString="; string url = urlleft + icao; XmlDocument doc = new XmlDocument(); doc.Load(url); XmlNodeList xnList = doc.SelectNodes("/response[@*]/data"); foreach (XmlNode xn in xnList) { XmlNode metar = xn.SelectSingleNode("METAR"); if (metar != null) { string raw = metar["raw_text"].InnerText; string observation_time = metar["observation_time"].InnerText; string station_id = metar["station_id"].InnerText; string temp_c = metar["temp_c"].InnerText; string dewpoint_c = metar["dewpoint_c"].InnerText; string wind_dir_degrees = metar["wind_dir_degrees"].InnerText; string wind_speed_kt = metar["wind_speed_kt"].InnerText; string visibility_statute_mi = metar["visibility_statute_mi"].InnerText; string altim_in_hg = metar["altim_in_hg"].InnerText; string sea_level_pressure_mb = metar["sea_level_pressure_mb"].InnerText; string flight_category = metar["flight_category"].InnerText; x.txt_metar.Text = raw + "\r\n" + "Decoded Metar" + "\r\n" + "Station ID: " + station_id + "\r\n" + "Observation Time: " + observation_time + "\r\n" + "Wind: " + wind_dir_degrees + "/" + wind_speed_kt + "kts" + "\r\n" + "Temperature: " + temp_c + "\r\n" + "Dewpoint: " + dewpoint_c + "\r\n" + "Visibility: " + visibility_statute_mi + "\r\n" + "Altimiter: " + altim_in_hg + "\r\n" + "Sea Level Pressure: " + sea_level_pressure_mb + " HPa" + "\r\n" + "Flight Category: " + flight_category; } if (metar == null) { x.txt_metar.Text = "No METAR Available"; } } }
public void ClearIDS() { ZJX_Application x = new ZJX_Application(); try { string strCon = "datasource=167.114.146.160;port=3306;username=zjxartcc_app;password=rE2f86DNT9U74s43"; MySqlConnection myConn = new MySqlConnection(strCon); string Query = "update zjxartcc_laravel.ids_airports set atis='',departure='',arrival='',approach='' where id='" + x.txt_sqlicao.Text + "';"; MySqlCommand MyCommand2 = new MySqlCommand(Query, myConn); MySqlDataReader MyReader2; myConn.Open(); MyReader2 = MyCommand2.ExecuteReader(); MessageBox.Show("Data Cleared"); myConn.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }