Central Key Management

using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.SqlClient;
using Core.DatabaseBlock;

namespace KeyManager
{
    class SessionKeyInfo
    {
        private string _keyData;
        private string _keyId;
        private string _wrappingCert;
        private string _description;
        private DateTime _expiration;
        private DateTime _creation;

        public DateTime Creation
        {
            get { return _creation; }
            set { _creation = value; }
        }

        public string KeyId
        {
            get { return _keyId; }
            set { _keyId = value; }
        }

        public string WrappingCert
        {
            get { return _wrappingCert; }
            set { _wrappingCert = value; }
        }

        public string Description
        {
            get { return _description; }
            set { _description = value; }
        }

        public DateTime Expiration
        {
            get { return _expiration; }
            set { _expiration = value; }
        } 

        public string KeyData
        {
          get { return _keyData; }
          set { _keyData = value; }
        }
   }

    class DataLayer : DataModuleCore
    {
        public DataLayer(string connectionString)
            : base( connectionString )
        {
        }

        public int StoreSessionKey(string key, string wrappingCert, DateTime expiration, string description)
        {
            using (DataCommand command = NewCommand("dbo.[InsertSessionKey]"))
            {
                command.NewParameter.StringParameter("@keyData", key);
                command.NewParameter.StringParameter("@wrappingCert", wrappingCert);
                command.NewParameter.DateTimeParameter("@expiration", expiration);
                command.NewParameter.StringParameter("@description", description);

                return command.ExecuteScalarInt();
            }
        }

        public SessionKeyInfo GetSessionKey(string key)
        {
            int keyId;
            
            if ( Int32.TryParse( key, out keyId ) == false )
                throw new ArgumentException( "Invalid KeyID." );

            SessionKeyInfo info = new SessionKeyInfo();
            using (DataCommand command = NewCommand("dbo.[GetSessionKey]"))
            {
                command.NewParameter.Int32Parameter("@keyId", keyId);

                DataReader reader = command.ExecuteReader();
                if (reader.Read() == true)
                {
                    info.KeyData = reader.ReadString("keyData");
                    info.KeyId = reader.ReadString("keyId");
                    info.Expiration = reader.ReadDateTime("expiration");
                    info.Creation = reader.ReadDateTime("creation");
                    info.Description = reader.ReadString("description");
                    info.WrappingCert = reader.ReadString("wrappingCert");
                }
            }

            return info;
        }

    }
}