protected void DisposeCommand(OracleCommand cmd)
{
_conexion.DisposeCommand(cmd);
}
private void AsegurarDatosInicioSesion()
{
OracleCommand cmd = _conexion.CrearCommand();
cmd.CommandText = "INICIOSESSION.InformacionSession";
cmd.CommandType = CommandType.StoredProcedure;
OracleParameter p_refcursorAgente = new OracleParameter();
OracleParameter p_refcursorRol = new OracleParameter();
OracleParameter p_refcursorDatosUsuario = new OracleParameter();
OracleParameter p_refcursorSession = new OracleParameter();
OracleParameter p_refcursorRolEmpresa = new OracleParameter();
p_refcursorAgente.OracleDbType = OracleDbType.RefCursor;
p_refcursorRol.OracleDbType = OracleDbType.RefCursor;
p_refcursorDatosUsuario.OracleDbType = OracleDbType.RefCursor;
p_refcursorSession.OracleDbType = OracleDbType.RefCursor;
p_refcursorRolEmpresa.OracleDbType = OracleDbType.RefCursor;
p_refcursorAgente.Direction = ParameterDirection.Output;
p_refcursorRol.Direction = ParameterDirection.Output;
p_refcursorDatosUsuario.Direction = ParameterDirection.Output;
p_refcursorSession.Direction = ParameterDirection.Output;
p_refcursorRolEmpresa.Direction = ParameterDirection.Output;
cmd.Parameters.Add(p_refcursorAgente);
cmd.Parameters.Add(p_refcursorRol);
cmd.Parameters.Add(p_refcursorDatosUsuario);
cmd.Parameters.Add(p_refcursorSession);
cmd.Parameters.Add(p_refcursorRolEmpresa);
PistaMgr.Instance.Debug("Sesion", "Previo Sesion");
PistaMgr.Instance.Debug("Sesion", "Iniciando Sesion");
DataSet ds = new DataSet();
OracleDataAdapter da = null;
try
{
PistaMgr.Instance.Debug("Sesion", "Iniciando TRY");
da = new OracleDataAdapter(cmd);
da.Fill(ds);
PistaMgr.Instance.Debug("Sesion", "Fin TRY");
}
catch (Exception excep)
{
PistaMgr.Instance.Error("Sesion", excep);
}
foreach (DataTable tabla in ds.Tables)
{
PistaMgr.Instance.Debug("Sesion", string.Format("TABLA: {0} REGISTROS:{1}", tabla.TableName, tabla.Rows.Count));
}
_empresaActual = new Persona(ds.Tables[0].Rows[0]);
_rolesActuales = readRoles(ds.Tables[1]);
_usuarioActual = new Usuario(ds.Tables[2].Rows[0]);
_rolSIN = ObjetoDeNegocio.GetValor <string>(ds.Tables[4].Rows[0]["NOM_ROL"]);
ReadValuesSession(ds.Tables[3]);
_conexion.DisposeCommand(cmd);
if (da != null)
{
da.Dispose();
}
_idSesion = GetIdSesionBD();
PistaMgr.Instance.Debug("Sesion", "Sesion Iniciada IdSesion = " + _idSesion);
}