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