private void btnListarTabelas_Click(object sender, EventArgs e)
{
bool verifica = false;
TiposDeBancoDeDados BD;
ControlaInterface controlainterface = new ControlaInterface();
if (tbcBD.SelectedTab.Text == "SqlServer")
{
BD = TiposDeBancoDeDados.SQLSERVER;
if (chkWindwsAuthentication.Checked)
{
if (cmbServeName.Text != string.Empty)
{
verifica = controlainterface.VerificaConexao(cmbServeName.Text, cmbDataBase.Text);
}
}
else
{
if (cmbServeName.Text != string.Empty
&& txtLogin.Text != string.Empty
&& txtSenha.Text != string.Empty)
{
verifica = controlainterface.VerificaConexao(cmbServeName.Text, cmbDataBase.Text,
txtLogin.Text, txtSenha.Text);
}
}
}
else
{
BD = TiposDeBancoDeDados.ORACLE;
verifica = controlainterface.VerificaConexao(@"(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=" + txtLocalHost.Text
+ ")(PORT=" + txtPorta.Text + ")))(CONNECT_DATA=(SERVICE_NAME=" + txtSID.Text + ")))",
txtNomeUsuario.Text, txtSenhaOralce.Text, BD);
}
if (verifica)
{
controlainterface.ListaTabelas(chkTabelas, BD, true);
}
}
private void Nenhum_Click(object sender, EventArgs e)
{
bool verifica = false;
ControlaInterface controlainterface = new ControlaInterface();
if (chkWindwsAuthentication.Checked)
{
if (cmbServeName.Text != string.Empty)
{
verifica = controlainterface.VerificaConexao(cmbServeName.Text, cmbDataBase.Text);
}
}
else
{
if (cmbServeName.Text != string.Empty
&& txtLogin.Text != string.Empty
&& txtSenha.Text != string.Empty)
{
verifica = controlainterface.VerificaConexao(cmbServeName.Text, cmbDataBase.Text,
txtLogin.Text, txtSenha.Text);
}
}
if (verifica)
{
controlainterface.ListaTabelas(chkTabelas, TiposDeBancoDeDados.SQLSERVER, false);
}
}