+ if (dictionaryName.startsWith("VNFType")) {
+ for (int i = 1; i < dictSheet.size(); i++) {
+ VnfType attribute = new VnfType();
+ UserInfo userinfo = new UserInfo();
+ userinfo.setUserLoginId(userId);
+ attribute.setUserCreatedBy(userinfo);
+ attribute.setUserModifiedBy(userinfo);
+ String[] rows = dictSheet.get(i);
+ for (int j = 0; j < rows.length; j++) {
+ if ("vnf_type".equalsIgnoreCase(dictSheet.get(0)[j])
+ || "VNF Type".equalsIgnoreCase(dictSheet.get(0)[j])) {
+ attribute.setType(rows[j]);
+ }
+ if (DESCRIPTION.equalsIgnoreCase(dictSheet.get(0)[j])) {
+ attribute.setDescription(rows[j]);
+ }
+ }
+ commonClassDao.save(attribute);
+ }
+ }
+ if (dictionaryName.startsWith("VSCLAction")) {
+ for (int i = 1; i < dictSheet.size(); i++) {
+ VsclAction attribute = new VsclAction();
+ UserInfo userinfo = new UserInfo();
+ userinfo.setUserLoginId(userId);
+ attribute.setUserCreatedBy(userinfo);
+ attribute.setUserModifiedBy(userinfo);
+ String[] rows = dictSheet.get(i);
+ for (int j = 0; j < rows.length; j++) {
+ if ("vscl_action".equalsIgnoreCase(dictSheet.get(0)[j])
+ || "VSCL Action".equalsIgnoreCase(dictSheet.get(0)[j])) {
+ attribute.setAction(rows[j]);
+ }
+ if (DESCRIPTION.equalsIgnoreCase(dictSheet.get(0)[j])) {
+ attribute.setDescription(rows[j]);
+ }
+ }
+ commonClassDao.save(attribute);
+ }
+ }
+ if (dictionaryName.startsWith("ClosedLoopService")) {
+ for (int i = 1; i < dictSheet.size(); i++) {
+ ClosedLoopD2Services attribute = new ClosedLoopD2Services();
+ UserInfo userinfo = new UserInfo();
+ userinfo.setUserLoginId(userId);
+ attribute.setUserCreatedBy(userinfo);
+ attribute.setUserModifiedBy(userinfo);
+ String[] rows = dictSheet.get(i);
+ for (int j = 0; j < rows.length; j++) {
+ if ("serviceName".equalsIgnoreCase(dictSheet.get(0)[j])
+ || "Service Name".equalsIgnoreCase(dictSheet.get(0)[j])) {
+ attribute.setServiceName(rows[j]);
+ }
+ if (DESCRIPTION.equalsIgnoreCase(dictSheet.get(0)[j])) {
+ attribute.setDescription(rows[j]);
+ }
+ }
+ commonClassDao.save(attribute);
+ }
+ }
+ if (dictionaryName.startsWith("ClosedLoopSite")) {
+ for (int i = 1; i < dictSheet.size(); i++) {
+ ClosedLoopSite attribute = new ClosedLoopSite();
+ UserInfo userinfo = new UserInfo();
+ userinfo.setUserLoginId(userId);
+ attribute.setUserCreatedBy(userinfo);
+ attribute.setUserModifiedBy(userinfo);
+ String[] rows = dictSheet.get(i);
+ for (int j = 0; j < rows.length; j++) {
+ if ("siteName".equalsIgnoreCase(dictSheet.get(0)[j])
+ || "Site Name".equalsIgnoreCase(dictSheet.get(0)[j])) {
+ attribute.setSiteName(rows[j]);
+ }
+ if (DESCRIPTION.equalsIgnoreCase(dictSheet.get(0)[j])) {
+ attribute.setDescription(rows[j]);
+ }
+ }
+ commonClassDao.save(attribute);
+ }
+ }
+ if (dictionaryName.startsWith("PepOptions")) {
+ for (int i = 1; i < dictSheet.size(); i++) {
+ PepOptions attribute = new PepOptions();
+ UserInfo userinfo = new UserInfo();
+ userinfo.setUserLoginId(userId);
+ attribute.setUserCreatedBy(userinfo);
+ attribute.setUserModifiedBy(userinfo);
+ String[] rows = dictSheet.get(i);
+ for (int j = 0; j < rows.length; j++) {
+ if ("PEP_NAME".equalsIgnoreCase(dictSheet.get(0)[j])
+ || "PEP Name".equalsIgnoreCase(dictSheet.get(0)[j])) {
+ attribute.setPepName(rows[j]);
+ }
+ if (DESCRIPTION.equalsIgnoreCase(dictSheet.get(0)[j])) {
+ attribute.setDescription(rows[j]);
+ }
+ if ("Actions".equalsIgnoreCase(dictSheet.get(0)[j])) {
+ attribute.setActions(rows[j]);
+ }
+ }
+ commonClassDao.save(attribute);
+ }
+ }
+ if (dictionaryName.startsWith("VarbindDictionary")) {
+ for (int i = 1; i < dictSheet.size(); i++) {
+ VarbindDictionary attribute = new VarbindDictionary();
+ UserInfo userinfo = new UserInfo();
+ userinfo.setUserLoginId(userId);
+ attribute.setUserCreatedBy(userinfo);
+ attribute.setUserModifiedBy(userinfo);
+ String[] rows = dictSheet.get(i);
+ for (int j = 0; j < rows.length; j++) {
+ if ("varbind_Name".equalsIgnoreCase(dictSheet.get(0)[j])
+ || "Varbind Name".equalsIgnoreCase(dictSheet.get(0)[j])) {
+ attribute.setVarbindName(rows[j]);
+ }
+ if ("varbind_Description".equalsIgnoreCase(dictSheet.get(0)[j])
+ || "Varbind Description".equalsIgnoreCase(dictSheet.get(0)[j])) {
+ attribute.setVarbindDescription(rows[j]);
+ }
+ if ("varbind_oid".equalsIgnoreCase(dictSheet.get(0)[j])
+ || "Varbind OID".equalsIgnoreCase(dictSheet.get(0)[j])) {
+ attribute.setVarbindOid(rows[j]);
+ }
+ }
+ commonClassDao.save(attribute);
+ }
+ }
+ if (dictionaryName.startsWith("BRMSParamDictionary")) {
+ for (int i = 1; i < dictSheet.size(); i++) {
+ BrmsParamTemplate attribute = new BrmsParamTemplate();
+ UserInfo userinfo = new UserInfo();
+ userinfo.setUserLoginId(userId);
+ attribute.setUserCreatedBy(userinfo);
+ String[] rows = dictSheet.get(i);
+ for (int j = 0; j < rows.length; j++) {
+ if ("param_template_name".equalsIgnoreCase(dictSheet.get(0)[j])
+ || "Rule Name".equalsIgnoreCase(dictSheet.get(0)[j])) {
+ attribute.setRuleName(rows[j]);
+ }
+ if (DESCRIPTION.equalsIgnoreCase(dictSheet.get(0)[j])) {
+ attribute.setDescription(rows[j]);
+ }
+ if ("rule".equalsIgnoreCase(dictSheet.get(0)[j])) {
+ attribute.setRule(rows[j]);
+ }
+ }
+ commonClassDao.save(attribute);
+ }
+ }
+ if (dictionaryName.startsWith("BRMSControllerDictionary")) {
+ for (int i = 1; i < dictSheet.size(); i++) {
+ BrmsController attribute = new BrmsController();
+ UserInfo userinfo = new UserInfo();
+ userinfo.setUserLoginId(userId);
+ attribute.setUserCreatedBy(userinfo);
+ String[] rows = dictSheet.get(i);
+ for (int j = 0; j < rows.length; j++) {
+ if ("controllerName".equalsIgnoreCase(dictSheet.get(0)[j])
+ || "Controller Name".equalsIgnoreCase(dictSheet.get(0)[j])) {
+ attribute.setControllerName(rows[j]);
+ }
+ if (DESCRIPTION.equalsIgnoreCase(dictSheet.get(0)[j])) {
+ attribute.setDescription(rows[j]);
+ }
+ if ("controller".equalsIgnoreCase(dictSheet.get(0)[j])) {
+ attribute.setController(rows[j]);
+ }
+ }
+ commonClassDao.save(attribute);
+ }
+ }
+ if (dictionaryName.startsWith("BRMSDependencyDictionary")) {
+ for (int i = 1; i < dictSheet.size(); i++) {
+ BrmsDependency attribute = new BrmsDependency();
+ UserInfo userinfo = new UserInfo();
+ userinfo.setUserLoginId(userId);
+ attribute.setUserCreatedBy(userinfo);
+ String[] rows = dictSheet.get(i);
+ for (int j = 0; j < rows.length; j++) {
+ if ("dependencyName".equalsIgnoreCase(dictSheet.get(0)[j])
+ || "Dependency Name".equalsIgnoreCase(dictSheet.get(0)[j])) {
+ attribute.setDependencyName(rows[j]);
+ }
+ if (DESCRIPTION.equalsIgnoreCase(dictSheet.get(0)[j])) {
+ attribute.setDescription(rows[j]);
+ }
+ if (DEPENDENCY.equalsIgnoreCase(dictSheet.get(0)[j])) {
+ attribute.setDependency(rows[j]);
+ }
+ }
+ commonClassDao.save(attribute);
+ }
+ }
+ if (dictionaryName.startsWith("Settings")) {
+ for (int i = 1; i < dictSheet.size(); i++) {
+ DecisionSettings attribute = new DecisionSettings();
+ UserInfo userinfo = new UserInfo();
+ userinfo.setUserLoginId(userId);
+ attribute.setUserCreatedBy(userinfo);
+ attribute.setUserModifiedBy(userinfo);
+ String[] rows = dictSheet.get(i);
+ for (int j = 0; j < rows.length; j++) {
+ if ("xacml_id".equalsIgnoreCase(dictSheet.get(0)[j])
+ || "Settings ID".equalsIgnoreCase(dictSheet.get(0)[j])) {
+ attribute.setXacmlId(rows[j]);
+ }
+ if (DESCRIPTION.equalsIgnoreCase(dictSheet.get(0)[j])) {
+ attribute.setDescription(rows[j]);
+ }
+ if ("priority".equalsIgnoreCase(dictSheet.get(0)[j])) {
+ attribute.setPriority(rows[j]);
+ }
+ if ("datatype".equalsIgnoreCase(dictSheet.get(0)[j])
+ || "Data Type".equalsIgnoreCase(dictSheet.get(0)[j])) {
+ Datatype dataType = new Datatype();
+ if ("string".equalsIgnoreCase(rows[j])) {
+ dataType.setId(26);
+ } else if ("integer".equalsIgnoreCase(rows[j])) {
+ dataType.setId(12);
+ } else if ("double".equalsIgnoreCase(rows[j])) {
+ dataType.setId(25);
+ } else if ("boolean".equalsIgnoreCase(rows[j])) {
+ dataType.setId(18);
+ } else if ("user".equalsIgnoreCase(rows[j])) {
+ dataType.setId(29);
+ }
+ attribute.setDatatypeBean(dataType);
+ }
+ }
+ commonClassDao.save(attribute);
+ }
+ }
+ if (dictionaryName.startsWith("PrefixList")) {
+ for (int i = 1; i < dictSheet.size(); i++) {
+ PrefixList attribute = new PrefixList();
+ String[] rows = dictSheet.get(i);
+ for (int j = 0; j < rows.length; j++) {
+ if ("prefixListName".equalsIgnoreCase(dictSheet.get(0)[j])
+ || "PrefixList Name".equalsIgnoreCase(dictSheet.get(0)[j])) {
+ attribute.setPrefixListName(rows[j]);
+ }
+ if (DESCRIPTION.equalsIgnoreCase(dictSheet.get(0)[j])) {
+ attribute.setPrefixListValue(rows[j]);
+ }
+ if ("prefixListValue".equalsIgnoreCase(dictSheet.get(0)[j])
+ || "PrefixList Value".equalsIgnoreCase(dictSheet.get(0)[j])) {
+ attribute.setDescription(rows[j]);
+ }
+ }
+ commonClassDao.save(attribute);
+ }
+ }
+ if (dictionaryName.startsWith("SecurityZone")) {
+ for (int i = 1; i < dictSheet.size(); i++) {
+ SecurityZone attribute = new SecurityZone();
+ String[] rows = dictSheet.get(i);
+ for (int j = 0; j < rows.length; j++) {
+ if ("zoneName".equalsIgnoreCase(dictSheet.get(0)[j])
+ || "Zone Name".equalsIgnoreCase(dictSheet.get(0)[j])) {
+ attribute.setZoneName(rows[j]);
+ }
+ if ("zoneValue".equalsIgnoreCase(dictSheet.get(0)[j])
+ || "Zone Value".equalsIgnoreCase(dictSheet.get(0)[j])) {
+ attribute.setZoneValue(rows[j]);
+ }
+ }
+ commonClassDao.save(attribute);
+ }
+ }
+ if (dictionaryName.startsWith("Zone")) {
+ for (int i = 1; i < dictSheet.size(); i++) {
+ Zone attribute = new Zone();
+ String[] rows = dictSheet.get(i);
+ for (int j = 0; j < rows.length; j++) {
+ if ("zoneName".equalsIgnoreCase(dictSheet.get(0)[j])
+ || "Zone Name".equalsIgnoreCase(dictSheet.get(0)[j])) {
+ attribute.setZoneName(rows[j]);
+ }
+ if ("zoneValue".equalsIgnoreCase(dictSheet.get(0)[j])
+ || "Zone Value".equalsIgnoreCase(dictSheet.get(0)[j])) {
+ attribute.setZoneValue(rows[j]);
+ }
+ }
+ commonClassDao.save(attribute);
+ }
+ }
+ if (dictionaryName.startsWith("ServiceList")) {
+ for (int i = 1; i < dictSheet.size(); i++) {
+ ServiceList attribute = new ServiceList();
+ String[] rows = dictSheet.get(i);
+ for (int j = 0; j < rows.length; j++) {
+ if ("serviceName".equalsIgnoreCase(dictSheet.get(0)[j])
+ || "Service Name".equalsIgnoreCase(dictSheet.get(0)[j])) {
+ attribute.setServiceName(rows[j]);
+ }
+ if ("serviceDesc".equalsIgnoreCase(dictSheet.get(0)[j])
+ || DESCRIPTION.equalsIgnoreCase(dictSheet.get(0)[j])) {
+ attribute.setServiceDescription(rows[j]);
+ }
+ if ("serviceType".equalsIgnoreCase(dictSheet.get(0)[j])
+ || "Service Type".equalsIgnoreCase(dictSheet.get(0)[j])) {
+ attribute.setServiceType(rows[j]);
+ }
+ if ("serviceTrasProtocol".equalsIgnoreCase(dictSheet.get(0)[j])
+ || "Transport Protocol".equalsIgnoreCase(dictSheet.get(0)[j])) {
+ attribute.setServiceTransportProtocol(rows[j]);
+ }
+ if ("serviceAppProtocol".equalsIgnoreCase(dictSheet.get(0)[j])
+ || "APP Protocol".equalsIgnoreCase(dictSheet.get(0)[j])) {
+ attribute.setServiceAppProtocol(rows[j]);
+ }
+ if ("servicePorts".equalsIgnoreCase(dictSheet.get(0)[j])
+ || "Ports".equalsIgnoreCase(dictSheet.get(0)[j])) {
+ attribute.setServicePorts(rows[j]);
+ }
+ }
+ commonClassDao.save(attribute);
+ }
+ }
+ if (dictionaryName.startsWith("ServiceGroup")) {
+ for (int i = 1; i < dictSheet.size(); i++) {
+ GroupServiceList attribute = new GroupServiceList();
+ String[] rows = dictSheet.get(i);
+ for (int j = 0; j < rows.length; j++) {
+ if ("name".equalsIgnoreCase(dictSheet.get(0)[j])
+ || "Group Name".equalsIgnoreCase(dictSheet.get(0)[j])) {
+ attribute.setGroupName(rows[j]);
+ }
+ if ("serviceList".equalsIgnoreCase(dictSheet.get(0)[j])
+ || "Service List".equalsIgnoreCase(dictSheet.get(0)[j])) {
+ attribute.setServiceList(rows[j]);
+ }
+ }
+ commonClassDao.save(attribute);
+ }
+ }
+ if (dictionaryName.startsWith("AddressGroup")) {
+ for (int i = 1; i < dictSheet.size(); i++) {
+ AddressGroup attribute = new AddressGroup();
+ String[] rows = dictSheet.get(i);
+ for (int j = 0; j < rows.length; j++) {
+ if ("name".equalsIgnoreCase(dictSheet.get(0)[j])
+ || "Group Name".equalsIgnoreCase(dictSheet.get(0)[j])) {
+ attribute.setGroupName(rows[j]);
+ }
+ if ("serviceList".equalsIgnoreCase(dictSheet.get(0)[j])
+ || "Prefix List".equalsIgnoreCase(dictSheet.get(0)[j])) {
+ attribute.setServiceList(rows[j]);
+ }
+ if (DESCRIPTION.equalsIgnoreCase(dictSheet.get(0)[j])) {
+ attribute.setDescription(rows[j]);
+ }
+ }
+ commonClassDao.save(attribute);
+ }
+ }
+ if (dictionaryName.startsWith("ProtocolList")) {
+ for (int i = 1; i < dictSheet.size(); i++) {
+ ProtocolList attribute = new ProtocolList();
+ String[] rows = dictSheet.get(i);
+ for (int j = 0; j < rows.length; j++) {
+ if ("protocolName".equalsIgnoreCase(dictSheet.get(0)[j])
+ || "Protocol Name".equalsIgnoreCase(dictSheet.get(0)[j])) {
+ attribute.setProtocolName(rows[j]);
+ }
+ if (DESCRIPTION.equalsIgnoreCase(dictSheet.get(0)[j])) {
+ attribute.setDescription(rows[j]);
+ }
+ }
+ commonClassDao.save(attribute);
+ }
+ }
+ if (dictionaryName.startsWith("ActionList")) {
+ for (int i = 1; i < dictSheet.size(); i++) {
+ ActionList attribute = new ActionList();
+ String[] rows = dictSheet.get(i);
+ for (int j = 0; j < rows.length; j++) {
+ if ("actionName".equalsIgnoreCase(dictSheet.get(0)[j])
+ || "Action Name".equalsIgnoreCase(dictSheet.get(0)[j])) {
+ attribute.setActionName(rows[j]);
+ }
+ if (DESCRIPTION.equalsIgnoreCase(dictSheet.get(0)[j])) {
+ attribute.setDescription(rows[j]);
+ }
+ }
+ commonClassDao.save(attribute);
+ }
+ }
+ if (dictionaryName.startsWith("TermList")) {
+ for (int i = 1; i < dictSheet.size(); i++) {
+ TermList attribute = new TermList();
+ UserInfo userinfo = new UserInfo();
+ userinfo.setUserLoginId(userId);
+ attribute.setUserCreatedBy(userinfo);
+ attribute.setUserModifiedBy(userinfo);
+ String[] rows = dictSheet.get(i);
+ for (int j = 0; j < rows.length; j++) {
+ if ("termName".equalsIgnoreCase(dictSheet.get(0)[j])
+ || "Term-Name".equalsIgnoreCase(dictSheet.get(0)[j])) {
+ attribute.setTermName(rows[j]);
+ }
+ if ("Term-Description".equalsIgnoreCase(dictSheet.get(0)[j])
+ || "termDescription".equalsIgnoreCase(dictSheet.get(0)[j])) {
+ attribute.setDescription(rows[j]);
+ }
+ if ("fromZone".equalsIgnoreCase(dictSheet.get(0)[j])
+ || "From Zone".equalsIgnoreCase(dictSheet.get(0)[j])) {
+ attribute.setFromZone(rows[j]);
+ }
+ if ("toZone".equalsIgnoreCase(dictSheet.get(0)[j])
+ || "To Zone".equalsIgnoreCase(dictSheet.get(0)[j])) {
+ attribute.setToZone(rows[j]);
+ }
+ if ("srcIPList".equalsIgnoreCase(dictSheet.get(0)[j])
+ || "Source-IP-List".equalsIgnoreCase(dictSheet.get(0)[j])) {
+ attribute.setSrcIpList(rows[j]);
+ }
+ if ("destIPList".equalsIgnoreCase(dictSheet.get(0)[j])
+ || "Destination-IP-List".equalsIgnoreCase(dictSheet.get(0)[j])) {
+ attribute.setDestIpList(rows[j]);
+ }
+ if ("srcPortList".equalsIgnoreCase(dictSheet.get(0)[j])
+ || "Source-Port-List".equalsIgnoreCase(dictSheet.get(0)[j])) {
+ attribute.setSrcPortList(rows[j]);
+ }
+ if ("destPortList".equalsIgnoreCase(dictSheet.get(0)[j])
+ || "Destination-Port-List".equalsIgnoreCase(dictSheet.get(0)[j])) {
+ attribute.setDestPortList(rows[j]);
+ }
+ if ("action".equalsIgnoreCase(dictSheet.get(0)[j])
+ || "Action List".equalsIgnoreCase(dictSheet.get(0)[j])) {
+ attribute.setAction(rows[j]);
+ }
+ }
+ commonClassDao.save(attribute);
+ }
+ }
+ if (dictionaryName.startsWith("SearchCriteria")) {
+ for (int i = 1; i < dictSheet.size(); i++) {
+ DescriptiveScope attribute = new DescriptiveScope();
+ UserInfo userinfo = new UserInfo();
+ userinfo.setUserLoginId(userId);
+ attribute.setUserCreatedBy(userinfo);
+ attribute.setUserModifiedBy(userinfo);
+ String[] rows = dictSheet.get(i);
+ for (int j = 0; j < rows.length; j++) {
+ if ("descriptiveScopeName".equalsIgnoreCase(dictSheet.get(0)[j])
+ || "Descriptive Scope Name".equalsIgnoreCase(dictSheet.get(0)[j])) {
+ attribute.setScopeName(rows[j]);
+ }
+ if (DESCRIPTION.equalsIgnoreCase(dictSheet.get(0)[j])) {
+ attribute.setDescription(rows[j]);
+ }
+ if ("search".equalsIgnoreCase(dictSheet.get(0)[j])
+ || "Search Criteria".equalsIgnoreCase(dictSheet.get(0)[j])) {
+ attribute.setSearch(rows[j]);
+ }
+ }
+ commonClassDao.save(attribute);
+ }
+ }
+ csvReader.close();
+ response.setStatus(HttpServletResponse.SC_OK);
+ response.getWriter().write("Success");
+ } catch (Exception e) {
+ LOGGER.error("Exception Occured while importing dictionary" + e);
+ response.setStatus(HttpServletResponse.SC_INTERNAL_SERVER_ERROR);
+ response.getWriter().write(ERROR);
+ } finally {
+ if (file != null && file.exists()) {
+ boolean deleted = file.delete();
+ LOGGER.error("Imported File has been deleted: " + deleted);
+ }
+ }
+ }