private void FrmLogin_KeyDown(object sender, KeyEventArgs e) { if (e.KeyCode == Keys.F12) { this.Hide(); FrmConfiguracaoSQL frmConfiguracaoSQL = new FrmConfiguracaoSQL(); frmConfiguracaoSQL.ShowDialog(); Application.Exit(); } }
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); } }
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(); } }
private void conexãoSQLToolStripMenuItem_Click(object sender, EventArgs e) { FrmConfiguracaoSQL frmConfiguracaoSQL = new FrmConfiguracaoSQL(); frmConfiguracaoSQL.ShowDialog(); }