public void addNoteToTrash(Note note) { database = DBHelper.getWritableDatabase(); ContentValues values = new ContentValues(); values.put(com.subhrajyoti.babai.noteworthy.DB.DBHelper.COL_NOTE_TITLE_TRASH, note.getTitle()); values.put(com.subhrajyoti.babai.noteworthy.DB.DBHelper.COL_NOTE_DESC_TRASH, note.getDesc()); values.put(com.subhrajyoti.babai.noteworthy.DB.DBHelper.COL_NOTE_DATE_TRASH, note.getDate()); database.insert(com.subhrajyoti.babai.noteworthy.DB.DBHelper.TABLE_NAME_TRASH, null, values); database.close(); }
// Updating single note public int updateNote(Note note) { SQLiteDatabase db = DBHelper.getWritableDatabase(); ContentValues values = new ContentValues(); values.put(com.subhrajyoti.babai.noteworthy.DB.DBHelper.COL_NOTE_TITLE, note.getTitle()); values.put(com.subhrajyoti.babai.noteworthy.DB.DBHelper.COL_NOTE_DESC, note.getDesc()); values.put(com.subhrajyoti.babai.noteworthy.DB.DBHelper.COL_NOTE_DATE, note.getDate()); // updating row return db.update( com.subhrajyoti.babai.noteworthy.DB.DBHelper.TABLE_NAME, values, com.subhrajyoti.babai.noteworthy.DB.DBHelper.COL_ID + " = ?", new String[] {String.valueOf(note.getId())}); }