/**
* @param characterID
* @return
*/
public CharacterSheetResponse getCharacterSheet(int characterID) {
CharacterSheetResponse characterSheet = new CharacterSheetResponse();
Cursor c =
db.query(
TABLE,
null,
COL_CHARACTER_ID + " = ?",
new String[] {String.valueOf(characterID)},
null,
null,
null);
if (c.moveToFirst()) {
characterSheet.setCharacterID(c.getLong(c.getColumnIndex(COL_CHARACTER_ID)));
characterSheet.setName(c.getString(c.getColumnIndex(COL_NAME)));
// characterSheet.setRace(EveRace.valueOf(c.getString(c.getColumnIndex(COL_RACE)))); TODO Fix
// eve race.
try {
characterSheet.setDateOfBirth(formatter.parse(c.getString(c.getColumnIndex(COL_DOB))));
} catch (ParseException e) {
e.printStackTrace();
}
characterSheet.setBloodLine(
EveBloodline.valueOf(c.getString(c.getColumnIndex(COL_BLOODLINE))));
characterSheet.setAncestry(EveAncestry.valueOf(c.getString(c.getColumnIndex(COL_ANCESTRY))));
characterSheet.setGender(c.getString(c.getColumnIndex(COL_GENDER)));
characterSheet.setCorporationName(c.getString(c.getColumnIndex(COL_CORP_NAME)));
characterSheet.setCorporationID(c.getLong(c.getColumnIndex(COL_CORP_ID)));
characterSheet.setAllianceID(c.getLong(c.getColumnIndex(COL_ALLIANCE_ID)));
characterSheet.setAllianceName(c.getString(c.getColumnIndex(COL_ALLIANCE)));
characterSheet.setCloneName(c.getString(c.getColumnIndex(COL_CLONE_NAME)));
characterSheet.setCloneSkillPoints(c.getLong(c.getColumnIndex(COL_CLONE_SP)));
characterSheet.setBalance(c.getDouble(c.getColumnIndex(COL_BALANCE)));
characterSheet.setIntelligence(c.getInt(c.getColumnIndex(COL_INTELLIGENCE)));
characterSheet.setMemory(c.getInt(c.getColumnIndex(COL_MEMORY)));
characterSheet.setCharisma(c.getInt(c.getColumnIndex(COL_CHARISMA)));
characterSheet.setPerception(c.getInt(c.getColumnIndex(COL_PERCEPTION)));
characterSheet.setWillpower(c.getInt(c.getColumnIndex(COL_WILLPOWER)));
}
c.close();
return characterSheet;
}
