// 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;
}
