private List <FlightDTO> createFlightDTO(FlightOffer flightOffer, AmadeusDictionaries dictionaries)
{
var results = new List <FlightDTO>();
for (int i = 0; i < Math.Min(flightOffer.Itineraries.Count, 2); i++)
{
var flightDTO = new FlightDTO();
var segments = flightOffer.Itineraries[i].Segments.OrderBy(s => s.Departure.Time).ToList();
flightDTO.Aircraft = string.Join(",",
segments.Select(s => dictionaries.Aircrafts[s.Aircraft.Code]).Distinct());
flightDTO.ArrivalAirport = segments.Last().Arrival.IataCode;
flightDTO.ArrivalTime = segments.Last().Arrival.Time;
flightDTO.Carrier = string.Join(",",
segments.Select(s => dictionaries.Carriers[s.CarrierCode]).Distinct());
flightDTO.DepartureAirport = segments.First().Departure.IataCode;
flightDTO.DepartureTime = segments.First().Departure.Time;
flightDTO.FlightDuration = (flightDTO.ArrivalTime - flightDTO.DepartureTime).ToString();
flightDTO.IsAmadeusFlight = true;
flightDTO.IsFlightDirect = segments.Count == 1;
flightDTO.IsReturnFlight = i == 1;
//add travel class
flightDTO.Prices = flightOffer.TravelerPricing
.Select(p => new FlightPriceDTO()
{
TravelerType = p.TravelerType, Price = p.Price.TotalPrice
})
.ToList();
flightDTO.Stops = createFlightStops(segments);
flightDTO.TotalPrice = flightOffer.Price.TotalPrice;
results.Add(flightDTO);
}
return(results);
}
public int Insert(Repo.Models.Flights.Flight model, string origin, string destionation, string departureDate, string returnDate = null, string currency = Default.CURRENCY, int adults = Default.ADULTS)
{
if (model == null || String.IsNullOrEmpty(origin) || String.IsNullOrEmpty(destionation) || String.IsNullOrEmpty(departureDate))
{
throw new ArgumentNullException();
}
if (model.Data == null || model.Dictionaries == null || model.Meta == null)
{
throw new NullReferenceException();
}
if (model.Dictionaries.Currencies != null)
{
foreach (var item in model.Dictionaries.Currencies)
{
if (unitOfWork.Currencies.FindByCode(item.Key) == null)
{
unitOfWork.Currencies.Insert(item);
}
}
}
if (model.Dictionaries.Aircraft != null)
{
foreach (var item in model.Dictionaries.Aircraft)
{
if (unitOfWork.Aircrafts.FindByCode(item.Key) == null)
{
unitOfWork.Aircrafts.Insert(item);
}
}
}
if (model.Dictionaries.Carriers != null)
{
foreach (var item in model.Dictionaries.Carriers)
{
if (unitOfWork.Carriers.FindByCode(item.Key) == null)
{
unitOfWork.Carriers.Insert(item);
}
}
}
if (model.Dictionaries.Locations != null)
{
foreach (var item in model.Dictionaries.Locations)
{
if (unitOfWork.Locations.FindByCode(item.Key) == null)
{
unitOfWork.Locations.Insert(new KeyValuePair <string, string>(item.Key, item.Value.detailedName));
}
}
}
Flight flight = new Flight()
{
Adults = adults,
CurrencyId = unitOfWork.Currencies.FindByCode(model.Meta.Currency).CurrencyId,
Origin = origin,
Destination = destionation,
DepartureDate = DateTime.Parse(departureDate),
ReturnDate = DateTime.Parse(returnDate ?? DateTime.MinValue.ToString()),
Link = model.Meta.Links.Self,
};
flight.FlightId = unitOfWork.Flights.Insert(flight);
try
{
foreach (var item in model.Data)
{
FlightOffer flightOffer = new FlightOffer
{
Id = item.Id,
Type = item.Type,
FlightId = flight.FlightId,
};
var flightOfferId = unitOfWork.FlightOffers.Insert(flightOffer);
foreach (var offer in item.OfferItems)
{
OfferItem offerItem = new OfferItem();
offerItem.FlightOfferId = flightOfferId;
Price price = new Price
{
Total = offer.Price.Total,
TotalTaxes = offer.Price.TotalTaxes,
};
offerItem.PriceId = unitOfWork.Prices.Insert(price);
if (offer.PricePerAdult != null)
{
Price adult = new Price
{
Total = offer.PricePerAdult.Total,
TotalTaxes = offer.PricePerAdult.TotalTaxes,
};
offerItem.PricePerAdultId = unitOfWork.Prices.Insert(adult);
}
if (offer.PricePerChild != null)
{
Price child = new Price
{
Total = offer.PricePerChild.Total,
TotalTaxes = offer.PricePerChild.TotalTaxes,
};
offerItem.PricePerChildId = unitOfWork.Prices.Insert(child);
}
if (offer.PricePerInfant != null)
{
Price infant = new Price
{
Total = offer.PricePerInfant.Total,
TotalTaxes = offer.PricePerInfant.TotalTaxes,
};
offerItem.PricePerInfantId = unitOfWork.Prices.Insert(infant);
}
if (offer.PricePerSenior != null)
{
Price senior = new Price
{
Total = offer.PricePerSenior.Total,
TotalTaxes = offer.PricePerSenior.TotalTaxes,
};
offerItem.PricePerSeniorId = unitOfWork.Prices.Insert(senior);
}
var offerItemId = unitOfWork.OfferItems.Insert(offerItem);
foreach (var ser in offer.Services)
{
Data.Flights.Service service = new Data.Flights.Service();
service.OfferItemId = offerItemId;
var serviceId = unitOfWork.Services.Insert(service);
if (ser.Segments != null)
{
foreach (var seg in ser.Segments)
{
Segment segment = new Segment();
segment.ServiceId = serviceId;
FlightSegment flightSegment = new FlightSegment();
flightSegment.AircraftId = unitOfWork.Aircrafts.FindByCode(seg.FlightSegment.Aircraft.Code).AircraftId;
FlightEndPoint arrival = new FlightEndPoint
{
At = seg.FlightSegment.Arrival.At,
LocationId = unitOfWork.Locations.FindByCode(seg.FlightSegment.Arrival.IataCode).LocationId,
Terminal = seg.FlightSegment.Arrival.Terminal,
};
flightSegment.ArrivalId = unitOfWork.FlightEndPoints.Insert(arrival);
flightSegment.CarrierId = unitOfWork.Carriers.FindByCode(seg.FlightSegment.CarrierCode).CarrierId;
FlightEndPoint departure = new FlightEndPoint
{
At = seg.FlightSegment.Departure.At,
LocationId = unitOfWork.Locations.FindByCode(seg.FlightSegment.Departure.IataCode).LocationId,
Terminal = seg.FlightSegment.Departure.Terminal,
};
flightSegment.DepartureId = unitOfWork.FlightEndPoints.Insert(departure);
flightSegment.Duration = seg.FlightSegment.Duration;
flightSegment.Number = seg.FlightSegment.Number;
Operation operation = new Operation
{
CarrierId = unitOfWork.Carriers.FindByCode(seg.FlightSegment.Operating.CarrierCode).CarrierId,
Number = seg.FlightSegment.Operating.Number,
};
flightSegment.OperationId = unitOfWork.Operations.Insert(operation);
segment.FlightSegmentId = unitOfWork.FlightSegments.Insert(flightSegment);
if (seg.FlightSegment.Stops != null)
{
foreach (var stop in seg.FlightSegment.Stops)
{
FlightStop flightStop = new FlightStop
{
AircraftId = unitOfWork.Aircrafts.FindByCode(stop.NewAircraft.Code).AircraftId,
ArrivalAt = stop.ArrivalAt,
CarrierId = unitOfWork.Carriers.FindByCode(stop.IataCode).CarrierId,
DepartureAt = stop.DepartureAt,
Duration = stop.Duration,
FlightSegmentId = segment.FlightSegmentId,
};
unitOfWork.FlightStops.Insert(flightStop);
}
}
if (seg.PricingDetailPerAdult != null)
{
PricingDetail adult = new PricingDetail
{
Availability = seg.PricingDetailPerAdult.Availability,
FareBasis = seg.PricingDetailPerAdult.FareBasis,
FareClass = seg.PricingDetailPerAdult.FareClass,
TravelClass = seg.PricingDetailPerAdult.TravelClass,
};
segment.PricingDetailPerAdultId = unitOfWork.PricingDetails.Insert(adult);
}
if (seg.PricingDetailPerChild != null)
{
PricingDetail child = new PricingDetail
{
Availability = seg.PricingDetailPerChild.Availability,
FareBasis = seg.PricingDetailPerChild.FareBasis,
FareClass = seg.PricingDetailPerChild.FareClass,
TravelClass = seg.PricingDetailPerChild.TravelClass,
};
segment.PricingDetailPerChildId = unitOfWork.PricingDetails.Insert(child);
}
if (seg.PricingDetailPerInfant != null)
{
PricingDetail infant = new PricingDetail
{
Availability = seg.PricingDetailPerInfant.Availability,
FareBasis = seg.PricingDetailPerInfant.FareBasis,
FareClass = seg.PricingDetailPerInfant.FareClass,
TravelClass = seg.PricingDetailPerInfant.TravelClass,
};
segment.PricingDetailPerInfantId = unitOfWork.PricingDetails.Insert(infant);
}
if (seg.PricingDetailPerSenior != null)
{
PricingDetail senior = new PricingDetail
{
Availability = seg.PricingDetailPerSenior.Availability,
FareBasis = seg.PricingDetailPerSenior.FareBasis,
FareClass = seg.PricingDetailPerSenior.FareClass,
TravelClass = seg.PricingDetailPerSenior.TravelClass,
};
segment.PricingDetailPerSeniorId = unitOfWork.PricingDetails.Insert(senior);
}
var segmentId = unitOfWork.Segments.Insert(segment);
}
}
}
}
}
}
catch (Exception e)
{
throw new Exception(e.Message);
}
return(flight.FlightId);
}