public List<? extends ProjectMember> getActiveProjectMembers(long id) {
   return create()
       .selectFrom(PROJECT_MEMBER)
       .where(PROJECT_MEMBER.PROJECT_ID.eq(id))
       .and(PROJECT_MEMBER.STATE.eq(CommonStatesConstants.ACTIVE))
       .and(PROJECT_MEMBER.REMOVED.isNull())
       .orderBy(PROJECT_MEMBER.ID.asc())
       .fetch();
 }
 @Override
 public ProjectMember getProjectMember(long id) {
   return create().selectFrom(PROJECT_MEMBER).where(PROJECT_MEMBER.ID.eq(id)).fetchOne();
 }