// GET: AirRoutes
        public ActionResult Index()
        {
            var airRoutes = db.AirRoutes.Include(a => a.AirLine).Where(p => p.IsActive == true);

            List <AirRouteViewModel> model = new List <AirRouteViewModel>();

            foreach (var airRoute in airRoutes)
            {
                AirRouteViewModel route = new AirRouteViewModel()
                {
                    AirLine       = airRoute.AirLine,
                    PublicId      = airRoute.PublicId,
                    StartAirport  = airRoute.StartAirportCode,
                    FinishAirport = airRoute.FinishAirportCode
                };
                model.Add(route);
            }

            return(View(model.ToList()));
        }
        // GET: AirRoutes/Delete/5
        public ActionResult Delete(Guid?id)
        {
            if (id == Guid.Empty)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            AirRoute airRoute = db.AirRoutes.FirstOrDefault(p => p.PublicId == id);

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

            AirRouteViewModel model = new AirRouteViewModel()
            {
                AirLine       = airRoute.AirLine,
                StartAirport  = airRoute.StartAirportCode,
                FinishAirport = airRoute.FinishAirportCode
            };

            return(View(model));
        }