using System.Threading.Tasks;
using SQLite;
namespace XamarinSQLite
{
    public class SQLiteHelper
    {
        SQLiteAsyncConnection db;
        public SQLiteHelper(string dbPath)
        {
            db = new SQLiteAsyncConnection(dbPath);
            db.CreateTableAsync<person>().Wait();
        }

        //Insert and Update new record
        public Task<int> SaveItemAsync(Person person)
        {
            if (person.PersonID != 0)
            {
                return db.UpdateAsync(person);
            }
            else
            {
                return db.InsertAsync(person);
            }
        }

        //Delete
        public Task<int> DeleteItemAsync(Person person)
        {
            return db.DeleteAsync(person);
        }

        //Read All Items
        public Task<list erson="">&gt; GetItemsAsync()
        {
            return db.Table<person>().ToListAsync();
        }

       
        //Read Item
        public Task<person> GetItemAsync(int personId)
        {
            return db.Table<person>().Where(i =&gt; i.PersonID == personId).FirstOrDefaultAsync();
        }
    }
}