public Flight FlightParser(DBFlight _DBFlight) { var flight = new Flight(); flight.PNR = _DBFlight.PNR; flight.Type = _DBFlight.Type; flight.Source = new List <string>(_DBFlight.Source.Split(',')); flight.Destination = new List <string>(_DBFlight.Destination.Split(',')); flight.DeparatureTimes = new List <string>(_DBFlight.DeparatureTimes.Split(',')); flight.ArrivalTimes = new List <string>(_DBFlight.ArrivalTimes.Split(',')); flight.Status = _DBFlight.Status; flight.Cost = _DBFlight.Cost; flight.Discount = _DBFlight.Discount; flight.PassengerCount = _DBFlight.PassengerCount; flight.AirlineDetails = new List <string>(_DBFlight.AirlineDetails.Split(',')); return(flight); }
public DBFlight GetFlight(string PNR) { DBFlight dBFlight = new DBFlight(); try { _SqlConnection.Open(); using (_SqlCommand = new SqlCommand("Select * from Flight where PNR='" + PNR + "'", _SqlConnection)) { var reader = _SqlCommand.ExecuteReader(); if (reader.HasRows) { while (reader.Read()) { dBFlight.PNR = reader[0].ToString(); dBFlight.Type = reader[1].ToString(); dBFlight.Source = reader[2].ToString(); dBFlight.Destination = reader[3].ToString(); dBFlight.DeparatureTimes = reader[4].ToString(); dBFlight.ArrivalTimes = reader[5].ToString(); dBFlight.Status = reader[6].ToString(); dBFlight.Cost = reader[7].ToString(); dBFlight.Discount = reader[8].ToString(); dBFlight.PassengerCount = reader[9].ToString(); dBFlight.AirlineDetails = reader[10].ToString(); } } } } finally { _SqlConnection.Close(); } return(dBFlight); }