/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */
package com.bestray.transtracking.service.impl;

import com.bestray.transporttracking.DataSourceObject;
import com.bestray.transtracking.dao.BalanceSheetDao;
import com.bestray.transtracking.dao.ReceiptVoucherDao;
import com.bestray.transtracking.dao.impl.BalanceSheetDaoImpl;
import com.bestray.transtracking.dto.ClientCollectionSearchDTO;
import com.bestray.transtracking.dto.JobEntrySearchDTO;
import com.bestray.transtracking.dto.PaymentVoucherSearchDTO;
import com.bestray.transtracking.dto.VehicleExpenseSearchDTO;
import com.bestray.transtracking.service.BalanceSheetService;
import com.bestray.trastrack.domain.ClientCollection;
import com.bestray.trastrack.domain.JobEntry;
import java.util.ArrayList;
import java.util.List;
import javax.sql.DataSource;
import com.bestray.transtracking.exceptions.TransTrackException;
import com.bestray.trastrack.domain.PaymentVoucher;
import com.bestray.trastrack.domain.VehicleExpense;
import com.bestray.trastrack.domain.VehicleExpenseDetails;
import java.util.logging.Level;
import java.util.logging.Logger;

/**
 *
 * @author user3
 */
public class BalanceSheetServiceImpl implements BalanceSheetService{
    
    private ReceiptVoucherDao voucherdao;
    private BalanceSheetDao balancedao;
    private PaymentVoucherSearchDTO search;
    
    public BalanceSheetServiceImpl(){
        
    }

    public List<JobEntry> getSearchResult(JobEntrySearchDTO search) throws TransTrackException {
       List<JobEntry> results = new ArrayList<JobEntry>();
       try{ 
       DataSource ds =  DataSourceObject.getDataSourceObject();
         balancedao = new BalanceSheetDaoImpl(ds);
         //employeeDao = new EmployeeDaoImpl(ds);
            results = balancedao.getSearchResults(search);
            for(JobEntry object :results){
                //object.setEmployee(employeeDao.findEmplRegistraion(object.getLoan_paid_by()));
            }
       }catch(Exception e){
           throw new TransTrackException("Error in Fetching Job Entry");
       }
         return results; 
    }

    public List<ClientCollection> getCollectionSearchResult(ClientCollectionSearchDTO search2) throws TransTrackException{
         List<ClientCollection> results = new ArrayList<ClientCollection>();
        try{
        DataSource ds =  DataSourceObject.getDataSourceObject();
         balancedao = new BalanceSheetDaoImpl(ds);
         //employeeDao = new EmployeeDaoImpl(ds);
             results = balancedao.getCollectionSearchResults(search2);
            for(ClientCollection object :results){
                //object.setEmployee(employeeDao.findEmplRegistraion(object.getLoan_paid_by()));
            }
            }catch(Exception e){
           throw new TransTrackException("Error in Fetching Collection Entry");
       }
         return results; 
    }

    public List<VehicleExpenseDetails> getExpenseSearchResult(VehicleExpenseSearchDTO expensesearch) throws TransTrackException {
        List<VehicleExpenseDetails> results = new ArrayList<VehicleExpenseDetails>();
        try{
        DataSource ds =  DataSourceObject.getDataSourceObject();
         balancedao = new BalanceSheetDaoImpl(ds);
         //employeeDao = new EmployeeDaoImpl(ds);
             results = balancedao.getExpenseSearchResults(expensesearch);
           
            }catch(Exception e){
           throw new TransTrackException("Error in Fetching Expense Entry");
       }
         return results; 
    }

    public List<PaymentVoucher> getPaymentSearchResult(PaymentVoucherSearchDTO paymentsearch) throws TransTrackException {
         List<PaymentVoucher> results = new ArrayList<PaymentVoucher>();
        try{
        DataSource ds =  DataSourceObject.getDataSourceObject();
         balancedao = new BalanceSheetDaoImpl(ds);
         //employeeDao = new EmployeeDaoImpl(ds);
             results = balancedao.getPaymentSearchResults(paymentsearch);
            }catch(Exception e){
           throw new TransTrackException("Error in Fetching Collection Entry");
       }
         return results; 
    }

    public Double getJobEntryTotalAmount(JobEntrySearchDTO search) throws TransTrackException {
       DataSource ds =  DataSourceObject.getDataSourceObject();
         double amount = 0.0;
         balancedao = new BalanceSheetDaoImpl(ds);
        try {
            amount = balancedao.getJobEntryTotalAmount(search);
        } catch (Exception ex) {
            Logger.getLogger(BalanceSheetServiceImpl.class.getName()).log(Level.SEVERE, null, ex);
            throw new TransTrackException("Error in fetching Total Amount");
        }
        
         return amount;
             
    }
    
     public Double getPartyPaymentTotalAmount(PaymentVoucherSearchDTO paymentsearch)throws TransTrackException {
       DataSource ds =  DataSourceObject.getDataSourceObject();
         double amount = 0.0;
         balancedao = new BalanceSheetDaoImpl(ds);
        try {
            amount = balancedao.getPartyPaymentTotalAmount(search);
        } catch (Exception ex) {
            Logger.getLogger(BalanceSheetServiceImpl.class.getName()).log(Level.SEVERE, null, ex);
            throw new TransTrackException("Error in fetching Total Amount");
        }
        
         return amount;
             
    }
   
    
}