ch.flashcard.service.CardServiceImpl.java Source code

Introduction

Here is the source code for ch.flashcard.service.CardServiceImpl.java

Source

/*******************************************************************************
 * Copyright (c) 2011-2014 Fernando Petrola
 * 
 *  This file is part of Dragome SDK.
 * 
 * All rights reserved. This program and the accompanying materials
 * are made available under the terms of the GNU Public License v3.0
 * which accompanies this distribution, and is available at
 * http://www.gnu.org/licenses/gpl.html
 ******************************************************************************/
package ch.flashcard.service;

import java.util.List;

import org.hibernate.Criteria;
import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.Transaction;
import org.hibernate.criterion.Restrictions;

import ch.flashcard.persistence.CardDeckEntity;
import ch.flashcard.persistence.CardEntity;
import ch.flashcard.persistence.HibernateUtil;

/**
 * Provides access to the cards in the database.
 * 
 * @author Marc Baur, Adrian Herzog
 */
@SuppressWarnings("unchecked")
public class CardServiceImpl implements CardService {
    public final CardEntity getCardById(final int id) {
        Session session = HibernateUtil.getSessionFactory().openSession();
        Transaction transaction = session.beginTransaction();

        CardEntity cardEntity = (CardEntity) session.get(CardEntity.class, id);

        transaction.commit();
        session.close();

        return cardEntity;
    }

    public final List<CardEntity> getAllCards() {
        Session session = HibernateUtil.getSessionFactory().openSession();
        Transaction transaction = session.beginTransaction();

        final Query query = session.createQuery("from CardDeck");
        List<CardEntity> cardEntities = query.list();

        transaction.commit();
        session.close();

        return cardEntities;
    }

    public final List<CardEntity> getAllCardsByCardDeck(final int cardDeckId) {
        Session session = HibernateUtil.getSessionFactory().openSession();
        Transaction transaction = session.beginTransaction();

        CardDeckEntity cardDeckEntity = (CardDeckEntity) session.get(CardDeckEntity.class, cardDeckId);
        final Criteria criteria = session.createCriteria(CardEntity.class);
        criteria.add(Restrictions.eq("carddeck", cardDeckEntity));
        List<CardEntity> cardEntities = criteria.list();

        transaction.commit();
        session.close();

        return cardEntities;
    }

}