Пример #1
0
        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);
            }
        }
Пример #2
0
        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);
                }
            }
        }