public void insertNewProduct(Product product) { SQLiteDatabase db1 = mDbHelper.getReadableDatabase(); Cursor cursor = db1.query( DatabaseHelper.TABLE_PRODUCTS, mAllColumns, DatabaseHelper.TABLE_PRODUCT_ID + "= ?", new String[] {String.valueOf(product.getmId())}, null, null, null); if (cursor != null && cursor.getCount() != 0) { return; } SQLiteDatabase db = mDbHelper.getWritableDatabase(); ContentValues cv = new ContentValues(); cv.put(DatabaseHelper.TABLE_PRODUCT_ID, product.getmId()); String name_en = product.getmName("EN"); if (name_en != null) { cv.put(DatabaseHelper.TABLE_PRODUCT_NAME, name_en); } String name_ar = product.getmName("AR"); if (name_ar != null) { cv.put(DatabaseHelper.TABLE_PRODUCT_NAME_AR, name_ar); } cv.put(DatabaseHelper.TABLE_PRODUCT_CATEGORY_ID, product.getmCategoryId()); cv.put(DatabaseHelper.TABLE_PRODUCT_PIC_NAME, product.getmPictureName()); cv.put(DatabaseHelper.TABLE_PRODUCT_PRICE, product.getmPrice()); long i = db.insert(DatabaseHelper.TABLE_PRODUCTS, null, cv); Log.d(TAG, "insert return value = " + i); }