From 1dfdccb8118aeaa3cd844ac8de2a672c93312166 Mon Sep 17 00:00:00 2001 From: mokhan Date: Sat, 21 Feb 2009 21:44:27 +0000 Subject: git-svn-id: http://svn.xp-dev.com/svn/mokhan-sait@2 da190166-9cfc-4ee1-ae03-434a172be219 --- slips/src/app/Marina/DataAccess/DatabaseCommand.cs | 23 ++++++++++++++++++++++ 1 file changed, 23 insertions(+) create mode 100644 slips/src/app/Marina/DataAccess/DatabaseCommand.cs (limited to 'slips/src/app/Marina/DataAccess/DatabaseCommand.cs') diff --git a/slips/src/app/Marina/DataAccess/DatabaseCommand.cs b/slips/src/app/Marina/DataAccess/DatabaseCommand.cs new file mode 100644 index 0000000..f394ec0 --- /dev/null +++ b/slips/src/app/Marina/DataAccess/DatabaseCommand.cs @@ -0,0 +1,23 @@ +using System; +using System.Data; + +namespace Marina.DataAccess { + public class DatabaseCommand : IDatabaseCommand { + public DatabaseCommand( IDbCommand command ) { + _command = command; + } + + public DataTable ExecuteQuery() { + DataTable table = new DataTable( ); + table.Load( _command.ExecuteReader( ) ); + return table; + } + + public long ExecuteScalarQuery() { + object scalar = _command.ExecuteScalar( ); + return DBNull.Value != scalar ? Convert.ToInt32( scalar ) : -1; + } + + private readonly IDbCommand _command; + } +} \ No newline at end of file -- cgit v1.2.3