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 Force.
	/// </summary>
	public class Force : Common
	{

		protected string countryid;
		protected string countryRus;
		protected string image;
		protected int forcetype;
		protected string aircraftid;
		protected string href;


		protected void PrintForce()
		{
			SqlConnection connForce = new SqlConnection(connString);
			SqlCommand cmdForce = new SqlCommand(("SELECT * FROM V_Force WHERE countryid='"+countryid+"'"), connForce);
			connForce.Open();
			SqlDataReader drForce;
			drForce = cmdForce.ExecuteReader();

			Response.Write ("<table width='400' border='0' cellpadding='5' cellspacing='0'>");
			
				if (drForce.Read())
			{
				Response.Write ("<tr><td width='400' bgcolor='#007373' align='center' valign='top' colspan='3'>");
				Response.Write ("<div class='table'><b><i><font color='#ffffff'>"+drForce["ForceName"].ToString()+"<br></font></i></b></div></td></tr><tr><td width='400' height='10' bgcolor='#BBFFFF' align='center' valign='top' colspan='3'></td></tr>");
				forcetype = Convert.ToInt32(drForce["ForceType"]);
					if (drForce["AircraftID"].ToString() != "")
					{
						href = "<a class='type' target='_blank' href='aircraft.aspx?id="+drForce["AircraftID"].ToString()+"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;"+drForce["ACName"].ToString()+"</a>";
					}
					else
					{
						href = "&nbsp;&nbsp;&nbsp;&nbsp;"+drForce["ACName"].ToString();
					}
				Response.Write ("<tr><td width='250' bgcolor='#BBFFFF' align='left' valign='top'><div class='table'>"+href+"</div></td>");
				Response.Write ("<td width='70' bgcolor='#BBFFFF' align='right' valign='top'><div class='table'><b>"+drForce["number"].ToString()+"</b></div></td><td width='80' bgcolor='#BBFFFF' align='left' valign='top'></td></tr>");

					while (drForce.Read())
					{
						if (forcetype != Convert.ToInt32(drForce["ForceType"]))
						{
							Response.Write ("<tr><td width='400' height='10' bgcolor='#BBFFFF' align='center' valign='top' colspan='3'></td></tr><tr><td width='400' height='10' bgcolor='#ffffff' align='center' valign='top' colspan='3'></td></tr><tr><td width='400' bgcolor='#007373' align='center' valign='top' colspan='3'>");
							Response.Write ("<div class='table'><b><i><font color='#ffffff'>"+drForce["ForceName"].ToString()+"<br></font></i></b></div></td></tr><tr><td width='400' height='10' bgcolor='#BBFFFF' align='center' valign='top' colspan='3'></td></tr>");
							forcetype = Convert.ToInt32(drForce["ForceType"]);
							if (drForce["AircraftID"].ToString() != "")
							{
								href = "<a class='type' target='_blank' href='aircraft.aspx?id="+drForce["AircraftID"].ToString()+"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;"+drForce["ACName"].ToString()+"</a>";
							}
							else
							{
								href = "&nbsp;&nbsp;&nbsp;&nbsp;"+drForce["ACName"].ToString();
							}
							Response.Write ("<tr><td width='250' bgcolor='#BBFFFF' align='left' valign='top'><div class='table'>"+href+"</div></td>");
							Response.Write ("<td width='70' bgcolor='#BBFFFF' align='right' valign='top'><div class='table'><b>"+drForce["number"].ToString()+"</b></div></td><td width='80' bgcolor='#BBFFFF' align='left' valign='top'></td></tr>");
						}
						else
						{
							if (drForce["AircraftID"].ToString() != "")
							{
								href = "<a class='type' target='_blank' href='aircraft.aspx?id="+drForce["AircraftID"].ToString()+"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;"+drForce["ACName"].ToString()+"</a>";
							}
							else
							{
								href = "&nbsp;&nbsp;&nbsp;&nbsp;"+drForce["ACName"].ToString();
							}
							Response.Write ("<tr><td width='250' bgcolor='#BBFFFF' align='left' valign='top'><div class='table'>"+href+"</div></td>");
							Response.Write ("<td width='70' bgcolor='#BBFFFF' align='right' valign='top'><div class='table'><b>"+drForce["number"].ToString()+"</b></div></td><td width='80' bgcolor='#BBFFFF' align='left' valign='top'></td></tr>");
						
						}
					}



			}
				else
				{
					Response.Write ("<td>Отсутствуют данные</td>"); 
				}

			Response.Write ("<tr><td width='400' height='10' bgcolor='#BBFFFF' align='center' valign='top' colspan='3'></td></tr></table>");

			drForce.Close();
			connForce.Close();				
		
		}

		protected void PrintAccidentForce()
		{
			Transform("AccidentForce.xml?CountryForce="+countryid.ToString(),"AccidentForce.xsl",this.Response,1);
		}


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

			//Получить countryid из строки запроса
			if (Request.QueryString["countryid"] == null)
			{
				Response.Redirect("CountryForce.aspx"); 
			}
			else
			{
				countryid = Request.QueryString["countryid"].ToString();
			}

			SqlConnection connCountry = new SqlConnection(connString);
			SqlCommand cmdCountry = new SqlCommand(("SELECT countryRus, image FROM V_Force WHERE countryid='"+countryid+"'"), connCountry);
			connCountry.Open();
			SqlDataReader drCountry;
			drCountry = cmdCountry.ExecuteReader();
			
			if (drCountry.Read())
			{
				countryRus = drCountry["countryRus"].ToString();
				image =  drCountry["image"].ToString();
			}
			else
			{
				Response.Write ("Ошибка на сервере");
			}
			drCountry.Close();
			connCountry.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);
		}
		
		/// <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
	}
}