DBTool for Oracle - Part 1

using System;
using System.Collections.Generic;
using System.Text;
using System.Reflection;
using System.Configuration;
using System.Security.Principal;

using Oracle.DataAccess.Client;

namespace Harlinn.Oracle.DBTool.Example.Common
{
    public class OperationContext : IDisposable
    {
        private static readonly log4net.ILog sfLog = log4net.LogManager.GetLogger(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType);

        private static void LogException(Exception exc, System.Reflection.MethodBase method)
        {
            Logger.LogException(sfLog, exc, method);
        }

        public const string DEFAULTCONFIGURATIONSTRINGNAME = "OracleConnection";

        OracleConnection oracleConnection;
        readonly MethodBase method;
        readonly IPrincipal principal;

        private static string oracleConfigurationStringName = DEFAULTCONFIGURATIONSTRINGNAME;
        [ThreadStatic]
        private static OperationContext current;

        public OperationContext(MethodBase method, IPrincipal principal)
        {
            current = this;
            this.method = method;
            this.principal = principal;
        }


        public OperationContext(MethodBase method)
        {
            current = this;
            this.method = method;
            this.principal = System.Threading.Thread.CurrentPrincipal;
        }

        public void Dispose()
        {
            current = null;
            if (oracleConnection != null)
            {
                oracleConnection.Dispose();
            }
        }

        public static OperationContext Current
        {
            get
            {
                return current;
            }
            set
            {
                current = value;
            }
        }

        public static string OracleConfigurationStringName
        {
            get
            {
                return oracleConfigurationStringName;
            }
            set
            {
                oracleConfigurationStringName = value;
            }
        }


        public static string GetOracleConnectionString()
        {
            try
            {
                string result = string.Empty;
                ConnectionStringSettings connectionStringSettings = ConfigurationManager.ConnectionStrings[OracleConfigurationStringName];
                if (connectionStringSettings != null)
                {
                    result = connectionStringSettings.ConnectionString;
                }
                return result;
            }
            catch (Exception exc)
            {
                LogException(exc, MethodBase.GetCurrentMethod());
                throw;
            }
        }

        public static OracleConnection CreateOracleConnection()
        {
            try
            {
                string oracleConnectionString = GetOracleConnectionString();
                OracleConnection result = new OracleConnection(oracleConnectionString);
                result.Open();
                return result;
            }
            catch (Exception exc)
            {
                LogException(exc, MethodBase.GetCurrentMethod());
                throw;
            }
        }


        public OracleConnection OracleConnection
        {
            get
            {
                try
                {
                    if (oracleConnection == null)
                    {
                        oracleConnection = CreateOracleConnection();
                    }
                    return oracleConnection;
                }
                catch (Exception exc)
                {
                    LogException(exc, MethodBase.GetCurrentMethod());
                    throw;
                }
            }
            set
            {
                try
                {
                    if ((oracleConnection != value) && (oracleConnection != null))
                    {
                        throw new InvalidOperationException("OracleConnection is already set for this operation context.");
                    }
                    oracleConnection = value;
                }
                catch (Exception exc)
                {
                    LogException(exc, MethodBase.GetCurrentMethod());
                    throw;
                }
            }
        }

        public MethodBase Method
        {
            get
            {
                return method;
            }
        }

        public IPrincipal Principal
        {
            get
            {
                return principal;
            }
        }


    }
}