public void updateActivityAssignment() throws Exception {
activityObj.setActivityId("1001");
activityUserObj.setActivityObj(activityObj);
userObj.setEmpNo("002");
activityUserObj.setUserObj(userObj);
activityUserObj.setActivityEffort(0);
Date startDate = new Date(2010, 05, 07);
activityUserObj.setStartDate(startDate);
Date endDate = new Date(2010, 05, 10);
activityUserObj.setEndDate(endDate);
activityUserObj.setStatus(0);
activityUserObj.setPercentageCompleted(0);
activityUserObj.setTimeStamp("null");
System.out.println(tmsManager.updateTestActivityAssignment(activityUserObj));
}
/*-------------------------------------UpdateTestActivity-----------------------------------------*/
public void updateTestActivity() throws Exception {
activityObj.setActivityId("1001");
testPhaseObj.setPhaseId("101");
activityObj.setTestPhaseObj(testPhaseObj);
activityObj.setActivityName("first activity test");
activityObj.setActivityDescription("I am the latest activity to execute ");
activityObj.setActivityType(1);
Date startDate = new Date(2010, 05, 07);
activityObj.setStartDate(startDate);
Date endDate = new Date(2010, 06, 11);
activityObj.setEndDate(endDate);
activityObj.setActivityEffort(30);
activityObj.setStatus(1);
userObj.setEmpNo("002");
activityObj.setUserObj(userObj);
java.sql.Date date1 = java.sql.Date.valueOf("2011-03-28");
activityObj.setTimeStamp(date1);
System.out.println(tmsManager.updateTestActivity(activityObj));
}
public void addTestActivityEffort() throws Exception {
activityObj.setActivityId("001");
effortObj.setActivityObj(activityObj);
userObj.setEmpNo("1");
effortObj.setUserObj(userObj);
effortObj.setEffortDate(new Date(2010, 10, 01));
effortObj.setStartDate(new Date(2010, 10, 02));
effortObj.setEndDate(new Date(2010, 11, 01));
effortObj.setEffort(4);
effortObj.setEffortDescription("I dont Know");
effortObj.setEffortTimeStamp("2010-11-17");
System.out.println(tmsManager.addTestActivityEffort(effortObj));
}