using System;

using System.Data;

using System.Data.OracleClient;

using System.Configuration;

using System.Web;

using System.Web.SessionState;



/// <summary>

/// Clase que administra la conexion con la base de datos

/// </summary>

public class clsConexion

{

    protected OracleConnection db;

    protected OracleTransaction tr;



    #region Properties

    public OracleConnection DBConnection

    {

        get

        {

            return db;

        }

    }



    public OracleTransaction DBTransaction

    {

        get

        {

            return tr;

        }

    }

    #endregion



    #region Contructor

    public clsConexion()

    {

        tr = null;

        conectarBD();

    }

    #endregion



    #region Metodos de Instancia

    private void conectarBD()

    {

        string strConnStr;



        //Guardo en strConnStr el connection string

        strConnStr = Globals.DBConection;

        // Remplazo [Usuario] y [Passwd] con lo que trae de SSO

        strConnStr = strConnStr.Replace("[Usuario]", Globals.DBUser);

        strConnStr = strConnStr.Replace("[Passwd]", Globals.PWDDBUser);



        db = new OracleConnection(strConnStr);

        db.Open();

    }



    public void iniciarTransaccion()

    {

        tr = db.BeginTransaction();

    }



    public void finalizarTransaccion()

    {

        tr.Commit();

        tr = null;

    }



    public void errorTransaccion()

    {

        tr.Rollback();

        tr = null;

    }

    #endregion

}