/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */

package be.mct.model;

import be.mct.entities.BeerLover;
import be.mct.entities.BeerReview;
import java.util.List;
import javax.persistence.EntityManager;
import javax.persistence.PersistenceContext;

/**
 *
 * @author Dimitri
 */
public class ReviewUserFacade {
@PersistenceContext
    private EntityManager em;
    private BeerLover user;
    private int maxResults = 2;
    private int offset;

    public BeerLover getUser() {
        return user;
    }

    public void setUser(BeerLover user) {
        this.user = user;
    }

    public int getMaxResults() {
        return maxResults;
    }

    public void setMaxResults(int maxResults) {
        this.maxResults = maxResults;
    }

    public int getOffset() {
        return offset;
    }

    public void setOffset(int offset) {
        this.offset = offset;
    }



    public List<BeerReview> getReviewByOwner(){

     try {
            String qry = "SELECT a FROM BeerReview a " + "WHERE a.reviewer = :owner";
            List<BeerReview> ReviewsByOwner = (List<BeerReview>) em.createQuery(qry).setFirstResult(offset).setMaxResults(maxResults).setParameter("owner",getUser()).getResultList();
            return ReviewsByOwner;
        } catch (Exception ex) {
            ex.printStackTrace();
            return null;
        }
    }



}