public ActionResult Create([Bind(Include = "From_Airport,To_Airport,ItineraryId")] ItineraryRoute itineraryRoute) { DistanceController distanceLogic = new DistanceController(); Airport fromAirport = db.Airports .Where(i => i.Ident.Equals(itineraryRoute.From_Airport)) .First(); Airport toAirport = db.Airports .Where(i => i.Ident.Equals(itineraryRoute.To_Airport)) .First(); Position fromPosition = new Position(fromAirport.Latitude, fromAirport.Longitude); Position toPosition = new Position(toAirport.Latitude, toAirport.Longitude); itineraryRoute.Distance = distanceLogic.CalcDistance(fromPosition, toPosition, "Miles"); itineraryRoute.Itinerary = db.Itineraries.Find(itineraryRoute.ItineraryId); if (ModelState.IsValid) { db.ItineraryRoutes.Add(itineraryRoute); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(itineraryRoute)); }
public ActionResult Index(FormCollection collection) { try { if (collection.Count == 0) { return(View()); } else { DistanceController distanceLogic = new DistanceController(); string fromAirportStr = collection["fromAirport"]; string toAirportStr = collection["toAirport"]; Airport fromAirport = db.Airports .Where(i => i.Ident.Equals(fromAirportStr)) .First(); Airport toAirport = db.Airports .Where(i => i.Ident.Equals(toAirportStr)) .First(); Position fromPosition = new Position(fromAirport.Latitude, fromAirport.Longitude); Position toPosition = new Position(toAirport.Latitude, toAirport.Longitude); ViewBag.Distance = distanceLogic.CalcDistance(fromPosition, toPosition, "Miles");; ViewBag.TimeDif = (Convert.ToDateTime(collection["TravelDate"]) - DateTime.Today).Days; return(View()); } } catch { return(View()); } }