package com.nsi.components.util;

import java.sql.Connection;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
import java.util.Map;

import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;

import com.nsi.components.employeetype.EmployeeTypeInfo;
import com.nsi.control.exceptions.NsiEventException;
import com.nsi.persistence.DataSrcUtil;
import com.nsi.persistence.IsqlDataSource;
import com.nsi.util.ValHelper;

public final class EmployeeTypeUtil
{
	private static Log log = LogFactory.getLog(EmployeeTypeUtil.class);
	/**
	 * private constructor of EmployeeTypeUtil, prevent instantiation
	 */
	private EmployeeTypeUtil()
	{
	}
	private static class EmployeeTypeUtilHolder
	{
		static final EmployeeTypeUtil employeeTypeUtil = new EmployeeTypeUtil();
	}
	/**
	 * @return an instance of EmployeeTypeUtil
	 */
	public static EmployeeTypeUtil getInstance()
	{
		return EmployeeTypeUtilHolder.employeeTypeUtil;
	}
	public List<EmployeeTypeInfo> getEmployeeTypeList() throws NsiEventException
	{
		List<EmployeeTypeInfo> employeeTypeList = new ArrayList<EmployeeTypeInfo>();
		String sSql = "select empltypeid, empltype from ct_empl_type order by empltype";
		IsqlDataSource src = DataSrcUtil.getInstance().getDataSource();
		Connection conn = null;
		try
		{
			conn = src.getConnection();
			List<Map<String,String>> result = src.executeRetrieve(conn, sSql);
			src.closeConn(conn);
			int size = result.size();
			for( int i=0;i<size;i++)
			{
				Map<String,String> resultMap = result.get(i);
				EmployeeTypeInfo employeeTypeInfo = new EmployeeTypeInfo();
				employeeTypeInfo.setEmpltypeid(ValHelper.getInstance().getValue(resultMap, "empltypeid"));
				employeeTypeInfo.setEmpltypedescription(ValHelper.getInstance().getValue(resultMap, "empltype"));
				employeeTypeList.add(employeeTypeInfo);
			}
		}
		catch( SQLException se )
		{
			log.error( "getEmployeeTypeList() caught SQLException: " + se );
			src.closeConn(conn);
			throw new NsiEventException( "getEmployeeTypeList() caught SQLException: ", se );
		}
		catch( Exception ex )
		{
			log.error( "getEmployeeTypeList() caught Exception: " + ex );
			src.closeConn(conn);
			throw new NsiEventException( "getEmployeeTypeList() caught Exception: ", ex );
		}
		return employeeTypeList;
	}
	public String getEmployeeTypeDesc( String emplTypeID ) throws NsiEventException
	{
		String employeeTypeDesc="";
		String sSql = "select empltype from ct_empl_type where empltypeid='" + emplTypeID + "'";
		IsqlDataSource src = DataSrcUtil.getInstance().getDataSource();
		Connection conn = null;
		try
		{
			conn = src.getConnection();
			Map<String,String> result = src.retrieveSingleRow(conn, sSql);
			src.closeConn(conn);
			employeeTypeDesc = result.get("empltype");
		}
		catch( SQLException se )
		{
			log.error( "getEmployeeTypeDesc() caught SQLException: " + se );
			src.closeConn(conn);
			throw new NsiEventException( "getEmployeeTypeDesc() caught SQLException: ", se );
		}
		catch( Exception ex )
		{
			log.error( "getEmployeeTypeDesc() caught Exception: " + ex );
			src.closeConn(conn);
			throw new NsiEventException( "getEmployeeTypeDesc() caught Exception: ", ex );
		}
		return employeeTypeDesc;
	}
}