public static SqlConnection GetConnection() { var servidor = ConfigIniUtil.Read("SERVIDOR", "servidor"); var banco = ConfigIniUtil.Read("SERVIDOR", "banco"); var instancia = ConfigIniUtil.Read("SERVIDOR", "instancia"); var porta = ConfigIniUtil.Read("SERVIDOR", "porta"); var usuario = ConfigIniUtil.Read("SERVIDOR", "usuario"); var senha = ConfigIniUtil.Read("SERVIDOR", "senha"); var dataSource = new StringBuilder(); dataSource.Append(servidor); if (string.IsNullOrEmpty(instancia)) { dataSource.Append(","); dataSource.Append(porta); } else { dataSource.Append(@"\"); dataSource.Append(instancia); } _connectionStringBuilder.DataSource = dataSource.ToString(); _connectionStringBuilder.InitialCatalog = banco; _connectionStringBuilder.IntegratedSecurity = true; var conn = new SqlConnection(_connectionStringBuilder.ConnectionString); conn.Open(); return(conn); }
public override void ProcessaVerificacao() { var connectionString = string.Empty; var connectionStringController = new ConnectionStringController(); var config = new Config { Servidor = ConfigIniUtil.Read("SERVIDOR", "servidor"), Banco = ConfigIniUtil.Read("SERVIDOR", "banco"), Instancia = ConfigIniUtil.Read("SERVIDOR", "instancia"), Porta = Convert.ToInt32(ConfigIniUtil.Read("SERVIDOR", "porta")), Usuario = ConfigIniUtil.Read("SERVIDOR", "usuario"), Senha = ConfigIniUtil.Read("SERVIDOR", "senha"), TokenApi = ConfigIniUtil.Read("MUNDIPAGG", "basicAuthUserName") }; connectionString = connectionStringController.MontaConnectionString(config); SistemaSingleton.Instancia.TokenApi = config.TokenApi; if (!connectionStringController.TestConnectionString(connectionString) || String.IsNullOrEmpty(config.TokenApi)) { new FrmConfigConexaoBanco().ShowDialog(); Environment.Exit(0); } }
private void FrmConfigConexaoBanco_Load(object sender, EventArgs e) { txtServidor.Text = ConfigIniUtil.Read("SERVIDOR", "servidor"); txtBanco.Text = ConfigIniUtil.Read("SERVIDOR", "banco"); txtInstancia.Text = ConfigIniUtil.Read("SERVIDOR", "instancia"); nupPorta.Text = ConfigIniUtil.Read("SERVIDOR", "porta"); txtUsuario.Text = ConfigIniUtil.Read("SERVIDOR", "usuario"); txtSenha.Text = ConfigIniUtil.Read("SERVIDOR", "senha"); txtTokenApi.Text = ConfigIniUtil.Read("MUNDIPAGG", "basicAuthUserName"); }
public void SalvarDadosConfiguracao(Config config) { // Sessão SERVIDOR ConfigIniUtil.Write("SERVIDOR", "servidor", config.Servidor); ConfigIniUtil.Write("SERVIDOR", "banco", config.Banco); ConfigIniUtil.Write("SERVIDOR", "porta", config.Porta.ToString()); ConfigIniUtil.Write("SERVIDOR", "senha", config.Senha); // Sessão MUNDIPAGG ConfigIniUtil.Write("MUNDIPAGG", "basicAuthUserName", config.TokenApi); }
private void btnSalvar_Click(object sender, EventArgs e) { var config = ObterDadosConfiguracao(); if (ValidacaoUtil.ValidarModelo(config)) { ConfigIniUtil.Write("SERVIDOR", "servidor", config.Servidor); ConfigIniUtil.Write("SERVIDOR", "banco", config.Banco); ConfigIniUtil.Write("SERVIDOR", "instancia", config.Instancia); ConfigIniUtil.Write("SERVIDOR", "porta", config.Porta.ToString()); ConfigIniUtil.Write("SERVIDOR", "usuario", config.Usuario); ConfigIniUtil.Write("SERVIDOR", "senha", config.Senha); ConfigIniUtil.Write("MUNDIPAGG", "basicAuthUserName", config.TokenApi); } Close(); }
public override void ProcessaVerificacao() { if (!File.Exists(filePath)) { using (File.Create(filePath)) { } // Sessão SERVIDOR ConfigIniUtil.Write("SERVIDOR", "servidor", ""); ConfigIniUtil.Write("SERVIDOR", "banco", ""); ConfigIniUtil.Write("SERVIDOR", "instancia", ""); ConfigIniUtil.Write("SERVIDOR", "porta", ""); ConfigIniUtil.Write("SERVIDOR", "usuario", ""); ConfigIniUtil.Write("SERVIDOR", "senha", ""); // Sessão MUNDIPAGG ConfigIniUtil.Write("MUNDIPAGG", "basicAuthUserName", ""); new FrmConfigConexaoBanco().ShowDialog(); Environment.Exit(0); } ProximaVerificacao.ProcessaVerificacao(); }