Index: lams_tool_lamc/src/java/org/lamsfoundation/lams/tool/mc/dao/IMcUsrAttemptDAO.java =================================================================== diff -u -rf3a234b1e836f365e9489c5cc0f0ab62ddc6776b -ra2ef8341e962faf704283059bd59b6f7038a5bbf --- lams_tool_lamc/src/java/org/lamsfoundation/lams/tool/mc/dao/IMcUsrAttemptDAO.java (.../IMcUsrAttemptDAO.java) (revision f3a234b1e836f365e9489c5cc0f0ab62ddc6776b) +++ lams_tool_lamc/src/java/org/lamsfoundation/lams/tool/mc/dao/IMcUsrAttemptDAO.java (.../IMcUsrAttemptDAO.java) (revision a2ef8341e962faf704283059bd59b6f7038a5bbf) @@ -33,12 +33,18 @@ public McUsrAttempt getMcUserAttemptByUID(Long uid); public McUsrAttempt findMcUsrAttemptById(Long attemptId); - - public McUsrAttempt getMcUsrAttemptById(long attemptId); - - public void createUsrAttempt(McUsrAttempt mcUsrAttempt); + + public void saveMcUsrAttempt(McUsrAttempt mcUsrAttempt); - public void removeUsrAttempt(long attemptId); + public void updateMcUsrAttempt(McUsrAttempt mcUsrAttempt); + + public void removeMcUsrAttemptByUID(Long uid); + + public void removeMcUsrAttempt(Long attemptId); + + public void removeMcUsrAttemptById(Long attemptId); + + public void removeMcUsrAttempt(McUsrAttempt mcUsrAttempt); } Index: lams_tool_lamc/src/java/org/lamsfoundation/lams/tool/mc/dao/hibernate/McUsrAttemptDAO.java =================================================================== diff -u -rf3a234b1e836f365e9489c5cc0f0ab62ddc6776b -ra2ef8341e962faf704283059bd59b6f7038a5bbf --- lams_tool_lamc/src/java/org/lamsfoundation/lams/tool/mc/dao/hibernate/McUsrAttemptDAO.java (.../McUsrAttemptDAO.java) (revision f3a234b1e836f365e9489c5cc0f0ab62ddc6776b) +++ lams_tool_lamc/src/java/org/lamsfoundation/lams/tool/mc/dao/hibernate/McUsrAttemptDAO.java (.../McUsrAttemptDAO.java) (revision a2ef8341e962faf704283059bd59b6f7038a5bbf) @@ -8,6 +8,8 @@ import java.util.List; +import net.sf.hibernate.Hibernate; + import org.apache.log4j.Logger; import org.lamsfoundation.lams.tool.mc.McUsrAttempt; import org.lamsfoundation.lams.tool.mc.dao.IMcUsrAttemptDAO; @@ -48,20 +50,45 @@ } - - public McUsrAttempt getMcUsrAttemptById(long attemptId) - { - return (McUsrAttempt) this.getHibernateTemplate().load(McUsrAttempt.class, new Long(attemptId)); - } - - public void createUsrAttempt(McUsrAttempt mcUsrAttempt) + + public void saveMcUsrAttempt(McUsrAttempt mcUsrAttempt) { this.getHibernateTemplate().save(mcUsrAttempt); } + + public void updateMcUsrAttempt(McUsrAttempt mcUsrAttempt) + { + this.getHibernateTemplate().update(mcUsrAttempt); + } - public void removeUsrAttempt(long attemptId) + public void removeMcUsrAttemptByUID(Long uid) { - McUsrAttempt mcUsrAttempt= (McUsrAttempt) this.getHibernateTemplate().load(McUsrAttempt.class, new Long(attemptId)); - this.getHibernateTemplate().delete(mcUsrAttempt); + McUsrAttempt mca = (McUsrAttempt)getHibernateTemplate().get(McUsrAttempt.class, uid); + this.getHibernateTemplate().delete(mca); } + + + public void removeMcUsrAttempt(Long attemptId) + { + String query = "from McUsrAttempt as mca where mca.attemptId="; + StringBuffer sb = new StringBuffer(query); + sb.append(attemptId.longValue()); + String queryString = sb.toString(); + + this.getHibernateTemplate().delete(queryString); + } + + + public void removeMcUsrAttemptById(Long attemptId) + { + String query = "from mca in class org.lamsfoundation.lams.tool.mc.McUsrAttempt" + + " where mca.attemptId = ?"; + this.getHibernateTemplate().delete(query,attemptId,Hibernate.LONG); + } + + public void removeMcUsrAttempt(McUsrAttempt mcUsrAttempt) + { + this.getHibernateTemplate().delete(mcUsrAttempt); + } + } \ No newline at end of file