Index: trunk/WEB-INF/src/com/showcase/sql/DealerAttendeesDAOImpl.java
===================================================================
diff -u -r225 -r230
--- trunk/WEB-INF/src/com/showcase/sql/DealerAttendeesDAOImpl.java	(.../DealerAttendeesDAOImpl.java)	(revision 225)
+++ trunk/WEB-INF/src/com/showcase/sql/DealerAttendeesDAOImpl.java	(.../DealerAttendeesDAOImpl.java)	(revision 230)
@@ -719,9 +719,43 @@
 				try { con.close(); } catch(SQLException sq) { }
 			}
 		}
+		addPlatFormRegistrationPermissionToDealerOnPNW(dealer_id);
 	}
+
+	private void addPlatFormRegistrationPermissionToDealerOnPNW(String dealer_id) throws DAOException {
+		PreparedStatement pstmt = null;
+		Connection con = null;
+		try {
+			con = getPNWDBConnection();
+			StringBuffer buff = new StringBuffer();
+			buff.append(" INSERT INTO partsnetweb.dbo.user_functions (function_id, dealer_id, user_id)");
+			buff.append(" SELECT 'platformRegistration', pu.dealer_id, pu.user_id");
+			buff.append(" FROM partsnetweb.dbo.pnet_user pu");
+			buff.append(" LEFT JOIN partsnetweb.dbo.user_functions uf");
+			buff.append(" ON pu.dealer_id = uf.dealer_id ");
+			buff.append("    AND pu.user_id = uf.user_id");
+			buff.append("    AND uf.function_id = 'platformRegistration'");
+			buff.append(" WHERE pu.dealer_id IN ('");
+			buff.append(dealer_id);
+			buff.append("') ");
+			buff.append(" AND uf.function_id IS NULL");
+
+			pstmt = con.prepareStatement(buff.toString());
+			@SuppressWarnings("unused")
+			int i = pstmt.executeUpdate();
+
+
+		} catch (SQLException sqlE) {
+			log.error("SQLException while giving platformRegistartion permission to all the dealer attended", sqlE);
+			throw new DAOException("SQLException while giving platformRegistartion permission to all the dealer attended" + sqlE.getMessage());
+		} finally {
+			try {
+				con.close();
+			} catch (SQLException sq) {
+			}
+		}
+	}
 	 
-	 
 	 protected DealerAttendee extractDealerAttendeesFromResultSetRoles(ResultSet rs) throws SQLException
 		{
 		 	DealerAttendee report = new DealerAttendee();
Index: trunk/WEB-INF/src/com/showcase/util/BaseDAO.java
===================================================================
diff -u -r223 -r230
--- trunk/WEB-INF/src/com/showcase/util/BaseDAO.java	(.../BaseDAO.java)	(revision 223)
+++ trunk/WEB-INF/src/com/showcase/util/BaseDAO.java	(.../BaseDAO.java)	(revision 230)
@@ -15,6 +15,14 @@
 	 * @throws SQLException
 	 */
 	public Connection getDBConnection() throws SQLException {
+		return getDataBaseConnectionByJNDI("jdbc/showcase");
+	}
+
+	public Connection getPNWDBConnection() throws SQLException {
+		return getDataBaseConnectionByJNDI("jdbc/pnw");
+	}
+
+	public Connection getDataBaseConnectionByJNDI(String jdbcJndi) throws SQLException {
 		Context ctx = null;
 		Connection conn = null;
 
@@ -26,7 +34,7 @@
 
 			Context envCtx = (Context) ctx.lookup("java:comp/env");
 			//Look up our data source
-			DataSource ds = (DataSource) envCtx.lookup("jdbc/showcase");
+			DataSource ds = (DataSource) envCtx.lookup(jdbcJndi);
 
 			if (ds != null) {
 				conn = ds.getConnection();