public static OracleConnection RetornaConexao(OracleCon acesso, bool mensagem) { OracleConnection conexao = new OracleConnection(); try { var conString = "Data Source=" + "(DESCRIPTION=(ADDRESS=(PROTOCOL=" + Cripto.Decrypt(acesso.Protocol) + ")" + "(HOST=" + Cripto.Decrypt(acesso.Host) + ")(PORT=" + Cripto.Decrypt(acesso.Port) + "))" + "(CONNECT_DATA=(SERVICE_NAME=" + Cripto.Decrypt(acesso.ServiceName) + ")));" + "User Id = " + Cripto.Decrypt(acesso.User) + "; Password = "******"; "; conexao.ConnectionString = conString; conexao.Open(); //var retorno = conexao.State.ToString() == "Open" ? conexao : null; } catch (Exception e) { XtraMessageBox.Show("Não foi possível abrir a conexão com o Banco de Dados " + Cripto.Decrypt(acesso.SystemName) + "! \n" + e.Message, "Sem conexão", MessageBoxButtons.OK, MessageBoxIcon.Error); } if (mensagem && conexao.State.ToString() == "Open") { XtraMessageBox.Show("Conexão com o Banco de Dados " + Cripto.Decrypt(acesso.SystemName) + " efetuada com sucesso! \n", "Conexão", MessageBoxButtons.OK, MessageBoxIcon.Information); } return(conexao); }
public override List <Usuario> Read() { _comando = _conexao.ObterComando(); lista = new List <Usuario>(); try { _comando.CommandText = $"SELECT * FROM USUARIO"; using (var reader = _comando.ExecuteReader()) { while (reader.Read()) { lista.Add(new Usuario() { Id = Convert.ToInt32(reader["USUARIOID"]), NomeUsuario = reader["NOMEUSUARIO"].ToString(), Senha = Cripto.Decrypt(reader["SENHA"].ToString()), Ativo = Convert.ToInt32(reader["ATIVO"] ?? 0) == 1, DataCriacao = Convert.ToDateTime(reader["DATACRIACAO"]) }); } return(base.Read()); } } catch (Exception) { throw; } finally { _comando.Liberar(); } }
public override List <ContaCorrente> Read() { lista = new List <ContaCorrente>(); try { _comando = _conexao.ObterComando(); _comando.CommandText = @"SELECT * FROM CONTACORRENTE CC JOIN CORRENTISTA C ON C.CORRENTISTAID = CC.CORRENTISTAID"; using (var reader = _comando.ExecuteReader()) { while (reader.Read()) { var contacorrente = new ContaCorrente(); contacorrente.Id = Convert.ToInt32(reader["CONTACORRENTEID"]); contacorrente.Agencia = reader["AGENCIA"].ToString(); contacorrente.NumConta = reader["NUMCONTA"].ToString(); contacorrente.CorrentistaId = Convert.ToInt32(reader["CORRENTISTAID"]); contacorrente.Senha = Cripto.Decrypt(reader["SENHA"].ToString()); contacorrente.Correntista = new Correntista() { Id = Convert.ToInt32(reader["CORRENTISTAID"]), Nome = reader["NOME"].ToString(), CpfCnpj = reader["CPFCNPJ"].ToString(), Ativo = Convert.ToInt16(reader["ATIVO"] ?? 0) == 1, DataCriacao = Convert.ToDateTime(reader["DATACRIACAO"]) }; lista.Add(contacorrente); } return(lista); } } catch (Exception) { throw; } finally { _comando.Liberar(); } }
private void GetDados() { using (var contexto = new ContextSqlite()) { var systemName = "PIMS"; pims_Acesso = contexto.OracleCon.Find(Cripto.Encrypt(systemName)); edtServiceNamePims.Text = Cripto.Decrypt(pims_Acesso.ServiceName); edtHostPims.Text = Cripto.Decrypt(pims_Acesso.Host); edtPortPims.Text = Cripto.Decrypt(pims_Acesso.Port); edtUserPims.Text = Cripto.Decrypt(pims_Acesso.User); edtPasswordPims.Text = Cripto.Decrypt(pims_Acesso.Password); cboProtocolPims.Text = Cripto.Decrypt(pims_Acesso.Protocol); systemName = "SISMA"; sisma_Acesso = contexto.OracleCon.Find(Cripto.Encrypt(systemName)); edtServiceNameSisma.Text = Cripto.Decrypt(sisma_Acesso.ServiceName); edtHostSisma.Text = Cripto.Decrypt(sisma_Acesso.Host); edtPortSisma.Text = Cripto.Decrypt(sisma_Acesso.Port); edtUserSisma.Text = Cripto.Decrypt(sisma_Acesso.User); edtPasswordSisma.Text = Cripto.Decrypt(sisma_Acesso.Password); cboProtocolSisma.Text = Cripto.Decrypt(sisma_Acesso.Protocol); systemName = "MEGA"; mega_Acesso = contexto.OracleCon.Find(Cripto.Encrypt(systemName)); edtServiceNameMega.Text = Cripto.Decrypt(mega_Acesso.ServiceName); edtHostMega.Text = Cripto.Decrypt(mega_Acesso.Host); edtPortMega.Text = Cripto.Decrypt(mega_Acesso.Port); edtUserMega.Text = Cripto.Decrypt(mega_Acesso.User); edtPasswordMega.Text = Cripto.Decrypt(mega_Acesso.Password); cboProtocolMega.Text = Cripto.Decrypt(mega_Acesso.Protocol); systemName = "SENIOR"; senior_Acesso = contexto.OracleCon.Find(Cripto.Encrypt(systemName)); edtServiceNameSenior.Text = Cripto.Decrypt(senior_Acesso.ServiceName); edtHostSenior.Text = Cripto.Decrypt(senior_Acesso.Host); edtPortSenior.Text = Cripto.Decrypt(senior_Acesso.Port); edtUserSenior.Text = Cripto.Decrypt(senior_Acesso.User); edtPasswordSenior.Text = Cripto.Decrypt(senior_Acesso.Password); cboProtocolSenior.Text = Cripto.Decrypt(senior_Acesso.Protocol); } }
public async Task LerChavesAsync() { ChaveVisualizas = new List <ChaveVisualiza>(); BlockDeblockFolder(false); using StreamReader sr = new StreamReader(CaminhoFile); string line = string.Empty; int contline = 0; while ((line = await sr.ReadLineAsync()) != null) { try { string[] items = Cripto.Decrypt(line).Split(":-"); if (items.Count() >= 2) { ChaveVisualizas.Add(new ChaveVisualiza(new Chave { Id = int.Parse(items[0]) }, DateTime.Parse(items[1]))); } else { RetornoMensagem.Add("Erro na leitura do arquivo de ChaveVisualiza => Linha " + contline); } } catch (Exception) { RetornoMensagem.Add("Erro na leitura do arquivo de ChaveVisualiza => Linha " + contline); } contline++; } sr.Close(); BlockDeblockFolder(true); }
private void BtnOk_Click(object sender, EventArgs e) { using (var contexto = new ContextSqlite()) { sqliteuser = contexto.SqliteUsers.Find(Cripto.Encrypt(txtLogin.Text)); if (sqliteuser == null) { XtraMessageBox.Show("Usuário e/ou senha inválidos ", "Login", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); return; } if (txtPassword.Text != Cripto.Decrypt(sqliteuser.Password)) { XtraMessageBox.Show("Usuário e/ou senha inválidos ", "Login", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); return; } servTest = (Cripto.Decrypt(sqliteuser.LastBase) == "T"); loginUser = Cripto.Decrypt(sqliteuser.Login); var _permissions = Cripto.Decrypt(sqliteuser.Permissions); permissions = _permissions.Substring(_permissions.IndexOf("[") + 1, 5); //XtraMessageBox.Show(permissions, "Permissões", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); administrator = permissions.Substring(0, 1) == "S"; warehouse = permissions.Substring(1, 1) == "S"; if (!File.Exists(Directory.GetCurrentDirectory() + @"\Data\config.db")) { File.Copy(Directory.GetCurrentDirectory() + @"\sqlite.dll", Directory.GetCurrentDirectory() + @"\Data\config.db", true); } //servTest = false; //loginUser = "******"; //this.Hide(); frmManager frm = new frmManager(); frm.Show(); } }
string getField(GridView view, int listSourceRowIndex, string field) { string login = Cripto.Decrypt(Convert.ToString(view.GetListSourceRowCellValue(listSourceRowIndex, field))); return(login); }