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