models.TrialBalance.java Source code

Introduction

Here is the source code for models.TrialBalance.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 models;

import config.DatabaseUtil;
import org.hibernate.Transaction;
import java.util.List;
import org.hibernate.Criteria;
import org.hibernate.HibernateException;
import org.hibernate.Query;
import org.hibernate.SQLQuery;
import org.hibernate.Session;
import org.hibernate.criterion.Order;
import services.TrialBalances;

/**
 *
 * @author BDO-IT
 */
public class TrialBalance {

    public void deleteAll() {
        Session session;
        session = DatabaseUtil.getSessionFactory().openSession();
        Transaction tx = null;
        try {
            tx = session.beginTransaction();
            String hql = "delete from TrialBalances where id >= :id";
            Query query = session.createQuery(hql);
            query.setInteger("id", 1);
            System.out.println(query.executeUpdate());
            session.flush();
            tx.commit();
        } catch (HibernateException ex) {
            System.out.println(ex.getMessage());
            if (tx != null) {
                tx.rollback();
            }
        } finally {
            session.close();
        }
    }

    public void resetAll() {
        Session session;
        session = DatabaseUtil.getSessionFactory().openSession();
        Transaction tx = null;
        try {
            tx = session.beginTransaction();
            String sql = "ALTER TABLE trial_balances AUTO_INCREMENT = :id";
            SQLQuery query = session.createSQLQuery(sql);
            query.setInteger("id", 1);
            System.out.println(query.executeUpdate());
            session.flush();
            tx.commit();
        } catch (HibernateException ex) {
            System.out.println(ex.getMessage());
            if (tx != null) {
                tx.rollback();
            }
        } finally {
            session.close();
        }
    }

    public List getRowsByList() {
        List list;
        Session session = DatabaseUtil.getSessionFactory().openSession();
        Transaction tx = null;
        try {
            tx = session.beginTransaction();
            Criteria criteria = session.createCriteria(TrialBalances.class);
            criteria.addOrder(Order.asc("accountNo"));
            list = criteria.list();
            session.flush();
            tx.commit();
        } catch (HibernateException e) {
            list = null;
            if (tx != null) {
                tx.rollback();
            }
        } finally {
            session.close();
        }
        return list;
    }

    public void save(String accountNo, String accountName, Double beginningBalanceDebet,
            Double beginningBalanceCredit, Double profitLossDebet, Double profitLossCredit, Double balanceDebet,
            Double balanceCredit, Double endingBalanceDebet, Double endingBalanceCredit) {
        Session session;
        TrialBalances tb = new TrialBalances();
        session = DatabaseUtil.getSessionFactory().openSession();
        Transaction tx = null;
        try {
            tx = session.beginTransaction();
            tb.setAccountNo(accountNo);
            tb.setAccountName(accountName);
            tb.setBeginningBalanceDebet(beginningBalanceDebet);
            tb.setBeginningBalanceCredit(beginningBalanceCredit);
            tb.setProfitLossDebet(profitLossDebet);
            tb.setProfitLossCredit(profitLossCredit);
            tb.setBalanceDebet(balanceDebet);
            tb.setBalanceCredit(balanceCredit);
            tb.setEndingBalanceDebet(endingBalanceDebet);
            tb.setEndingBalanceCredit(endingBalanceCredit);
            session.save(tb);
            session.flush();
            tx.commit();
        } catch (HibernateException ex) {
            if (tx != null) {
                tx.rollback();
            }
        } finally {
            session.close();
        }
    }
}