/*
   * 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())});
  }
  /*
   * 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;
  }