public frmSessoes()
{
InitializeComponent();
_Username = "";
_Password = "";
_Database = "";
this.Text = "Sessões - NÃO CONECTADO";
lvwColumnSorter = new csListViewColumnSorter();
}
public frmScriptAgendado()
{
InitializeComponent();
lvwColumnSorter = new csListViewColumnSorter();
lvwAgendamentos.ListViewItemSorter = lvwColumnSorter;
lvwColumnSorter.SortColumn = 0;
_csAgendaDeScripts = new csAgendaDeScripts(_CaminhoArquivoAgenda);
this.AtualizarListaAgendamentos();
}
public frmJobs()
{
InitializeComponent();
this._PropriedadesPadrao();
_Username = "";
_Password = "";
_Database = "";
lvwColumnSorter = new csListViewColumnSorter();
this.lvwJobs.ListViewItemSorter = lvwColumnSorter;
this.Text = "Jobs de banco - NÃO CONECTADO";
}
public frmExtractUser()
{
InitializeComponent();
_Username = "";
_Password = "";
_Database = "";
this.PreencheComboOwners();
// Create an instance of a ListView column sorter and assign it
// to the ListView control.
lvwColumnSorter = new csListViewColumnSorter();
this.lvwUsuarios.ListViewItemSorter = lvwColumnSorter;
this.Text = "Extract User Oracle - NÃO CONECTADO";
}
public frmSessoes(string p_Username, string p_Password, string p_Database)
{
InitializeComponent();
_Username = p_Username;
_Password = p_Password;
_Database = p_Database;
lvwSessoes.ListViewItemSorter = lvwColumnSorter;
string _Mensagem = "";
string _InfoBanco = "";
_InfoBanco = _csOracle.InfoBanco(_Username, _Password, _Database, ref _Mensagem);
if (_Mensagem.Length == 0)
{
this.Text = "Sessões - " + _InfoBanco;
}
lvwColumnSorter = new csListViewColumnSorter();
}
public frmJobs(string p_Username, string p_Password, string p_Database)
{
InitializeComponent();
this._PropriedadesPadrao();
_Username = p_Username;
_Password = p_Password;
_Database = p_Database;
lvwColumnSorter = new csListViewColumnSorter();
this.lvwJobs.ListViewItemSorter = lvwColumnSorter;
string _Mensagem = "";
string _InfoBanco = "";
_InfoBanco = _csOracle.InfoBanco(_Username, _Password, _Database, ref _Mensagem);
if (_Mensagem.Length == 0)
{
this.Text = "Jobs de banco - " + _InfoBanco;
}
}
public frmExtractUser(string p_Username, string p_Password, string p_Database)
{
InitializeComponent();
_Username = p_Username;
_Password = p_Password;
_Database = p_Database;
this.PreencheComboOwners();
this.PreencheComboProfiles();
// Create an instance of a ListView column sorter and assign it
// to the ListView control.
lvwColumnSorter = new csListViewColumnSorter();
this.lvwUsuarios.ListViewItemSorter = lvwColumnSorter;
string _Mensagem = "";
string _InfoBanco = "";
_InfoBanco = _csOracle.InfoBanco(_Username, _Password, _Database, ref _Mensagem);
if (_Mensagem.Length == 0)
{
this.Text = "Extract User Oracle - " + _InfoBanco;
}
}
private void _PropriedadesPadrao()
{
// Create an instance of a ListView column sorter and assign it
// to the ListView control.
lvwColumnSorter = new csListViewColumnSorter();
this.lvwJobs.ListViewItemSorter = lvwColumnSorter;
object _ObjColocarCabecalhoAoExtrairDDL = csUtil.CarregarPreferencia("ColocarCabecalhoAoExtrairDDL");
string _ColocarCabecalhoAoExtrairDDL = null;
if (_ObjColocarCabecalhoAoExtrairDDL == null)
{
csUtil.SalvarPreferencia("ColocarCabecalhoAoExtrairDDL", "1");
}
else
{
_ColocarCabecalhoAoExtrairDDL = _ObjColocarCabecalhoAoExtrairDDL.ToString().Trim().ToUpper();
if (_ColocarCabecalhoAoExtrairDDL != "1" && _ColocarCabecalhoAoExtrairDDL != "0" && _ColocarCabecalhoAoExtrairDDL != "TRUE" && _ColocarCabecalhoAoExtrairDDL != "FALSE" && _ColocarCabecalhoAoExtrairDDL != "SIM" && _ColocarCabecalhoAoExtrairDDL != "NÃO")
{
csUtil.SalvarPreferencia("ColocarCabecalhoAoExtrairDDL", "1");
}
}
}
public frmBackupsControleConcorrencia(string p_Usuario, string p_Senha, string p_Database, string p_OwnerNomeObj)
{
InitializeComponent();
_Username = p_Usuario;
_Password = p_Senha;
_Database = p_Database;
_OwnerNomeObj = p_OwnerNomeObj;
this.Text = "Backups do objeto " + p_OwnerNomeObj;
lvwColumnSorterBackups = new csListViewColumnSorter();
this.lvwBackups.ListViewItemSorter = lvwColumnSorterBackups;
if (_csOracle.ConectouNoBanco(_Username, _Password, _Database))
{
this.Show();
Application.DoEvents();
this.PreencheListaBackups();
}
else
{
MessageBox.Show("Problemas para conectar no banco de dados\nUsuario: " + _Username + "\nDatabase: " + _Database, "Lista Backups", MessageBoxButtons.OK, MessageBoxIcon.Error);
this.Hide();
}
}