@Override
public List<SeekerAimsTO> buildParticipants() throws Exception {
boolean mark = false;
List<Row> participantRows = new ArrayList<Row>();
for (int i = 0; i < sheetParticipants.getLastRowNum(); i++) {
Row row = sheetParticipants.getRow(i);
if (mark) {
if (row != null) {
participantRows.add(row);
}
}
if (row != null && row.getCell(ParticipantCols.NAME.getColumn()) != null) {
String string = row.getCell(ParticipantCols.NAME.getColumn()).toString();
if (string.contains(ParticipantCols.NAME.getHeader())) {
mark = true;
}
if (mark) {
if (row == null
|| (row.getCell(ParticipantCols.NAME.getColumn()) == null)
|| row.getCell(ParticipantCols.NAME.getColumn()).toString().isEmpty()) {
mark = false;
}
}
}
}
ProgramHeaderTO buildProgramDetails = buildProgramDetails();
List<SeekerAimsTO> processRows = processRows(participantRows);
for (SeekerAimsTO seekerAims : processRows) {
seekerAims.setCountry(buildProgramDetails.getCountry());
}
sLogger.info("Participant list:" + participantRows.size());
return processRows;
}
/**
* @param header
* @param cellPhone
*/
private void populateOrgContactMobile(ProgramHeaderTO header, Cell cellPhone) {
if (cellPhone != null) {
try {
Double parseDouble = Double.parseDouble(cellPhone.toString());
header.setOrgContactMobile(String.valueOf(parseDouble.longValue()));
} catch (Exception e) {
header.setOrgContactMobile(cellPhone.toString());
}
}
}
/**
* @param header
* @param codateRow
*/
private void populateStartDate(ProgramHeaderTO header, Row codateRow) {
if (codateRow.getCell(ProgramCols.EVENT_DATE.getCell() + 1) != null) {
String string = codateRow.getCell(ProgramCols.EVENT_DATE.getCell() + 1).toString();
SimpleDateFormat format = new SimpleDateFormat(DD_MMM_YYYY);
try {
Date date = format.parse(string);
header.setProgramStartDate(date);
} catch (ParseException e) {
header.setProgramRawStartDate(string);
}
}
}
/*
* (non-Javadoc)
*
* @see org.srcm.pmp.utility.ExcelDataProcessor#buildProgramDetails()
*/
@Override
public ProgramHeaderTO buildProgramDetails() throws Exception {
if (sheetEvent == null || sheetParticipants == null) {
throw new Exception("Invalid V2");
}
ProgramHeaderTO header = new ProgramHeaderTO();
Row programEventRow = sheetEvent.getRow(ProgramCols.EVENT_TYPE.getRow());
Row programOther = sheetEvent.getRow(ProgramCols.OTHER.getRow());
Row programEventPlace = sheetEvent.getRow(ProgramCols.EVENT_PLACE.getRow());
Row programEventDate = sheetEvent.getRow(ProgramCols.EVENT_DATE.getRow());
Row programCountry = sheetEvent.getRow(ProgramCols.EVENT_COUNTRY.getRow());
Row programState = sheetEvent.getRow(ProgramCols.EVENT_STATE.getRow());
Row programCity = sheetEvent.getRow(ProgramCols.EVENT_CITY.getRow());
Row programCoordinator = sheetEvent.getRow(ProgramCols.EVENT_COORDINATORNAME.getRow());
Row programCoordinatorMobile = sheetEvent.getRow(ProgramCols.EVENT_COORDINATOR_MOBILE.getRow());
Row programCoordinatorMail = sheetEvent.getRow(ProgramCols.EVENT_COORDINATOR_MAIL.getRow());
Row organizationName = sheetEvent.getRow(ProgramCols.ORGANIZATION_NAME.getRow());
Row orgContactPerson = sheetEvent.getRow(ProgramCols.ORGANIZATION_CONTACT_PERSON.getRow());
Row orgWebSite = sheetEvent.getRow(ProgramCols.ORGANIZATION_WEBSITE.getRow());
Row orgContactMailId = sheetEvent.getRow(ProgramCols.ORGANIZATION_CONTACT_MAILID.getRow());
Row orgContactMobile = sheetEvent.getRow(ProgramCols.ORGANIZATION_CONTACT_MOBILE.getRow());
Row preceptorName = sheetEvent.getRow(ProgramCols.PRECEPTOR_NAME.getRow());
Row preceptorId = sheetEvent.getRow(ProgramCols.PRECEPTOR_ID.getRow());
Row welcomeCardSignedBy = sheetEvent.getRow(ProgramCols.WELCOME_CARD_SIGNEDBY.getRow());
Row welcomeCardSignedID = sheetEvent.getRow(ProgramCols.WELCOME_CARD_SIGNER_ID.getRow());
Row remarks = sheetEvent.getRow(ProgramCols.REMARKS.getRow() + 1);
header.setEmail(
validateNull(
programCoordinatorMail.getCell(ProgramCols.EVENT_COORDINATOR_MAIL.getCell() + 1)));
header.setChannelName(
programEventRow.getCell(ProgramCols.EVENT_TYPE.getCell() + 1).getStringCellValue());
header.setCenter(
programEventPlace.getCell(ProgramCols.EVENT_PLACE.getCell() + 1).getStringCellValue());
header.setCoordinatorName(
validateNull(programCoordinator.getCell(ProgramCols.EVENT_COORDINATORNAME.getCell() + 1)));
header.setInstituteName(
organizationName.getCell(ProgramCols.ORGANIZATION_NAME.getCell() + 1).toString());
header.setWebsite(
validateNull(orgWebSite.getCell(ProgramCols.ORGANIZATION_WEBSITE.getCell() + 1)));
header.setCountry(
validateNull(programCountry.getCell(ProgramCols.EVENT_COUNTRY.getCell() + 1)));
header.setState(validateNull(programState.getCell(ProgramCols.EVENT_STATE.getCell() + 1)));
populateStartDate(header, programEventDate);
header.setOther(validateNull(programOther.getCell(ProgramCols.OTHER.getCell() + 1)));
header.setEventCity(validateNull(programCity.getCell(ProgramCols.EVENT_CITY.getCell() + 1)));
populateCoordnatorMobile(
header,
programCoordinatorMobile.getCell(ProgramCols.EVENT_COORDINATOR_MOBILE.getCell() + 1));
populateOrgContactMobile(
header, orgContactMobile.getCell(ProgramCols.ORGANIZATION_CONTACT_MOBILE.getCell() + 1));
header.setOrgContactPerson(
validateNull(
orgContactPerson.getCell(ProgramCols.ORGANIZATION_CONTACT_PERSON.getCell() + 1)));
header.setOrgContactEmail(
validateNull(
orgContactMailId.getCell(ProgramCols.ORGANIZATION_CONTACT_MAILID.getCell() + 1)));
header.setPreceptorName(
validateNull(preceptorName.getCell(ProgramCols.PRECEPTOR_NAME.getCell() + 1)));
header.setPreceptorId(
validateNull(preceptorId.getCell(ProgramCols.PRECEPTOR_ID.getCell() + 1)));
header.setWelcomeCardSignedBy(
validateNull(welcomeCardSignedBy.getCell(ProgramCols.WELCOME_CARD_SIGNEDBY.getCell() + 1)));
header.setWelcomeCardSignedID(
validateNull(
welcomeCardSignedID.getCell(ProgramCols.WELCOME_CARD_SIGNER_ID.getCell() + 1)));
header.setRemarks(validateNull(remarks.getCell(ProgramCols.REMARKS.getCell())));
return header;
}