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