public function update($data) { $result = false; $pdo = DbUtil::connect(); $dao = new M03LevelDao($pdo); // create new category object $obj = new M03LevelBO(); // get id from request if (property_exists($data, 'id')) { $obj->setM03Levelid($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(M03LevelBO $obj) { $stmt = $this->db->prepare(self::$selectByIdSQL); $id = intval($obj->getM03levelid()); $stmt->execute(array($id)); $row = $stmt->fetch(PDO::FETCH_ASSOC); if ($row != null) { $obj = new M03LevelBO(); $obj->setM03levelid($row['M03LEVELID']); $obj->setLabel($row['LABEL']); $obj->setM11statusid($row['M11STATUSID']); $obj->setCreatedon($row['CREATEDON']); $obj->setCreatedby($row['CREATEDBY']); $obj->setModifiedon($row['MODIFIEDON']); $obj->setModifiedby($row['MODIFIEDBY']); } return $obj; }