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