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