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);
}
