/*
* (non-Javadoc)
*
* @see ca.unb.cs.pcsf.db.DBAccessService#getParticipantById(java.lang.String)
*/
public Participant getParticipantById(String participantId) {
logger.debug(LOGPRE + "getParticipantById() start" + LOGPRE);
Participant participant = new Participant();
String selectRequest = "select * from `" + DOMAIN_PARTICIPANT + "`";
List<Item> items = this.getDataFromDomain(selectRequest);
Item findItem = new Item();
if (!items.isEmpty()) {
for (Item item : items) {
if (item.getName().equals(participantId)) {
findItem = item;
break;
}
}
}
if (findItem != null) {
participant.setId(findItem.getName());
for (Attribute attribute : findItem.getAttributes()) {
if (attribute.getName().equals(PARTICIPANT_ATTRIBUTE_NAME))
participant.setName(attribute.getValue());
if (attribute.getName().equals(PARTICIPANT_ATTRIBUTE_EMAIL))
participant.setEmail(attribute.getValue());
if (attribute.getName().equals(PARTICIPANT_ATTRIBUTE_COLLABORATION_ID))
participant.setCollaborationId(attribute.getValue());
if (attribute.getName().equals(PARTICIPANT_ATTRIBUTE_IS_REG))
participant.setIsReg(attribute.getValue());
}
}
logger.debug(LOGPRE + "getParticipantById() end" + LOGPRE);
return participant;
}
/**
* Get a participant record from the data base by name and collaboration id.
*
* @param participantName
* @param collaborationId
* @return a participant
*/
private Participant getParticipantByNameAndCollaborationId(
String participantName, String collaborationId) {
logger.debug(LOGPRE + "getParticipantByNameAndCollaborationId() start" + LOGPRE);
Participant participant = new Participant();
String selectRequest =
"select * from `"
+ DOMAIN_PARTICIPANT
+ "` where "
+ PARTICIPANT_ATTRIBUTE_NAME
+ " = '"
+ participantName
+ "' AND "
+ PARTICIPANT_ATTRIBUTE_COLLABORATION_ID
+ "='"
+ collaborationId
+ "'";
List<Item> items = this.getDataFromDomain(selectRequest);
if (items != null) {
Item item = items.get(0);
participant.setId(item.getName());
for (Attribute attribute : item.getAttributes()) {
if (attribute.getName().equals(PARTICIPANT_ATTRIBUTE_NAME))
participant.setName(attribute.getValue());
if (attribute.getName().equals(PARTICIPANT_ATTRIBUTE_EMAIL))
participant.setEmail(attribute.getValue());
if (attribute.getName().equals(PARTICIPANT_ATTRIBUTE_COLLABORATION_ID))
participant.setCollaborationId(attribute.getValue());
if (attribute.getName().equals(PARTICIPANT_ATTRIBUTE_IS_REG))
participant.setIsReg(attribute.getValue());
}
}
logger.debug(LOGPRE + "getParticipantByNameAndCollaborationId() end" + LOGPRE);
return participant;
}