public bool DoIt() { BDConexao conexao = new BDConexao(); conexao.connection.Open(); conexao.command.Parameters.Clear(); conexao.command.CommandText = "SELECT idCliente,nome FROM Cliente WHERE EMAIL = @EMAIL AND SENHA = @SENHA"; conexao.command.Parameters.Add("@EMAIL", SqlDbType.VarChar).Value = Email; conexao.command.Parameters.Add("@SENHA", SqlDbType.VarChar).Value = StatueStoreEncrypt.Encrypt(Senha); System.Data.SqlClient.SqlDataReader dr = conexao.command.ExecuteReader(); if (dr.HasRows) { dr.Read(); HttpContext.Current.Session["idUsuario"] = dr.GetInt32(0); HttpContext.Current.Session["nomeUsuario"] = dr.GetString(1); conexao.connection.Close(); return(true); } conexao.connection.Close(); return(false); }
public int BdSetClient() { BDConexao conexao = new BDConexao(); conexao.connection.Open(); conexao.command.CommandText = "INSERT INTO CLIENTE OUTPUT INSERTED.IDCLIENTE VALUES " + "(@EMAIL, @SENHA, @NOME, @SOBRENOME, @SEXO, @CPF, @DATANASC, @DATAINSC, null)"; conexao.command.Parameters.Clear(); conexao.command.Parameters.Add("@EMAIL", SqlDbType.VarChar).Value = Email; conexao.command.Parameters.Add("@SENHA", SqlDbType.VarChar).Value = StatueStoreEncrypt.Encrypt(Senha); conexao.command.Parameters.Add("@NOME", SqlDbType.VarChar).Value = Nome; conexao.command.Parameters.Add("@SOBRENOME", SqlDbType.VarChar).Value = Sobrenome; conexao.command.Parameters.Add("@SEXO", SqlDbType.VarChar).Value = TrataSexo(Sexo); conexao.command.Parameters.Add("@CPF", SqlDbType.VarChar).Value = Cpf.Trim().Replace(".", "").Replace("-", "").Replace(" ", ""); conexao.command.Parameters.Add("@DATANASC", SqlDbType.Date).Value = DataNascimento; conexao.command.Parameters.Add("@DATAINSC", SqlDbType.Date).Value = DataInscricao; int idCliente = (int)conexao.command.ExecuteScalar(); conexao.connection.Close(); EnviarEmailParaCliente(Email, Nome); return(idCliente); }
public void AlterarSenha(string novaSenha) { BDConexao conexao = new BDConexao(); conexao.connection.Open(); conexao.command.Parameters.Clear(); conexao.command.CommandText = "UPDATE CLIENTE SET SENHA = @NOVASENHA WHERE IDCLIENTE = @IDCLIENTE"; conexao.command.Parameters.Add("@IDCLIENTE", SqlDbType.Int).Value = (int)HttpContext.Current.Session["idUsuario"]; conexao.command.Parameters.Add("@NOVASENHA", SqlDbType.VarChar).Value = StatueStoreEncrypt.Encrypt(novaSenha); conexao.command.ExecuteNonQuery(); conexao.connection.Close(); }
public void RedefinirSenhaPorkey(string key, string novaSenha) { BDConexao conexao = new BDConexao(); conexao.connection.Open(); conexao.command.Parameters.Clear(); conexao.command.CommandText = "UPDATE CLIENTE SET senha = @SENHA WHERE codSenha = @CODSENHA"; conexao.command.Parameters.Add("@SENHA", SqlDbType.VarChar).Value = StatueStoreEncrypt.Encrypt(novaSenha); conexao.command.Parameters.Add("@CODSENHA", SqlDbType.VarChar).Value = key; conexao.command.ExecuteNonQuery(); conexao.connection.Close(); }
public void CadastraCartao() { BDConexao conexao = new BDConexao(); conexao.connection.Open(); conexao.command.CommandText = "DELETE FROM CARTAOCREDITO WHERE IDCLIENTE = @ID"; conexao.command.Parameters.Clear(); conexao.command.Parameters.Add("@ID", SqlDbType.VarChar).Value = IdCliente; conexao.command.ExecuteNonQuery(); conexao.command.CommandText = "INSERT INTO CARTAOCREDITO VALUES(@BANDEIRA, @NUMCARTAO, @CVV, @VALIDADE, @IDCLIENTE, @TITULAR)"; conexao.command.Parameters.Clear(); conexao.command.Parameters.Add("@BANDEIRA", SqlDbType.VarChar).Value = StatueStoreEncrypt.Encrypt(Bandeira); conexao.command.Parameters.Add("@NUMCARTAO", SqlDbType.VarChar).Value = StatueStoreEncrypt.Encrypt(NumeroCartao.ToString().Trim().Replace(".", "").Replace("-", "").Replace(" ", "")); conexao.command.Parameters.Add("@CVV", SqlDbType.VarChar).Value = StatueStoreEncrypt.Encrypt(CVV.Trim().Replace(".", "").Replace("-", "").Replace(" ", "")); conexao.command.Parameters.Add("@VALIDADE", SqlDbType.VarChar).Value = StatueStoreEncrypt.Encrypt(Validade); conexao.command.Parameters.Add("@IDCLIENTE", SqlDbType.VarChar).Value = IdCliente; conexao.command.Parameters.Add("@TITULAR", SqlDbType.VarChar).Value = StatueStoreEncrypt.Encrypt(Titular); conexao.command.ExecuteNonQuery(); conexao.connection.Close(); }
public bool verificaSenha(string senha) { BDConexao conexao = new BDConexao(); conexao.connection.Open(); conexao.command.Parameters.Clear(); conexao.command.CommandText = "SELECT COUNT(*) FROM CLIENTE WHERE IDCLIENTE = @IDCLIENTE AND SENHA = @SENHA"; conexao.command.Parameters.Add("@IDCLIENTE", SqlDbType.Int).Value = (int)HttpContext.Current.Session["idUsuario"];; conexao.command.Parameters.Add("@SENHA", SqlDbType.VarChar).Value = StatueStoreEncrypt.Encrypt(senha); int ok = (int)conexao.command.ExecuteScalar(); conexao.connection.Close(); if (ok == 0) { return(false); } else { return(true); } }
public string UltimosDigitos() { BDConexao conexao = new BDConexao(); conexao.connection.Open(); conexao.command.CommandText = "SELECT numCartao FROM CARTAOCREDITO WHERE IDCLIENTE = @ID"; conexao.command.Parameters.Clear(); conexao.command.Parameters.Add("@ID", SqlDbType.Int).Value = (int)HttpContext.Current.Session["idUsuario"]; string numero = string.Empty; System.Data.SqlClient.SqlDataReader dr = conexao.command.ExecuteReader(); if (dr.HasRows) { dr.Read(); numero = StatueStoreEncrypt.Decrypt(dr.GetString(0)); } conexao.connection.Close(); dr.Close(); return(numero.Substring(numero.Length - 4, 4)); }