/*
 * 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.CodeDao;
import com.bestray.transtracking.dao.EmployeeDao;
import com.bestray.transtracking.dao.OfficeExpenseDao;
import com.bestray.transtracking.dao.impl.CodeDaoImpl;
import com.bestray.transtracking.dao.impl.EmployeeDaoImpl;
import com.bestray.transtracking.dao.impl.OfficeExpenseDaoImpl;
import com.bestray.transtracking.dto.OfficeExpenseSearchDTO;
import com.bestray.transtracking.exceptions.TransTrackException;
import com.bestray.transtracking.service.OfficeExpenseService;
import com.bestray.trastrack.domain.Employee;
import com.bestray.trastrack.domain.OfficeExpense;
import java.util.ArrayList;
import java.util.List;
import java.util.logging.Level;
import java.util.logging.Logger;
import javax.sql.DataSource;

/**
 *
 * @author User1
 */
public class OfficeExpenseServiceImpl implements  OfficeExpenseService{
    
    private OfficeExpenseDao oeDao;
    private EmployeeDao empDao;
    private CodeDao codeDao;
    

    public OfficeExpenseServiceImpl() {
    }
    
   
    public boolean saveOfficeExpense(OfficeExpense officeexpense) throws TransTrackException {
        boolean flag = false;
        
        try {
            oeDao = new OfficeExpenseDaoImpl(DataSourceObject.getDataSourceObject());
            empDao = new EmployeeDaoImpl(DataSourceObject.getDataSourceObject());
            codeDao = new CodeDaoImpl(DataSourceObject.getDataSourceObject());
            if(officeexpense.getId()!=null && officeexpense.getId()>0){
          oeDao.updateOfficeExpense(officeexpense);
       }
        else{
            if(officeexpense.getId()==null){
                oeDao.saveOfficeExpense(officeexpense);
                flag = true;
            }
       }
            
                //flag = true;
            
        } catch (Exception ex) {
            Logger.getLogger(OfficeExpenseServiceImpl.class.getName()).log(Level.SEVERE, null, ex);
            throw new TransTrackException("Error in saving Office Staff Record");
        }
        
        return flag;
    }

    public List<OfficeExpense> getSearchResult(OfficeExpenseSearchDTO search) throws TransTrackException {
        
        try{
        DataSource ds =  DataSourceObject.getDataSourceObject();
       
         oeDao = new OfficeExpenseDaoImpl(DataSourceObject.getDataSourceObject());
         empDao = new EmployeeDaoImpl(DataSourceObject.getDataSourceObject());
         codeDao = new CodeDaoImpl(DataSourceObject.getDataSourceObject());
             List<OfficeExpense> results = oeDao.getSearchResults(search);
            for(OfficeExpense object :results){
                
                object.setOffice_staff(empDao.findEmplRegistraion(object.getOffice_staff_id()));
                object.setPaid_person(empDao.findEmplRegistraion(object.getPaid_by()));
            }
            return results;
             }catch(Exception ex){
                 Logger.getLogger(OfficeExpenseServiceImpl.class.getName()).log(Level.SEVERE, null, ex);
                 throw new TransTrackException("Error in Searching Records in database");
       }
         
    }

    public void deleteOfficeExpenseRecords(Long expenseID) throws TransTrackException {
        try{
        OfficeExpense collection = oeDao.findExpenseDetails(expenseID);
        if(collection.getId()!=null){
            
                oeDao.delete(expenseID);
                 }
            }catch(Exception ex){
                 Logger.getLogger(OfficeExpenseServiceImpl.class.getName()).log(Level.SEVERE, null, ex);
                 throw new TransTrackException("Error in Delete Office Expense Record");
            }
    }

    public List<Employee> getOfficeStaffList() throws TransTrackException {
       try {
           oeDao = new OfficeExpenseDaoImpl(DataSourceObject.getDataSourceObject()); 
           return oeDao.findOfficeStaffList();
        } catch (Exception ex) {
            Logger.getLogger(OfficeExpenseServiceImpl.class.getName()).log(Level.SEVERE, null, ex);
            throw new TransTrackException("Error in fetching Office Staff Record");
        }
    }

    
    public OfficeExpense getOfficeExpenseDetails(Long valueOf) throws TransTrackException {
        OfficeExpense officeexpense ;
       try{
            oeDao = new OfficeExpenseDaoImpl(DataSourceObject.getDataSourceObject());
            empDao = new EmployeeDaoImpl(DataSourceObject.getDataSourceObject());
            codeDao = new CodeDaoImpl(DataSourceObject.getDataSourceObject());
       officeexpense = oeDao.findCollectionDetails(valueOf);
    }catch(Exception e){
           throw new TransTrackException("Error in Fetching Client Collection");
       }
        return officeexpense;
    }
    
    
}