/* * (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; }