Пример #1
0
  public List<Product> getProductsCategory(String categoryId) {
    List<Product> list = new ArrayList<Product>();
    SQLiteDatabase db = null;
    Cursor cursor = null;
    try {
      db = mDbHelper.getReadableDatabase();
      cursor =
          db.query(
              DatabaseHelper.TABLE_PRODUCTS,
              mAllColumns,
              DatabaseHelper.TABLE_PRODUCT_CATEGORY_ID + "=?",
              new String[] {categoryId},
              null,
              null,
              null,
              null);
    } catch (NullPointerException e) {
      if (AlwarshaApp.DEBUG) Log.e(TAG, "Exception at getProductGroup");
    }
    if (cursor.moveToFirst()) {
      for (int i = 0; i < cursor.getCount(); i++) {
        Product product = null;
        int db_id = cursor.getInt(cursor.getColumnIndex(DatabaseHelper.TABLE_PRODUCT_ID));
        String db_name_ar =
            cursor.getString(cursor.getColumnIndex(DatabaseHelper.TABLE_PRODUCT_NAME_AR));

        String db_name_en =
            cursor.getString(cursor.getColumnIndex(DatabaseHelper.TABLE_PRODUCT_NAME));

        int db_category_id =
            cursor.getInt(cursor.getColumnIndex(DatabaseHelper.TABLE_PRODUCT_CAT_ID));
        String db_pic_name =
            cursor.getString(cursor.getColumnIndex(DatabaseHelper.TABLE_PRODUCT_PIC_NAME));
        float db_price = cursor.getFloat(cursor.getColumnIndex(DatabaseHelper.TABLE_PRODUCT_PRICE));

        product = new Product(db_id, db_name_en, db_category_id, db_pic_name, db_price, "EN");
        product.addName("AR", db_name_ar);
        list.add(product);

        cursor.moveToNext();
      }
    }
    cursor.close();

    return list;
  }
Пример #2
0
  public Product getProduct(int id) {

    Product product = null;
    SQLiteDatabase db = null;
    Cursor cursor = null;
    try {
      db = mDbHelper.getReadableDatabase();
      cursor =
          db.query(
              DatabaseHelper.TABLE_PRODUCTS,
              mAllColumns,
              DatabaseHelper.TABLE_PRODUCT_ID + "=?",
              new String[] {String.valueOf(id)},
              null,
              null,
              null,
              null);
    } catch (NullPointerException e) {
      if (AlwarshaApp.DEBUG) Log.e(TAG, "Exception at getProduct");
    }
    if (cursor.moveToFirst()) {
      int db_id = cursor.getInt(cursor.getColumnIndex(DatabaseHelper.TABLE_PRODUCT_ID));
      String db_name_ar =
          cursor.getString(cursor.getColumnIndex(DatabaseHelper.TABLE_PRODUCT_NAME_AR));

      String db_name_en =
          cursor.getString(cursor.getColumnIndex(DatabaseHelper.TABLE_PRODUCT_NAME));

      int db_category_id =
          cursor.getInt(cursor.getColumnIndex(DatabaseHelper.TABLE_PRODUCT_CAT_ID));
      String db_pic_name =
          cursor.getString(cursor.getColumnIndex(DatabaseHelper.TABLE_PRODUCT_PIC_NAME));
      float db_price = cursor.getFloat(cursor.getColumnIndex(DatabaseHelper.TABLE_PRODUCT_PRICE));
      cursor.close();

      product = new Product(db_id, db_name_en, db_category_id, db_pic_name, db_price, "EN");
      product.addName("AR", db_name_ar);
    }
    return product;
  }
Пример #3
0
  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);
  }