} //Fin Desconectar
/********************************************************/
#endregion Fin Conectar y Desconectar
#region Transaction
/********************************************************/
public void BeginTransaction()
{
try
{
if (_TransacActiva)
{
return;
}
LBSSqlConnection oLbsSql;
if (_command != null)
{
oLbsSql = LBSSqlConnection.GetInstance(_LstConexion, _command.Connection);
}
else
{
oLbsSql = ConexionHabilitada.Open();
}
oLbsSql.BeginTransaction();
if (_command != null)
{
_command.Transaction = LBSSqlConnection.Transaction;
}
_TransacActiva = true;
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
} //Fin BeginTransaction
}//Fin CommitTransaction()
/// <summary>
/// Hace un RollBack de la Transaccion
/// </summary>
public void RoolbackTransaction()
{
try
{
_TransaccionActual.Rollback();
_ConexionTransaccion = null;
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}//Fin RoolbackTransaction()
}//Fin BeginTransaction()
/// <summary>
/// Hace un Commit de la Transaccion
/// </summary>
public void CommitTransaction()
{
try
{
_TransaccionActual.Commit();
_ConexionTransaccion = null;
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}//Fin CommitTransaction()
}//Fin Open()
/// <summary>
/// Inicio la Transaccion
/// </summary>
public void BeginTransaction()
{
try
{
Open();
_TransaccionActual = _conexion.BeginTransaction();
_ConexionTransaccion = this;
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}//Fin BeginTransaction()
} //Fin Metodo Conectar(...)
private void Desconectar(SqlCommand oCommand = null)
{
try
{
if (oCommand == null)
{
oCommand = _command;
}
LBSSqlConnection oLbsSql = LBSSqlConnection.GetInstance(_LstConexion, oCommand.Connection);
if (oLbsSql != null)
{
oLbsSql.Close();
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
} //Fin Desconectar
