public void testGetSimpleProject() throws DAOException {

    projectService.create(project);
    Project projectTest = projectService.getSimpleProject(project.getId());
    projectService.delete(project);

    assertNotNull(projectTest);
  }
  @Test
  public void testUpdate() throws DAOException {

    createProjectWithMembers();
    Project oldProject = projectService.getById(project.getId());
    Project newProject = projectService.getById(project.getId());
    newProject.setProjectName("UPDAREPROJECT");
    projectService.update(oldProject, newProject);
    Project superNewProject = projectService.getById(newProject.getId());
    deleteProjectWithMembers();

    assertEquals(superNewProject.getProjectName(), "UPDAREPROJECT");
  }
  private void deleteProjectWithMembers() throws DAOException {

    projectService.delete(project);

    for (Member member : members) {
      memberService.delete(member);
    }
  }
  @Test
  public void testGetAllFromSearch() throws DAOException {

    String query = "SELECT * FROM Project WHERE status = 'OPEN'";
    Collection<Project> projects = projectService.getAllFromSearch(query);

    assertNotNull(projects);
  }
  @Test
  public void testDelete() throws DAOException {

    createProjectWithMembers();
    deleteProjectWithMembers();
    Project testDeleteProject = projectService.getById(project.getId());

    assertEquals(testDeleteProject, null);
  }
  private void createProjectWithMembers() throws DAOException {

    for (Member member : members) {
      memberService.create(member);
    }
    project.setMembers(members);

    Long idProject = projectService.create(project);
    project.setId(idProject);
  }
  @Test
  public void testGetById() throws DAOException {

    createProjectWithMembers();
    Project testProject = projectService.getById(project.getId());
    deleteProjectWithMembers();

    assertNotNull(testProject);
    assertTrue((project.getMembers() != null) && (project.getMembers().size() > 0));
  }
  @Test
  public void testGetAll() throws DAOException {

    boolean memberExist = false;
    List<Project> projectsTest = projectService.getAll();

    assertNotNull(projectsTest);
    assertTrue(projectsTest.size() > 0);

    for (Project project : projectsTest) {
      if ((project.getMembers() != null) && (project.getMembers().size() > 0)) {
        memberExist = true;
        break;
      }
    }

    assertTrue(memberExist);
  }