D-Net

package eu.dnetlib.goldoa.service;

import eu.dnetlib.goldoa.domain.Organization;

import eu.dnetlib.goldoa.domain.Project;

import eu.dnetlib.goldoa.domain.Vocabulary;

import eu.dnetlib.goldoa.service.dao.OrganizationDAO;

import eu.dnetlib.goldoa.service.dao.PersonDAO;

import eu.dnetlib.goldoa.service.dao.ProjectDAO;

import org.springframework.dao.EmptyResultDataAccessException;

import org.springframework.jdbc.core.JdbcTemplate;

import org.springframework.jdbc.core.RowMapper;

import org.springframework.jdbc.datasource.DataSourceUtils;

import org.springframework.transaction.annotation.Transactional;

import javax.sql.DataSource;

import java.sql.Connection;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.sql.Types;

import java.util.ArrayList;

import java.util.List;

/**

 * Created by antleb on 3/3/15.

 */

@Transactional

public class ProjectManagerImpl implements ProjectManager {

	private ProjectDAO projectDAO;

	private PersonDAO personDAO;

	private OrganizationDAO organizationDAO;

	@Override

	public List<Vocabulary> search(String term) {

		return projectDAO.search(term);

	}

	@Override

	public Project getById(String projectId) {

		Project project = projectDAO.getProject(projectId);

		loadRelationships(project);

		return project;

	}

	private void loadRelationships(Project project) {

        try {

            project.setCoordinator(personDAO.getPerson(project.getCoordinator().getEmail()));

        } catch (EmptyResultDataAccessException e) {

            ;

        }

		List<Organization> orgs = new ArrayList<Organization>();

		for (Organization org:project.getOrganizations()) {

			orgs.add(organizationDAO.getOrganization(org.getId()));

		}

		project.setOrganizations(orgs);

	}

	public ProjectDAO getProjectDAO() {

		return projectDAO;

	}

	public void setProjectDAO(ProjectDAO projectDAO) {

		this.projectDAO = projectDAO;

	}

	public PersonDAO getPersonDAO() {

		return personDAO;

	}

	public void setPersonDAO(PersonDAO personDAO) {

		this.personDAO = personDAO;

	}

	public OrganizationDAO getOrganizationDAO() {

		return organizationDAO;

	}

	public void setOrganizationDAO(OrganizationDAO organizationDAO) {

		this.organizationDAO = organizationDAO;

	}

}