} //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
/********************************************************/
#endregion Fin Propiedades
#region Conectar y Desconectar
/********************************************************/
private void Conectar(Boolean ComprobarStore = true, int?timeout = null)
{
try
{
if (_command != null)
{
_command.Connection = ConexionHabilitada.Open().Conexion;
if (timeout.HasValue)
{
_command.CommandTimeout = timeout.Value;
}
if (ComprobarStore)
{
if (_isStoreProcedure)
{
_command.CommandType = CommandType.StoredProcedure;
}
else
{
_command.CommandType = CommandType.Text;
}
} //fin ComprobarStore
}
} //fin try
catch (Exception ex)
{
throw new Exception(ex.Message);
} //Fin catch
} //Fin Metodo Conectar(...)