public void getTestCase() throws Exception {
TestCase testCaseObj = tmsManager.getTestCase("15");
System.out.println(testCaseObj.getTestCaseId());
System.out.println(testCaseObj.getTestCaseDescription());
System.out.println(testCaseObj.getTestCasePhase());
Project projectObj = testCaseObj.getProjectObj();
System.out.println(projectObj.getProjectId());
User userObj = testCaseObj.getUserObj();
System.out.println(userObj.getUserId());
Activity activityObj = testCaseObj.getActivityObj();
System.out.println(activityObj.getActivityId());
System.out.println(testCaseObj.getExpectedBehaviour());
}
public void getTestCaseExecutionDetails() throws Exception {
// testCaseObj.setTestCaseId("001");
TestCase testCaseObj = tmsManager.getTestCaseExecutionDetails("001");
Activity activityObj = testCaseObj.getActivityObj();
System.out.println(activityObj.getActivityId());
System.out.println(testCaseObj.getTestCaseId());
User userObj = testCaseObj.getUserObj();
System.out.println(userObj.getUserId());
System.out.println(testCaseObj.getActualDate());
System.out.println(testCaseObj.getTestCaseStatus());
System.out.println(testCaseObj.getComments());
System.out.println(testCaseObj.getActualBehaviour());
}
public void getTestActivityEffort(String activityId) throws Exception {
Effort effortObj = tmsManager.getTestActivityEffort(activityId);
Activity activityObj = effortObj.getActivityObj();
System.out.println(activityObj.getActivityId());
User userObj = effortObj.getUserObj();
System.out.println(userObj.getEmpNo());
System.out.println(effortObj.getEffortDate());
System.out.println(effortObj.getStartDate());
System.out.println(effortObj.getEndDate());
System.out.println(effortObj.getEffort());
System.out.println(effortObj.getEffortDescription());
System.out.println(effortObj.getEffortTimeStamp());
}
public void updateTestActivityEffort() throws Exception {
activityObj.setActivityId("001");
effortObj.setActivityObj(activityObj);
effortObj.setEffortDescription("Well");
System.out.println(tmsManager.updateTestActivityEffort(effortObj));
}
/*-----------------------------------------ViewAssignment------------------------------------------*/
public void getActivityAssignment() throws Exception {
activityObj.setActivityId("1001");
activityUserObj.setActivityObj(activityObj);
activityObj = activityUserObj.getActivityObj();
ActivityUser activityUserObj1 =
tmsManager.getTestActivityAssignment(activityObj.getActivityId());
activityObj = activityUserObj1.getActivityObj();
System.out.println(activityObj.getActivityId());
activityObj = activityUserObj1.getActivityObj();
System.out.println("activity_id : " + activityObj.getActivityId());
userObj = activityUserObj1.getUserObj();
System.out.println("emp_no : " + userObj.getEmpNo());
System.out.println("activity_effort : " + activityUserObj1.getActivityEffort());
System.out.println("start_date : " + activityUserObj1.getStartDate());
System.out.println("end_date : " + activityUserObj1.getEndDate());
System.out.println("status : " + activityUserObj1.getStatus());
System.out.println("percentage_completed : " + activityUserObj1.getPercentageCompleted());
System.out.println("time_stamp : " + activityUserObj1.getTimeStamp());
}
public void createTestCase() throws Exception {
testCaseObj.setTestCaseId("15");
testCaseObj.setTestCaseDescription("this s Next testcase Description");
testCaseObj.setTestCasePhase("normal ");
Project projectObj = new Project();
projectObj.setProjectId("2");
testCaseObj.setProjectObj(projectObj);
User userObj = new User();
userObj.setUserId("123");
testCaseObj.setUserObj(userObj);
Activity activityObj = new Activity();
activityObj.setActivityId("001");
testCaseObj.setActivityObj(activityObj);
testCaseObj.setExpectedBehaviour("Bad");
System.out.println(tmsManager.createTestCase(testCaseObj));
}
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));
}
public void addTestCaseExecutionDetails() throws Exception {
activityObj.setActivityId("001");
testCaseObj.setActivityObj(activityObj);
testCaseObj.setTestCaseId("001");
userObj.setUserId("12");
testCaseObj.setUserObj(userObj);
testCaseObj.setActualDate(new Date(1970, 01, 01));
testCaseObj.setTestCaseStatus("complete");
testCaseObj.setComments("better");
testCaseObj.setActualBehaviour("got value");
System.out.println(tmsManager.addTestCaseExecutionDetails(testCaseObj));
}
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));
}
/*---------------------------------------------------VieTestPhase----------------------------*/
public void getTestActivity() throws Exception {
activityObj.setActivityId("1001");
Activity activityObj1 = tmsManager.getTestActivity(activityObj.getActivityId());
System.out.println("activity_id: " + activityObj1.getActivityId());
TestPhase testphaseObj1 = activityObj1.getTestPhaseObj();
System.out.println("phase_id: " + testphaseObj1.getPhaseId());
System.out.println("activity_name: " + activityObj1.getActivityName());
System.out.println("activity_description: " + activityObj1.getActivityDescription());
System.out.println("activity_type: " + activityObj1.getActivityType());
System.out.println("start_date: " + activityObj1.getStartDate());
System.out.println("end_date: " + activityObj1.getEndDate());
System.out.println("activity_effort: " + activityObj1.getActivityEffort());
System.out.println("status: " + activityObj1.getStatus());
userObj = activityObj.getUserObj();
System.out.println("emp_no: " + userObj.getEmpNo());
System.out.println("time_stamp: " + activityObj1.getTimeStamp());
}
/* ----------------------------------------------Create Test activity-------------------------------------*/
public void createTestActivity() throws Exception {
activityObj.setActivityId("1001");
testPhaseObj.setPhaseId("102");
activityObj.setTestPhaseObj(testPhaseObj);
activityObj.setActivityName("second activity test");
activityObj.setActivityDescription("activity execution ");
activityObj.setActivityType(0);
Date startDate = new Date(2010, 05, 07);
activityObj.setStartDate(startDate);
Date endDate = new Date(2010, 06, 10);
activityObj.setEndDate(endDate);
activityObj.setActivityEffort(20);
activityObj.setStatus(1);
userObj.setEmpNo("001");
activityObj.setUserObj(userObj);
java.sql.Date date = java.sql.Date.valueOf("2011-03-28");
activityObj.setTimeStamp(date);
System.out.println(tmsManager.createTestActivity(activityObj));
}
/*---------------------------------DeleteTestActivity-----------------------------------------*/
public void deleteTestActivity() throws Exception {
activityObj.setActivityId("1001");
System.out.println(tmsManager.deleteTestActivity(activityObj.getActivityId()));
}