public List <UsuarioSistema> ConsultarUsuario(UsuarioSistema user)
{
ConexaoOracle objConexao = new ConexaoOracle();
List <UsuarioSistema> list = new List <UsuarioSistema>();
UsuarioSistema usu;
try
{
objConexao.AdicionarParametro("P_LOGIN", user.login);
objConexao.AdicionarParametro("P_NOME", user.nome);
objConexao.AdicionarParametro("P_DEPARTAMENTO", user.departamento);
objConexao.AdicionarParametro("P_EMAIL", user.email);
objConexao.AdicionarParametroCursor("dados");
System.Data.OracleClient.OracleDataReader leitor = objConexao.ObterLeitor("FUN_PKG_USUARIO.LISTAR_USUARIOS_IMPORTADOS");
while (leitor.Read())
{
usu = new UsuarioSistema();
usu.departamento = leitor["DEPARTAMENTO"].ToString();
usu.email = leitor["EMAIL"].ToString();
usu.login = leitor["LOGIN"].ToString();
usu.nome = leitor["NOME"].ToString();
usu.dt_inclusao = DateTime.Parse(leitor["DT_INCLUSAO"].ToString());
usu.id_usuario = int.Parse(leitor["ID_USUARIO"].ToString());
usu.id_status = int.Parse(leitor["status"].ToString());
usu.descricao_status = usu.id_status == 0 ? "INATIVO" : "ATIVO";
list.Add(usu);
}
leitor.Dispose();
}
catch (Exception ex)
{
throw new Exception("Problemas contate o administrador do sistema: \\n" + ex.Message);
}
finally
{
objConexao.Dispose();
}
return(list);
}
public List <UsuarioHistorico> ConsultarMovimentacao(UsuarioSistema user)
{
ConexaoOracle objConexao = new ConexaoOracle();
List <UsuarioHistorico> list = new List <UsuarioHistorico>();
UsuarioHistorico usu;
try
{
objConexao.AdicionarParametro("P_LOGIN", user.login);
objConexao.AdicionarParametroCursor("dados");
System.Data.OracleClient.OracleDataReader leitor = objConexao.ObterLeitor("FUN_PKG_USUARIO.LISTAR_MOVIMENTACAO_USUARIO");
while (leitor.Read())
{
usu = new UsuarioHistorico();
usu.nome = leitor["nome"].ToString();
usu.login = leitor["LOGIN"].ToString();
usu.dt_inclusao = DateTime.Parse(leitor["DT_INCLUSAO"].ToString());
usu.ds_justitificativa = leitor["ds_justificativa"].ToString();
usu.id_status = int.Parse(leitor["status"].ToString());
usu.descricao_status = usu.id_status == 0 ? "INATIVO" : "ATIVO";
list.Add(usu);
}
leitor.Dispose();
}
catch (Exception ex)
{
throw new Exception("Problemas contate o administrador do sistema: \\n" + ex.Message);
}
finally
{
objConexao.Dispose();
}
return(list);
}
protected override void GatherKeyColumns(
DBSqlParserTable table
)
{
// Called after the table and column information is completed to
// identify which columns in the select-list are key columns for
// their table.
OracleCommand cmd = null;
OracleDataReader rdr = null;
try {
try {
cmd = _connection.CreateCommand();
cmd.Transaction = _connection.Transaction; // must set the transaction context to be the same as the command, or we'll throw when we execute.
string schemaName = CatalogCase(table.SchemaName);
string tableName = CatalogCase(table.TableName);
string synonymSchemaName = schemaName;
string synonymTableName = tableName;
// First, we have to "dereference" a synonym, if it was specified, because
// synonyms don't have catalog items stored for them, they're for the table
// or view that the synonym references.
cmd.CommandText = GetSynonymQueryStatement(schemaName, tableName);
rdr = cmd.ExecuteReader();
if (rdr.Read())
{
synonymSchemaName = rdr.GetString(0);
synonymTableName = rdr.GetString(1);
}
rdr.Dispose();
// Now we have the real schema name and table name, go and derive the key
// columns
cmd.CommandText = GetConstraintQueryStatement(synonymSchemaName, synonymTableName);
rdr = cmd.ExecuteReader();
ArrayList constraintColumnNames = new ArrayList();
bool isUniqueConstraint;
if (true == (_moreConstraints = rdr.Read()))
{
while (GetConstraint(rdr, out isUniqueConstraint, constraintColumnNames))
{
bool foundAllColumns = true;
int constraintColumnCount = constraintColumnNames.Count;
DBSqlParserColumn[] constraintColumn = new DBSqlParserColumn[constraintColumnCount];
for (int j = 0; j < constraintColumnCount; ++j)
{
DBSqlParserColumn column = FindConstraintColumn(
schemaName,
tableName,
(string)constraintColumnNames[j]
);
if (null == column)
{
foundAllColumns = false;
break;
}
constraintColumn[j] = column;
}
if (foundAllColumns)
{
for (int j = 0; j < constraintColumnCount; ++j)
{
constraintColumn[j].SetAsKey(isUniqueConstraint);
}
break;
}
}
}
}
finally
{
if (null != cmd)
{
cmd.Dispose();
cmd = null;
}
if (null != rdr)
{
rdr.Dispose();
rdr = null;
}
}
}
catch { // Prevent exception filters from running in our space
throw;
}
}