/** * * @param unknown $data */ public function updateCategory($data) { $result = false; $pdo = DbUtil::connect(); $dao = new M02CategoryDao($pdo); // create new category object $obj = new M02CategoryBO(); // get id from request if (property_exists($data, 'id')) { $obj->setM02categoryid($data->id); } // get the persistance obj from db $obj = $dao->getById($obj); $obj->import($data); $result = $dao->update($obj); DbUtil::disconnect(); return $result; }
public function getById(M02CategoryBO $obj) { $stmt = $this->db->prepare(self::$selectByIdSQL); $id = intval($obj->getM02categoryid()); $stmt->execute(array($id)); $row = $stmt->fetch(PDO::FETCH_ASSOC); if ($row != null) { $obj = new M02CategoryBO(); $obj->setM02categoryid($row['M02CATEGORYID']); $obj->setLabel($row['LABEL']); $obj->setM11statusid($row['M11STATUSID']); $obj->setStartage($row['STARTAGE']); $obj->setEndage($row['ENDAGE']); $obj->setGender($row['GENDER']); $obj->setCreatedon($row['CREATEDON']); $obj->setCreatedby($row['CREATEDBY']); $obj->setModifiedon($row['MODIFIEDON']); $obj->setModifiedby($row['MODIFIEDBY']); } return $obj; }