private void GetDatabaseObjects2(DBRegistrationClass dbR)
{
if (dbR == null)
{
return;
}
this.Cursor = Cursors.WaitCursor;
var db = dbR.Clone();
var ddc = new DatabaseDesignClass
{
Tables = StaticTreeClass.Instance().GetAllNonSystemTableObjectsComplete(db),
Views = StaticTreeClass.Instance().GetViewObjects(db)
};
var generators = StaticTreeClass.Instance().GetGeneratorObjects(db);
var procedures = StaticTreeClass.Instance().GetProcedureObjects(db);
var functions = StaticTreeClass.Instance().GetFunctionObjects(db);
slbDbObjects2.ClearItems();
if (ddc.Tables != null)
{
foreach (var tc in ddc.Tables.Values)
{
slbDbObjects2.Add($@"TABLE.{tc.Name}", CheckState.Checked, tc);
}
}
if (ddc.Views != null)
{
foreach (var tc in ddc.Views.Values)
{
slbDbObjects2.Add($@"VIEW.{tc.Name}", CheckState.Checked, tc);
}
}
if (generators != null)
{
foreach (var tc in generators.Values)
{
slbDbObjects2.Add($@"GEN.{tc.Name}", CheckState.Checked, tc);
}
}
if (procedures != null)
{
foreach (var tc in procedures.Values)
{
slbDbObjects2.Add($@"PROC.{tc.Name}", CheckState.Checked, tc);
}
}
if (functions != null)
{
foreach (var tc in functions.Values)
{
slbDbObjects2.Add($@"FUNC.{tc.Name}", CheckState.Checked, tc);
}
}
this.Cursor = Cursors.Default;
}
private void GetDatabaseObjects1(DBRegistrationClass dbR)
{
if (dbR == null)
{
return;
}
this.Cursor = Cursors.WaitCursor;
var db = dbR.Clone();
var ddc = new DatabaseDesignClass
{
Tables = StaticTreeClass.GetAllTableObjectsComplete(db),
Views = StaticTreeClass.GetViewObjects(db)
};
var generators = StaticTreeClass.GetGeneratorObjects(db);
var procedures = StaticTreeClass.GetProcedureObjects(db);
slbDbObjects1.ClearItems();
foreach (var tc in ddc.Tables.Values)
{
slbDbObjects1.Add($@"TABLE.{tc.Name}", CheckState.Checked, tc);
}
foreach (var tc in ddc.Views.Values)
{
slbDbObjects1.Add($@"VIEW.{tc.Name}", CheckState.Checked, tc);
}
foreach (var tc in generators.Values)
{
slbDbObjects1.Add($@"GEN.{tc.Name}", CheckState.Checked, tc);
}
foreach (var tc in procedures.Values)
{
slbDbObjects1.Add($@"PROC.{tc.Name}", CheckState.Checked, tc);
}
this.Cursor = Cursors.Default;
}
