Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public long addItemProduct(ItemProduct product, DataBaseHandler dh) {
- long inserted;
- SQLiteDatabase db = dh.getWritableDatabase();
- ContentValues values = new ContentValues();
- values.put(DataBaseHandler.KEY_PRODUCT_CATEGORY, product.getCategory().getIdCategory());
- values.put(DataBaseHandler.KEY_PRODUCT_IMAGE, product.getImage());
- values.put(DataBaseHandler.KEY_PRODUCT_TITLE, product.getTitle());
- values.put(DataBaseHandler.KEY_PRODUCT_STORE, product.getStore().getId());
- values.put(DataBaseHandler.KEY_PRODUCT_DESCRIPTION, product.getDescription());
- inserted = db.insert(DataBaseHandler.TABLE_PRODUCT, null, values);
- try {
- db.close();
- } catch (Exception e) {
- }
- return inserted;
- }
- public int updateProduct(ItemProduct product, DataBaseHandler dh) {
- SQLiteDatabase db = dh.getWritableDatabase();
- ContentValues values = new ContentValues();
- values.put(DataBaseHandler.KEY_PRODUCT_CATEGORY, product.getCategory().getIdCategory());
- values.put(DataBaseHandler.KEY_PRODUCT_IMAGE, product.getImage());
- values.put(DataBaseHandler.KEY_PRODUCT_TITLE, product.getTitle());
- values.put(DataBaseHandler.KEY_PRODUCT_STORE, product.getStore().getId());
- values.put(DataBaseHandler.KEY_PRODUCT_DESCRIPTION, product.getDescription());
- // Updating row
- int count = db.update(DataBaseHandler.TABLE_PRODUCT, values,
- DataBaseHandler.KEY_PRODUCT_ID + " = ?",
- new String[]{String.valueOf(product.getCode())});
- try {
- db.close();
- } catch (Exception e) {
- }
- return count;
- }
- public void deleteProduct(int idProduct, DataBaseHandler dh) {
- SQLiteDatabase db = dh.getWritableDatabase();
- db.delete(DataBaseHandler.TABLE_PRODUCT, DataBaseHandler.KEY_PRODUCT_ID
- + " = ?", new String[]{String.valueOf(idProduct)});
- try {
- db.close();
- } catch (Exception e) {
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement