private void GetDados()
{
using (var contexto = new ContextSqlite())
{
var sqliteusers = contexto.SqliteUsers.ToList().Where(c => c.Login != "Reuber");
grdSqliteUsers.DataSource = sqliteusers;
}
}
private void btnSaveConfig_Click(object sender, EventArgs e)
{
using (var contexto = new ContextSqlite())
{
contexto.OracleCon.Attach(senior_Acesso);
contexto.OracleCon.Attach(pims_Acesso);
contexto.OracleCon.Attach(mega_Acesso);
contexto.OracleCon.Attach(sisma_Acesso);
SetDados("SENIOR");
SetDados("PIMS");
SetDados("MEGA");
SetDados("SISMA");
contexto.SaveChanges();
}
}
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();
}
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();
}
}
