public List <BookedTicketModel> GetBookedTicketList()
{
List <BookedTicketModel> model = new List <BookedTicketModel>();
var result = from a in ent.PNRs where a.TicketStatusId == 1 select a;
foreach (var item in result)
{
BookedTicketModel obj = new BookedTicketModel
{
PNRId = item.PNRId,
PNR = item.GDSRefrenceNumber,
BookedDate = item.CreatedDate,
ArrivalCity = _ser.GetCityName(item.PNRSectors.Where(x => x.PNRId == item.PNRId).Select(x => x.DestinationCityId).FirstOrDefault()),
FullName = item.Prefix + "." + item.FirstName + " " + item.MiddleName + " " + item.LastName,
FlightDate = item.PNRSectors.Where(x => x.PNRId == item.PNRId).Select(x => x.DepartDate).FirstOrDefault(),
DepartureCity = _ser.GetCityName(item.PNRSectors.Where(x => x.PNRId == item.PNRId).Select(x => x.DepartCityId).FirstOrDefault()),
};
model.Add(obj);
}
return(model);
}
public IEnumerable <TravelFareModel> GetDomesticTravelFare()
{
var tempData = ent.PaperFareRules.Where(x => x.FlightTypeId == 2).ToList();
var reviewModel = new List <TravelFareModel>();
foreach (var item in tempData)
{
var viewModel = new TravelFareModel
{
PaperFareId = item.PaperFareId,
AirlineId = item.AirlineId,
AirlineNmae = item.Airlines.AirlineName,
FlightSeasonId = item.FlightSeasonId,
DepartureCityId = item.DepartureCityId,
DestinationCityName = _provider.GetCityName(item.DestinationCityId),
DestinationCityId = item.DepartureCityId,
DepartureCityName = _provider.GetCityName(item.DepartureCityId),
FlightClassId = item.FlightClassId,
OneWayFareBasis = item.OneWayFareBasis,
OneWayFare = item.OneWayFare,
RoundWayFareBasis = item.RoundWayFareBasis,
RoundWayFare = item.RoundWayFare,
EffectiveFrom = item.EffectiveFrom,
ExpireOn = item.ExpireOn,
FlightTypeId = item.FlightTypeId,
ChildFare = item.ChildFare,
ChildFareType = item.ChildFareType,
ChildFareOn = item.ChildFareOn,
InfantFare = item.InfantFare,
InfantFareType = item.InfantFareType,
InfantFareOn = item.InfantFareOn,
RefundFee = item.RefundFee,
ReissueFee = item.ReissueFee,
//FlightClassName = _provider.GetFlightClassName(item.FlightClassId),
TermsAndConditions = item.TermsAndConditions,
TourCode = item.TourCode,
FlightClassName = item.Air_DomesticFlightClasses.FlightClassCode + "(" + item.Air_DomesticFlightClasses.FlightClassType + ")"
};
reviewModel.Add(viewModel);
}
return(reviewModel.AsEnumerable());
}
