void Carregar()
{
modelConfiguracaoSQL = controllerConfiguracaoSQL.Carregar();
txtServidorBD.Text = modelConfiguracaoSQL.ServidorBD;
txtNomeBD.Text = modelConfiguracaoSQL.NomeBD;
txtIDBD.Text = modelConfiguracaoSQL.IDBD;
txtSenhaBD.Text = modelConfiguracaoSQL.SenhaBD;
modelConfiguracaoSQLCentral = controllerConfiguracaoSQLCentral.Carregar();
txtServidorBDCentral.Text = modelConfiguracaoSQLCentral.ServidorBD;
txtNomeBDCentral.Text = modelConfiguracaoSQLCentral.NomeBD;
txtIDTecSistemas.Text = modelConfiguracaoSQLCentral.IDTecSistemas;
txtSenhaTecSistemas.Text = modelConfiguracaoSQLCentral.SenhaTecSistemas;
}
static void Main()
{
ControllerConfiguracaoSQLCentral controllerConfiguracaoSQLCentral = new ControllerConfiguracaoSQLCentral();
ModelConfiguracaoSQLCentral modelConfiguracaoSQLCentral = controllerConfiguracaoSQLCentral.Carregar();
ControllerConfiguracaoSQL controllerConfiguracaoSQL = new ControllerConfiguracaoSQL();
ModelConfiguracaoSQL modelConfiguracaoSQL = new ModelConfiguracaoSQL();
string instrucao = string.Format(@"SELECT * FROM tbCadastro WHERE idTecSistemas = '" + modelConfiguracaoSQLCentral.IDTecSistemas + "' AND senhaTecSistemas = '" + modelConfiguracaoSQLCentral.SenhaTecSistemas + "' AND status = '1' AND dataVencimento > CURRENT_TIMESTAMP");
SqlCommand command;
try
{
command = new SqlCommand(instrucao, controllerConfiguracaoSQLCentral.Conectar());
}
catch (Exception ex)
{
var result = MessageBox.Show(ex.Message + "\n\nVerificar conexão?", "Erro!", MessageBoxButtons.YesNo, MessageBoxIcon.Error);
if (result == DialogResult.Yes)
{
FrmConfiguracaoSQL frmConfiguracaoSQL = new FrmConfiguracaoSQL();
frmConfiguracaoSQL.ShowDialog();
}
return;
}
SqlDataReader sqlDataReader = command.ExecuteReader();
if (sqlDataReader.HasRows)
{
string conexaoBanco = string.Format(@"SELECT servidorBD, nomeBD, idBD, senhaBD FROM tbCadastro WHERE idTecSistemas = '" + modelConfiguracaoSQLCentral.IDTecSistemas + "'");
SqlCommand command1 = new SqlCommand(conexaoBanco, controllerConfiguracaoSQLCentral.Conectar());
SqlDataReader sqlDataReader1 = command1.ExecuteReader();
sqlDataReader1.Read();
modelConfiguracaoSQL.ServidorBD = sqlDataReader1["servidorBD"].ToString();
modelConfiguracaoSQL.NomeBD = sqlDataReader1["nomeBD"].ToString();
modelConfiguracaoSQL.IDBD = sqlDataReader1["idBD"].ToString();
modelConfiguracaoSQL.SenhaBD = sqlDataReader1["senhaBD"].ToString();
controllerConfiguracaoSQL.SalvarConexao(modelConfiguracaoSQL);
ModelLogin modelLogin = new ModelLogin();
Application.EnableVisualStyles();
Application.SetCompatibleTextRenderingDefault(false);
Application.Run(new FrmLogin(modelLogin));
}
else
{
MessageBox.Show("O sistema está desativado ou vencido, entre em contato com o desenvolvedor.", "Alerta!", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
public bool Conectar(ModelConfiguracaoSQLCentral modelConfiguracaoSQLCentral)
{
try
{
Properties.SettingsSQLCentral.Default.ServidorBD = modelConfiguracaoSQLCentral.ServidorBD;
Properties.SettingsSQLCentral.Default.NomeBD = modelConfiguracaoSQLCentral.NomeBD;
Properties.SettingsSQLCentral.Default.IDBD = modelConfiguracaoSQLCentral.IDBD;
Properties.SettingsSQLCentral.Default.SenhaBD = modelConfiguracaoSQLCentral.SenhaBD;
Properties.SettingsSQLCentral.Default.IDTecSistemas = modelConfiguracaoSQLCentral.IDTecSistemas;
Properties.SettingsSQLCentral.Default.SenhaTecSistemas = modelConfiguracaoSQLCentral.SenhaTecSistemas;
Properties.SettingsSQLCentral.Default.Save();
return(true);
}
catch
{
throw new Exception();
}
}
static void Main()
{
ControllerConfiguracaoSQLCentral controllerConfiguracaoSQLCentral = new ControllerConfiguracaoSQLCentral();
ModelConfiguracaoSQLCentral modelConfiguracaoSQLCentral = controllerConfiguracaoSQLCentral.Carregar();
string instrucao = string.Format(@"SELECT * FROM tbCadastro WHERE idTecSistemas = '" + modelConfiguracaoSQLCentral.IDTecSistemas + "' AND senhaTecSistemas = '" + modelConfiguracaoSQLCentral.SenhaTecSistemas + "' AND status = '1' AND dataVencimento > CURRENT_TIMESTAMP");
SqlCommand command = new SqlCommand(instrucao, controllerConfiguracaoSQLCentral.Conectar());
SqlDataReader sqlDataReader = command.ExecuteReader();
if (sqlDataReader.HasRows)
{
ModelLogin modelLogin = new ModelLogin();
Application.EnableVisualStyles();
Application.SetCompatibleTextRenderingDefault(false);
Application.Run(new FrmLogin(modelLogin));
}
else
{
MessageBox.Show("O sistema está desativado ou vencido, entre em contato com o desenvolvedor.", "Alerta!", MessageBoxButtons.OK, MessageBoxIcon.Information);
FrmConfiguracaoSQL frmConfiguracaoSQL = new FrmConfiguracaoSQL();
frmConfiguracaoSQL.ShowDialog();
}
}
