Index: lams_tool_nb/src/java/org/lamsfoundation/lams/tool/noticeboard/dao/INoticeboardUserDAO.java
===================================================================
RCS file: /usr/local/cvsroot/lams_tool_nb/src/java/org/lamsfoundation/lams/tool/noticeboard/dao/INoticeboardUserDAO.java,v
diff -u -r1.3 -r1.4
--- lams_tool_nb/src/java/org/lamsfoundation/lams/tool/noticeboard/dao/INoticeboardUserDAO.java	10 Aug 2005 06:50:30 -0000	1.3
+++ lams_tool_nb/src/java/org/lamsfoundation/lams/tool/noticeboard/dao/INoticeboardUserDAO.java	26 Aug 2005 02:41:15 -0000	1.4
@@ -56,6 +56,18 @@
     public NoticeboardUser getNbUserByID(Long userId);
     
     /**
+	 * <p> Return the persistent instance of a NoticeboardUser
+	 * who has the user id <code>userId</code> and tool session id
+	 * <code>sessionId</code>
+	 * returns null if not found.</p>
+	 * 
+	 * @param userId. The id of the learner
+	 * @param sessionId. The tool session id to which this user belongs to.
+	 * @return the persistent instance of a NoticeboardUser or null if not found.
+	 */
+    public NoticeboardUser getNbUserBySession(Long userId, Long sessionId);
+    
+    /**
 	 * <p>Persist the given persistent instance of NoticeboardUser.</p>
 	 * 
 	 * @param nbUser The instance of NoticeboardUser to persist.
Index: lams_tool_nb/src/java/org/lamsfoundation/lams/tool/noticeboard/dao/hibernate/NoticeboardUserDAO.java
===================================================================
RCS file: /usr/local/cvsroot/lams_tool_nb/src/java/org/lamsfoundation/lams/tool/noticeboard/dao/hibernate/NoticeboardUserDAO.java,v
diff -u -r1.3 -r1.4
--- lams_tool_nb/src/java/org/lamsfoundation/lams/tool/noticeboard/dao/hibernate/NoticeboardUserDAO.java	10 Aug 2005 06:50:39 -0000	1.3
+++ lams_tool_nb/src/java/org/lamsfoundation/lams/tool/noticeboard/dao/hibernate/NoticeboardUserDAO.java	26 Aug 2005 02:41:33 -0000	1.4
@@ -38,8 +38,9 @@
 public class NoticeboardUserDAO extends HibernateDaoSupport implements INoticeboardUserDAO {
     
     private static final String COUNT_USERS_IN_SESSION = "select nu.userId from NoticeboardUser nu where nu.nbSession= :nbSession";
-  
+   
     
+    
     /** @see org.lamsfoundation.lams.tool.noticeboard.dao.INoticeboardUserDAO#getNbUserByUID(java.lang.Long) */
 	public NoticeboardUser getNbUserByUID(Long uid)
 	{
@@ -62,7 +63,27 @@
 			return (NoticeboardUser)users.get(0);
 		}
 	}
+	
+	/** @see org.lamsfoundation.lams.tool.noticeboard.dao.INoticeboardUserDAO#getNbUserBySession(java.lang.Long, java.lang.Long)*/
+	public NoticeboardUser getNbUserBySession(Long userId, Long sessionId)
+	{
+		String query = "select nu from NoticeboardUser nu where nu.userId=? and nu.nbSession.nbSessionId=?";
+		Long[] bindingValues = new Long[2];
+		bindingValues[0] = userId;
+		bindingValues[1] = sessionId;
+		List usersReturned = getHibernateTemplate().find(query, bindingValues); //although only one or no users should be returned
+		
+		if (usersReturned!= null && usersReturned.size() == 0)
+		{
+			return null;
+		}
+		else
+		{
+			return (NoticeboardUser)usersReturned.get(0);
+		}
 
+	}
+
 	/** @see org.lamsfoundation.lams.tool.noticeboard.dao.INoticeboardUserDAO#saveNbUser(org.lamsfoundation.lams.tool.noticeboard.NoticeboardUser) */
 	public void saveNbUser(NoticeboardUser nbUser)
     {