private void CreateView_Load(object sender, EventArgs e)
{
Vista = new MyView();
Vista.Inicializar();
var connectionData = Padre.GetConnectionInformation();
var tablas = FbObjetos.GetTables(connectionData);
var misTablas = tablas.Select("TABLE_NAME <> ''");
var arrayTablas = misTablas.Select(row => ((string)row["TABLE_NAME"])).ToArray(); //
comboBox1.DataSource = arrayTablas;
}
private void CreateTrigger_Load(object sender, EventArgs e)
{
Trigger = new Trigger();
cmbTipo.DataSource = Enum.GetValues((typeof(TriggerType)));
cmbEvento.DataSource = Enum.GetValues((typeof(TriggerEvent)));
var connectionData = Padre.GetConnectionInformation();
var tablas = FbObjetos.GetTables(connectionData);
var misTablas = tablas.Select("TABLE_NAME <> ''");
var arrayTablas = misTablas.Select(row => ((string)row["TABLE_NAME"])).ToArray(); //
cmbTabla.DataSource = arrayTablas;
}
private void TableForeignKey_Load(object sender, EventArgs e)
{
Llave = new ForeignKey();
foreach (var campo in Tabla.Tabla.Campos)
{
// cmbField
cmbField.Items.Add(campo.Nombre);
}
// cmbField.DataSource = Tabla.Tabla.Campos;
var connectionData = Tabla.GetConnectionInformation();
var tablas = FbObjetos.GetTables(connectionData);
var misTablas = tablas.Select("TABLE_NAME <> ''");
var arrayTablas = misTablas.Select(row => ((string)row["TABLE_NAME"])).ToArray(); //
cmbForeignTable.DataSource = arrayTablas;
}
public void SetTreeValues(ConnectionData connData)
{
var tablas = FbObjetos.GetTables(connData);
var dominios = FbObjetos.GetDomains(connData);
var funciones = FbObjetos.GetFunctions(connData);
var generadores = FbObjetos.GetGenerators(connData);
var procedimientos = FbObjetos.GetProcedures(connData);
var triggers = FbObjetos.GetTriggers(connData);
var vistas = FbObjetos.GetViews(connData);
//GETTING TABLES
var misTablas = tablas.Select("TABLE_NAME <> ''");
var arrayTablas = misTablas.Select(row => new TreeNode((string)row["TABLE_NAME"])).ToArray(); //
var treeNode = new TreeNode("Tablas", arrayTablas);
treeView1.Nodes.Add(treeNode);
foreach (TreeNode child in treeNode.Nodes)
{
//SETTIG COLUMNS TO EACH TABLE
var a = child.Text;
var col = FbObjetos.GetColumns(connData, a);
var misCs = col.Select("COLUMN_NAME <> ''");
var arrayCols = misCs.Select(row => new TreeNode((string)row["COLUMN_NAME"])).ToArray(); //
child.Nodes.Add(new TreeNode("Columnas", arrayCols));
//SETTIG primnary TO EACH TABLE
var pri = FbObjetos.GetPrimaryKeys(connData, a);
var misPri = pri.Select("COLUMN_NAME <> '' ");
var arrPri = misPri.Select(row => new TreeNode((string)row["COLUMN_NAME"])).ToArray(); //
child.Nodes.Add(new TreeNode("Primarias", arrPri));
//SETTIG INDEXES TO EACH TABLE
var ind = FbObjetos.GetIndexes(connData, a);
var misIn = ind.Select("INDEX_NAME <> '' AND IS_PRIMARY = FALSE");
var arrIn = misIn.Select(row => new TreeNode((string)row["INDEX_NAME"])).ToArray(); //
child.Nodes.Add(new TreeNode("Indices", arrIn));
//SETTIG FOREIGN KEYS TO EACH TABLE
var fora = FbObjetos.GetForeignKeys(connData);
var misFora = fora.Select("CONSTRAINT_NAME <> '' AND TABLE_NAME ='" + a + "'");
var arrFora = misFora.Select(row => new TreeNode((string)row["CONSTRAINT_NAME"])).ToArray(); //
child.Nodes.Add(new TreeNode("Foráneas", arrFora));
//SETTIG triggers KEYS TO EACH TABLE
var tr = FbObjetos.GetTriggers(connData);
var misTr = tr.Select("TRIGGER_NAME <> '' AND TABLE_NAME ='" + a + "' AND IS_SYSTEM_TRIGGER = 0");
var arrTr = misTr.Select(row => new TreeNode((string)row["TRIGGER_NAME"])).ToArray(); //
child.Nodes.Add(new TreeNode("Triggers", arrTr));
}
//GETTING DOMAINS
var misDominios = dominios.Select("DOMAIN_NAME <> ''");
var arrayDominios = misDominios.Select(row => new TreeNode((string)row["DOMAIN_NAME"])).ToArray(); //
treeNode = new TreeNode("Dominios", arrayDominios);
treeView1.Nodes.Add(treeNode);
//GETTING FUNCTIONS
var misFunciones = funciones.Select("IS_SYSTEM_FUNCTION = 0 ");
var arrayFunciones = misFunciones.Select(row => new TreeNode((string)row["FUNCTION_NAME"])).ToArray(); //
treeNode = new TreeNode("Funciones", arrayFunciones);
treeView1.Nodes.Add(treeNode);
//GETTING GENERATORS
var misGeneradores = generadores.Select("IS_SYSTEM_GENERATOR = 0");
var arrayGeneradores = misGeneradores.Select(row => new TreeNode((string)row["GENERATOR_NAME"])).ToArray(); //
treeNode = new TreeNode("Generadores", arrayGeneradores);
treeView1.Nodes.Add(treeNode);
//GETTING PROCEDURES
var misProcedimientos = procedimientos.Select("IS_SYSTEM_PROCEDURE = 0");
var arrayProcedimientos = misProcedimientos.Select(row => new TreeNode((string)row["PROCEDURE_NAME"])).ToArray();
//
treeNode = new TreeNode("Procedimientos", arrayProcedimientos);
treeView1.Nodes.Add(treeNode);
//GETTING TRIGGERS
var misTriggers = triggers.Select("IS_SYSTEM_TRIGGER = 0 ");
var arrayTriggers = misTriggers.Select(row => new TreeNode((string)row["TRIGGER_NAME"])).ToArray(); //
treeNode = new TreeNode("Triggers", arrayTriggers);
treeView1.Nodes.Add(treeNode);
//GETTING VIEWS
var misVistas = vistas.Select("IS_SYSTEM_VIEW = 0");
var arrayVistas = misVistas.Select(row => new TreeNode((string)row["VIEW_NAME"])).ToArray(); //
treeNode = new TreeNode("Vistas", arrayVistas);
treeView1.Nodes.Add(treeNode);
nuevoObejtoToolStripMenuItem.Enabled = true;
foreach (TreeNode child in treeNode.Nodes)
{
//SETTIG COLUMNS TO EACH VIEW
var a = child.Text;
var col = FbObjetos.GetViewColumns(connData, a);
var misCs = col.Select("COLUMN_NAME <> '' AND VIEW_NAME = '" + a + "'");
var arrayCols = misCs.Select(row => new TreeNode((string)row["COLUMN_NAME"])).ToArray(); //
child.Nodes.Add(new TreeNode("Columnas", arrayCols));
}
}
