Ejemplo n.º 1
0
  /**
   * Update Audit
   *
   * @param audit
   * @return
   */
  public int updateAudit(Audit audit) {
    SQLiteDatabase db = this.getWritableDatabase();

    ContentValues values = new ContentValues();
    values.put(KEY_ID, audit.getId());
    values.put(KEY_NAME, audit.getName());
    values.put(KEY_STORY_ID, audit.getStore_id());
    values.put(KEY_SCORE, audit.getScore());

    // updating row
    return db.update(
        TABLE_AUDITS, values, KEY_ID + " = ?", new String[] {String.valueOf(audit.getId())});
  }
Ejemplo n.º 2
0
  /**
   * Create Audit
   *
   * @param audit
   * @return
   */
  public long createAudit(Audit audit) {
    SQLiteDatabase db = this.getWritableDatabase();

    ContentValues values = new ContentValues();

    values.put(KEY_ID, audit.getId());
    values.put(KEY_NAME, audit.getName());
    values.put(KEY_STORY_ID, audit.getStore_id());
    values.put(KEY_SCORE, audit.getScore());

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

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