fi.foyt.fni.persistence.dao.materials.CharacterSheetRollDAO Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of persistence Show documentation

Forge & Illusion - Persistence

There is a newer version: 3.3.13

package fi.foyt.fni.persistence.dao.materials;

import java.util.Date;
import java.util.List;

import javax.persistence.EntityManager;
import javax.persistence.criteria.CriteriaBuilder;
import javax.persistence.criteria.CriteriaQuery;
import javax.persistence.criteria.Root;

import fi.foyt.fni.persistence.dao.GenericDAO;
import fi.foyt.fni.persistence.model.materials.CharacterSheetRoll;
import fi.foyt.fni.persistence.model.materials.CharacterSheetRollLabel;
import fi.foyt.fni.persistence.model.materials.CharacterSheetRoll_;
import fi.foyt.fni.persistence.model.users.User;

public class CharacterSheetRollDAO extends GenericDAO {

	private static final long serialVersionUID = 1L;

	public CharacterSheetRoll create(CharacterSheetRollLabel label, String roll, User user, Date time, Integer result) {
    CharacterSheetRoll characterSheetRollResult = new CharacterSheetRoll();

    characterSheetRollResult.setUser(user);
    characterSheetRollResult.setResult(result);
    characterSheetRollResult.setLabel(label);
    characterSheetRollResult.setRoll(roll);
    characterSheetRollResult.setTime(time);
    

    return persist(characterSheetRollResult);
  }
	
  public List listByLabel(CharacterSheetRollLabel label) {
    EntityManager entityManager = getEntityManager();

    CriteriaBuilder criteriaBuilder = entityManager.getCriteriaBuilder();
    CriteriaQuery criteria = criteriaBuilder.createQuery(CharacterSheetRoll.class);
    Root root = criteria.from(CharacterSheetRoll.class);
    criteria.select(root);
    criteria.where(
      criteriaBuilder.and(
        criteriaBuilder.equal(root.get(CharacterSheetRoll_.label), label)
      )
    );
    
    return entityManager.createQuery(criteria).getResultList();
  }
  
  public List listByRollAndUser(CharacterSheetRollLabel label, User user) {
    EntityManager entityManager = getEntityManager();

    CriteriaBuilder criteriaBuilder = entityManager.getCriteriaBuilder();
    CriteriaQuery criteria = criteriaBuilder.createQuery(CharacterSheetRoll.class);
    Root root = criteria.from(CharacterSheetRoll.class);
    criteria.select(root);
    criteria.where(
      criteriaBuilder.and(
        criteriaBuilder.equal(root.get(CharacterSheetRoll_.label), label),
        criteriaBuilder.equal(root.get(CharacterSheetRoll_.user), user)
      )
    );
    
    return entityManager.createQuery(criteria).getResultList();
  }
  
}