edu.mum.dao.impl.EventsDaoImpl.java Source code

Introduction

Here is the source code for edu.mum.dao.impl.EventsDaoImpl.java

Source

/*
 * To change this license header, choose License Headers in Project Properties.
 * To change this template file, choose Tools | Templates
 * and open the template in the editor.
 */
package edu.mum.dao.impl;

import edu.mum.dao.EventsDao;
import edu.mum.domain.Event;

import java.util.List;
import javax.persistence.Query;
import org.springframework.stereotype.Repository;

/**
 *
 * @author HAGOS
 */
@Repository
public class EventsDaoImpl extends GenericDaoImpl<Event> implements EventsDao {

    public EventsDaoImpl() {
        super.setDaoType(Event.class);
    }

    @Override
    public Event findById(Integer Id) {
        return entityManager.find(Event.class, Id);
    }

    @Override
    public List<Event> findEventsByUserId(int userId) {
        Query query = this.entityManager.createQuery("SELECT e from Event e where e.eventOwner.id =:id");
        query.setParameter("id", userId);
        return query.getResultList();
    }

    @Override
    public void deleteEvent(Event event) {
    }

    @Override
    public List<Event> findInvitedEventsByUserId(int userId) {
        Query query = this.entityManager.createQuery("SELECT e from Event e inner join e.users u where u.id =:id "
                + "and u.id not in (SELECT er.user.id from EventRegister er "
                + "where er.user.id=:id and er.event.id=e.id)");
        query.setParameter("id", userId);
        return query.getResultList();
    }

}