diff options
Diffstat (limited to 'src/app/Cmpp298.Assignment3.Task/TermTask.cs')
| -rw-r--r-- | src/app/Cmpp298.Assignment3.Task/TermTask.cs | 31 |
1 files changed, 31 insertions, 0 deletions
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 |