From 2fbc53d1f5d9e0a000717642d02558453bc610a8 Mon Sep 17 00:00:00 2001
From: wei <>
Date: Tue, 18 Jul 2006 23:39:13 +0000
Subject: Add more tests and business code for time-tracker

---
 .../protected/App_Code/CategoryDao.php             | 50 ++++++++++++++++++++++
 1 file changed, 50 insertions(+)
 create mode 100644 demos/time-tracker/protected/App_Code/CategoryDao.php

(limited to 'demos/time-tracker/protected/App_Code/CategoryDao.php')

diff --git a/demos/time-tracker/protected/App_Code/CategoryDao.php b/demos/time-tracker/protected/App_Code/CategoryDao.php
new file mode 100644
index 00000000..f0149f0b
--- /dev/null
+++ b/demos/time-tracker/protected/App_Code/CategoryDao.php
@@ -0,0 +1,50 @@
+<?php
+
+class CategoryDao extends BaseDao
+{
+	function addNewCategory($category)
+	{
+		$sqlmap = $this->getConnection();
+		$sqlmap->insert('AddNewCategory', $category);
+	}	
+	
+	function getCategoryByID($categoryID)
+	{
+		$sqlmap = $this->getConnection();
+		return $sqlmap->queryForObject('GetCategoryByID', $categoryID);
+	}
+	
+	function getAllCategories()
+	{
+		$sqlmap = $this->getConnection();
+		return $sqlmap->queryForList('GetAllCategories');
+	}
+	
+	function deleteCategory($categoryID)
+	{
+		$sqlmap = $this->getConnection();
+		$sqlmap->delete('DeleteCategory', $categoryID);
+	}
+	
+	function getCategoriesByProjectID($projectID)
+	{
+		$sqlmap = $this->getConnection();
+		return $sqlmap->queryForList('GetCategoriesByProjectID', $projectID);
+	}
+	
+	function getCategoryByNameInProject($name, $projectID)
+	{
+		$sqlmap = $this->getConnection();
+		$param['project'] = $projectID;
+		$param['category'] = $name;
+		return $sqlmap->queryForObject('GetCategoryByNameInProject', $param);
+	}
+	
+	function updateCategory($category)
+	{
+		$sqlmap = $this->getConnection();
+		$sqlmap->update('UpdateCategory', $category);
+	}
+}
+
+?>
\ No newline at end of file
-- 
cgit v1.2.3