// 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())}); }
// Adding new Reminder public int addReminder(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()); // Inserting Row long ID = db.insert(TABLE_REMINDERS, null, values); db.close(); return (int) ID; }