public async Task <Object> GetSearchedFlights(string flyingfrom, string flyingTo, string dateDepart, int numberOfSeat, string dateReturn) { List <Flight> Retflights = new List <Flight>(); if (flyingfrom == "" && flyingTo == "" && dateDepart == "") { return(BadRequest()); } else { var DateDepart = DateTime.Parse(dateDepart); if (DateTime.UtcNow.Date == DateDepart.Date) //Ako izaberemo danasnji datum..pokazati samo letove koji polecu nakon trenutnog vremena { DateDepart = DateTime.UtcNow; } var flights = _context.Flights.Where(x => x.FlyingFrom.ToUpper() == flyingfrom.ToUpper() && x.FlyingTo.ToUpper() == flyingTo.ToUpper() && x.VacantSeats >= numberOfSeat).ToList(); foreach (Flight flight in flights) { if (flight.DateDepart >= DateDepart && flight.DateDepart <= DateDepart.AddDays(3)) // period od 3 dana { Retflights.Add(flight); } } DateTime DateReturn; if (dateReturn != "-") //ako je korisnik naveo i datum vracanja { DateReturn = DateTime.Parse(dateReturn); flights = _context.Flights.Where(x => x.FlyingFrom.ToUpper() == flyingTo.ToUpper() && x.FlyingTo.ToUpper() == flyingfrom.ToUpper() && x.VacantSeats >= numberOfSeat).ToList(); foreach (Flight flight in flights) { if (flight.DateDepart >= DateReturn && flight.DateArrival <= DateReturn.AddDays(3)) // period od 3 dana { Retflights.Add(flight); } } } } return(Ok(new { Retflights })); }