public async Task <bool> DeleteFromDBAsync(FreeDiscItemDownload freeDiscDownloader) { if (freeDiscDownloader == null) { #if DEBUG Debug.Write("DeleteFromDBAsync: freeDiscDownloader == null"); #endif return(false); } Debug.Write("DeleteFromDB: ID" + freeDiscDownloader.DBID + " Title: " + freeDiscDownloader?.Title + " Status: " + freeDiscDownloader?.ItemStatus.ToString()); if (freeDiscDownloader.DBID == 0) { Debug.Write("DeleteFromDB: freeDiscDownloader.DBID == 0 !"); return(false); } try { var conn = new SQLite.SQLiteAsyncConnection(App.AppSetting.DBDownloadPath); await conn.CreateTableAsync <FreeDiscItemDownload>(); await conn.DeleteAsync(freeDiscDownloader); } catch (Exception e) { Debug.Write("DeleteFromDB: Delete error !"); return(false); } return(true); }
public async Task DeleteAllArticlesAsync() { if (_dbConnection != null) { try { var allArticles = await _dbConnection.Table <NewsItem>().ToListAsync(); foreach (var article in allArticles) { await _dbConnection.DeleteAsync(article); } } catch (Exception e) { Debug.WriteLine(e.ToString()); } } else { Debug.WriteLine("failed to get sqlite connection"); } }
public Task<int> DeleteLogAsync(Logs log) { return DataBase.DeleteAsync(log); }
private Task <int> DeleteItemAsync(DummyTable item) { return(_db.DeleteAsync(item)); }
async public Task DeleteTrashImageAsync(string imageName) { SQLite.SQLiteAsyncConnection context = new SQLite.SQLiteAsyncConnection(connectionString); TrashImage image = await context.Table<TrashImage>().Where(p => p.Name == imageName).FirstOrDefaultAsync(); if (image != null) await context.DeleteAsync(image); }
public async Task DeleteItemAsync(int identifier) { SQLite.SQLiteAsyncConnection context = new SQLite.SQLiteAsyncConnection(connectionString); List<Item> childs = await context.Table<Item>().Where(p => p.Parent == identifier).ToListAsync(); foreach(Item child in childs) { await context.DeleteAsync(child); } Item item = await context.Table<Item>().Where(p => p.Identifier == identifier).FirstOrDefaultAsync(); if (item != null) await context.DeleteAsync(item); }
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); } }
public async Task<bool> DeleteAccount(int accountId) { var db = new SQLite.SQLiteAsyncConnection(app.DBPath); var existingAccount = await (db.Table<Account>().Where( a => a.Id == accountId)).FirstAsync(); return await db.DeleteAsync(existingAccount) > 0; }
public async void Remove(Cliente cliente) { await _connection.DeleteAsync(cliente); }