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); }