Subversion-Projekte lars-tiefland.prado

<?php

Prado::using('Example.Person');

class crud2 extends TPage
{
        private function sqlmap()
        {
                return $this->Application->Modules['person-sample']->Client;
        }

        private function loadData()
        {
                $this->personList->DataSource =  $this->sqlmap()->queryForList('SelectAll');
                $this->personList->dataBind();
        }

        public function onLoad($param)
        {
                if(!$this->IsPostBack)
                        $this->loadData();
        }

        protected function editPerson($sender,$param)
        {
                $this->personList->EditItemIndex=$param->Item->ItemIndex;
                $this->loadData();
        }

        protected function deletePerson($sender, $param)
        {
                $id = $this->getKey($sender, $param);

                $this->sqlmap()->update("Delete", $id);
                $this->loadData();
        }

        protected function updatePerson($sender, $param)
        {
                $person = new Person();
                $person->FirstName = $this->getText($param, 0);
                $person->LastName = $this->getText($param, 1);
                $person->HeightInMeters = $this->getText($param, 2);
                $person->WeightInKilograms = $this->getText($param, 3);
                $person->ID = $this->getKey($sender, $param);

                $this->sqlmap()->update("Update", $person);
                $this->refreshList($sender, $param);
        }

        protected function addNewPerson($sender, $param)
        {
                $person = new Person;
                $person->FirstName = "-- New Person --";
                $this->sqlmap()->insert("Insert", $person);

                $this->loadData();;
        }

        protected function refreshList($sender, $param)
        {
                $this->personList->EditItemIndex=-1;
                $this->loadData();
        }

        private function getText($param, $index)
        {
                $item = $param->Item;
                return $item->Cells[$index]->Controls[0]->Text;
        }

        private function getKey($sender, $param)
        {
                return $sender->DataKeys[$param->Item->DataSourceIndex];
        }
}

?>