public async Task <Route> GetRouteAsync(String routeName) { List <DatabaseRoute> results = await Database.QueryAsync <DatabaseRoute>("SELECT * FROM DatabaseRoute WHERE Name = ? AND RouteID <> 999 AND RouteID <> 998", new object[] { routeName }); if (results.Count == 0) { return(null); } else { return(DatabaseRoute.ToRoute(results[0])); } }
public async Task <Route> GetVisitedRoute() { List <DatabaseRoute> results = await Database.QueryAsync <DatabaseRoute>("SELECT * FROM DatabaseRoute WHERE RouteID = 998"); if (results.Count == 0) { return(null); } else { return(DatabaseRoute.ToRoute(results[0])); } }