// GET: Airports
        public ActionResult Index()
        {
            List <Airport> airports = db.Airports.Where(p => p.IsActive == true).ToList();

            List <AirPortViewModel> airportsViewModel = new List <AirPortViewModel>();

            foreach (Airport airport in airports)
            {
                AirPortViewModel ap = new AirPortViewModel();
                ap.Name          = airport.Name;
                ap.Code          = airport.Code;
                ap.publicId      = airport.PublicId;
                ap.StartedRoutes = db.AirRoutes.Where(c => c.StartAirportCode == airport.Code).ToList();
                ap.FinishRoutes  = db.AirRoutes.Where(c => c.FinishAirportCode == airport.Code).ToList();

                airportsViewModel.Add(ap);
            }


            return(View(airportsViewModel.ToList()));
        }
        // GET: Airports/Details/5
        public ActionResult Details(string code)
        {
            if (code == string.Empty)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            Airport airport = db.Airports.FirstOrDefault(p => p.Code.Equals(code));

            if (airport == null)
            {
                return(HttpNotFound());
            }

            AirPortViewModel airPortViewModel = new AirPortViewModel
            {
                publicId      = airport.PublicId,
                Name          = airport.Name,
                Code          = airport.Code,
                StartedRoutes = db.AirRoutes.Where(c => c.StartAirportCode == airport.Code).ToList(),
                FinishRoutes  = db.AirRoutes.Where(c => c.FinishAirportCode == airport.Code).ToList()
            };

            return(View(airPortViewModel));
        }