csns.model.academics.dao.jpa.AssignmentDaoImpl.java Source code

Introduction

Here is the source code for csns.model.academics.dao.jpa.AssignmentDaoImpl.java

Source

/*
 * This file is part of the CSNetwork Services (CSNS) project.
 * 
 * Copyright 2012, Chengyu Sun (csun@calstatela.edu).
 * 
 * CSNS is free software: you can redistribute it and/or modify it under the
 * terms of the GNU Affero General Public License as published by the Free
 * Software Foundation, either version 3 of the License, or (at your option)
 * any later version.
 * 
 * CSNS is distributed in the hope that it will be useful, but WITHOUT ANY
 * WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS
 * FOR A PARTICULAR PURPOSE. See the GNU Affero General Public License for
 * more details.
 * 
 * You should have received a copy of the GNU Affero General Public License
 * along with CSNS. If not, see http://www.gnu.org/licenses/agpl.html.
 */
package csns.model.academics.dao.jpa;

import java.util.List;

import javax.persistence.EntityManager;
import javax.persistence.PersistenceContext;
import javax.persistence.TypedQuery;

import org.springframework.security.access.prepost.PostAuthorize;
import org.springframework.security.access.prepost.PreAuthorize;
import org.springframework.stereotype.Repository;
import org.springframework.transaction.annotation.Transactional;

import csns.model.academics.Assignment;
import csns.model.academics.OnlineAssignment;
import csns.model.academics.Section;
import csns.model.academics.dao.AssignmentDao;
import csns.model.core.User;

@Repository
public class AssignmentDaoImpl implements AssignmentDao {

    @PersistenceContext
    private EntityManager entityManager;

    @Override
    @PostAuthorize("returnObject.section.isInstructor(principal) or returnObject.section.isEnrolled(principal) or principal.admin")
    public Assignment getAssignment(Long id) {
        return entityManager.find(Assignment.class, id);
    }

    @Override
    public List<Assignment> searchAssignments(String term, String type, User instructor, int maxResults) {
        TypedQuery<Assignment> query = entityManager.createNamedQuery("assignment.search", Assignment.class);
        if (maxResults > 0)
            query.setMaxResults(maxResults);

        return query.setParameter("term", term).setParameter("type", type)
                .setParameter("instructorId", instructor.getId()).getResultList();
    }

    @Override
    public List<OnlineAssignment> getOnlineAssignments(Section section) {
        String query = "from OnlineAssignment where section = :section " + "order by name asc";

        return entityManager.createQuery(query, OnlineAssignment.class).setParameter("section", section)
                .getResultList();
    }

    @Override
    public List<OnlineAssignment> getOnlineAssignments(User instructor) {
        String query = "select assignment from OnlineAssignment assignment "
                + "join assignment.section.instructors instructor "
                + "where instructor = :instructor order by assignment.dueDate desc";

        return entityManager.createQuery(query, OnlineAssignment.class).setParameter("instructor", instructor)
                .getResultList();
    }

    @Override
    @Transactional
    @PreAuthorize("#assignment.section.isInstructor(principal)")
    public Assignment saveAssignment(Assignment assignment) {
        return entityManager.merge(assignment);
    }

}