EditorAccessDAO.java

package edu.asu.spring.quadriga.dao.editor.impl;

import org.apache.commons.lang.NotImplementedException;
import org.hibernate.Query;
import org.hibernate.SessionFactory;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Repository;

import edu.asu.spring.quadriga.dao.editor.IEditorAccessDAO;
import edu.asu.spring.quadriga.dao.impl.BaseDAO;
import edu.asu.spring.quadriga.exceptions.QuadrigaStorageException;

@Repository
public class EditorAccessDAO extends BaseDAO implements IEditorAccessDAO
{
   
	@Autowired
	private SessionFactory sessionFactory;

	/**
	 * This method checks if the logged in user has an editor role
	 * @param : userName - logged in user
	 * @throws : QuadrigaStorageException
	 * @return : has editor role - true
	 *           no editor role - false
	 */
	@Override
	public boolean chkIsEditor(String userName) throws QuadrigaStorageException 
	{
		boolean isEditor;
		int count;
		Query query = null;
		isEditor = false;
		
		//check if he is a project editor
		query = sessionFactory.getCurrentSession().createQuery("SELECT COUNT(p.projectEditorDTOPK.projectid) FROM ProjectEditorDTO p WHERE p.projectEditorDTOPK.editor =:userName");
		query.setParameter("userName", userName);
		count = ((Number)query.iterate().next()).intValue();
		if(count > 0)
		{
			isEditor = true;
		}
		
		//check if he is workspace editor
		if(!isEditor)
		{
			query = sessionFactory.getCurrentSession().createQuery("SELECT COUNT(ws.workspaceEditorDTOPK.workspaceid) FROM WorkspaceEditorDTO ws WHERE ws.workspaceEditorDTOPK.editor =:userName");
			query.setParameter("userName", userName);
			count = ((Number)query.iterate().next()).intValue();
			if(count > 0)
			{
				isEditor = true;
			}
		}
		
		
		return isEditor;
	}

	/**
	 * This method checks if the logged in user has an editor role for
	 * the given network
	 * @param : networkId - network id
	 * @param : userName - logged in user
	 * @throws : QuadrigaStorageException
	 * @return : has network editor role - true
	 *           no network editor role - false
	 */
	@Override
	public boolean chkIsNetworkEditor(String networkId, String userName)
			throws QuadrigaStorageException 
	{
		boolean isEditor;
		Query query = null;
		int count;
		
		isEditor = false;
		
		//check if he is workspace editor for given network
		query = sessionFactory.getCurrentSession().createQuery("SELECT COUNT(n.networkid) FROM NetworksDTO n WHERE n.networkid =:networkId" +
				" AND n.workspaceid IN (SELECT ws.workspaceid FROM WorkspaceEditorDTO ws WHERE ws.editor =:username)");
		query.setParameter("networkid", networkId);
		query.setParameter("username", userName);
		count = ((Number)query.iterate().next()).intValue();
		if(count > 0)
		{
			isEditor = true;
		}
		
		//check if the user is project editor for given network
		if(!isEditor)
		{
			query = sessionFactory.getCurrentSession().createQuery("SELECT COUNT(n.networkid) FROM NetworksDTO n WHERE n.networkid" +
					" AND n.workspaceid IN (SELECT pws.workspaceid FROM ProjectWorkspaceDTO pws WHERE pws.projectWorkspaceDTOPK.projectid IN " +
					" (SELECT p.projectid FROM ProjectEditorDTO p WHERE p.projectEditorDTOPK.editor =:username))");
			query.setParameter("networkid", networkId);
            query.setParameter("username", userName);
            count = ((Number)query.iterate().next()).intValue();
    		if(count > 0)
    		{
    			isEditor = true;
    		}
		}
		
		return isEditor;
	}

    @Override
    public Object getDTO(String id) {
        throw new NotImplementedException();
    }
}