using System;
using System.Data;
using System.Collections;
using 數據訪問.實體類;
using 數據訪問.控制類;

namespace 數據訪問.控制類
{
	using OceanSoft.Data;
	/// <summary>
	/// Flights 的摘要說明。
	/// </summary>
	public class Flights
	{   
		//聲明連接對象
		ICommonAccess action;
        
		/// <summary>
		/// 空的構造函數，用默認值初始化連接對象
		/// </summary>
		public Flights()
		{
			this.action=DataFactory.GetInstance();
		}
        
		/// <summary>
		/// 帶參數的構造函數，用指定值初始化連接對象
		/// </summary>
		/// <param name="action"></param>
		public Flights(ICommonAccess action)
		{
			this.action=action;
		}
        
		/// <summary>
		/// 此方法用于關閉連接對象
		/// </summary>
		public void Close()
		{
			this.action.Close();
		}
        
		/// <summary>
		/// 獲得FlilghtCollection
		/// </summary>
		/// <param name="departureCityId"></param>
		/// <param name="arrivalCityId"></param>
		/// <param name="departureTime"></param>
		/// <param name="arrivalTime"></param>
		/// <returns></returns>
		public FlilghtCollection GetFlight(int departureCityId,int arrivalCityId,DateTime departureTime,DateTime arrivalTime)
		{
			action.CommandString="SelectFlight";
			action.IsStoredProcedure=true;
			Hashtable ht=new Hashtable();
			ht.Add("@departureCityId",departureCityId);
			ht.Add("@arrivalCityId",arrivalCityId);
			ht.Add("@departureTime",departureTime);
			ht.Add("@arrivalTime",arrivalTime);
			action.CommandParams=ht;

			DataSet ds=null;
			try
			{
				ds=this.action.GetDataSet("Flight");
			}
			catch(Exception err)
			{
				throw err;
			}
			FlilghtCollection flightCol =new FlilghtCollection();

			foreach(DataRow row in ds.Tables[0].Rows)
			{
				Flight flight=new Flight();
				flight.FlightId=int.Parse(row["FlightId"].ToString());
				flight.FlightName=row["FlightName"].ToString();
				flight.DepartureCityId=int.Parse(row["DepartureCityId"].ToString());
				flight.ArrivalCityId=int.Parse(row["ArrivalCityId"].ToString());
				flight.DepartureCityName=row["DepartureCityName"].ToString();
			    flight.ArrivalCityName=row["ArrivalCityName"].ToString();
				flight.DepartureTime=DateTime.Parse( row["DepartureTime"].ToString());
				flight.ArrivalTime=DateTime.Parse(row["ArrivalTime"].ToString());
                flight.Cabin = new Cabins().GetCabin(flight.FlightId);
				flightCol.Add(flight);
			}
			return flightCol;


		}
	}
}