public IndexForm(Form parent, string indexName, DBRegistrationClass dbReg, List <TableClass> tables, eBearbeiten mode) { InitializeComponent(); this.MdiParent = parent; BearbeitenMode = mode; _dbReg = dbReg; if (mode == eBearbeiten.eInsert) { IndexName = "NEW_INDEX_INX1"; NewIndexName = "NEW_INDEX_INX1"; TableName = tables[0].Name; } else { IndexName = indexName; NewIndexName = indexName; TableName = RefreshIndicesAndGetTablename(); } _localNotify.Notify.OnRaiseErrorHandler += Notify_OnRaiseErrorHandler; _localNotify.Notify.OnRaiseInfoHandler += Notify_OnRaiseInfoHandler; _tables = tables; TableObject = StaticTreeClass.GetTableObjectForIndexForm(_dbReg, TableName); cbFields.Items.Clear(); lvFields.Items.Clear(); DataFilled = true; }
public IMPORTDataForm(Form parent, DBRegistrationClass drc) { InitializeComponent(); this.MdiParent = parent; localNotify = new NotifiesClass() { ErrorGranularity = eMessageGranularity.never }; localNotify.Register4Info(InfoRaised); localNotify.Register4Error(ErrorRaised); DBReg = drc; var tableObjects = StaticTreeClass.Instance().GetAllNonSystemTableObjectsComplete(DBReg); if (tableObjects.Count <= 0) { return; } foreach (var tc in tableObjects.Values) { selTables.Add(tc.ToString(), CheckState.Unchecked, tc); } selTables.CheckChecks(); SelectAllTableFields(); }
private int MakeSQLNew() { var SQLScript = new List <string>(); SQLScript.Clear(); SQLScript = StaticTreeClass.MakeSQLCreateProcedure(_procedureObject, true); SQLToUI(SQLScript); return(SQLScript.Count); }
private int MakeSQLAlter() { var SQLScript = new List <string>(); SQLScript.Clear(); SQLScript = StaticTreeClass.Instance().MakeSQLAlterProcedure(_procedureObject, _procedureObjectOld, true); SQLToUI(SQLScript); return(SQLScript.Count); }
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; }
public void MakeSQL() { SQLScript = (BearbeitenMode == StateClasses.EditStateClass.eBearbeiten.eEdit) ? StaticTreeClass.Instance().MakeSQLAlterFunction(FunctionObject, OldFunctionObject, true) : StaticTreeClass.Instance().MakeSQLCreateFunction(FunctionObject, true); SQLToUI(SQLScript); ShowCaptions(); hsCreate.Enabled = (txtFuncName.Text.Length > 0); }
public string[] DatabaseViewFields(string view) { var words = new List <string>(); var actViewFields = StaticTreeClass.Instance().GetViewFieldObjects(_dbReg, view); foreach (var tcf in actViewFields.Values) { words.Add(tcf.Name); } return(words.ToArray()); }
public string[] DatabaseTableFields(string table) { var words = new List <string>(); var actTable = StaticTreeClass.Instance().GetTableObjectFromName(_dbReg, table); foreach (var tcf in actTable.Fields.Values) { words.Add(tcf.Name); } return(words.ToArray()); }
public void FillCombos() { var domains = StaticTreeClass.Instance().GetDomainObjects(_dbReg); cbDOMAIN.Items.Clear(); foreach (DomainClass domain in domains.Values) { cbDOMAIN.Items.Add(domain); } cbDOMAIN.Text = ""; }
public void GetSourceFieldsFromTableObject(string SourceTableName) { cbSourceTableFields.Items.Clear(); if (SourceTableName.Length > 0) { var DestFds = StaticTreeClass.GetTableObjectFromName(_dbReg, SourceTableName).Fields; foreach (TableFieldClass dstr in DestFds.Values) { cbSourceTableFields.Items.Add(dstr.Name); } } // cbSourceTableFieldNames.Text = ForeignKeyObject.FieldName; }
private void EventsForm_Load(object sender, EventArgs e) { FormDesign.SetFormLeft(this); triggers = StaticTreeClass.Instance().GetAllTriggerObjects(_dbReg); lvEvents.Items.Clear(); SetCombo(); LoadUserDesign(); DataToEdit(); ClearDevelopDesign(FbXpertMainForm.Instance().DevelopDesign); SetDesign(FbXpertMainForm.Instance().AppDesign); RefreshLanguageText(); Restart(); }
public ConstraintForm(Form parent, string indexName, DBRegistrationClass dbReg) { InitializeComponent(); this.MdiParent = parent; _dbReg = dbReg; IndexName = indexName; NewIndexName = indexName; _localNotify.Notify.OnRaiseErrorHandler += Notify_OnRaiseErrorHandler; _localNotify.Notify.OnRaiseInfoHandler += Notify_OnRaiseInfoHandler; TableName = RefreshIndicesAndGetTablename(); TableObject = StaticTreeClass.GetTableObjectForConstraintForm(_dbReg, TableName); }
private void RefreshStatistics() { List <string> data = StaticTreeClass.GetDatabaseStatistics(dbReg); rtbInfo.Clear(); info.Clear(); info.Append(pre); foreach (string str in data) { this.AddLine(str); } this.Set(); this.SetTitle("Statistics for " + dbReg.Alias); }
private void EventsForm_Load(object sender, EventArgs e) { triggers = StaticTreeClass.GetAllTriggerObjects(_dbReg); lvEvents.Items.Clear(); SetCombo(); LoadUserDesign(); DataToEdit(); ClearDevelopDesign(FbXpertMainForm.Instance().DevelopDesign); SetDesign(FbXpertMainForm.Instance().AppDesign); ac = new AutocompleteClass(fctSQL, _dbReg); ac.RefreshAutocompleteForDatabase(); RefreshLanguageText(); Restart(); }
public void RefreshXml() { _ddc.Tables = StaticTreeClass.Instance().GetAllNonSystemTableObjectsComplete(_dbReg); _ddc.Views = StaticTreeClass.Instance().GetViewObjects(_dbReg); StaticTreeClass.Instance().GetAllTablePrimaryKeyObjects(_dbReg, _ddc.Tables); _ddc.Database = _dbReg; var fs = new FileStream(ApplicationPathClass.Instance.ApplicationPath + "\\temp\\tmp.xml", FileMode.Create); var serializer = new ConfigurationContainer().Create(); var xml = serializer.Serialize(fs, _ddc); // var serializer = new XmlSerializer(typeof(DatabaseDesignClass)); // var fs = new FileStream(ApplicationPathClass.Instance.ApplicationPath + "\\temp\\tmp.xml", FileMode.Create); //serializer.Serialize(_ddc,ApplicationPathClass.Instance.ApplicationPath + "\\temp\\tmp.xml"); fs.Close(); xmlEditStruktur.LoadXmlFromFile(ApplicationPathClass.Instance.ApplicationPath + "\\temp\\tmp.xml"); }
public void FillCombos() { var domains = StaticTreeClass.Instance().GetDomainObjects(_dbReg); cbDOMAIN.Items.Clear(); foreach (DomainClass domain in domains.Values) { cbDOMAIN.Items.Add(domain); } cbDOMAIN.Text = ""; cbFieldTypes.Items.Clear(); DBTypeList dbList = new DBTypeList(); foreach (DBDataTypes dt in dbList.Values) { cbFieldTypes.Items.Add(dt); } }
public void RefreshAutocompleteForDatabase() { //create autocomplete popup menu var actTables = StaticTreeClass.GetAllTableObjects(_dbReg); var actSystemTables = StaticTreeClass.GetSystemTableObjects(_dbReg); var actViews = StaticTreeClass.GetViewObjects(_dbReg); _popupMenu = new AutocompleteMenu(_txtBox) { MinFragmentLength = 1 }; var words = new List <string>(); words.AddRange(SqlCommands()); words.AddRange(DatabaseTables(actTables)); words.AddRange(DatabaseViews(actViews)); words.AddRange(DatabaseSystemTables(actSystemTables)); if (actTables != null) { words.AddRange(DatabaseTableFields(actTables)); } if (actViews != null) { words.AddRange(DatabaseViewFields(actViews)); } if (actSystemTables != null) { words.AddRange(DatabaseSystemTableFields(actSystemTables)); } _popupMenu.SearchPattern = @"[\w\.$]"; _popupMenu.Items.SetAutocompleteItems(words); _popupMenu.AllowTabKey = true; //size of popupmenu _popupMenu.Items.MaximumSize = new System.Drawing.Size(400, 500); _popupMenu.Items.Width = 400; }
public IndexForm(Form parent, string indexName, DBRegistrationClass dbReg, List <TableClass> tables, eBearbeiten mode) { InitializeComponent(); this.MdiParent = parent; BearbeitenMode = mode; _dbReg = dbReg; cbFields.Items.Clear(); lvFields.Items.Clear(); string TableName = string.Empty; if (mode == eBearbeiten.eInsert) { TableName = tables[0].Name; _orgIndexObject = new IndexClass(); _orgIndexObject.Name = "NEW_INDEX_INX1"; _orgIndexObject.IsActive = true; } else { TableName = RefreshIndicesAndGetTablename(indexName); _tableObject = tables.Find(X => X.Name == TableName); _tableObject.Indices.TryGetValue(indexName, out _orgIndexObject); } _indexObject = _orgIndexObject; _indexActiveChanged = false; _localNotify.Notify.OnRaiseErrorHandler += Notify_OnRaiseErrorHandler; _localNotify.Notify.OnRaiseInfoHandler += Notify_OnRaiseInfoHandler; _tables = tables; _tableObject = StaticTreeClass.Instance().GetTableObjectForIndexForm(_dbReg, TableName); _orgTableObject = _tableObject; FillSortingToCombo(); _dataFilled = true; }
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; }
public NotNullForm(Form parent, DBRegistrationClass dbReg, TreeNode tn, ContextMenuStrip cmGroup, ContextMenuStrip cm) { InitializeComponent(); this.MdiParent = parent; _dbReg = dbReg; Cm = cm; CmGroup = cmGroup; Tn = tn; TreeNode t = StaticTreeClass.FindPrevDBNode(Tn); TreeNode orgTableNode = StaticTreeClass.FindPrevTableNode(Tn); TreeNode TableNode = StaticTreeClass.FindFirstNodeInAllNodes(t, StaticVariablesClass.CommonTablesKeyGroupStr); //Bei insert if (Tn.Tag == null) { NotNullObject = new NotNullsClass(); NotNullObject.Name = "NEW_CNSTR"; NotNullObject.ConstraintType = eConstraintType.NOTNULL; } else { NotNullObject = Tn.Tag as NotNullsClass; } if (orgTableNode != null) { OrgTable = orgTableNode.Tag as TableClass; NotNullObject.TableName = OrgTable.Name; } Tables = StaticTreeClass.GetTableObjectsFromNode(TableNode); _localNotify.Notify.OnRaiseErrorHandler += Notify_OnRaiseErrorHandler; _localNotify.Notify.OnRaiseInfoHandler += Notify_OnRaiseInfoHandler; }
public void ExportAllViewsSQL() { progressBar1.Minimum = 0; progressBar1.Value = 0; int n = 0; if (ckCreateFunction.Checked) { n++; } if (ckAlterFunction.Checked) { n++; } progressBar1.Maximum = Functions.Count * n; string path = Path.Combine(txtSQLExportPath.Text); if (!Directory.Exists(path)) { Directory.CreateDirectory(path); } if (!Directory.Exists(path)) { return; } if (ckDeleteAllFiles.Checked) { string[] fls = Directory.GetFiles(path, "*.sql"); foreach (string fn in fls) { try { File.Delete(fn); } catch (Exception ex) { Console.WriteLine(ex.Message); } } } foreach (var Function in Functions.Values) { try { if (ckAlterFunction.Checked) { string fna = Path.Combine(path, $@"{Function.Name}_alter.sql"); List <string> txt = StaticTreeClass.Instance().MakeSQLAlterFunction(Function, Function, true); File.WriteAllLines(fna, txt); progressBar1.Value++; } if (ckCreateFunction.Checked) { string fnc = Path.Combine(path, $@"{Function.Name}_create.sql"); List <string> txt = StaticTreeClass.Instance().MakeSQLCreateFunction(Function, true); File.WriteAllLines(fnc, txt); progressBar1.Value++; } } catch (Exception ex) { Console.WriteLine(ex.Message); break; } } }
public EXPORTDataForm(Form parent, DBRegistrationClass drc) { InitializeComponent(); this.MdiParent = parent; localNotify = new NotifiesClass() { NotifyType = eNotifyType.ErrorWithoutMessage, AllowErrors = false }; localNotify.Notify.OnRaiseInfoHandler += new NotifyInfos.RaiseNotifyHandler(InfoRaised); localNotify.Notify.OnRaiseErrorHandler += new NotifyInfos.RaiseNotifyHandler(ErrorRaised); DBReg = drc; var viewobjects = StaticTreeClass.GetViewObjects(DBReg); var tableObjects = StaticTreeClass.GetAllTableObjectsComplete(DBReg); var domainObjects = StaticTreeClass.GetDomainObjects(DBReg); var generatorObjects = StaticTreeClass.GetGeneratorObjects(DBReg); var indecesObjects = StaticTreeClass.GetIndecesObjects(DBReg); var triggerObjects = StaticTreeClass.GetTriggerObjects(DBReg); //var procedureObjects = StaticTreeClass.GetAllProcedureObjects(DBReg); var procedureObjects = StaticTreeClass.GetProcedureObjects(DBReg); var functionObjects = StaticTreeClass.GetInternalFunctionObjects(DBReg); if (tableObjects.Count <= 0) { return; } foreach (var tc in tableObjects.Values) { selTables.Add(tc.ToString(), CheckState.Unchecked, tc); } selTables.CheckChecks(); foreach (var tc in tableObjects.Values) { selStructureTables.Add(tc.ToString(), CheckState.Unchecked, tc); } selStructureTables.CheckChecks(); SelectAllTableFields(); foreach (var tc in viewobjects.Values) { selStructureViews.Add(tc.ToString(), CheckState.Unchecked, tc); } selStructureViews.CheckChecks(); foreach (var tc in domainObjects.Values) { if ((tc.ToString().StartsWith("RDB$")) || (tc.ToString().StartsWith("SEC$")) || (tc.ToString().StartsWith("MON$"))) { continue; } selDomains.Add(tc.ToString(), CheckState.Unchecked, tc); } selDomains.CheckChecks(); foreach (var tc in generatorObjects.Values) { if ((tc.ToString().StartsWith("RDB$")) || (tc.ToString().StartsWith("SEC$")) || (tc.ToString().StartsWith("MON$"))) { continue; } selGenerators.Add(tc.ToString(), CheckState.Unchecked, tc); } selGenerators.CheckChecks(); foreach (var tc in triggerObjects.Values) { selTriggerStructure.Add(tc.ToString(), CheckState.Unchecked, tc); } selTriggerStructure.CheckChecks(); foreach (var tc in indecesObjects.Values) { selIndeces.Add(tc.ToString(), CheckState.Unchecked, tc); } selIndeces.CheckChecks(); foreach (var tc in procedureObjects.Values) { selProceduresStructure.Add(tc.ToString(), CheckState.Unchecked, tc); } selProceduresStructure.CheckChecks(); foreach (var tc in functionObjects.Values) { selFunctionsStructure.Add(tc.ToString(), CheckState.Unchecked, tc); } selFunctionsStructure.CheckChecks(); var itm = selTables.ItemDatas[0] as ItemDataClass; TableObject = itm.Object as TableClass; selExportStructureList.AllowMultipleChecks = true; selExportStructureList.Add("Domains", CheckState.Checked, new DomainClass()); selExportStructureList.Add("UDFs", CheckState.Checked, new UserDefinedFunctionClass()); selExportStructureList.Add("Generators", CheckState.Checked, new GeneratorClass()); selExportStructureList.Add("Procedures", CheckState.Checked, new ProcedureClass()); selExportStructureList.Add("Functions", CheckState.Checked, new FunctionClass()); selExportStructureList.Add("Tables", CheckState.Checked, new TableClass()); selExportStructureList.Add("Views", CheckState.Checked, new ViewClass()); selExportStructureList.Add("Check constraints", CheckState.Checked, new ChecksClass()); selExportStructureList.Add("Unique constraints", CheckState.Checked, new UniquesClass()); selExportStructureList.Add("Primary keys", CheckState.Checked, new PrimaryKeyClass()); selExportStructureList.Add("Foreign keys", CheckState.Checked, new ForeignKeyClass()); selExportStructureList.Add("Indices", CheckState.Checked, new IndexClass()); selExportStructureList.Add("Triggers", CheckState.Checked, new TriggerClass()); selExportStructureList.Add("UDF descriptions", CheckState.Checked, new object()); selExportStructureList.Add("Generator descriptions", CheckState.Checked, new object()); selExportStructureList.Add("Procedure descriptions", CheckState.Checked, new object()); selExportStructureList.Add("Table descriptions", CheckState.Checked, new object()); selExportStructureList.Add("Table field descriptions", CheckState.Checked, new object()); selExportStructureList.Add("View descriptions", CheckState.Checked, new object()); selExportStructureList.Add("View field descriptions", CheckState.Checked, new object()); selExportStructureList.Add("Index descriptions", CheckState.Checked, new object()); selExportStructureList.Add("Trigger descriptions", CheckState.Checked, new object()); selExportStructureList.Add("Procedure parameter descriptions", CheckState.Checked, new object()); }
public string[] DatabaseTableFields() { var actTables = StaticTreeClass.GetAllTableObjects(_dbReg); return(DatabaseTableFields(actTables)); }
public void MakeSQL() { SQLScript = StaticTreeClass.MakeSQLDeclareUserDefinedFunction(UserDefinedFunctionObject, OldUserDefinedFunctionObject, true); SQLToUI(SQLScript); ShowCaptions(); }
public string[] DatabaseSystemTables() { var actTables = StaticTreeClass.GetSystemTableObjects(_dbReg); return(DatabaseSystemTables(actTables)); }
public string[] DatabaseSystemTableFields() { var actSystemTables = StaticTreeClass.Instance().GetAllSystemTableObjects(_dbReg); return(DatabaseSystemTableFields(actSystemTables)); }
public string[] DatabaseViews() { var actViews = StaticTreeClass.Instance().GetViewObjects(_dbReg); return(DatabaseViews(actViews)); }