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);
}
