public async Task <bool> DeleteQuote(QuoteDbItem quote) { try { using (var db = new SQLiteConnection(GetDataPath(), SQLiteOpenFlags.ReadWrite | SQLiteOpenFlags.FullMutex)) { await Task.Run(() => db.Delete(quote)); return(true); } } catch (Exception ex) { Debug.WriteLine(ex.Message); return(false); } }
public async Task <bool> AddQuote(QuoteDbItem quote) { if (FileExists()) { try { using (var db = new SQLiteConnection(GetDataPath(), SQLiteOpenFlags.ReadWrite | SQLiteOpenFlags.FullMutex)) { await Task.Run(() => db.Insert(quote)); return(true); } } catch { return(false); } } else { if (DbCreate()) { try { using (var db = new SQLiteConnection(GetDataPath(), SQLiteOpenFlags.ReadWrite | SQLiteOpenFlags.FullMutex)) { await Task.Run(() => db.Insert(quote)); return(true); } } catch { return(false); } } else { return(false); } } }