Advertisement
Guest User

Untitled

a guest
Oct 16th, 2017
81
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 2.08 KB | None | 0 0
  1.  public long addItemProduct(ItemProduct product, DataBaseHandler dh) {
  2.         long inserted;
  3.  
  4.         SQLiteDatabase db = dh.getWritableDatabase();
  5.         ContentValues values = new ContentValues();
  6.         values.put(DataBaseHandler.KEY_PRODUCT_CATEGORY, product.getCategory().getIdCategory());
  7.         values.put(DataBaseHandler.KEY_PRODUCT_IMAGE, product.getImage());
  8.         values.put(DataBaseHandler.KEY_PRODUCT_TITLE, product.getTitle());
  9.         values.put(DataBaseHandler.KEY_PRODUCT_STORE, product.getStore().getId());
  10.         values.put(DataBaseHandler.KEY_PRODUCT_DESCRIPTION, product.getDescription());
  11.  
  12.         inserted = db.insert(DataBaseHandler.TABLE_PRODUCT, null, values);
  13.  
  14.         try {
  15.             db.close();
  16.         } catch (Exception e) {
  17.         }
  18.  
  19.         return inserted;
  20.     }
  21.  
  22.     public int updateProduct(ItemProduct product, DataBaseHandler dh) {
  23.         SQLiteDatabase db = dh.getWritableDatabase();
  24.         ContentValues values = new ContentValues();
  25.         values.put(DataBaseHandler.KEY_PRODUCT_CATEGORY, product.getCategory().getIdCategory());
  26.         values.put(DataBaseHandler.KEY_PRODUCT_IMAGE, product.getImage());
  27.         values.put(DataBaseHandler.KEY_PRODUCT_TITLE, product.getTitle());
  28.         values.put(DataBaseHandler.KEY_PRODUCT_STORE, product.getStore().getId());
  29.         values.put(DataBaseHandler.KEY_PRODUCT_DESCRIPTION, product.getDescription());
  30.  
  31.         // Updating row
  32.         int count = db.update(DataBaseHandler.TABLE_PRODUCT, values,
  33.                 DataBaseHandler.KEY_PRODUCT_ID + " = ?",
  34.                 new String[]{String.valueOf(product.getCode())});
  35.         try {
  36.             db.close();
  37.         } catch (Exception e) {
  38.         }
  39.         return count;
  40.     }
  41.  
  42.     public void deleteProduct(int idProduct, DataBaseHandler dh) {
  43.         SQLiteDatabase db = dh.getWritableDatabase();
  44.         db.delete(DataBaseHandler.TABLE_PRODUCT, DataBaseHandler.KEY_PRODUCT_ID
  45.                 + " = ?", new String[]{String.valueOf(idProduct)});
  46.         try {
  47.             db.close();
  48.         } catch (Exception e) {
  49.         }
  50.     }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement