public static List<Email> getAll() { DataBaseHelper dataBaseHelper = DataBaseHelper.getIstance(); SQLiteDatabase db = dataBaseHelper.getReadableDatabase(); Cursor cursor = db.query( EmailContract.TABLE, EmailContract.COLUNS, null, null, null, null, EmailContract.ID); List<Email> values = EmailContract.getEmails(cursor); db.close(); dataBaseHelper.close(); return values; }
public static List<Email> getAllByContact(Long idcontact) { DataBaseHelper dataBaseHelper = DataBaseHelper.getIstance(); SQLiteDatabase db = dataBaseHelper.getReadableDatabase(); String where = EmailContract.CONTACTID + " = ? "; String[] params = {idcontact.toString()}; Cursor cursor = db.query( EmailContract.TABLE, EmailContract.COLUNS, where, params, null, null, EmailContract.ID); List<Email> values = EmailContract.getEmails(cursor); db.close(); dataBaseHelper.close(); return values; }