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>
	/// Summary description for aircraft.
	/// </summary>
	public class aircraft : Common
	{
		protected string country = "";


		protected void PrintAircraftTitle()
		{
			// Соединение с SQL-сервером
			SqlConnection connAircraftTitle = new SqlConnection(connString);
			//Создать команду
			SqlCommand cmdAircraftTitle = new SqlCommand(("SELECT * FROM V_AircraftTitle ORDER BY countryRus ASC, name ASC, ACname ASC"), connAircraftTitle);
			//Открыть соединение
			connAircraftTitle.Open();
			//Создать DataReader и считать данные
			SqlDataReader drAircraftTitle;
			drAircraftTitle = cmdAircraftTitle.ExecuteReader();


			Response.Write ("<table width='450' cellpadding='0' cellspacing='0' border='0'><tr><td></td><td></td>");

			while (drAircraftTitle.Read())
			{
				if ((drAircraftTitle["countryRus"].ToString()) != country)
				{
					country = (drAircraftTitle["countryRus"].ToString());
					
					Response.Write ("</tr><tr><td align='left' valign='top' width='50' bgcolor='#ffffff'><br><img src='images/"+drAircraftTitle["image"]+"' width='43' height='30'></td>");
					Response.Write ("<td align='left' valign='middle' width='400' bgcolor='#ffffff'><br>&nbsp;&nbsp;<big>"+drAircraftTitle["countryRus"]+"</big><br></td>");
					Response.Write ("</tr><tr><td align='left' valign='top' width='50' bgcolor='#ffffff'></td>");
					Response.Write ("<td align='left' valign='middle' width='400' bgcolor='#ffffff'><img src='images/ball.gif'>&nbsp;&nbsp;<a class='type' href='aircraft.aspx?id="+drAircraftTitle["aircraftID"]+"'>"+drAircraftTitle["name"]+"&nbsp;&nbsp;"+drAircraftTitle["ACname"]+"</a><br></td>");
				}
				else
				{
					Response.Write ("</tr><tr><td align='left' valign='top' width='50' bgcolor='#ffffff'></td>");
					Response.Write ("<td align='left' valign='middle' width='400' bgcolor='#ffffff'><img src='images/ball.gif'>&nbsp;&nbsp;<a class='type' href='aircraft.aspx?id="+drAircraftTitle["aircraftID"]+"'>"+drAircraftTitle["name"]+"&nbsp;&nbsp;"+drAircraftTitle["ACname"]+"</a><br></td>");
				}

			}
			Response.Write ("</tr></table>");

		

			//Закрываем DataReader и соединение
			drAircraftTitle.Close();
			connAircraftTitle.Close();
		
		}





		private void Page_Load(object sender, System.EventArgs e)
		{
			//Загрузить верхнее меню
			TopMenu();
		}

		#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);
		}
		
		/// <summary>
		/// Required method for Designer support - do not modify
		/// the contents of this method with the code editor.
		/// </summary>
		private void InitializeComponent()
		{    
			this.Load += new System.EventHandler(this.Page_Load);
		}
		#endregion
	}
}