/*-
 * ============LICENSE_START=======================================================
 * ONAP-PAP-REST
 * ================================================================================
 * Copyright (C) 2017 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 org.apache.commons.compress.utils.IOUtils;
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.BRMSParamTemplate;
import org.onap.policy.rest.jpa.Category;
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.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 com.fasterxml.jackson.databind.DeserializationFeature;
import com.fasterxml.jackson.databind.ObjectMapper;

import au.com.bytecode.opencsv.CSVReader;


@Controller
public class DictionaryImportController {
	private String newFile;

	private static CommonClassDao commonClassDao;
	
	@Autowired
	public DictionaryImportController(CommonClassDao commonClassDao){
		DictionaryImportController.commonClassDao = commonClassDao;
	}
	
	public DictionaryImportController(){}	


	@RequestMapping(value={"/dictionary/import_dictionary"}, method={org.springframework.web.bind.annotation.RequestMethod.POST})
	public void ImportDictionaryData(HttpServletRequest request) throws IOException{
		ObjectMapper mapper = new ObjectMapper();
		mapper.configure(DeserializationFeature.FAIL_ON_UNKNOWN_PROPERTIES, false);
		String userId = request.getParameter("userId");
		String dictionaryName = request.getParameter("dictionaryName");

		File file = new File(dictionaryName);
		OutputStream outputStream = new FileOutputStream(file);
		IOUtils.copy(request.getInputStream(), outputStream);
		outputStream.close();
		this.newFile = file.toString();
		CSVReader csvReader = new CSVReader(new FileReader(this.newFile));
		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("",  userId);
				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.setMethod(rows[j]);
					}
					if(("url").equalsIgnoreCase(dictSheet.get(0)[j])){
						attribute.setMethod(rows[j]);
					}
				}
				commonClassDao.save(attribute);
			}
		}
		if(dictionaryName.startsWith("OnapName")){
			for(int i = 1; i< dictSheet.size(); i++){
				OnapName attribute = new OnapName("",  userId);
				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("VNFType")){
			for(int i = 1; i< dictSheet.size(); i++){
				VNFType attribute = new VNFType("",  userId);
				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("",  userId);
				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("PEPOptions")){
			for(int i = 1; i< dictSheet.size(); i++){
				PEPOptions attribute = new PEPOptions("",  userId);
				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("",  userId);
				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]) || ("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("Settings")){
			for(int i = 1; i< dictSheet.size(); i++){
				DecisionSettings attribute = new DecisionSettings("",  userId);
				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("",  userId);
				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("",  userId);
				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("",  userId);
				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("",  userId);
				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("",  userId);
				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("",  userId);
				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("",  userId);
				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("",  userId);
				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("",  userId);
				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("",  userId);
				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 ScopeName").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();
		if(file.exists()){
			file.delete();
		}
	}
}