Index: lams_tool_sbmt/src/java/org/lamsfoundation/lams/tool/sbmt/dao/ISubmitFilesSessionDAO.java
===================================================================
RCS file: /usr/local/cvsroot/lams_tool_sbmt/src/java/org/lamsfoundation/lams/tool/sbmt/dao/ISubmitFilesSessionDAO.java,v
diff -u -r1.2 -r1.3
--- lams_tool_sbmt/src/java/org/lamsfoundation/lams/tool/sbmt/dao/ISubmitFilesSessionDAO.java	13 Jul 2005 06:27:57 -0000	1.2
+++ lams_tool_sbmt/src/java/org/lamsfoundation/lams/tool/sbmt/dao/ISubmitFilesSessionDAO.java	17 Nov 2005 06:32:20 -0000	1.3
@@ -6,6 +6,8 @@
  */
 package org.lamsfoundation.lams.tool.sbmt.dao;
 
+import java.util.List;
+
 import org.lamsfoundation.lams.learningdesign.dao.IBaseDAO;
 import org.lamsfoundation.lams.tool.sbmt.SubmitFilesSession;
 
@@ -28,5 +30,5 @@
 	 */
 	public void createSession(SubmitFilesSession submitSession);
 	
-
+    public List getSubmitFilesSessionByContentID(Long contentID);
 }
Index: lams_tool_sbmt/src/java/org/lamsfoundation/lams/tool/sbmt/dao/hibernate/SubmitFilesSessionDAO.java
===================================================================
RCS file: /usr/local/cvsroot/lams_tool_sbmt/src/java/org/lamsfoundation/lams/tool/sbmt/dao/hibernate/SubmitFilesSessionDAO.java,v
diff -u -r1.2 -r1.3
--- lams_tool_sbmt/src/java/org/lamsfoundation/lams/tool/sbmt/dao/hibernate/SubmitFilesSessionDAO.java	13 Jul 2005 06:27:58 -0000	1.2
+++ lams_tool_sbmt/src/java/org/lamsfoundation/lams/tool/sbmt/dao/hibernate/SubmitFilesSessionDAO.java	17 Nov 2005 06:32:20 -0000	1.3
@@ -6,6 +6,8 @@
  */
 package org.lamsfoundation.lams.tool.sbmt.dao.hibernate;
 
+import java.util.List;
+
 import org.lamsfoundation.lams.learningdesign.dao.hibernate.BaseDAO;
 import org.lamsfoundation.lams.tool.sbmt.SubmitFilesSession;
 import org.lamsfoundation.lams.tool.sbmt.dao.ISubmitFilesSessionDAO;
@@ -16,6 +18,11 @@
 public class SubmitFilesSessionDAO extends BaseDAO implements
 		ISubmitFilesSessionDAO {
 
+    private static final String FIND_LEARNER_BY_CONTENT_ID = 
+        " from SubmitFilesSession session " +
+        " where session.content.contentID = :contentID";
+
+    
 	/**
 	 * (non-Javadoc)
 	 * @see org.lamsfoundation.lams.tool.sbmt.dao.ISubmitFilesSessionDAO#getSessionByID(java.lang.Long)
@@ -30,5 +37,14 @@
 	public void createSession(SubmitFilesSession submitSession) {
 		 this.getHibernateTemplate().save(submitSession);
 	}
+    
+    public List getSubmitFilesSessionByContentID(Long contentID){
+        if ( contentID != null ) {
+            return this.getSession().createQuery(FIND_LEARNER_BY_CONTENT_ID)
+                .setLong("contentID", contentID.longValue())
+                .list();
+        }
+        return null;
+    }
 
 }
Index: lams_tool_sbmt/src/java/org/lamsfoundation/lams/tool/sbmt/service/ISubmitFilesService.java
===================================================================
RCS file: /usr/local/cvsroot/lams_tool_sbmt/src/java/org/lamsfoundation/lams/tool/sbmt/service/ISubmitFilesService.java,v
diff -u -r1.18 -r1.19
--- lams_tool_sbmt/src/java/org/lamsfoundation/lams/tool/sbmt/service/ISubmitFilesService.java	7 Nov 2005 00:22:53 -0000	1.18
+++ lams_tool_sbmt/src/java/org/lamsfoundation/lams/tool/sbmt/service/ISubmitFilesService.java	17 Nov 2005 06:32:20 -0000	1.19
@@ -193,4 +193,12 @@
      * @return the default content id
      */
     public Long getToolDefaultContentIdBySignature(String toolSignature);
+    
+    /**
+     * This method retrieves a list of SubmitFileSession from the contentID.
+     * @param contentID
+     * @return a list of SubmitFileSession
+     */
+    //public List getSubmitFilesSessionsByContentID(Long contentID);
+    public List getSubmitFilesSessionByContentID(Long contentID);
 }
Index: lams_tool_sbmt/src/java/org/lamsfoundation/lams/tool/sbmt/service/SubmitFilesService.java
===================================================================
RCS file: /usr/local/cvsroot/lams_tool_sbmt/src/java/org/lamsfoundation/lams/tool/sbmt/service/SubmitFilesService.java,v
diff -u -r1.26 -r1.27
--- lams_tool_sbmt/src/java/org/lamsfoundation/lams/tool/sbmt/service/SubmitFilesService.java	7 Nov 2005 00:22:53 -0000	1.26
+++ lams_tool_sbmt/src/java/org/lamsfoundation/lams/tool/sbmt/service/SubmitFilesService.java	17 Nov 2005 06:32:20 -0000	1.27
@@ -825,4 +825,11 @@
     	
 		return content;
 	}
+
+    public List getSubmitFilesSessionByContentID(Long contentID) {
+        List learners = submitFilesSessionDAO.getSubmitFilesSessionByContentID(contentID);
+        if(learners == null)
+            learners = new ArrayList(); //return sized 0 list rather than null value
+        return learners;
+    }
 }
\ No newline at end of file