/**
* save WorkExperience
* @param EmpWorkExperience $empWorkExp
* @return EmpWorkExperience
*/
public function saveEmployeeWorkExperience(EmpWorkExperience $empWorkExp)
{
try {
$sequenceNo = 1;
if (trim($empWorkExp->getSeqno()) == "") {
$q = Doctrine_Query::create()->select('MAX(w.seqno)')->from('EmpWorkExperience w')->where('w.emp_number = ?', $empWorkExp->getEmpNumber());
$result = $q->execute(array(), Doctrine::HYDRATE_ARRAY);
$sequenceNo = $result[0]['MAX'] + 1;
$empWorkExp->setSeqno($sequenceNo);
}
$empWorkExp->save();
return $empWorkExp;
// @codeCoverageIgnoreStart
} catch (Exception $e) {
throw new DaoException($e->getMessage(), $e->getCode(), $e);
}
// @codeCoverageIgnoreEnd
}
/**
* Testing getWorkExperience
*/
public function testGetWorkExperience()
{
$empNumber = 121;
$sequence = 1;
$experience = new EmpWorkExperience();
$experience->setEmpNumber($empNumber);
$experience->setSeqno(1);
$experience->setEmployer('ACME Inc');
$experience->setJobtitle('Manager');
$isEss = true;
$mockDao = $this->getMock('EmployeeDao');
$mockDao->expects($this->once())->method('getWorkExperience')->with($empNumber, $sequence)->will($this->returnValue($experience));
$this->employeeService->setEmployeeDao($mockDao);
$result = $this->employeeService->getWorkExperience($empNumber, $sequence);
$this->assertEquals($experience, $result);
}
