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