protected override async void OnNavigatedTo(System.Windows.Navigation.NavigationEventArgs e)
{
base.OnNavigatedTo(e);
OCSettings settings = await OCTranspoStopsData.getSettings();
nearbyDistanceSlider.Value = settings.nearbyDistance;
}
// Stops
public static async Task <ObservableCollection <OCStop> > getCloseStops(double latitude, double longitude, double zoomLevel)
{
//TODO Math.
String path = ApplicationData.Current.LocalFolder.Path + "/OCTranspo.sqlite";
SQLiteAsyncConnection conn = new SQLiteAsyncConnection(path);
var count = await conn.ExecuteScalarAsync <int>("SELECT COUNT(*) FROM sqlite_master WHERE type='table' AND name='OCStop'");
if (count > 0)
{
OCSettings settings = await getSettings();
OCGeoMath latlong = OCGeoMath.getRange(latitude, longitude, settings.nearbyDistance);
String Query = "SELECT DISTINCT(stop_id), * from OCStop where ((stop_lat BETWEEN " + latlong.lowerLat + " AND " + latlong.upperLat + ")" +
" AND (stop_lon BETWEEN " + latlong.lowerLong + " AND " + latlong.upperLong + ")) ORDER BY stop_id;";
List <OCStop> stops = await conn.QueryAsync <OCStop>(Query);
ObservableCollection <OCStop> stopsCollection = new ObservableCollection <OCStop>(stops);
return(stopsCollection);
}
else
{
OCTranspoStopsData.initDB();
return(await getCloseStops(latitude, longitude, zoomLevel));
}
}
public static OCSettings newOCSettings(int nearbyDistance)
{
OCSettings settings = new OCSettings();
settings.nearbyDistance = nearbyDistance;
return(settings);
}
public static async Task<int> updateSettings(OCSettings settings)
{
settings.id = 1;
String path = ApplicationData.Current.LocalFolder.Path + "/OCTranspo.sqlite";
SQLiteAsyncConnection conn = new SQLiteAsyncConnection(path);
int result = await conn.UpdateAsync(settings);
return result;
}
public static async Task <int> updateSettings(OCSettings settings)
{
settings.id = 1;
String path = ApplicationData.Current.LocalFolder.Path + "/OCTranspo.sqlite";
SQLiteAsyncConnection conn = new SQLiteAsyncConnection(path);
int result = await conn.UpdateAsync(settings);
return(result);
}
private static async void createSettingsTable()
{
String path = ApplicationData.Current.LocalFolder.Path + "/OCTranspo.sqlite";
SQLiteAsyncConnection conn = new SQLiteAsyncConnection(path);
var count = await conn.ExecuteScalarAsync <int>("SELECT COUNT(*) FROM sqlite_master WHERE type='table' AND name='OCSettings'");
if (count == 0)
{
await conn.CreateTableAsync <OCSettings>();
OCSettings settings = OCSettings.newOCSettings(500);
settings.id = 1;
await conn.InsertAsync(settings);
}
}
private async Task <Boolean> saveSettings(Boolean fromExit)
{
int result = await OCTranspoStopsData.updateSettings(OCSettings.newOCSettings(distance));
if (result > 0)
{
MessageBox.Show("Settings were successfully saved.");
dirtyPage = false;
if (this.NavigationService.CanGoBack && fromExit == false)
{
this.NavigationService.GoBack();
}
return(true);
}
else
{
MessageBox.Show("There was an error saving your settings, please try again.");
return(false);
}
}
public static OCSettings newOCSettings(int nearbyDistance)
{
OCSettings settings = new OCSettings();
settings.nearbyDistance = nearbyDistance;
return settings;
}
