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