/// <summary>
/// Gets the flight routes
/// </summary>
/// <exception cref="RouteManagerException">Thrown when unable to get routes</exception>
/// <returns>Returns a list with all the route information</returns>
public List <Route> GetRoutes()
{
try
{
DataSet dsDS = routeDAO.GetRoutes();
var routes = from route in dsDS.Tables[0].AsEnumerable().Distinct()
orderby route["DistanceInKms"]
select new Route
{
ID = Convert.ToInt64(route["RouteId"]),
FromCity = CityDAOFactory.GetInstance().CreateCity().GetCityById(Convert.ToInt64(route["FromCityId"])),
ToCity = CityDAOFactory.GetInstance().CreateCity().GetCityById(Convert.ToInt64(route["ToCityId"])),
DistanceInKms = Convert.ToDouble(route["DistanceInKms"]),
IsActive = Convert.ToBoolean(route["Status"])
};
return(routes.ToList <Route>());
}
catch (RouteDAOException ex)
{
throw new RouteManagerException("Unable to get routes", ex);
}
}
/// <summary>
/// Gets the flight routes
/// </summary>
/// <exception cref="RouteManagerException">Thrown when unable to get routes</exception>
/// <returns>Returns a list with all the route information</returns>
public List <Route> GetRoutes()
{
List <Route> routes = null;
try
{
DataSet dsDS = routeDAO.GetRoutes();
routes = new List <Route>();
foreach (DataRow rw in dsDS.Tables[0].Rows)
{
Route r = new Route();
r.ID = Convert.ToInt64(rw["RouteId"]);
r.FromCity = CityDAOFactory.GetInstance().CreateCity().GetCityById(Convert.ToInt64(rw["FromCityId"]));
r.ToCity = CityDAOFactory.GetInstance().CreateCity().GetCityById(Convert.ToInt64(rw["ToCityId"]));
r.DistanceInKms = Convert.ToDouble(rw["DistanceInKms"]);
r.IsActive = Convert.ToBoolean(rw["Status"]);
routes.Add(r);
}
return(routes);
}
catch (RouteDAOException ex)
{
throw new RouteManagerException("Unable to get routes", ex);
}
}
/// <summary>
/// Default Constructor
/// </summary>
public CityManager()
{
cityDAO = CityDAOFactory.GetInstance().CreateCity();
}
