public void updateTestActivityEffort() throws Exception {

    activityObj.setActivityId("001");
    effortObj.setActivityObj(activityObj);

    effortObj.setEffortDescription("Well");
    System.out.println(tmsManager.updateTestActivityEffort(effortObj));
  }
 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));
  }
  /*---------------------------------------------------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());
  }
 /*-----------------------------------------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());
 }
 /*-------------------------------------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));
  }
 /*---------------------------------DeleteTestActivity-----------------------------------------*/
 public void deleteTestActivity() throws Exception {
   activityObj.setActivityId("1001");
   System.out.println(tmsManager.deleteTestActivity(activityObj.getActivityId()));
 }