/** * 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); }