// **********************************************************************
//
// Copyright (c) 2003-2007 ZeroC, Inc. All rights reserved.
//
// This copy of Ice is licensed to you under the terms described in the
// ICE_LICENSE file included in this distribution.
//
// **********************************************************************

#ifndef DEPTI_H
#define DEPTI_H

#include <HR.h>
#include <occi.h>
#include <DbTypes.h>

class DeptI : public HR::Dept
{
public:

    DeptI(oracle::occi::Environment* env, 
	  oracle::occi::StatelessConnectionPool*, const std::string&);
    
    virtual void ice_ping(const Ice::Current&) const;

    virtual HR::EmpPrx createEmp(int, const HR::EmpDesc&, const Ice::Current&);

    virtual HR::DeptDesc getDesc(const Ice::Current&);    
    virtual void updateDesc(const HR::DeptDesc& newDesc, const Ice::Current&);
    virtual void remove(const Ice::Current&);

    virtual HR::EmpPrxSeq findAll(const Ice::Current&);
    virtual HR::EmpPrxSeq findByName(const std::string&, const Ice::Current&);

    //
    // Throws Ice::ObjectNotExistException when not found
    //
    static oracle::occi::Ref<DEPT_T> getRef(oracle::occi::Connection* con, int deptno);

private:

    oracle::occi::Environment* _env;
    oracle::occi::StatelessConnectionPool* _pool;
    const std::string _empCategory;
};

#endif