public List <AdminViewFlight> searchFlight(SearchFlight search) { List <AdminViewFlight> list = new List <AdminViewFlight>(); if (search.Date == "") { var f = new AdminViewFlight(); f.ID = 0; list.Add(f); return(list); } else { var f = new AdminViewFlight() { ID = 1, Departure = "Oslo", DepartureTime = "00:00", Destination = "Bardufoss", DestinationTime = "00:00", Airplane = "Boeing737", ClassType = "Økonomi", Price = 500, Seats = 500, TravelDate = "00/00/00" }; list.Add(f); list.Add(f); list.Add(f); return(list); } }
public List <SearchFlight> GetFlightDetails(string fldate, string source, string destination) { List <SearchFlight> details = new List <SearchFlight>(); conn.Open(); cmdFetchFlightDetails = new SqlCommand("proc_SearchFlight", conn); cmdFetchFlightDetails.Parameters.Add("@date", SqlDbType.VarChar, 10); cmdFetchFlightDetails.Parameters.Add("@source", SqlDbType.VarChar, 20); cmdFetchFlightDetails.Parameters.Add("@destination", SqlDbType.VarChar, 20); cmdFetchFlightDetails.CommandType = CommandType.StoredProcedure; cmdFetchFlightDetails.Parameters[0].Value = fldate; cmdFetchFlightDetails.Parameters[1].Value = source; cmdFetchFlightDetails.Parameters[2].Value = destination; SqlDataReader drFlightDetails = cmdFetchFlightDetails.ExecuteReader(); SearchFlight search = null; //if (drFlightDetails.HasRows == false) // throw new NoFlightInDatabaseException(); while (drFlightDetails.Read()) { search = new SearchFlight(); search.Flightid = drFlightDetails[0].ToString(); search.Departuretime = drFlightDetails[1].ToString(); search.Arrivaltime = drFlightDetails[2].ToString(); search.Duration = drFlightDetails[3].ToString(); search.Fare = drFlightDetails[4].ToString(); details.Add(search); } return(details); }
public async Task <IActionResult> SearchFlight(SearchFlight vm) { //var to keep search input for flight results use var searchFlightTemp = new SearchFlight { OriginID = vm.OriginID, DestID = vm.DestID, WaySelection = vm.WaySelection, DepartDate = vm.DepartDate, ReturnDate = vm.ReturnDate }; _globalRepo.SaveObjToSessionJSON <SearchFlight>("searchFlightTemp", searchFlightTemp); HttpContext.Session.SetInt32("adultNum", vm.AdultNum); HttpContext.Session.SetInt32("childrenNum", vm.ChildrenNum); //get the result of search input var result = await _flightRepo.GetBySearchInput(vm); //subscribe to signalR real time update of item addition to Booking Table //_bookingRepo.subscribeBookingAdd(); //copy and bring over variables needed for next view result.OriginName = vm.OriginName; result.DestName = vm.DestName; return(View("FlightResults", result)); }
public async Task <FlightsInputsVM> GetBySearchInput(SearchFlight vm) { using (IDbConnection conn = Connection) { try { string sQuery = $"SELECT * FROM {Flight.tableName} WHERE OriginLocID = @OriginId AND DestLocID = @DestId AND CAST(DepartDateTime AS DATE) = @DepartDate;"; //string sQuery = "SELECT * FROM Flights AS f INNER JOIN FlightSeatTypes AS fs ON f.FlightSeatTypeID = fs.ID AND f.OriginLocID = @OriginId AND f.DestLocID = @DestId AND CAST(f.DepartDateTime AS DATE) >= @DepartDate;"; conn.Open(); var flights = new FlightsInputsVM(); flights.GoFlights = await conn.QueryAsync <Flight>(sQuery, new { OriginId = vm.OriginID, DestId = vm.DestID, DepartDate = vm.DepartDate }); //if return flight option selected if (vm.WaySelection == 2 && vm.ReturnDate != null && vm.ReturnDate.ToShortDateString() != "1/1/0001") { flights.ReturnFlights = await conn.QueryAsync <Flight>(sQuery, new { OriginId = vm.DestID, DestId = vm.OriginID, DepartDate = vm.ReturnDate }); } return(flights); } catch (Exception) { throw; } finally { conn.Close(); } } }
public void getSearchResults() { //Create class instance which has six parameters SearchFlight SearchClassInstance = new SearchFlight(Session["source"].ToString(), Session["destination"].ToString(), Session["travelClass"].ToString(), Session["dateOfJourney"].ToString(), Convert.ToInt32(Session["numberOfAdults"]), Convert.ToInt32(Session["numberOfChildren"])); //Search flight results of one way stored in a data table DataTable dtSearchFlightsResults = new DataTable(); dtSearchFlightsResults = SearchClassInstance.SearchFlights(); //Store dtSearchFlights as a session variable Session["dtSearchFlightResults"] = dtSearchFlightsResults; //Search flight results of round trip stored in a data table if (Session["tripType"].ToString().Equals("Round Trip")) { Session["dateOfJourney"] = txtDateOfJourney.Text; Session["dateOfReturn"] = txtDateOfReturn.Text; var SearchClassInstanceRoundTrip = new SearchFlight(Session["destination"].ToString(), Session["source"].ToString(), Session["travelClass"].ToString(), Session["dateOfReturn"].ToString(), Convert.ToInt32(Session["numberOfAdults"]), Convert.ToInt32(Session["numberOfChildren"]) ); DataTable dtSearchFlightsResultsRoundTrip = new DataTable(); dtSearchFlightsResultsRoundTrip = SearchClassInstanceRoundTrip.SearchFlights(); //Store dtSearchFlights as a session variable Session["dtSearchFlightResultsRoundTrip"] = dtSearchFlightsResultsRoundTrip; } }
public void TestFlightsExpectedResults() { SearchFlightModel inputSearch = new SearchFlightModel() { Origin = "LHR", Destination = "BOS" }; List <SearchFlightModel> expectedResult = new List <SearchFlightModel>(); SearchFlight source = new SearchFlight(); expectedResult = source.searchFlighsByOriginDestination(inputSearch); searchFlightsController controller = new searchFlightsController(); var view = controller.Index(inputSearch) as ViewResult; List <SearchFlightModel> actualResult = (List <SearchFlightModel>)view.ViewData.Model; Assert.AreEqual(expectedResult.Count, actualResult.Count); if (expectedResult.Count > 0) { for (int i = 0; i >= expectedResult.Count; i++) { Assert.AreEqual(expectedResult[i].Origin, actualResult[i].Origin); Assert.AreEqual(expectedResult[i].DepartureTime, actualResult[i].DepartureTime); Assert.AreEqual(expectedResult[i].Destination, actualResult[i].DestinationTime); Assert.AreEqual(expectedResult[i].DestinationTime, actualResult[i].DestinationTime); Assert.AreEqual(expectedResult[i].Price, actualResult[i].Price); } } }
public ActionResult Index(SearchFlightModel inputSearch) { if (ModelState.IsValid) { List <SearchFlightModel> result = new List <SearchFlightModel>(); SearchFlight source = new SearchFlight(); result = source.searchFlighsByOriginDestination(inputSearch); ViewBag.NoRecordFound = false; //check flight count if its zero then message is created & if its greater than zero, flight list will be display on view. if (result.Count <= 0) { ViewBag.NoRecordFound = true; ViewBag.Message = "No Flights Found for " + inputSearch.Origin + " --> " + inputSearch.Destination; } return(View(result)); } else { //Model state is not valid, for validation please check the model return(RedirectToAction("Index", "InvalidRequest")); } }
public void SearchFlight() { SearchFlight search = new SearchFlight(driver); search.Search(); string expected = "Flights from Mumbai to Bengaluru, and back"; Assert.AreEqual(expected, search.SearchFlightValidation()); }
public async Task <ActionResult <IEnumerable <Flight> > > GetFlights(SearchFlight search) { var flights = await searchFlightsRepo.GetFlights(_context, search); if (flights == null) { return(NotFound()); } return(flights); //List<Flight> flights; //if (search.selectType == 1) //{ // return flights = await _context.Flights // .Where(x => x.deleted == false && x.company == search.inputSearch) // .Include(from => from.from) // .Include(to => to.to) // .Include(presedanje => presedanje.presedanje) // .ThenInclude(gradoviPresedanja => gradoviPresedanja.gradoviPresedanja) // .Include(aeroplane => aeroplane.aeroplane) // .Include(allSeatsForThisFlight => allSeatsForThisFlight.allSeatsForThisFlight) // .Include(luggage => luggage.luggage) // .Include(ocene => ocene.ocene) // .ToListAsync(); //} //else if (search.selectType == 2) //{ // return flights = await _context.Flights // .Where(x => x.deleted == false && x.from.city == search.inputSearch) // .Include(from => from.from) // .Include(to => to.to) // .Include(presedanje => presedanje.presedanje) // .ThenInclude(gradoviPresedanja => gradoviPresedanja.gradoviPresedanja) // .Include(aeroplane => aeroplane.aeroplane) // .Include(allSeatsForThisFlight => allSeatsForThisFlight.allSeatsForThisFlight) // .Include(luggage => luggage.luggage) // .Include(ocene => ocene.ocene) // .ToListAsync(); //} //else if (search.selectType == 3) //{ // return flights = await _context.Flights // .Where(x => x.deleted == false && x.to.city == search.inputSearch) // .Include(from => from.from) // .Include(to => to.to) // .Include(presedanje => presedanje.presedanje) // .ThenInclude(gradoviPresedanja => gradoviPresedanja.gradoviPresedanja) // .Include(aeroplane => aeroplane.aeroplane) // .Include(allSeatsForThisFlight => allSeatsForThisFlight.allSeatsForThisFlight) // .Include(luggage => luggage.luggage) // .Include(ocene => ocene.ocene) // .ToListAsync(); //} //return BadRequest(); }
public IActionResult Index() { HttpContext.Session.Remove("searchFlightTemp"); var vm = new SearchFlight { DepartDate = DateTime.Today, ReturnDate = DateTime.Today }; return(View(vm)); }
public async Task <List <FlightDetails> > SearchFlightsAsync(SearchFlight bookingInfo) { string searchDetailsJson = JsonConvert.SerializeObject(bookingInfo); string response = await this._serviceCallUtil.SearchFlightAsync(searchDetailsJson); if (!string.IsNullOrEmpty(response)) { ParseResponseData(response); } return(this.FlightDetails); }
public ActionResult Search(SearchFlight searchflight) { Flight flight = AutoMapper.Mapper.Map <SearchFlight, Flight>(searchflight); IEnumerable <Flight> flights = flightBL.SearchDisplayFlight(flight); List <FlightModel> flightModels = new List <FlightModel>(); foreach (var temp in flights) { FlightModel flightModel = AutoMapper.Mapper.Map <Flight, FlightModel>(temp); //Auto Mapper entity to model flightModels.Add(flightModel); } TempData["flightsDisplay"] = flightModels; return(View()); }
public IHttpActionResult GetFlights([FromBody] SearchFlight search) { var departureDate = search.departureDate.ToString("yyyyMMdd"); var arrivalDate = search.arrivalDate.ToString("yyyyMMdd"); var url = $"http://developer.goibibo.com/api/search/?&app_id={appId}&app_key={appKey}&format=json&source={search.source}&destination={search.destination}&dateofdeparture={departureDate}&dateofarrival={arrivalDate}&seatingclass={search.seatingClass}&adults={search.numAdults}&children={search.numChildren}&infants={search.numInfants}&counter={search.counter}"; var flights = GetDeserializedFlights(url); if (flights != null) { var results = flights.Data.OnwardFlights; results.AddRange(flights.Data.ReturnFlights); return(Ok(results)); } return(BadRequest()); }
/* * THIS ACTION RESULT SEARCHES CORRESPONDING FLIGHT REQUESTED BY USER AND DISPLAYS FLIGHT DETAILS TO THE USER */ public ActionResult BookFlight(SearchFlight search) { if (!ModelState.IsValid) { return(RedirectToAction("SearchFlight", new { ErrMsg = "Please enter Source and Date of Journey. Destination is optional." })); } List <Flight> flights = new List <Flight>(); string sql = "SELECT * FROM FLIGHT WHERE departure_airport LIKE '%" + search.Source + "%' AND arrival_airport LIKE '%" + search.Destination + "%' AND availability >= 1 AND departure_date = '" + search.DateOfJourney + "';"; sql = String.Format(sql); using (SqlConnection connection = new SqlConnection(connectionString)) { command = new SqlCommand(sql, connection); command.Connection.Open(); var datareader = command.ExecuteReader(); if (!datareader.HasRows) { return(RedirectToAction("SearchFlight", new { ErrMsg = "No flights or seats available." })); } while (datareader.Read()) { flights.Add(new Flight() { FlightNo = datareader.GetValue(7).ToString(), PriceFirstClass = (int)datareader.GetValue(1), PriceEconomyClass = (int)datareader.GetValue(2), DepartureAirport = datareader.GetValue(3).ToString(), ArrivalAirport = datareader.GetValue(4).ToString(), DepartureTime = (DateTime)datareader.GetValue(5), ArrivalTime = (DateTime)datareader.GetValue(6), DepartureDate = (DateTime)datareader.GetValue(9), Availability = (int)datareader.GetValue(8) }); } connection.Close(); } return(View(flights)); }
public IHttpActionResult Search(FlightFilter filter) { try { var result = SearchFlight.GetFlights(filter); var respuesta = new { errorCode = 0, messageError = "Consulta correcta.", flights = result }; return(Ok(respuesta)); } catch (Exception ex) { CatchError.Log4Net("ERROR", ex); return(BadRequest(ex.Message)); } }
public ActionResult ReceiveMsg2_1() { string id = Request.Params["fid"]; TFlightTime result = new SearchFlight().Search(id); List <string> list = new List <string>(); if (result.f_id != null) { list.Add(result.f_id); list.Add(result.t_airport); list.Add(result.ex_takeoff_time); list.Add(result.t_terminal); list.Add(result.l_airport); list.Add(result.ex_land_time); list.Add(result.l_termnal); } else { list.Add("-1"); } return(View("ChangeFlight", list)); }
public List <AdminViewFlight> searchFlight(SearchFlight search) { var db = new WAPPContext(); int from = db.Airport.Where(w => w.Name.Equals(search.From)).Select(s => s.ID).FirstOrDefault(); int to = db.Airport.Where(w => w.Name.Equals(search.To)).Select(s => s.ID).FirstOrDefault(); List <AdminViewFlight> list = db.Flight.Where(w => w.Departure == from && w.Destination == to && w.TravelDate == search.Date).Select(e => new AdminViewFlight() { ID = e.ID, TravelDate = e.TravelDate, DepartureTime = e.DepartureTime, Departure = db.Airport.Where(w => w.Name.Equals(search.From)).Select(s => s.Name).FirstOrDefault(), DestinationTime = e.DestinationTime, Destination = db.Airport.Where(w => w.Name.Equals(search.To)).Select(s => s.Name).FirstOrDefault(), ClassType = e.ClassType, Seats = e.Seats, Airplane = db.Airplanes.Where(w => w.ID == e.Airplane.ID).Select(s => s.Name).FirstOrDefault(), Price = e.Price }).ToList(); return(list); }
public IActionResult Index(SearchFlight flightBookInfo) { var result = this._flightBookRepo.SearchFlightsAsync(flightBookInfo).GetAwaiter().GetResult(); return(View("SearchResults", result)); }
public List <AdminViewFlight> searchFlight(SearchFlight search) { return(_repository.searchFlight(search)); }
public async Task <ActionResult <IEnumerable <Flight> > > GetFlights(MAANPP20ContextFlight _context, SearchFlight search) { List <Flight> flights; if (search.selectType == 1) { return(flights = await _context.Flights .Where(x => x.deleted == false && x.company == search.inputSearch) .Include(from => from.from) .Include(to => to.to) .Include(presedanje => presedanje.presedanje) .ThenInclude(gradoviPresedanja => gradoviPresedanja.gradoviPresedanja) .Include(aeroplane => aeroplane.aeroplane) .Include(allSeatsForThisFlight => allSeatsForThisFlight.allSeatsForThisFlight) .Include(luggage => luggage.luggage) .Include(ocene => ocene.ocene) .ToListAsync()); } else if (search.selectType == 2) { return(flights = await _context.Flights .Where(x => x.deleted == false && x.from.city == search.inputSearch) .Include(from => from.from) .Include(to => to.to) .Include(presedanje => presedanje.presedanje) .ThenInclude(gradoviPresedanja => gradoviPresedanja.gradoviPresedanja) .Include(aeroplane => aeroplane.aeroplane) .Include(allSeatsForThisFlight => allSeatsForThisFlight.allSeatsForThisFlight) .Include(luggage => luggage.luggage) .Include(ocene => ocene.ocene) .ToListAsync()); } else if (search.selectType == 3) { return(flights = await _context.Flights .Where(x => x.deleted == false && x.to.city == search.inputSearch) .Include(from => from.from) .Include(to => to.to) .Include(presedanje => presedanje.presedanje) .ThenInclude(gradoviPresedanja => gradoviPresedanja.gradoviPresedanja) .Include(aeroplane => aeroplane.aeroplane) .Include(allSeatsForThisFlight => allSeatsForThisFlight.allSeatsForThisFlight) .Include(luggage => luggage.luggage) .Include(ocene => ocene.ocene) .ToListAsync()); } return(null); }
public ActionResult SearchChangeFlights(SearchFlight search) { return(PartialView("_ListChangeFlight", _AdminBll.searchFlight(search))); }
public async Task <ActionResult <IEnumerable <FlightCompany> > > GetFlightCompany(MAANPP20ContextFlight _context, SearchFlight search) { List <FlightCompany> flightCompanies; if (search.selectType == 1) { return(flightCompanies = await _context.FlightCompanies .Where(x => x.deleted == false && x.name == search.inputSearch) .Include(address => address.address) .Include(destinations => destinations.destinations) .ThenInclude(startAddress => startAddress.startAddress) .Include(destinations => destinations.destinations) .ThenInclude(endAddress => endAddress.endAddress) .Include(admin => admin.admin) //.Include(flights => flights.flights) //.Include(ocene => ocene.ocene) /* izbacio sam sve ove parametre, * jer nisu potrebni u prozoru koji * poziva ovu metodu!*/ .ToListAsync()); } else if (search.selectType == 2) { return(flightCompanies = await _context.FlightCompanies .Where(x => x.deleted == false && x.address.city == search.inputSearch) .Include(address => address.address) .Include(destinations => destinations.destinations) .ThenInclude(startAddress => startAddress.startAddress) .Include(destinations => destinations.destinations) .ThenInclude(endAddress => endAddress.endAddress) .Include(admin => admin.admin) .ToListAsync()); } else if (search.selectType == 3) { return(flightCompanies = await _context.FlightCompanies .Where(x => x.deleted == false && x.address.country == search.inputSearch) .Include(address => address.address) .Include(destinations => destinations.destinations) .ThenInclude(startAddress => startAddress.startAddress) .Include(destinations => destinations.destinations) .ThenInclude(endAddress => endAddress.endAddress) .Include(admin => admin.admin) .ToListAsync()); } return(null); }
public IActionResult GetFlights([FromBody] SearchFlight searchFlightCriteria) { Logger?.LogDebug("'{0}' has been invoked", nameof(GetFlights)); if (!searchFlightCriteria.NumberOfRecord.HasValue) { searchFlightCriteria.NumberOfRecord = 20; } var response = new ListResponse <Flight>(); try { if (searchFlightCriteria.GetType() .GetProperties() .Select(p => p.GetValue(searchFlightCriteria)) .Any(p => p != null) ) { var flightDetail = DbContext.Flight.Where(p => (string.IsNullOrEmpty(searchFlightCriteria.From) || p.Depart == searchFlightCriteria.From) && (string.IsNullOrEmpty(searchFlightCriteria.To) || p.Return == searchFlightCriteria.To) && (searchFlightCriteria.DepartDate == null || // p.DepartTime.ToDateTime() == searchFlightCriteria.DepartDate.Value.Date) && //(searchFlightCriteria.ReturnDate == null || // p.ReturnTime.ToDateTime() == searchFlightCriteria.ReturnDate.Value.Date) && //(string.IsNullOrEmpty(searchFlightCriteria.ClassType) || // p.ClassType.Contains(searchFlightCriteria.ClassType)) && (searchFlightCriteria.RoundTrip == null || p.RoundTrip == searchFlightCriteria.RoundTrip) && (searchFlightCriteria.PriceFrom == null || p.TotalMoney >= searchFlightCriteria.PriceFrom) && (searchFlightCriteria.PriceTo == null || p.TotalMoney <= searchFlightCriteria.PriceTo) && (searchFlightCriteria.Airlines == null || searchFlightCriteria.Airlines.Count == 0 || searchFlightCriteria.Airlines.Contains(p.DepartAirlineName) || searchFlightCriteria.Airlines.Contains(p.ReturnAirlineName)))); if (searchFlightCriteria.OrderBy == OrderByEnum.TotalMoney) { flightDetail = flightDetail.OrderBy(p => p.TotalMoney); } if (searchFlightCriteria.OrderBy == OrderByEnum.DepartTime) { flightDetail = flightDetail.OrderBy(p => Convert.ToDateTime(p.DepartTime)); } response.Model = flightDetail.Take(searchFlightCriteria.NumberOfRecord.Value).ToList(); } else { response.Model = DbContext.Flight.ToList(); } } catch (Exception ex) { response.DidError = true; response.ErrorMessage = ex.InnerException != null ? ex.InnerException.Message : ex.Message; Logger?.LogCritical("There was an error on '{0}' invocation: {1}", nameof(GetFlights), ex); } return(response.ToHttpResponse()); }
public async Task <ActionResult> GetFlightsAsync(Pagination pagination, SearchFlight search) { // Mapping: Flight var flightsSource = await _unitOfWork.Flights.GetAllAsync(); await _unitOfWork.Airlines.GetAllAsync(); await _unitOfWork.Airports.GetAllAsync(); await _unitOfWork.TicketCategories.GetAllAsync(); await _unitOfWork.Flights.GetFlightTicketCategoriesAsync(); var flights = _mapper.Map <IEnumerable <Flight>, IEnumerable <FlightDTO> >(flightsSource); // Search by Id: if (search.Id != "") { flights = flights.Where(f => f.Id.ToLower().Contains(search.Id.ToLower())); } // Search by StartTime: if (search.StartTime != null) { flights = flights.Where(f => f.StartTime == search.StartTime); } /// Search by FlightTime: if (search.FlightTime != null) { flights = flights.Where(f => f.FlightTime == search.FlightTime); } // Search by AirportFrom: if (search.AirportFrom != "") { flights = flights.Where(f => f.AirportFrom.ToLower().Contains(search.AirportFrom.ToLower())); } // Search by AirportTo: if (search.AirportTo != "") { flights = flights.Where(f => f.AirportTo.ToLower().Contains(search.AirportTo.ToLower())); } // Search by AirlineName: if (search.AirlineName != "") { var airlines = await _unitOfWork.Airlines.GetAllAsync(); flights = (from f in flights from a in airlines where f.AirlineId.Equals(a.Id) && a.Name.ToLower().Contains(search.AirlineName.ToLower()) select f); } // Search by Status: if (search.Status != null) { flights = flights.Where(f => f.Status == search.Status); } // Sort Asc: if (search.sortAsc != "") { flights = flights.OrderBy(f => f.GetType().GetProperty(search.sortAsc).GetValue(f)); } // Sort Desc: if (search.sortDesc != "") { flights = flights.OrderByDescending(f => f.GetType().GetProperty(search.sortDesc).GetValue(f)); } return(Ok(PaginatedList <FlightDTO> .Create(flights, pagination.current, pagination.pageSize))); }
public async Task <ActionResult> GetFlightsAsync([FromQuery] Pagination pagination, [FromQuery] SearchFlight search) { var flights = await _service.GetFlightsAsync(pagination, search); return(flights); }
public async Task <ActionResult <IEnumerable <FlightCompany> > > GetFlightCompany(SearchFlight search) { var flightCompanies = await searchFlightsRepo.GetFlightCompany(_context, search); if (flightCompanies == null) { return(NotFound()); } return(flightCompanies); //List<FlightCompany> flightCompanies; //if (search.selectType == 1) //{ // return flightCompanies = await _context.FlightCompanies // .Where(x => x.deleted == false && x.name == search.inputSearch) // .Include(address => address.address) // .Include(destinations => destinations.destinations) // .ThenInclude(startAddress => startAddress.startAddress) // .Include(destinations => destinations.destinations) // .ThenInclude(endAddress => endAddress.endAddress) // .Include(admin => admin.admin) // //.Include(flights => flights.flights) // //.Include(ocene => ocene.ocene) // /* izbacio sam sve ove parametre, // jer nisu potrebni u prozoru koji // poziva ovu metodu!*/ // .ToListAsync(); //} //else if (search.selectType == 2) //{ // return flightCompanies = await _context.FlightCompanies // .Where(x => x.deleted == false && x.address.city == search.inputSearch) // .Include(address => address.address) // .Include(destinations => destinations.destinations) // .ThenInclude(startAddress => startAddress.startAddress) // .Include(destinations => destinations.destinations) // .ThenInclude(endAddress => endAddress.endAddress) // .Include(admin => admin.admin) // .ToListAsync(); //} //else if (search.selectType == 3) //{ // return flightCompanies = await _context.FlightCompanies // .Where(x => x.deleted == false && x.address.country == search.inputSearch) // .Include(address => address.address) // .Include(destinations => destinations.destinations) // .ThenInclude(startAddress => startAddress.startAddress) // .Include(destinations => destinations.destinations) // .ThenInclude(endAddress => endAddress.endAddress) // .Include(admin => admin.admin) // .ToListAsync(); //} //return BadRequest(); }