/*-
 * ============LICENSE_START=======================================================
 * ONAP-PAP-REST
 * ================================================================================
 * Copyright (C) 2017-2018 AT&T Intellectual Property. All rights reserved.
 * ================================================================================
 * Licensed under the Apache License, Version 2.0 (the "License");
 * you may not use this file except in compliance with the License.
 * You may obtain a copy of the License at
 * 
 *      http://www.apache.org/licenses/LICENSE-2.0
 * 
 * Unless required by applicable law or agreed to in writing, software
 * distributed under the License is distributed on an "AS IS" BASIS,
 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 * See the License for the specific language governing permissions and
 * limitations under the License.
 * ============LICENSE_END=========================================================
 */

package org.onap.policy.pap.xacml.rest.controller;

import java.io.File;
import java.io.FileOutputStream;
import java.io.FileReader;
import java.io.IOException;
import java.io.OutputStream;
import java.util.List;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import org.apache.commons.compress.utils.IOUtils;
import org.onap.policy.common.logging.flexlogger.FlexLogger;
import org.onap.policy.common.logging.flexlogger.Logger;
import org.onap.policy.pap.xacml.rest.DictionaryNames;
import org.onap.policy.rest.dao.CommonClassDao;
import org.onap.policy.rest.jpa.ActionList;
import org.onap.policy.rest.jpa.ActionPolicyDict;
import org.onap.policy.rest.jpa.AddressGroup;
import org.onap.policy.rest.jpa.Attribute;
import org.onap.policy.rest.jpa.BRMSController;
import org.onap.policy.rest.jpa.BRMSDependency;
import org.onap.policy.rest.jpa.BRMSParamTemplate;
import org.onap.policy.rest.jpa.Category;
import org.onap.policy.rest.jpa.ClosedLoopD2Services;
import org.onap.policy.rest.jpa.ClosedLoopSite;
import org.onap.policy.rest.jpa.Datatype;
import org.onap.policy.rest.jpa.DecisionSettings;
import org.onap.policy.rest.jpa.DescriptiveScope;
import org.onap.policy.rest.jpa.GroupServiceList;
import org.onap.policy.rest.jpa.MicroServiceModels;
import org.onap.policy.rest.jpa.OnapName;
import org.onap.policy.rest.jpa.PEPOptions;
import org.onap.policy.rest.jpa.PrefixList;
import org.onap.policy.rest.jpa.ProtocolList;
import org.onap.policy.rest.jpa.SecurityZone;
import org.onap.policy.rest.jpa.ServiceList;
import org.onap.policy.rest.jpa.TermList;
import org.onap.policy.rest.jpa.UserInfo;
import org.onap.policy.rest.jpa.VNFType;
import org.onap.policy.rest.jpa.VSCLAction;
import org.onap.policy.rest.jpa.VarbindDictionary;
import org.onap.policy.rest.jpa.Zone;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestMethod;

import com.fasterxml.jackson.databind.DeserializationFeature;
import com.fasterxml.jackson.databind.ObjectMapper;

import au.com.bytecode.opencsv.CSVReader;


@Controller
public class DictionaryImportController {
	private static final Logger LOGGER  = FlexLogger.getLogger(DictionaryImportController.class);
	
	private static CommonClassDao commonClassDao;
	private static final String DESCRIPTION= "description";
	
	@Autowired
	public DictionaryImportController(CommonClassDao commonClassDao){
		DictionaryImportController.commonClassDao = commonClassDao;
	}
	
	public DictionaryImportController(){
		super();
	}	


