summaryrefslogtreecommitdiff
path: root/demos/sqlmap-sample/protected/pages/crud2.php
blob: 46fe3893ac63c3856155be2744190d5889381e30 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
<?php

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

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

	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];
	}
}

?>