Ejemplo n.º 1
0
  /** getting all products */
  public List<Product> getAllProducts() {
    List<Product> products = new ArrayList<Product>();
    String selectQuery = "SELECT  * FROM " + TABLE_PRODUCTS;

    Log.e(LOG, selectQuery);

    SQLiteDatabase db = this.getReadableDatabase();
    Cursor c = db.rawQuery(selectQuery, null);

    // looping through all rows and adding to list
    if (c.moveToFirst()) {
      do {
        Product pd = new Product();
        pd.setId(c.getInt((c.getColumnIndex(KEY_ID))));
        pd.setName((c.getString(c.getColumnIndex(KEY_NAME))));
        pd.setCode((c.getString(c.getColumnIndex(KEY_CODE))));
        pd.setImage((c.getString(c.getColumnIndex(KEY_IMAGEN))));
        pd.setCompany_id((c.getInt(c.getColumnIndex(KEY_COMPANY_ID))));
        pd.setCategory_id((c.getInt(c.getColumnIndex(KEY_CATEGORY_ID))));
        pd.setCategory_name((c.getString(c.getColumnIndex(KEY_CATEGORY_NAME))));
        // adding to todo list
        products.add(pd);
      } while (c.moveToNext());
    }
    return products;
  }
Ejemplo n.º 2
0
 /**
  * @param name
  * @return
  */
 public Product getProductName(String name) {
   SQLiteDatabase db = this.getReadableDatabase();
   String selectQuery = "SELECT  * FROM " + TABLE_PRODUCTS + " WHERE " + KEY_NAME + " = " + name;
   Log.e(LOG, selectQuery);
   Cursor c = db.rawQuery(selectQuery, null);
   if (c != null) c.moveToFirst();
   Product pd = new Product();
   pd.setId(c.getInt(c.getColumnIndex(KEY_ID)));
   pd.setName((c.getString(c.getColumnIndex(KEY_NAME))));
   pd.setCode((c.getString(c.getColumnIndex(KEY_CODE))));
   pd.setImage((c.getString(c.getColumnIndex(KEY_IMAGEN))));
   pd.setCompany_id((c.getInt(c.getColumnIndex(KEY_COMPANY_ID))));
   pd.setCategory_id((c.getInt(c.getColumnIndex(KEY_CATEGORY_ID))));
   pd.setCategory_name((c.getString(c.getColumnIndex(KEY_CATEGORY_NAME))));
   return pd;
 }
Ejemplo n.º 3
0
  /*
   * Updating a User
   */
  public int updateProduct(Product product) {
    SQLiteDatabase db = this.getWritableDatabase();

    ContentValues values = new ContentValues();
    values.put(KEY_NAME, product.getName());
    values.put(KEY_CODE, product.getCode());
    values.put(KEY_COMPANY_ID, product.getCompany_id());
    values.put(KEY_IMAGEN, product.getImage());
    values.put(KEY_CATEGORY_ID, product.getCategory_id());
    values.put(KEY_CATEGORY_NAME, product.getCategory_name());

    // updating row
    return db.update(
        TABLE_PRODUCTS, values, KEY_ID + " = ?", new String[] {String.valueOf(product.getId())});
  }
Ejemplo n.º 4
0
  /*
   * Creating a PRODUCTS
   */
  public long createProduct(Product product) {
    SQLiteDatabase db = this.getWritableDatabase();

    ContentValues values = new ContentValues();

    values.put(KEY_ID, product.getId());
    values.put(KEY_NAME, product.getName());
    values.put(KEY_CODE, product.getCode());
    values.put(KEY_IMAGEN, product.getImage());
    values.put(KEY_COMPANY_ID, product.getCompany_id());
    values.put(KEY_CATEGORY_ID, product.getCategory_id());
    values.put(KEY_CATEGORY_NAME, product.getCategory_name());

    // insert row
    // long todo_id = db.insert(TABLE_PEDIDO, null, values);
    db.insert(TABLE_PRODUCTS, null, values);

    long todo_id = product.getId();
    return todo_id;
  }