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