// Updating single Reminder public int updateReminder(Reminder reminder) { SQLiteDatabase db = this.getWritableDatabase(); ContentValues values = new ContentValues(); values.put(KEY_TITLE, reminder.getTitle()); values.put(KEY_DATE, reminder.getDate()); values.put(KEY_TIME, reminder.getTime()); values.put(KEY_REPEAT, reminder.getRepeat()); values.put(KEY_REPEAT_NO, reminder.getRepeatNo()); values.put(KEY_REPEAT_TYPE, reminder.getRepeatType()); values.put(KEY_ACTIVE, reminder.getActive()); // Updating row return db.update( TABLE_REMINDERS, values, KEY_ID + "=?", new String[] {String.valueOf(reminder.getID())}); }
// Deleting single Reminder public void deleteReminder(Reminder reminder) { SQLiteDatabase db = this.getWritableDatabase(); db.delete(TABLE_REMINDERS, KEY_ID + "=?", new String[] {String.valueOf(reminder.getID())}); db.close(); }