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