public async Task AddMessageSettingsToOld(OldMessageSettings settings) { await addOldMessage(settings); await refreshOldMessages(); }
private async Task removeOldMessage(OldMessageSettings settings) { var db = new SQLite.SQLiteAsyncConnection(this.DBPath); var messagesToDelete = db.Table<OldMessageSettings>().Where(m => m.ID == settings.ID); foreach (var messageToDelete in await messagesToDelete.ToListAsync()) { await db.DeleteAsync(messageToDelete); } }
private async Task addOldMessage(OldMessageSettings settings) { var db = new SQLite.SQLiteAsyncConnection(this.DBPath); OldMessageSettings existingMessage; try { existingMessage = await (db.Table<OldMessageSettings>().Where(m => m.ID == settings.ID).FirstAsync()); } catch { existingMessage = null; } if (existingMessage != null) { existingMessage.FontSize = settings.FontSize; existingMessage.AnimateMessage = settings.AnimateMessage; existingMessage.Duration = settings.Duration; existingMessage.Message = settings.Message; existingMessage.ShowCountdown = settings.ShowCountdown; existingMessage.Added = DateTime.Now; int success = await db.UpdateAsync(existingMessage); } else { settings.Added = DateTime.Now; int success = await db.InsertAsync(OldMessageSettings.CreateOldMessageSettings(settings)); } }
public async Task RemoveMessageSettingsFromOld(OldMessageSettings settings) { await removeOldMessage(settings); await refreshOldMessages(); }