public void Listar(DNA.Entidades.Usuario usu, ref DataTable oDT)
{
try
{
ConexaoPersonalizada oConn = new ConexaoPersonalizada();
try
{
OracleParameter[] arParms = new OracleParameter[5];
arParms[0] = new OracleParameter();
arParms[0].ParameterName = "V_CURSOR";
arParms[0].OracleDbType = OracleDbType.RefCursor;
arParms[0].Direction = ParameterDirection.Output;
arParms[1] = new OracleParameter();
arParms[1].ParameterName = "P_ID_USUARIO";
arParms[1].OracleDbType = OracleDbType.Int64;
arParms[1].Direction = ParameterDirection.Input;
if (usu.IdUsuario == 0)
{
arParms[1].Value = DBNull.Value;
}
else
{
arParms[1].Value = usu.IdUsuario;
}
arParms[2] = new OracleParameter();
arParms[2].ParameterName = "P_LOGIN";
arParms[2].OracleDbType = OracleDbType.Varchar2;
arParms[2].Direction = ParameterDirection.Input;
arParms[2].Value = usu.LoginUsuario;
arParms[3] = new OracleParameter();
arParms[3].ParameterName = "P_SENHA";
arParms[3].OracleDbType = OracleDbType.Varchar2;
arParms[3].Direction = ParameterDirection.Input;
arParms[3].Value = usu.SenhaUsuario;
arParms[4] = new OracleParameter();
arParms[4].ParameterName = "P_FLAG_ATIVO";
arParms[4].OracleDbType = OracleDbType.Char;
arParms[4].Direction = ParameterDirection.Input;
arParms[4].Value = usu.FlagAtivo;
oConn.Execute("DNASITE.P_L_USUARIOS", arParms, ref oDT);
}
catch (Exception ex)
{ throw ex; }
finally
{
oConn.CloseConnection();
oConn = null;
}
}
catch (Exception ex)
{ throw ex; }
}
public void AlterarSenha(int idUsuarioAlteracao, DNA.Entidades.Usuario usu)
{
try
{
ConexaoPersonalizada oConn = new ConexaoPersonalizada();
try
{
OracleParameter[] arParms = new OracleParameter[9];
arParms[0] = new OracleParameter();
arParms[0].ParameterName = "P_ID_USUARIO_ALTERADO";
arParms[0].OracleDbType = OracleDbType.Int64;
arParms[0].Direction = ParameterDirection.Input;
if (usu.IdUsuario == 0)
{
arParms[0].Value = DBNull.Value;
}
else
{
arParms[0].Value = usu.IdUsuario;
}
arParms[1] = new OracleParameter();
arParms[1].ParameterName = "P_ID_USUARIO_ALTERACAO";
arParms[1].OracleDbType = OracleDbType.Int64;
arParms[1].Direction = ParameterDirection.Input;
arParms[1].Value = idUsuarioAlteracao;
arParms[2] = new OracleParameter();
arParms[2].ParameterName = "P_NOVO_NOME";
arParms[2].OracleDbType = OracleDbType.Varchar2;
arParms[2].Direction = ParameterDirection.Input;
if (usu.NomeUsuario.Length == 0)
{
arParms[2].Value = DBNull.Value;
}
else
{
arParms[2].Value = usu.NomeUsuario;
}
arParms[3] = new OracleParameter();
arParms[3].ParameterName = "P_NOVO_LOGIN";
arParms[3].OracleDbType = OracleDbType.Varchar2;
arParms[3].Direction = ParameterDirection.Input;
if (usu.LoginUsuario.Length == 0)
{
arParms[3].Value = DBNull.Value;
}
else
{
arParms[3].Value = usu.LoginUsuario;
}
arParms[4] = new OracleParameter();
arParms[4].ParameterName = "P_NOVA_SENHA";
arParms[4].OracleDbType = OracleDbType.Varchar2;
arParms[4].Direction = ParameterDirection.Input;
if (usu.SenhaUsuario.Length == 0)
{
arParms[4].Value = DBNull.Value;
}
else
{
arParms[4].Value = usu.SenhaUsuario;
}
arParms[5] = new OracleParameter();
arParms[5].ParameterName = "P_NOVO_EMAIL1";
arParms[5].OracleDbType = OracleDbType.Varchar2;
arParms[5].Direction = ParameterDirection.Input;
if (usu.Email1.Length == 0)
{
arParms[5].Value = DBNull.Value;
}
else
{
arParms[5].Value = usu.Email1;
}
arParms[6] = new OracleParameter();
arParms[6].ParameterName = "P_NOVO_EMAIL2";
arParms[6].OracleDbType = OracleDbType.Varchar2;
arParms[6].Direction = ParameterDirection.Input;
if (usu.Email2.Length == 0)
{
arParms[6].Value = DBNull.Value;
}
else
{
arParms[6].Value = usu.Email2;
}
arParms[7] = new OracleParameter();
arParms[7].ParameterName = "P_NOVO_OBSERVACAO";
arParms[7].OracleDbType = OracleDbType.Varchar2;
arParms[7].Direction = ParameterDirection.Input;
if (usu.Observacao.Length == 0)
{
arParms[7].Value = DBNull.Value;
}
else
{
arParms[7].Value = usu.Observacao;
}
arParms[8] = new OracleParameter();
arParms[8].ParameterName = "P_FLAG_ATIVO";
arParms[8].OracleDbType = OracleDbType.Char;
arParms[8].Direction = ParameterDirection.Input;
if (usu.FlagAtivo.Length == 0)
{
arParms[8].Value = DBNull.Value;
}
else
{
arParms[8].Value = usu.FlagAtivo;
}
oConn.Execute("DNAINFO.P_U_USUARIO", arParms);
oConn.Commit();
}
catch (Exception ex)
{
oConn.Rollback();
throw ex;
}
finally
{
oConn.CloseConnection();
oConn = null;
}
}
catch (Exception ex)
{ throw ex; }
}
