/** Find one Person by Id */
public PersonalData getPersonById(long id) {
String sql =
"SELECT * FROM "
+ SalaryContract.PersonalData.TABLE_PERSONALDATA
+ " WHERE "
+ SalaryContract.PersonalData.KEY_ID
+ " = "
+ id;
Cursor cursor = this.db.rawQuery(sql, null);
cursor.moveToFirst();
PersonalData personalData = new PersonalData();
personalData.setName(
cursor.getString(cursor.getColumnIndex(SalaryContract.PersonalData.KEY_NAME)));
personalData.setLastname(
cursor.getString(cursor.getColumnIndex(SalaryContract.PersonalData.KEY_LASTNAME)));
personalData.setAddress(
cursor.getString(cursor.getColumnIndex(SalaryContract.PersonalData.KEY_ADDRESS)));
personalData.setBirthdate(
cursor.getString(cursor.getColumnIndex(SalaryContract.PersonalData.KEY_BIRTHDATE)));
personalData.setCivilStatus(
cursor.getString(cursor.getColumnIndex(SalaryContract.PersonalData.KEY_CIVILSTATUS)));
personalData.setNbChildren(
cursor.getInt(cursor.getColumnIndex(SalaryContract.PersonalData.KEY_NBCHILDREN)));
personalData.setNationality(
cursor.getString(cursor.getColumnIndex(SalaryContract.PersonalData.KEY_NATIONALITY)));
personalData.setPermit(
cursor.getString(cursor.getColumnIndex(SalaryContract.PersonalData.KEY_PERMIT)));
personalData.setBank(
cursor.getString(cursor.getColumnIndex(SalaryContract.PersonalData.KEY_BANK)));
personalData.setPassword(
cursor.getString(cursor.getColumnIndex(SalaryContract.PersonalData.KEY_PASSWORD)));
personalData.setPostId(
cursor.getInt(cursor.getColumnIndex(SalaryContract.PersonalData.KEY_POSTID)));
personalData.setContractBegin(
cursor.getString(cursor.getColumnIndex(SalaryContract.PersonalData.KEY_CONTRACT_BEGIN)));
personalData.setPercentage(
cursor.getInt(cursor.getColumnIndex(SalaryContract.PersonalData.KEY_PERCENTAGE)));
personalData.setHollidayLeft(
cursor.getInt(cursor.getColumnIndex(SalaryContract.PersonalData.KEY_HOLLIDAY_LEFT)));
return personalData;
}
