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