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);
}
}
