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