public void updateTestActivityEffort() throws Exception {
activityObj.setActivityId("001");
effortObj.setActivityObj(activityObj);
effortObj.setEffortDescription("Well");
System.out.println(tmsManager.updateTestActivityEffort(effortObj));
}
/*--------------------------------------------UpdateTestPhase---------------------------------------*/
public void updateTestPhase() throws Exception {
testPhaseObj.setPhaseId("101");
testPhaseObj.setPhaseName("functional testing");
projectObj.setProjectId("002");
testPhaseObj.setProjectObj(projectObj);
testPhaseObj.setDescription("test phase function test under process");
testPhaseObj.setIsAlive(1);
testPhaseObj.setTimeStamp("null");
System.out.println(tmsManager.updateTestPhase(testPhaseObj));
}
/* ---------------------------------------------- CreateTest phase -------------------------------------*/
public void createTestPhase() throws Exception {
testPhaseObj.setPhaseId("101");
testPhaseObj.setPhaseName("System test");
projectObj.setProjectId("003");
testPhaseObj.setProjectObj(projectObj);
testPhaseObj.setDescription(" this is phase System test");
testPhaseObj.setIsAlive(0);
testPhaseObj.setTimeStamp("null");
System.out.println(tmsManager.createTestPhase(testPhaseObj));
}
/*--------------------------------------------ViewTestPhase-----------------------------------------*/
public void getTestPhase() throws Exception {
testPhaseObj.setPhaseId("101");
TestPhase phaseObj = tmsManager.getTestPhase(testPhaseObj.getPhaseId());
System.out.println("phase_id: " + phaseObj.getPhaseId());
System.out.println("phase_name: " + phaseObj.getPhaseName());
projectObj = phaseObj.getProjectObj();
System.out.println("project_id: " + projectObj.getProjectId());
System.out.println("description: " + phaseObj.getDescription());
System.out.println("is_alive: " + phaseObj.getIsAlive());
System.out.println("time_stamp: " + phaseObj.getTimeStamp());
}
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 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 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 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 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));
}
/*-----------------------------------------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());
}
/*---------------------------------------------------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());
}
/*-------------------------------------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 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 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));
}
public void deleteTestPhase() throws Exception {
testPhaseObj.setPhaseId("101");
System.out.println(tmsManager.deleteTestPhase(testPhaseObj.getPhaseId()));
}
public void updateTestCase() throws Exception {
testCaseObj.setExpectedBehaviour("Excellent");
testCaseObj.setTestCaseId("15");
System.out.println(tmsManager.updateTestCase(testCaseObj));
}
/*---------------------------------DeleteTestActivity-----------------------------------------*/
public void deleteTestActivity() throws Exception {
activityObj.setActivityId("1001");
System.out.println(tmsManager.deleteTestActivity(activityObj.getActivityId()));
}
public void updateTestCaseExecutionDetails() throws Exception {
testCaseObj.setTestCaseStatus("Complete");
testCaseObj.setTestCaseId("001");
System.out.println(tmsManager.updateTestCaseExecutionDetails(testCaseObj));
}