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