public async Task RemoveMessageSettingsFromFavorites(FavoriteMessageSettings settings)
{
await removeFavoriteMessage(settings);
await refreshFavoriteMessages();
}
private async Task addFavoriteMessage(FavoriteMessageSettings settings)
{
var db = new SQLite.SQLiteAsyncConnection(this.DBPath);
FavoriteMessageSettings existingMessage;
try
{
existingMessage = await (db.Table<FavoriteMessageSettings>().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;
int success = await db.UpdateAsync(existingMessage);
}
else
{
int success = await db.InsertAsync(settings);
}
}
public async Task AddMessageSettingsToFavorites(FavoriteMessageSettings settings)
{
await addFavoriteMessage(settings);
await refreshFavoriteMessages();
}
private async Task removeFavoriteMessage(FavoriteMessageSettings settings)
{
var db = new SQLite.SQLiteAsyncConnection(this.DBPath);
var messagesToDelete = db.Table<FavoriteMessageSettings>().Where(m => m.ID == settings.ID);
foreach (var messageToDelete in await messagesToDelete.ToListAsync())
{
await db.DeleteAsync(messageToDelete);
}
}
