Example #1
0
        public async Task<GeoLocationItem> InsertAsync(GeoLocationItem item) 
        {

            var asyncConnect = new SQLiteAsyncConnection(DB_PATH);

            int insertedId  = await asyncConnect.InsertAsync(item);

            item.Id = insertedId;

            return item;
            
            /*using (var dbConn = new SQLite.SQLiteConnection(DB_PATH))
            {
                int insertedId = dbConn.Insert(item);
                item.Id = insertedId;
                return item;
            }*/
        }
Example #2
0
 public GeoLocationItem Insert(GeoLocationItem item)
 {
     using (var dbConn = new SQLite.SQLiteConnection(DB_PATH))
     {
         int insertedId = dbConn.Insert(item);
         item.Id = insertedId;
         return item;
     }
 }
Example #3
0
        public GeoLocationItem Update(GeoLocationItem item) 
        {
            if( GetGeoLocationItem(item.Id) == null)
                throw new Exception("GeoLocation not found");

            using (dbConn = new SQLiteConnection(DB_PATH))
            {
                dbConn.Update(item);
            }
            return item;
        }