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