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