From 330be9feefb6394479553be0e078b4c4df3cbff1 Mon Sep 17 00:00:00 2001
From: mo khan <mo@mokhan.ca>
Date: Sun, 26 Aug 2007 20:10:42 -0600
Subject: import from svn

---
 src/app/Cmpp298.Assignment3.Task/TermTask.cs | 31 ++++++++++++++++++++++++++++
 1 file changed, 31 insertions(+)
 create mode 100644 src/app/Cmpp298.Assignment3.Task/TermTask.cs

(limited to 'src/app/Cmpp298.Assignment3.Task/TermTask.cs')

diff --git a/src/app/Cmpp298.Assignment3.Task/TermTask.cs b/src/app/Cmpp298.Assignment3.Task/TermTask.cs
new file mode 100644
index 0000000..826d5ec
--- /dev/null
+++ b/src/app/Cmpp298.Assignment3.Task/TermTask.cs
@@ -0,0 +1,31 @@
+using System.Collections.Generic;
+using System.Data;
+using Cmpp298.Assignment3.DataAccess;
+using Cmpp298.Assignment3.Dto;
+
+namespace Cmpp298.Assignment3.Task {
+	public class TermTask : ITermTask {
+		private IDatabaseGateway _gateway;
+
+		public TermTask( ) : this( new DatabaseGateway( ) ) {}
+
+		public TermTask( IDatabaseGateway gateway ) {
+			_gateway = gateway;
+		}
+
+		public IEnumerable< IDropDownListItem > GetAll( ) {
+			SelectQueryBuilder builder = new SelectQueryBuilder( Tables.Terms.TableName );
+			builder.AddColumn( Tables.Terms.TermsID );
+			builder.AddColumn( Tables.Terms.Description );
+			return CreateFrom( _gateway.GetTableFrom( builder ) );
+		}
+
+		private static IEnumerable< IDropDownListItem > CreateFrom( DataTable table ) {
+			foreach ( DataRow row in table.Rows ) {
+				yield return
+					new DropDownListItem( row[ Tables.Terms.Description.ColumnName ].ToString( ),
+					                      row[ Tables.Terms.TermsID.ColumnName ].ToString( ) );
+			}
+		}
+	}
+}
\ No newline at end of file
-- 
cgit v1.2.3