// Getting All notes public List<Note> getAllNotes() { SQLiteDatabase db = DBHelper.getWritableDatabase(); List<Note> noteList = new ArrayList<>(); // Select All Query String selectQuery = "SELECT * FROM " + com.subhrajyoti.babai.noteworthy.DB.DBHelper.TABLE_NAME; Cursor cursor = db.rawQuery(selectQuery, null); // looping through all rows and adding to list if (cursor.moveToFirst()) { do { Note note = new Note(); note.setId(Integer.parseInt(cursor.getString(0))); note.setTitle(cursor.getString(1)); note.setDesc(cursor.getString(2)); note.setDate(cursor.getString(3)); // Adding note to list noteList.add(note); } while (cursor.moveToNext()); } cursor.close(); // return note list return noteList; }
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())}); }
// Deleting single note public void deleteNote(Note note) { SQLiteDatabase db = DBHelper.getWritableDatabase(); db.delete( com.subhrajyoti.babai.noteworthy.DB.DBHelper.TABLE_NAME, com.subhrajyoti.babai.noteworthy.DB.DBHelper.COL_ID + " = ?", new String[] {String.valueOf(note.getId())}); db.close(); }