public void getAllAirports()
{
ShortestFlightEntities db = new ShortestFlightEntities();
ar = new List <airport>();
ar = db.airports.ToList();
}
public List <route> getRoutes()
{
List <route> pathRoutes = new List <route>();
for (int i = 0; i < airports_list.Count; i++)
{
route rt = null;
if (i > 0)
{
int f = airports_list[i - 1].airport_ID;
int t = airports_list[i].airport_ID;
ShortestFlightEntities db = new ShortestFlightEntities();
rt = db.routes.SingleOrDefault(
r => r.from_OID == f && r.to_OID == t);
}
if (rt != null)
{
pathRoutes.Add(rt);
}
}
return(pathRoutes);
}
public void getAllroutes()
{
ShortestFlightEntities db = new ShortestFlightEntities();
fullRoutes = new List <route>();
fullRoutes = db.routes.ToList();
}
public void findStartAirport(List <route> allRoutes)
{
db = new ShortestFlightEntities();
int startRoute = allRoutes[0].route_ID;
int startAirportID = Int32.Parse(db.routes.Where(r => r.route_ID == startRoute).FirstOrDefault().from_OID.ToString());
fromAirport = db.airports.Where(a => a.airport_ID == startAirportID).FirstOrDefault().city;
}
public void findEndAirport(List <route> allRoutes)
{
int lid = allRoutes[allRoutes.Count - 1].route_ID;
db = new ShortestFlightEntities();
int endAirportID = (int)db.routes.Where(r => r.route_ID == lid).FirstOrDefault().to_OID;
toAirport = db.airports.Where(a => a.airport_ID == endAirportID).FirstOrDefault().city;
}
public void findFullRoute(List <route> allRoutes)
{
FullRoute = new List <string>();
foreach (route r in allRoutes)
{
db = new ShortestFlightEntities();
int routeId = r.route_ID;
int startAirportID = Int32.Parse(
db.routes.Where(rt => rt.route_ID == routeId).FirstOrDefault().from_OID.ToString());
String airportNameFrom = db.airports.Where(a => a.airport_ID == startAirportID).FirstOrDefault().city;
int toAirportID = Int32.Parse(
db.routes.Where(rt => rt.route_ID == routeId).FirstOrDefault().to_OID.ToString());
String airportNameTo = db.airports.Where(a => a.airport_ID == toAirportID).FirstOrDefault().city;
FullRoute.Add((airportNameFrom + " - " + airportNameTo + "- " + (r.distance * 1.61).ToString() + " km."));
}
}
public RoutesRepository(ShortestFlightEntities db)
{
this.db = db;
}
public AirportsRepository(ShortestFlightEntities db)
{
this.db = db;
}