Example #1
0
 public function update($data)
 {
     $result = false;
     $pdo = DbUtil::connect();
     $dao = new M05LessonDao($pdo);
     // create new category object
     $obj = new M05LessonBO();
     // get id from request
     if (property_exists($data, 'id')) {
         $obj->setM05Lessonid($data->id);
     }
     // get the persistance obj from db
     $obj = $dao->getById($obj);
     $obj->import($data);
     $result = $dao->update($obj);
     DbUtil::disconnect();
     return $result;
 }
Example #2
0
 public function getById(M05LessonBO $obj)
 {
     $stmt = $this->db->prepare(self::$selectByIdSQL);
     $id = intval($obj->getM05lessonid());
     $stmt->execute(array($id));
     $row = $stmt->fetch(PDO::FETCH_ASSOC);
     if ($row != null) {
         $obj = new M05LessonBO();
         $obj->setM05lessonid($row['M05LESSONID']);
         $obj->setTitle($row['TITLE']);
         $obj->setLongdesc($row['LONGDESC']);
         $obj->setShortdesc($row['SHORTDESC']);
         $obj->setAdditionalinfo($row['ADDITIONALINFO']);
         $obj->setCreatedon($row['CREATEDON']);
         $obj->setCreatedby($row['CREATEDBY']);
         $obj->setModifiedon($row['MODIFIEDON']);
         $obj->setModifiedby($row['MODIFIEDBY']);
         $obj->setM11statusid($row['M11STATUSID']);
     }
     return $obj;
 }