package com.nsi.components.util;

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

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

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

/**
 * @author Chris Ye, created on Oct 9, 2008
 *
 * UserRoleUtil
 */
public final class UserRoleUtil
{
	private static Log log = LogFactory.getLog(UserRoleUtil.class);
	/**
	 * private constructor of UserRoleUtil, prevent instantiation
	 */
	private UserRoleUtil()
	{
	}
	private static class UserRoleUtilHolder
	{
		static final UserRoleUtil userRoleUtil = new UserRoleUtil();
	}
	/**
	 * @return an instance of UserRoleUtil
	 */
	public static UserRoleUtil getInstance()
	{
		return UserRoleUtilHolder.userRoleUtil;
	}
	public Map<String,String> getRolemap() throws NsiEventException
	{
		Map<String, String> rolemap = new HashMap<String,String>();
		List<Map<String, String>> result = new ArrayList<Map<String, String>>();
		String sSql ="select userroleid, userrole from ct_user_role"; 
		IsqlDataSource src = DataSrcUtil.getInstance().getDataSource();
		Connection conn = null;
		try
		{
			conn = src.getConnection();
			result = src.executeRetrieve(conn, sSql);
		}
		catch(SQLException se)
		{
			log.error("getHRRecord() caught SQLException: " + se);
		}
		catch(Exception ex)
		{
			log.error("getHRRecord() caught Exception: " + ex);
		}
		finally
		{
			src.closeConn(conn);
		}
		if( !result.isEmpty())
		{
			int size = result.size();
			for (int i = 0; i < size; i++)
			{
				Map<String, String> resultmap = result.get(i);
				rolemap.put(ValHelper.getInstance().getValue(resultmap, "userroleid") , ValHelper.getInstance().getValue(resultmap, "userrole"));
			}
		}
		return rolemap;
	}
}