using System; using System.Collections; using System.ComponentModel; using System.Data; using System.Data.SqlClient; using System.Drawing; using System.Web; using System.Web.SessionState; using System.Web.UI; using System.Web.UI.WebControls; using System.Web.UI.HtmlControls; namespace AeroNet { ///

/// Summary description for Airport. ///

public class Airport : Common { protected string title = "Аэропорты мира: "; protected string AirportName; protected string AirportNameEng; protected string images; protected int countryid; protected string icao; protected int step; protected string iata; protected string coord; protected string elevation; protected string LocalTime; protected string WorkTime; protected string city; protected string notes; protected void PrintMenu () { Response.Write ("

"); Response.Write ("

Аэропорт
Airport
"); Response.Write ("

Топливозаправочные компании
Fuel
"); Response.Write ("

Техническое обслуживание ВС
Line / Ramp Engineering
"); Response.Write ("

Коммерческое обслуживание
Handling Agents
"); Response.Write ("

"); Response.Write ("

Бортпитание
Caterers
"); Response.Write ("

Гостиницы
Hotels
"); Response.Write ("

Банки
Banks
"); Response.Write ("

Транспорт
Transport
"); Response.Write ("

"); } protected void PrintAirport() { SqlConnection connAirport = new SqlConnection(connString); SqlCommand cmdAirport = new SqlCommand(("SELECT * FROM V_AirportUnit WHERE CodeICAO='"+icao.ToString()+"' AND CompanyTypeID=1"), connAirport); connAirport.Open(); SqlDataReader drAirport; drAirport = cmdAirport.ExecuteReader(); Response.Write (""); if (drAirport.Read()) { Response.Write (""); } drAirport.Close(); Response.Write (""); //Таможенный контроль SqlCommand cmdCustoms = new SqlCommand(("SELECT * FROM V_Customs WHERE CodeICAO='"+icao.ToString()+"'"), connAirport); SqlDataReader drCustoms; drCustoms = cmdCustoms.ExecuteReader(); if (drCustoms.Read()) { Response.Write (""); } drCustoms.Close(); //Паспортный контроль SqlCommand cmdImmigration = new SqlCommand(("SELECT * FROM V_Immigration WHERE CodeICAO='"+icao.ToString()+"'"), connAirport); SqlDataReader drImmigration; drImmigration = cmdImmigration.ExecuteReader(); if (drImmigration.Read()) { Response.Write ("

Паспортный контроль

"); if (drImmigration["Phone"].ToString() !="") {Response.Write ("

Телефон: "+drImmigration["Phone"].ToString()+"

");} if (drImmigration["Fax"].ToString() !="") {Response.Write ("

Факс: "+drImmigration["Fax"].ToString()+"

");} if (drImmigration["WorkTime"].ToString() !="") {Response.Write ("

Время работы: "+drImmigration["WorkTime"].ToString()+"

");} if (drImmigration["Information"].ToString() !="") {Response.Write ("

Документы: "+drImmigration["Information"].ToString()+"

");} if (drImmigration["Notes"].ToString() !="") {Response.Write ("

Примечание: "+drImmigration["Notes"].ToString()+"

");} } else { Response.Write (""); } drImmigration.Close(); Response.Write ("

Аэропорт
"+drAirport["CompanyName"].ToString()+" "); Response.Write (" Адрес: "+drAirport["Address"].ToString()+", "+drAirport["City"].ToString()+" "); if (drAirport["Phone"].ToString() !="") {Response.Write (" Телефон: "+drAirport["Phone"].ToString()+" ");} if (drAirport["Fax"].ToString() !="") {Response.Write (" Факс: "+drAirport["Fax"].ToString()+" ");} if (drAirport["Telex"].ToString() !="") {Response.Write (" Телекс: "+drAirport["Telex"].ToString()+" ");} if (drAirport["SITA"].ToString() !="") {Response.Write (" SITA: "+drAirport["SITA"].ToString()+" ");} if (drAirport["AFTN"].ToString() !="") {Response.Write (" AFTN: "+drAirport["AFTN"].ToString()+" ");} if (drAirport["Email"].ToString() !="") {Response.Write (" E-mail: "+drAirport["Email"].ToString()+" ");} if (drAirport["ATC"].ToString() !="") {Response.Write (" УВД: "+drAirport["ATC"].ToString()+" (Air Traffic Control) ");} if (drAirport["AIS"].ToString() !="") {Response.Write (" Аэронавигация: "+drAirport["AIS"].ToString()+" (Aeronautical Information Services) ");} if (drAirport["MET"].ToString() !="") {Response.Write (" Метеообеспечение: "+drAirport["MET"].ToString()+" ");} if (drAirport["WorkTime"].ToString() !="") {Response.Write (" Время работы: "+drAirport["WorkTime"].ToString()+" ");} if (drAirport["Notes"].ToString() !="") {Response.Write (" Примечание: "+drAirport["Notes"].ToString()+" ");} } else { Response.Write ("	Отсутствуют данные	Таможенный контроль "); if (drCustoms["Phone"].ToString() !="") {Response.Write (" Телефон: "+drCustoms["Phone"].ToString()+" ");} if (drCustoms["Fax"].ToString() !="") {Response.Write (" Факс: "+drCustoms["Fax"].ToString()+" ");} if (drCustoms["WorkTime"].ToString() !="") {Response.Write (" Время работы: "+drCustoms["WorkTime"].ToString()+" ");} if (drCustoms["Information"].ToString() !="") {Response.Write (" Документы: "+drCustoms["Information"].ToString()+" ");} if (drCustoms["Notes"].ToString() !="") {Response.Write (" Примечание: "+drCustoms["Notes"].ToString()+" ");} } else { Response.Write ("	Отсутствуют данные	Отсутствуют данные

"); //Закрываем соединение connAirport.Close(); } protected void PrintFuel() { SqlConnection connFuel = new SqlConnection(connString); SqlCommand cmdFuel = new SqlCommand(("SELECT * FROM V_AirportUnit WHERE CodeICAO='"+icao.ToString()+"' AND CompanyTypeID=3"), connFuel); connFuel.Open(); SqlDataReader drFuel; drFuel = cmdFuel.ExecuteReader(); Response.Write (""); while (drFuel.Read()) { if (drFuel["CompanyName"].ToString() !="") Response.Write (""); } drFuel.Close(); Response.Write ("

Топливозаправочные компании

"+drFuel["CompanyName"].ToString()+"

"); if (drFuel["Address"].ToString() !="") Response.Write ("

Адрес: "+drFuel["Address"].ToString()+", "+drFuel["City"].ToString()+"

"); if (drFuel["Phone"].ToString() !="") Response.Write ("

Телефон: "+drFuel["Phone"].ToString()+"

"); if (drFuel["Fax"].ToString() !="") Response.Write ("

Факс: "+drFuel["Fax"].ToString()+"

"); if (drFuel["Telex"].ToString() !="") Response.Write ("

Телекс: "+drFuel["Telex"].ToString()+"

"); if (drFuel["AFTN"].ToString() !="") Response.Write ("

AFTN: "+drFuel["AFTN"].ToString()+"

"); if (drFuel["SITA"].ToString() !="") Response.Write ("

SITA: "+drFuel["SITA"].ToString()+"

"); if (drFuel["WorkTime"].ToString() !="") Response.Write ("

Время работы: "+drFuel["WorkTime"].ToString()+"

"); if (drFuel["Notes"].ToString() !="") Response.Write ("

Примечание: "+drFuel["Notes"].ToString()+"

"); Response.Write ("

"); //Закрываем соединение connFuel.Close(); } protected void PrintRamp() { SqlConnection connRamp = new SqlConnection(connString); SqlCommand cmdRamp = new SqlCommand(("SELECT * FROM V_AirportUnit WHERE CodeICAO='"+icao.ToString()+"' AND CompanyTypeID=5"), connRamp); connRamp.Open(); SqlDataReader drRamp; drRamp = cmdRamp.ExecuteReader(); Response.Write (""); while (drRamp.Read()) { if (drRamp["CompanyName"].ToString() !="") Response.Write (""); } drRamp.Close(); Response.Write ("

Техническое обслуживание ВС

"+drRamp["CompanyName"].ToString()+"

"); if (drRamp["Address"].ToString() !="") Response.Write ("

Адрес: "+drRamp["Address"].ToString()+", "+drRamp["City"].ToString()+"

"); if (drRamp["Phone"].ToString() !="") Response.Write ("

Телефон: "+drRamp["Phone"].ToString()+"

"); if (drRamp["Fax"].ToString() !="") Response.Write ("

Факс: "+drRamp["Fax"].ToString()+"

"); if (drRamp["Telex"].ToString() !="") Response.Write ("

Телекс: "+drRamp["Telex"].ToString()+"

"); if (drRamp["AFTN"].ToString() !="") Response.Write ("

AFTN: "+drRamp["AFTN"].ToString()+"

"); if (drRamp["SITA"].ToString() !="") Response.Write ("

SITA: "+drRamp["SITA"].ToString()+"

"); if (drRamp["WorkTime"].ToString() !="") Response.Write ("

Время работы: "+drRamp["WorkTime"].ToString()+"

"); if (drRamp["Notes"].ToString() !="") Response.Write ("

Примечание: "+drRamp["Notes"].ToString()+"

"); Response.Write ("

"); //Закрываем соединение connRamp.Close(); } protected void PrintHandling() { SqlConnection connHandling = new SqlConnection(connString); SqlCommand cmdHandling = new SqlCommand(("SELECT * FROM V_AirportUnit WHERE CodeICAO='"+icao.ToString()+"' AND CompanyTypeID=2"), connHandling); connHandling.Open(); SqlDataReader drHandling; drHandling = cmdHandling.ExecuteReader(); Response.Write (""); while (drHandling.Read()) { if (Convert.ToInt32(drHandling["UnitTypeID"]) == 20) { if (drHandling["CompanyName"].ToString() !="") Response.Write (""); } drHandling.Close(); Response.Write ("

Коммерческое обслуживание

"+drHandling["CompanyName"].ToString()+"

"); if (drHandling["Address"].ToString() !="") Response.Write ("

Адрес: "+drHandling["Address"].ToString()+", "+drHandling["City"].ToString()+"

"); if (drHandling["Phone"].ToString() !="") Response.Write ("

Телефон: "+drHandling["Phone"].ToString()+"

"); if (drHandling["Fax"].ToString() !="") Response.Write ("

Факс: "+drHandling["Fax"].ToString()+"

"); if (drHandling["Telex"].ToString() !="") Response.Write ("

Телекс: "+drHandling["Telex"].ToString()+"

"); if (drHandling["SITA"].ToString() !="") Response.Write ("

SITA: "+drHandling["SITA"].ToString()+"

"); if (drHandling["AFTN"].ToString() !="") Response.Write ("

AFTN: "+drHandling["AFTN"].ToString()+"

"); if (drHandling["Email"].ToString() !="") Response.Write ("

E-mail: "+drHandling["Email"].ToString()+"

"); if (drHandling["WorkTime"].ToString() !="") Response.Write ("

Время работы: "+drHandling["WorkTime"].ToString()+"

"); if (drHandling["Notes"].ToString() !="") Response.Write ("

Примечание: "+drHandling["Notes"].ToString()+"

"); } else if (Convert.ToInt32(drHandling["UnitTypeID"]) == 5) { Response.Write ("

Пассажирские рейсы

"); if (drHandling["Phone"].ToString() !="") Response.Write ("

Телефон: "+drHandling["Phone"].ToString()+"

"); if (drHandling["Fax"].ToString() !="") Response.Write ("

Факс: "+drHandling["Fax"].ToString()+"

"); if (drHandling["Telex"].ToString() !="") Response.Write ("

Телекс: "+drHandling["Telex"].ToString()+"

"); if (drHandling["SITA"].ToString() !="") Response.Write ("

SITA: "+drHandling["SITA"].ToString()+"

"); if (drHandling["AFTN"].ToString() !="") Response.Write ("

AFTN: "+drHandling["AFTN"].ToString()+"

"); if (drHandling["WorkTime"].ToString() !="") Response.Write ("

Время работы: "+drHandling["WorkTime"].ToString()+"

"); if (drHandling["Notes"].ToString() !="") Response.Write ("

Примечание: "+drHandling["Notes"].ToString()+"

"); } else if (Convert.ToInt32(drHandling["UnitTypeID"]) == 6) { Response.Write ("

Грузовые рейсы

"); if (drHandling["Phone"].ToString() !="") Response.Write ("

Телефон: "+drHandling["Phone"].ToString()+"

"); if (drHandling["Fax"].ToString() !="") Response.Write ("

Факс: "+drHandling["Fax"].ToString()+"

"); if (drHandling["Telex"].ToString() !="") Response.Write ("

Телекс: "+drHandling["Telex"].ToString()+"

"); if (drHandling["SITA"].ToString() !="") Response.Write ("

SITA: "+drHandling["SITA"].ToString()+"

"); if (drHandling["AFTN"].ToString() !="") Response.Write ("

AFTN: "+drHandling["AFTN"].ToString()+"

"); if (drHandling["WorkTime"].ToString() !="") Response.Write ("

Время работы: "+drHandling["WorkTime"].ToString()+"

"); if (drHandling["Notes"].ToString() !="") Response.Write ("

Примечание: "+drHandling["Notes"].ToString()+"

"); } else { Response.Write ("

Корпоративные / VIP рейсы

"); if (drHandling["Phone"].ToString() !="") Response.Write ("

Телефон: "+drHandling["Phone"].ToString()+"

"); if (drHandling["Fax"].ToString() !="") Response.Write ("

Факс: "+drHandling["Fax"].ToString()+"

"); if (drHandling["Telex"].ToString() !="") Response.Write ("

Телекс: "+drHandling["Telex"].ToString()+"

"); if (drHandling["SITA"].ToString() !="") Response.Write ("

SITA: "+drHandling["SITA"].ToString()+"

"); if (drHandling["AFTN"].ToString() !="") Response.Write ("

AFTN: "+drHandling["AFTN"].ToString()+"

"); if (drHandling["WorkTime"].ToString() !="") Response.Write ("

Время работы: "+drHandling["WorkTime"].ToString()+"

"); if (drHandling["Notes"].ToString() !="") Response.Write ("

Примечание: "+drHandling["Notes"].ToString()+"

"); } Response.Write ("

"); //Закрываем соединение connHandling.Close(); } protected void PrintCaterers() { SqlConnection connCaterers = new SqlConnection(connString); SqlCommand cmdCaterers = new SqlCommand(("SELECT * FROM V_AirportUnit WHERE CodeICAO='"+icao.ToString()+"' AND CompanyTypeID=4"), connCaterers); connCaterers.Open(); SqlDataReader drCaterers; drCaterers = cmdCaterers.ExecuteReader(); Response.Write (""); while (drCaterers.Read()) { if (drCaterers["CompanyName"].ToString() !="") Response.Write (""); } drCaterers.Close(); Response.Write ("

Бортпитание

"+drCaterers["CompanyName"].ToString()+"

"); if (drCaterers["Address"].ToString() !="") Response.Write ("

Адрес: "+drCaterers["Address"].ToString()+", "+drCaterers["City"].ToString()+"

"); if (drCaterers["Phone"].ToString() !="") Response.Write ("

Телефон: "+drCaterers["Phone"].ToString()+"

"); if (drCaterers["Fax"].ToString() !="") Response.Write ("

Факс: "+drCaterers["Fax"].ToString()+"

"); if (drCaterers["Telex"].ToString() !="") Response.Write ("

Телекс: "+drCaterers["Telex"].ToString()+"

"); if (drCaterers["AFTN"].ToString() !="") Response.Write ("

AFTN: "+drCaterers["AFTN"].ToString()+"

"); if (drCaterers["SITA"].ToString() !="") Response.Write ("

SITA: "+drCaterers["SITA"].ToString()+"

"); if (drCaterers["WorkTime"].ToString() !="") Response.Write ("

Время работы: "+drCaterers["WorkTime"].ToString()+"

"); if (drCaterers["Notes"].ToString() !="") Response.Write ("

Примечание: "+drCaterers["Notes"].ToString()+"

"); Response.Write ("

"); //Закрываем соединение connCaterers.Close(); } protected void PrintHotel() { SqlConnection connHotel = new SqlConnection(connString); SqlCommand cmdHotel = new SqlCommand(("SELECT * FROM V_AirportUnit WHERE CodeICAO='"+icao.ToString()+"' AND CompanyTypeID=7"), connHotel); connHotel.Open(); SqlDataReader drHotel; drHotel = cmdHotel.ExecuteReader(); Response.Write (""); while (drHotel.Read()) { if (drHotel["CompanyName"].ToString() !="") Response.Write (""); } drHotel.Close(); Response.Write ("

Гостиницы

"+drHotel["CompanyName"].ToString()+"

"); if (drHotel["Address"].ToString() !="") Response.Write ("

Адрес: "+drHotel["Address"].ToString()+", "+drHotel["City"].ToString()+"

"); if (drHotel["Phone"].ToString() !="") Response.Write ("

Телефон: "+drHotel["Phone"].ToString()+"

"); if (drHotel["Fax"].ToString() !="") Response.Write ("

Факс: "+drHotel["Fax"].ToString()+"

"); if (drHotel["Telex"].ToString() !="") Response.Write ("

Телекс: "+drHotel["Telex"].ToString()+"

"); if (drHotel["Notes"].ToString() !="") Response.Write ("

Расположение: "+drHotel["Notes"].ToString()+"

"); Response.Write ("

"); //Закрываем соединение connHotel.Close(); } protected void PrintBank() { SqlConnection connBank = new SqlConnection(connString); SqlCommand cmdBank = new SqlCommand(("SELECT * FROM V_AirportUnit WHERE CodeICAO='"+icao.ToString()+"' AND CompanyTypeID=6"), connBank); connBank.Open(); SqlDataReader drBank; drBank = cmdBank.ExecuteReader(); Response.Write (""); while (drBank.Read()) { if (drBank["CompanyName"].ToString() !="") Response.Write (""); } drBank.Close(); Response.Write ("

Банк

"+drBank["CompanyName"].ToString()+"

"); if (drBank["Address"].ToString() !="") Response.Write ("

Адрес: "+drBank["Address"].ToString()+", "+drBank["City"].ToString()+"

"); if (drBank["Phone"].ToString() !="") Response.Write ("

Телефон: "+drBank["Phone"].ToString()+"

"); if (drBank["Fax"].ToString() !="") Response.Write ("

Факс: "+drBank["Fax"].ToString()+"

"); if (drBank["WorkTime"].ToString() !="") Response.Write ("

Время работы: "+drBank["WorkTime"].ToString()+"

"); if (drBank["Notes"].ToString() !="") Response.Write ("

Расположение: "+drBank["Notes"].ToString()+"

"); Response.Write ("

"); //Закрываем соединение connBank.Close(); } protected void PrintTransport() { SqlConnection connTransport = new SqlConnection(connString); SqlCommand cmdTransport = new SqlCommand(("SELECT * FROM V_AirportUnit WHERE CodeICAO='"+icao.ToString()+"' AND CompanyTypeID=8"), connTransport); connTransport.Open(); SqlDataReader drTransport; drTransport = cmdTransport.ExecuteReader(); Response.Write (""); while (drTransport.Read()) { if (drTransport["CompanyName"].ToString() !="") Response.Write (""); } drTransport.Close(); Response.Write ("

Транспорт, аренда автомобилей

"+drTransport["CompanyName"].ToString()+"

"); if (drTransport["Address"].ToString() !="") Response.Write ("

Адрес: "+drTransport["Address"].ToString()+", "+drTransport["City"].ToString()+"

"); if (drTransport["Phone"].ToString() !="") Response.Write ("

Телефон: "+drTransport["Phone"].ToString()+"

"); if (drTransport["Fax"].ToString() !="") Response.Write ("

Факс: "+drTransport["Fax"].ToString()+"

"); if (drTransport["Notes"].ToString() !="") Response.Write ("

Примечание: "+drTransport["Notes"].ToString()+"

"); Response.Write ("

"); //Закрываем соединение connTransport.Close(); } private void Page_Load(object sender, System.EventArgs e) { //Загрузить верхнее меню TopMenu(); //Получить countryid из строки запроса if (Request.QueryString["countryid"] == null) { countryid = 0; } else { countryid = Convert.ToInt32(Request.QueryString["countryid"]); } //Получить icao из строки запроса if (Request.QueryString["icao"] == null) { Response.Redirect("Country.aspx"); } else { icao = Request.QueryString["icao"].ToString(); } //Получить step из строки запроса if (Request.QueryString["step"] == null) { step = 1; } else { step = Convert.ToInt32(Request.QueryString["step"]); } //Установить название аэропорта // Соединение с SQL-сервером SqlConnection connAirportName = new SqlConnection(connString); //Создать команду SqlCommand cmdAirportName = new SqlCommand(("SELECT * FROM V_Airport WHERE CodeICAO='"+icao.ToString()+"'"), connAirportName); //Открыть соединение connAirportName.Open(); //Создать DataReader и считать данные SqlDataReader drAirportName; drAirportName = cmdAirportName.ExecuteReader(); if (drAirportName.Read()) { AirportName = drAirportName["RusName"].ToString(); AirportNameEng = drAirportName["EngName"].ToString(); iata = drAirportName["CodeIATA"].ToString(); coord = drAirportName["Latitude"].ToString()+" "+drAirportName["Longitude"].ToString(); elevation = drAirportName["Elevation"].ToString(); LocalTime = drAirportName["LocalTime"].ToString(); WorkTime = drAirportName["WorkTime"].ToString(); city = drAirportName["City"].ToString(); notes = drAirportName["Notes"].ToString(); images = " "+AirportName+"

"; } else { Response.Redirect("Country.aspx"); } //Закрываем DataReader и соединение drAirportName.Close(); connAirportName.Close(); } #region Web Form Designer generated code override protected void OnInit(EventArgs e) { // // CODEGEN: This call is required by the ASP.NET Web Form Designer. // InitializeComponent(); base.OnInit(e); } ///

/// Required method for Designer support - do not modify /// the contents of this method with the code editor. ///

private void InitializeComponent() { this.Load += new System.EventHandler(this.Page_Load); } #endregion } }