/** * Save Currency * @param sfWebRequest $request * @return unknown_type */ public function executeSaveSaleryGradeCurrency(sfWebRequest $request) { if ($request->isMethod('post')) { $jobService = new JobService(); $saleryGradeId = $request->getParameter('id'); $salaryCurrencyDetail = new SalaryCurrencyDetail(); $salaryCurrencyDetail->setSalGrdCode($saleryGradeId); $salaryCurrencyDetail->setCurrencyId($request->getParameter('cmbUnAssCurrency')); $salaryCurrencyDetail->setMinSalary($request->getParameter('txtMinSal')); $salaryCurrencyDetail->setMaxSalary($request->getParameter('txtMaxSal')); $salaryCurrencyDetail->setSalaryStep($request->getParameter('txtStepSal')); $jobService->saveSalleryGradeCurrency($salaryCurrencyDetail); $this->redirect('admin/updateSaleryGrade?id=' . $saleryGradeId); } }
/** * Checks for existing SalaryCurrencyDetail for a given currency * @param SalaryCurrencyDetail $salaryCurrencyDetail * @returns boolean * @throws DaoException */ public function isExistingSalleryGradeCurrency(SalaryCurrencyDetail $salaryCurrencyDetail) { try { $q = Doctrine_Query::create()->from('SalaryCurrencyDetail')->where("sal_grd_code='" . $salaryCurrencyDetail->getSalGrdCode() . "' AND currency_id='" . $salaryCurrencyDetail->getCurrencyId() . "'"); if ($q->count() > 0) { return true; } return false; } catch (Exception $e) { throw new DaoException($e->getMessage()); } }