public Usuario obterPeloEmail(string email)
{
string str = "select * from USUARIO Where UPPER(NOM_EMAIL) = " + Bd.aspas(email.ToUpper());
dt.Clear();
OracleDataAdapter da = new OracleDataAdapter(str, Bd.Instance.obterConexao());
OracleCommandBuilder cb = new OracleCommandBuilder(da);
da.Fill(dt);
if (dt.Rows.Count > 0)
{
return(modeloPelaEntidade(dt.Rows[0]));
}
return(null);
}
private OracleDataAdapter obterAdapter(UsuarioId usuarioId)
{
string str = "select * from USUARIO";
if (usuarioId != null)
{
str += " Where USUARIO_ID = " + Bd.aspas(usuarioId.Id);
}
dt.Clear();
OracleDataAdapter da = new OracleDataAdapter(str, Bd.Instance.obterConexao());
OracleCommandBuilder cb = new OracleCommandBuilder(da);
da.Fill(dt);
return(da);
}
public Usuario usuarioPelaCredencialAutenticacao(string usuario, string senha)
{
string str = "select * from USUARIO Where UPPER(NOM_USUARIO) = " +
Bd.aspas(usuario.ToUpper()) + " And UPPER(NOM_SENHA) = " + Bd.aspas(senha.ToUpper());
dt.Clear();
OracleDataAdapter da = new OracleDataAdapter(str, Bd.Instance.obterConexao());
OracleCommandBuilder cb = new OracleCommandBuilder(da);
da.Fill(dt);
if (dt.Rows.Count > 0)
{
return(modeloPelaEntidade(dt.Rows[0]));
}
return(null);
}
