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