	@RequestMapping(value={"/dictionary/import_dictionary"}, method={RequestMethod.POST})
	public void importDictionaryData(HttpServletRequest request, HttpServletResponse response) throws IOException{
		ObjectMapper mapper = new ObjectMapper();
		mapper.configure(DeserializationFeature.FAIL_ON_UNKNOWN_PROPERTIES, false);
		String userId = request.getParameter("userId");
		String dictionaryName = request.getParameter("dictionaryName");
		
		if(dictionaryName == null || dictionaryName.isEmpty()){
			LOGGER.error("dictionaryName is null/empty");
			response.setStatus(HttpServletResponse.SC_BAD_REQUEST);
			response.getWriter().write("Error");
			return;
		}
		
		// fix Fortify Path Manipulation issue
		if(!isValidDictionaryName(dictionaryName)){
			LOGGER.error("dictionaryName is invalid");
			response.setStatus(HttpServletResponse.SC_OK);
			response.getWriter().write("Dictionary Import failed. Hence the following dictionary doen't support import function  : "+ dictionaryName);
			return;			
		}
		File file = new File(dictionaryName);	
		try(OutputStream outputStream = new FileOutputStream(file); FileReader fileReader = new FileReader(file.toString())){
			IOUtils.copy(request.getInputStream(), outputStream);
			CSVReader csvReader = new CSVReader(fileReader);
			List<String[]> dictSheet = csvReader.readAll();
			if(dictionaryName.startsWith("Attribute")){
				for(int i = 1; i< dictSheet.size(); i++){
					Attribute attribute = new Attribute("");
					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]) || "Attribute 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);
							Category category = new Category();
							category.setId(5);
							attribute.setCategoryBean(category);
						}
						if("attribute_value".equalsIgnoreCase(dictSheet.get(0)[j]) || "Attribute Value".equalsIgnoreCase(dictSheet.get(0)[j])){
							attribute.setAttributeValue(rows[j]);
						}
					}
					commonClassDao.save(attribute);
				}
			}
			if(dictionaryName.startsWith("ActionPolicyDictionary")){
				for(int i = 1; i< dictSheet.size(); i++){
					ActionPolicyDict attribute = new ActionPolicyDict();
					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("attribute_name".equalsIgnoreCase(dictSheet.get(0)[j]) || "Attribute Name".equalsIgnoreCase(dictSheet.get(0)[j])){
							attribute.setAttributeName(rows[j]);
						}
						if("body".equalsIgnoreCase(dictSheet.get(0)[j])){
							attribute.setBody(rows[j]);
						}
						if(DESCRIPTION.equalsIgnoreCase(dictSheet.get(0)[j])){
							attribute.setDescription(rows[j]);
						}
						if("headers".equalsIgnoreCase(dictSheet.get(0)[j])){
							attribute.setHeader(rows[j]);
						}
						if("method".equalsIgnoreCase(dictSheet.get(0)[j])){
							attribute.setMethod(rows[j]);
						}
						if("type".equalsIgnoreCase(dictSheet.get(0)[j])){
							attribute.setType(rows[j]);
						}
						if("url".equalsIgnoreCase(dictSheet.get(0)[j])){
							attribute.setUrl(rows[j]);
						}
					}
					commonClassDao.save(attribute);
				}
			}
			if(dictionaryName.startsWith("OnapName")){
				for(int i = 1; i< dictSheet.size(); i++){
					OnapName attribute = new OnapName();
					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("onap_name".equalsIgnoreCase(dictSheet.get(0)[j]) || "Onap Name".equalsIgnoreCase(dictSheet.get(0)[j])){
							attribute.setOnapName(rows[j]);
						}
						if(DESCRIPTION.equalsIgnoreCase(dictSheet.get(0)[j])){
							attribute.setDescription(rows[j]);
						}
					}
					commonClassDao.save(attribute);
				}
			}

			if(dictionaryName.startsWith("MSPolicyDictionary")){
				for(int i = 1; i< dictSheet.size(); i++){
					MicroServiceModels attribute = new MicroServiceModels();
					UserInfo userinfo = new UserInfo();
					userinfo.setUserLoginId(userId);
					attribute.setUserCreatedBy(userinfo);
					String[] rows = dictSheet.get(i);
					for (int j=0 ; j<rows.length; j++ ){
						if("modelName".equalsIgnoreCase(dictSheet.get(0)[j]) || "Micro Service Model".equalsIgnoreCase(dictSheet.get(0)[j])){
							attribute.setModelName(rows[j]);
						}
						if("version".equalsIgnoreCase(dictSheet.get(0)[j]) || "Model Version".equalsIgnoreCase(dictSheet.get(0)[j])){
							attribute.setVersion(rows[j]);
						}
						if(DESCRIPTION.equalsIgnoreCase(dictSheet.get(0)[j])){
							attribute.setDescription(rows[j]);
						}
						if("dependency".equalsIgnoreCase(dictSheet.get(0)[j])){
							attribute.setDependency(rows[j]);
						}
						if("attributes".equalsIgnoreCase(dictSheet.get(0)[j])){
							attribute.setAttributes(rows[j]);
						}
						if("enumValues".equalsIgnoreCase(dictSheet.get(0)[j])){
							attribute.setEnumValues(rows[j]);
						}
						if("Ref Attributes".equalsIgnoreCase(dictSheet.get(0)[j])){
							attribute.setRef_attributes(rows[j]);
						}
						if("Sub Attributes".equalsIgnoreCase(dictSheet.get(0)[j])){
							attribute.setSub_attributes(rows[j]);
						}
					}

					commonClassDao.save(attribute);
				}
			}		

			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.setVnftype(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.setVsclaction(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.setServiceTransProtocol(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.setFromZones(rows[j]);
						}
						if("toZone".equalsIgnoreCase(dictSheet.get(0)[j]) || "To Zone".equalsIgnoreCase(dictSheet.get(0)[j])){
							attribute.setToZones(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);
			}
		}
	}
	
	public boolean isValidDictionaryName(String dictionaryName){
		
		String nameCheck = dictionaryName.replace(".csv", "");
		try{
			DictionaryNames mode = DictionaryNames.valueOf(nameCheck);
			switch (mode){
				case Attribute:
				case ActionPolicyDictionary:
				case OnapName:
				case MSPolicyDictionary:
				case VNFType:
				case VSCLAction:
				case ClosedLoopService:
				case ClosedLoopSite:
				case PEPOptions:
				case VarbindDictionary:
				case BRMSParamDictionary:
				case BRMSControllerDictionary:
				case BRMSDependencyDictionary:
				case Settings:
				case PrefixList:
				case SecurityZone:
				case Zone:
				case ServiceList:
				case ServiceGroup:
				case AddressGroup:
				case ProtocolList:
				case ActionList:
				case TermList:
				case SearchCriteria:
					return true;
				default:
					return false;
			}
		}catch(Exception e){
			LOGGER.error("Dictionary not exits: " +dictionaryName +e);
			return false;
		}	
	}
}