public AirlineCarrierFlight Find(string CarrierId, DateTime FlightDate, string FlightNo) { _carrierid = CarrierId; _flightdate = FlightDate; _flightno = FlightNo; AirlineCarrierFlight flight = new AirlineCarrierFlight(); int i = 0; if (_instance == null) { _instance = new AirlineCarrierFlights(); //_instance.GetCarrierFlights(_carrierid,_flightdate); } else { _instance.ClearItems(); } _instance.GetCarrierFlights(_carrierid, _flightdate); while (i < _instance.Count) { if (_instance.Items[i].CarrierFlightNo == _flightno.TrimEnd().TrimStart()) { flight = _instance.Items[i]; break; } i += 1; } return(flight); }
//public AirlineCarrierFlight GetCarrierFlight(string CarrierID, DateTime FlightDate, string FlightNo) //{ // _carrierid = CarrierID; // _flightdate = FlightDate; // _flightno = FlightNo; // DataTable dt = new DataTable(); // dt = DABase.Instance.ExecSP(cn_spGetCarrierFlight, DABase.Instance.Parameter(cn_pmCarrierID, _carrierid), DABase.Instance.Parameter(cn_pmFlightDate, _flightdate.ToShortDateString()), DABase.Instance.Parameter(cn_pmFlightNo, _flightno)); // AirlineCarrierFlight flight; // flight = new AirlineCarrierFlight(dt.Rows[0]); // return flight; //} public AirlineCarrierFlights GetCarrierFlights(string CarrierID, DateTime FlightDate) { _carrierid = CarrierID; _flightdate = FlightDate; DataTable dt = new DataTable(); dt = DABase.Instance.ExecSP(cn_spGetCarrierFlights, DABase.Instance.Parameter(cn_pmCarrierID, _carrierid), DABase.Instance.Parameter(cn_pmFlightDate, _flightdate.ToShortDateString())); if (_instance == null) { _instance = new AirlineCarrierFlights(); //_instance.GetCarrierFlights(_carrierid,_flightdate); } else { _instance.ClearItems(); } foreach (DataRow dr in dt.Rows) { AirlineCarrierFlight flight; flight = new AirlineCarrierFlight(dr); _instance.Add(flight); } ; return(_instance); { } }
public AirlineCarrierFlights ListAllCarrierFlights(DateTime FlightDate) { _flightdate = FlightDate; DataTable dt = new DataTable(); dt = DABase.Instance.ExecSP(cn_spListAll, DABase.Instance.Parameter(cn_pmFlightDate, _flightdate)); if (_instance == null) { _instance = new AirlineCarrierFlights(); //_instance.GetCarrierFlights(_carrierid,_flightdate); } else { _instance.ClearItems(); } foreach (DataRow dr in dt.Rows) { AirlineCarrierFlight flight; flight = new AirlineCarrierFlight(dr); _instance.Add(flight); } ; return(_instance); { } }