public async Task GravarAsync()
{
chaveVisualizaServices.ChaveVisualizas = new List <ChaveVisualiza>();
BlockDeblockFolder(false);
using StreamWriter sw = new StreamWriter(CaminhoFile);
Chaves.ForEach(async item =>
{
if (item.ChaveVisualizas != null)
{
chaveVisualizaServices.ChaveVisualizas.AddRange(item.ChaveVisualizas);
}
string line = $"{item.Id}:-{item.Nome}:-{item.Senha}:-{item.Observacao}:-{item.DataCadastro}";
await sw.WriteLineAsync(Cripto.Encrypt(line));
});
sw.Close();
BlockDeblockFolder(true);
chaveVisualizaServices.Gravar();
await LerChavesAsync();
}
private void SetDados(string systemName)
{
switch (systemName)
{
case "PIMS":
{
pims_Acesso.Host = Cripto.Encrypt(edtHostPims.Text);
pims_Acesso.User = Cripto.Encrypt(edtUserPims.Text);
pims_Acesso.Password = Cripto.Encrypt(edtPasswordPims.Text);
pims_Acesso.Port = Cripto.Encrypt(edtPortPims.Text);
pims_Acesso.Protocol = Cripto.Encrypt(cboProtocolPims.Text);
pims_Acesso.ServiceName = Cripto.Encrypt(edtServiceNamePims.Text);
break;
}
case "MEGA":
{
mega_Acesso.Host = Cripto.Encrypt(edtHostMega.Text);
mega_Acesso.User = Cripto.Encrypt(edtUserMega.Text);
mega_Acesso.Password = Cripto.Encrypt(edtPasswordMega.Text);
mega_Acesso.Port = Cripto.Encrypt(edtPortMega.Text);
mega_Acesso.Protocol = Cripto.Encrypt(cboProtocolMega.Text);
mega_Acesso.ServiceName = Cripto.Encrypt(edtServiceNameMega.Text);
break;
}
case "SISMA":
{
sisma_Acesso.Host = Cripto.Encrypt(edtHostSisma.Text);
sisma_Acesso.User = Cripto.Encrypt(edtUserSisma.Text);
sisma_Acesso.Password = Cripto.Encrypt(edtPasswordSisma.Text);
sisma_Acesso.Port = Cripto.Encrypt(edtPortSisma.Text);
sisma_Acesso.Protocol = Cripto.Encrypt(cboProtocolSisma.Text);
sisma_Acesso.ServiceName = Cripto.Encrypt(edtServiceNameSisma.Text);
break;
}
case "SENIOR":
{
senior_Acesso.Host = Cripto.Encrypt(edtHostSenior.Text);
senior_Acesso.User = Cripto.Encrypt(edtUserSenior.Text);
senior_Acesso.Password = Cripto.Encrypt(edtPasswordSenior.Text);
senior_Acesso.Port = Cripto.Encrypt(edtPortSenior.Text);
senior_Acesso.Protocol = Cripto.Encrypt(cboProtocolSenior.Text);
senior_Acesso.ServiceName = Cripto.Encrypt(edtServiceNameSenior.Text);
break;
}
}
}
public void Gravar()
{
BlockDeblockFolder(false);
using StreamWriter sw = new StreamWriter(CaminhoFile);
ChaveVisualizas.ForEach(async item =>
{
string line = $"{item.Chave.Id}:-{item.DataVisualizada}";
await sw.WriteLineAsync(Cripto.Encrypt(line));
});
sw.Close();
BlockDeblockFolder(true);
}
public override void Update(Usuario pObjeto)
{
var sql = @"UPDATE USUARIO SET NOMEUSUARIO = @NOMEUSUARIO, SENHA = @SENHA, ATIVO = @ATIVO
WHERE USUARIOID = @USUARIOID";
try
{
_comando = _conexao.ObterComando();
_comando.CommandText = sql;
_comando.Parameters.Add(new SQLiteParameter("USUARIOID", pObjeto.Id));
_comando.Parameters.Add(new SQLiteParameter("NOMEUSUARIO", pObjeto.NomeUsuario));
_comando.Parameters.Add(new SQLiteParameter("SENHA", Cripto.Encrypt(pObjeto.Senha)));
_comando.Parameters.Add(new SQLiteParameter("ATIVO", pObjeto.Ativo ? 1 : 0));
_comando.ExecuteNonQuery();
}
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);
}
}
private void BtnSave_Click(object sender, EventArgs e)
{
//checar dados
// não deixar desativar o usuário admin
sqliteuser.Login = Cripto.Encrypt(txtLogin.Text);
sqliteuser.User = Cripto.Encrypt(txtUser.Text);
sqliteuser.Password = Cripto.Encrypt(txtPassword.Text);
sqliteuser.Permissions = Cripto.Encrypt(txtLogin.Text + "[" + TrueFalse(chkAdministrador)
+ TrueFalse(chkAlmoxarifado)
+ TrueFalse(chkAgricola)
+ "NN]");
sqliteuser.LastBase = Cripto.Encrypt("P");
sqliteuser.Active = Cripto.Encrypt(TrueFalse(chkAtivo));
using (var contexto = new ContextSqlite())
{
contexto.SqliteUsers.Add(sqliteuser);
contexto.SaveChanges();
}
GetDados();
}
public override void Update(ContaCorrente pObjeto)
{
var sql = @"UPDATE CONTACORRENTE SET AGENCIA = @AGENCIA, NUMCONTA = @NUMCONTA, CORRENTISTAID = @CORRENTISTAID,
SENHA = @SENHA WHERE CONTACORRENTEID = @CONTACORRENTEID";
try
{
_comando = _conexao.ObterComando();
_comando.CommandText = sql;
_comando.Parameters.Add(new SQLiteParameter("CONTACORRENTEID", pObjeto.Id));
_comando.Parameters.Add(new SQLiteParameter("AGENCIA", pObjeto.Agencia));
_comando.Parameters.Add(new SQLiteParameter("NUMCONTA", pObjeto.NumConta));
_comando.Parameters.Add(new SQLiteParameter("CORRENTISTAID", pObjeto.CorrentistaId));
_comando.Parameters.Add(new SQLiteParameter("SENHA", Cripto.Encrypt(pObjeto.Senha)));
_comando.ExecuteNonQuery();
}
finally
{
_comando.Liberar();
}
}
public override void Create(ContaCorrente pObjeto)
{
pObjeto.Id = ObterProxSequencial();
pObjeto.DataCriacao = DateTime.Now;
var sql = @"INSERT INTO CONTACORRENTE (AGENCIA, NUMCONTA, CORRENTISTAID, SENHA) VALUES (@AGENCIA, @NUMCONTA, @CORRENTISTAID, @SENHA)";
try
{
_comando = _conexao.ObterComando();
_comando.CommandText = sql;
_comando.Parameters.Add(new SQLiteParameter("AGENCIA", pObjeto.Agencia));
_comando.Parameters.Add(new SQLiteParameter("NUMCONTA", pObjeto.NumConta));
_comando.Parameters.Add(new SQLiteParameter("SENHA", Cripto.Encrypt(pObjeto.Senha)));
_comando.Parameters.Add(new SQLiteParameter("CORRENTISTAID", pObjeto.CorrentistaId));
_comando.ExecuteNonQuery();
}
finally
{
_comando.Liberar();
}
}
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();
}
}
public override void Create(Usuario pObjeto)
{
pObjeto.Id = ObterProxSequencial();
pObjeto.DataCriacao = DateTime.Now;
var sql = @"INSERT INTO USUARIO (USUARIOID, NOMEUSUARIO, SENHA, ATIVO, DATACRIACAO)
VALUES (@USUARIOID, @NOMEUSUARIO, @SENHA, @ATIVO, @DATACRIACAO)";
try
{
_comando = _conexao.ObterComando();
_comando.CommandText = sql;
_comando.Parameters.Add(new SQLiteParameter("USUARIOID", pObjeto.Id));
_comando.Parameters.Add(new SQLiteParameter("NOMEUSUARIO", pObjeto.NomeUsuario));
_comando.Parameters.Add(new SQLiteParameter("SENHA", Cripto.Encrypt(pObjeto.Senha)));
_comando.Parameters.Add(new SQLiteParameter("ATIVO", pObjeto.Ativo ? 1 : 0));
_comando.Parameters.Add(new SQLiteParameter("DATACRIACAO", pObjeto.DataCriacao));
_comando.ExecuteNonQuery();
}
finally
{
_comando.Liberar();
}
}
protected override void Seed(ContextSqlite context)
{
context.OracleCon.Add(new OracleCon
{
SystemName = Cripto.Encrypt("PIMS"),
ServiceName = Cripto.Encrypt("PROD.LOCAL"),
Protocol = Cripto.Encrypt("TCP"),
Host = Cripto.Encrypt("192.168.0.71"),
User = Cripto.Encrypt("PIMSCS"),
Password = Cripto.Encrypt("deployuipj"),
Port = Cripto.Encrypt("1521")
});
context.OracleCon.Add(new OracleCon
{
SystemName = Cripto.Encrypt("SISMA"),
ServiceName = Cripto.Encrypt("SISMA.LOCAL"),
Protocol = Cripto.Encrypt("TCP"),
Host = Cripto.Encrypt("192.168.0.5"),
User = Cripto.Encrypt("system"),
Password = Cripto.Encrypt("l7xCNiKbty"),
Port = Cripto.Encrypt("1521")
});
context.OracleCon.Add(new OracleCon
{
SystemName = Cripto.Encrypt("MEGA"),
ServiceName = Cripto.Encrypt("SERRA.LOCAL"),
Protocol = Cripto.Encrypt("TCP"),
Host = Cripto.Encrypt("192.168.0.71"),
User = Cripto.Encrypt("system"),
Password = Cripto.Encrypt("l7xCNiKbty"),
Port = Cripto.Encrypt("1521")
});
context.OracleCon.Add(new OracleCon
{
SystemName = Cripto.Encrypt("SENIOR"),
ServiceName = Cripto.Encrypt("FSENIOR.LOCAL"),
Protocol = Cripto.Encrypt("TCP"),
Host = Cripto.Encrypt("192.168.0.6"),
User = Cripto.Encrypt("rhvetorh"),
Password = Cripto.Encrypt("rhvetorh"),
Port = Cripto.Encrypt("1521")
});
context.SqliteUsers.Add(new SqliteUsers
{
Login = Cripto.Encrypt("Reuber"),
User = Cripto.Encrypt("Reuber Abdias de Moura Junior"),
Password = Cripto.Encrypt("@Admin123$"),
Permissions = Cripto.Encrypt("Reuber[SSSSS]"),
LastBase = Cripto.Encrypt("P"),
Active = Cripto.Encrypt("S")
});
context.SqliteUsers.Add(new SqliteUsers
{
Login = Cripto.Encrypt("Admin"),
User = Cripto.Encrypt("Administrador"),
Password = Cripto.Encrypt("@Ipojuca2"),
Permissions = Cripto.Encrypt("Admin[SSSSS]"),
LastBase = Cripto.Encrypt("P"),
Active = Cripto.Encrypt("S")
});
/*context.SqlServerCon.Add(new SqlServerCon
* {
* Id = 1,
* ServerNameProduction = Cripto.Encrypt("TI-CPU-03\\SQLSERVER17"),
* UserProduction = Cripto.Encrypt("sa"),
* PasswordProduction = Cripto.Encrypt("@Admin123$"),
* ServerNameTest = Cripto.Encrypt("(localdb)\\mssqllocaldb"),
* UserTest = Cripto.Encrypt("sa"),
* PasswordTest = Cripto.Encrypt("@Admin123$")
* });*/
base.Seed(context);
}
