private void saveRecentToLocalDb(RecentMatchesModel model) { string applicationFolderPath = System.IO.Path.Combine(System.Environment.GetFolderPath(System.Environment.SpecialFolder.LocalApplicationData), "databaseFolder"); System.IO.Directory.CreateDirectory(applicationFolderPath); string databaseFileName = System.IO.Path.Combine(applicationFolderPath, "amera.db"); using (SQLiteConnection conn = new SQLiteConnection(databaseFileName)) { conn.CreateTable <RecentMatchesModel>(); conn.InsertOrReplace(model); } }
private async Task refreshData() { deleteSqliteData(); InboxModel initModel = new InboxModel() { user_id = "amare", session_id = "0", emoji = "?", last_sender = "amare", image = "Amare_logo.png", has_unread = "1", location = "0,0", username = "******", datetime = DateTime.Now.ToString("MM/dd/yyyy"), distance = "0", message = "Hi!, I am Amare's Digital Assistant", distance_metric = "0" }; RecentMatchesModel initRecent = new RecentMatchesModel() { user_id = "amare", datetime = DateTime.Now.ToString("MM/dd/yyyy"), image = "Amare_logo.png", username = "******" }; inboxModels.Clear(); matchesModel.Clear(); matchesModel.Add(initRecent); inboxModels.Add(initModel); await loadData(); await loadRecentMatches(); SyncFromDb(); overlay.IsVisible = false; overlay.IsEnabled = false; }