public ScriptingForm(DBRegistrationClass drc)
{
InitializeComponent();
MdiParent = FbXpertMainForm.Instance();
_actScriptingDbReg = drc;
_lastDirectory = AppSettingsClass.Instance.PathSettings.ScriptingPath;
_notifies.Register4Info(FormMeldungRaised);
_notifies.Register4Error(FormErrorRaised);
fcbSQL.Clear();
fcbSQL.SelectionStart = 0;
string _connstr = ConnectionStrings.Instance.MakeConnectionString(_actScriptingDbReg);
_sql = new DBBasicClassLibrary.SQLScriptingClass(_connstr, AppSettingsClass.Instance.SQLVariables.GetNewLine(), AppSettingsClass.Instance.SQLVariables.CommentStart, AppSettingsClass.Instance.SQLVariables.CommentEnd, AppSettingsClass.Instance.SQLVariables.SingleLineComment, "SCRIPT");
_sql.ScriptNotify.Register4Info(EventMeldungRaised);
}
public UniqueForm(Form parent, DBRegistrationClass dbReg, List <TableClass> tables, NotNullsClass notnullObject, ContextMenuStrip cmGroup, ContextMenuStrip cm)
{
InitializeComponent();
this.MdiParent = parent;
_dbReg = dbReg;
_tables = tables;
Cm = cm;
CmGroup = cmGroup;
if (notnullObject == null)
{
NotNullObject = new NotNullsClass();
NotNullObject.Name = "NEW_CNSTR";
NotNullObject.ConstraintType = eConstraintType.NOTNULL;
}
else
{
NotNullObject = notnullObject;
}
OrgTable = tables.Find(X => X.Name == notnullObject.TableName);
NotNullObject.TableName = OrgTable.Name;
_localNotify.Register4Error(Notify_OnRaiseErrorHandler);
_localNotify.Register4Info(Notify_OnRaiseInfoHandler);
}
public FieldForm(DBRegistrationClass dbReg, Form parent, TreeNode tableNode, TableFieldClass fieldObject, NotifiesClass lnotify, StateClasses.EditStateClass.eBearbeiten bearbeitenMode)
{
InitializeComponent();
DataFilled = false;
this.MdiParent = parent;
_dbReg = dbReg;
TableNode = tableNode;
var tc = (TableClass)tableNode.Tag;
TableObject = tc.Clone() as TableClass;
BearbeitenMode = bearbeitenMode;
FillCombos();
if (BearbeitenMode == StateClasses.EditStateClass.eBearbeiten.eInsert)
{
NewFieldObject();
}
else
{
FieldObject = fieldObject;
FieldObject.IsPrimary = TableObject.IsPrimary(FieldObject.Name);
FieldObject.Domain.NotNull = TableObject.IsNotNull(FieldObject.Name);
FieldObject.TableName = TableObject.Name;
}
OrgFieldObject = FieldObject.DeepClone();
ObjectToEdit(FieldObject);
_localTableNotify = (lnotify == null) ? new NotifiesClass() : lnotify;
DataFilled = false;
_localTableNotify.Register4Info(TableInfoRaised);
localNotify.Register4Info(InfoRaised);
localNotify.Register4Error(ErrorRaised);
}
public UserDefinedFunctionForm(Form parent, DBRegistrationClass dbReg, TreeNode tn, ContextMenuStrip cm, StateClasses.EditStateClass.eBearbeiten mode)
{
InitializeComponent();
this.MdiParent = parent;
Cm = cm;
Tn = tn;
try
{
BearbeitenMode = mode;
if (BearbeitenMode == StateClasses.EditStateClass.eBearbeiten.eInsert)
{
UserDefinedFunctionObject = new UserDefinedFunctionClass();
UserDefinedFunctionObject.Name = "NEW_UserDefinedFunction";
}
else
{
UserDefinedFunctionObject = (UserDefinedFunctionClass)tn.Tag;
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
OldUserDefinedFunctionObject = (UserDefinedFunctionClass)UserDefinedFunctionObject.Clone();
_dbReg = dbReg;
_localNotify.Register4Error(Notify_OnRaiseErrorHandler);
_localNotify.Register4Info(Notify_OnRaiseInfoHandler);
}
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();
}
public MaintainanceForm(DBClass DB)
{
InitializeComponent();
db = DB;
nf.Register4Info(InfoRaised);
nf.Register4Error(ErrorRaised);
}
public DomainForm(Form parent, DBRegistrationClass dbReg, List <TableClass> tables, TreeNode tn, ContextMenuStrip cm)
{
InitializeComponent();
this.MdiParent = parent;
_dbReg = dbReg;
_tables = tables;
DomainClass tc = (DomainClass)tn.Tag;
if (tc == null)
{
DomainObject = new DomainClass();
DomainObject.Name = "NEW_DOMAIN";
DomainObject.NotNull = false;
DomainObject.FieldType = "INTEGER";
DomainObject.CharSet = "NONE";
DomainObject.Collate = "NONE";
DomainObject.DefaultValue = string.Empty;
DomainObject.Check = string.Empty;
}
else
{
DomainObject = tc;
}
Cm = cm;
Tn = tn;
_localNotify.Register4Error(Notify_OnRaiseErrorHandler);
_localNotify.Register4Info(Notify_OnRaiseInfoHandler);
_localTableNotify.Register4Info(TableInfoRaised);
}
public DBUserManagementForm(Form parent, DBRegistrationClass drc)
{
InitializeComponent();
DBReg = drc;
this.MdiParent = parent;
_localNotify.Register4Error(ErrorRaised);
_localNotify.Register4Info(InfoRaised);
}
public XmlDesignForm(Form parent, DBRegistrationClass reg)
{
InitializeComponent();
MdiParent = parent;
_dbReg = reg;
_localNotify.Register4Info(InfoRaised);
_localNotify.Register4Error(ErrorRaised);
LanguageClass.Instance.RegisterChangeNotifiy(LanguageChanged);
}
public ReplicationDesignForm(Form parent, List <TableClass> tables, DBRegistrationClass dbReg)
{
InitializeComponent();
this.MdiParent = parent;
_tables = tables;
_dbReg = dbReg;
_localNotify.Register4Error(Notify_OnRaiseErrorHandler);
_localNotify.Register4Info(Notify_OnRaiseInfoHandler);
}
public GeneratorForm(Form parent, DBRegistrationClass drc, TreeNode tn, ContextMenuStrip cm)
{
InitializeComponent();
MdiParent = parent;
Tn = tn;
Cm = cm;
var tc = (GeneratorClass)tn.Tag;
GeneratorObject = tc;
_dbReg = drc;
_localNotify.Register4Error(Notify_OnRaiseErrorHandler);
_localNotify.Register4Info(Notify_OnRaiseInfoHandler);
}
public EventsForm(Form parent, DBRegistrationClass dbReg)
{
InitializeComponent();
this.MdiParent = parent;
_dbReg = dbReg;
_localNotify.Register4Error(Notify_OnRaiseErrorHandler);
_localNotify.Register4Info(Notify_OnRaiseInfoHandler);
string cn = ConnectionStrings.Instance.MakeConnectionString(dbReg);
revent = new FbRemoteEvent(cn);
revent.RemoteEventCounts += Revent_RemoteEventCounts;
}
public ForeignKeyForm(Form parent, DBRegistrationClass dbReg, List <TableClass> tables, string tableName, ForeignKeyClass foreignKeys, int newNr)
{
InitializeComponent();
this.MdiParent = parent;
_tables = tables;
_foreignKeys = foreignKeys;
NewNr = newNr;
FKName = (_foreignKeys == null) ? $@"FK_{TableName}_{NewNr}" : foreignKeys.Name;
TableName = tableName;
DataFilled = false;
_dbReg = dbReg;
_localNotify.Register4Error(Notify_OnRaiseErrorHandler);
_localNotify.Register4Info(Notify_OnRaiseInfoHandler);
}
public TriggerForm(Form parent, DBRegistrationClass drc, TreeNode tn, ContextMenuStrip cm, List <TableClass> tables)
{
FormEvents.DisableEvents(this, "TriggerForm");
InitializeComponent();
this.MdiParent = parent;
Tn = tn;
TriggerClass tc = (TriggerClass)tn.Tag;
Cm = cm;
_tables = tables;
TriggerObject = tc;
OrgTriggerObject = tc;
_dbReg = drc;
_localNotify.Register4Error(Notify_OnRaiseErrorHandler);
_localNotify.Register4Info(Notify_OnRaiseInfoHandler);
}
public MeasurementClass(MeasurementConfigClass measConfig, bool worker)
{
mcc = measConfig;
nf = new NotifiesClass();
nf.Register4Info(InfoRaised);
nf.Register4Error(ErrorRaised);
if (worker)
{
measWorker = new System.ComponentModel.BackgroundWorker();
this.measWorker.WorkerReportsProgress = true;
this.measWorker.WorkerSupportsCancellation = true;
this.measWorker.DoWork += new System.ComponentModel.DoWorkEventHandler(this.measWorker_DoWork);
this.measWorker.ProgressChanged += new System.ComponentModel.ProgressChangedEventHandler(this.measWorker_ProgressChanged);
this.measWorker.RunWorkerCompleted += new System.ComponentModel.RunWorkerCompletedEventHandler(this.measWorker_RunWorkerCompleted);
}
}
public FunctionForm(Form parent, DBRegistrationClass dbReg, List <TableClass> tables, TreeNode tn, ContextMenuStrip cm, StateClasses.EditStateClass.eBearbeiten mode)
{
InitializeComponent();
this.MdiParent = parent;
Cm = cm;
Tn = tn;
_tables = tables;
try
{
BearbeitenMode = mode;
if (BearbeitenMode == StateClasses.EditStateClass.eBearbeiten.eInsert)
{
FunctionObject = new FunctionClass();
FunctionObject.Name = "NEW_FUNCTION";
}
else
{
FunctionObject = (FunctionClass)tn.Tag;
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
OldFunctionObject = (FunctionClass)FunctionObject.Clone();
_dbReg = dbReg;
_localNotify.Register4Error(Notify_OnRaiseErrorHandler);
_localNotify.Register4Info(Notify_OnRaiseInfoHandler);
cbDatatype.Items.Clear();
DBTypeList dbList = new DBTypeList();
foreach (DBDataTypes dt in dbList.Values)
{
cbDatatype.Items.Add(dt);
}
DoEvents = true;
}
public ProcedureForm(Form parent, DBRegistrationClass dbReg, List <TableClass> tables, TreeNode tn, ContextMenuStrip cm, StateClasses.EditStateClass.eBearbeiten mode)
{
InitializeComponent();
this.MdiParent = parent;
_tn = tn;
_cm = cm;
_tables = tables;
try
{
BearbeitenMode = mode;
if (BearbeitenMode == StateClasses.EditStateClass.eBearbeiten.eInsert)
{
_procedureObject = new ProcedureClass();
_procedureObject.Name = "NEW_PROCEDURE";
}
else
{
_procedureObject = (ProcedureClass)tn.Tag;
}
}
catch
{
}
_procedureObjectOld = (ProcedureClass)_procedureObject.Clone();
_dbReg = dbReg;
_localNotify.Register4Error(Notify_OnRaiseErrorHandler);
_localNotify.Register4Info(Notify_OnRaiseInfoHandler);
cbDatatype.Items.Clear();
DBTypeList dbList = new DBTypeList();
foreach (DBDataTypes dt in dbList.Values)
{
cbDatatype.Items.Add(dt);
}
_doEvents = true;
}
public VIEWManageForm(Form parent, DBRegistrationClass drc, TreeNode tnSelected)
{
InitializeComponent();
this.MdiParent = parent;
instance = this;
ViewClass viewObject = (ViewClass)tnSelected.Tag;
_localNofity.ErrorGranularity = eMessageGranularity.never;
_localNofity.Register4Info(MeldungRaised);
_localNofity.Register4Error(ErrorRaised);
TnSelected = tnSelected;
ViewObject = (ViewClass)tnSelected.Tag;
DBReg = drc;
txtMaxRows.Text = AppSettingsClass.Instance.SQLVariables.MaxRowsForSelect.ToString();
this.GetDataWorker.WorkerReportsProgress = true;
this.GetDataWorker.WorkerSupportsCancellation = true;
this.GetDataWorker.DoWork += new System.ComponentModel.DoWorkEventHandler(this.bwGetData_DoWork);
this.GetDataWorker.ProgressChanged += new System.ComponentModel.ProgressChangedEventHandler(this.bwGetData_ProgressChanged);
this.GetDataWorker.RunWorkerCompleted += new System.ComponentModel.RunWorkerCompletedEventHandler(this.bwGetData_RunWorkerCompleted);
gridStore = new GridStoreClass(dgvResults);
}
public MainForm()
{
InitializeComponent();
nf.Register4Info(InfoRaised);
nf.Register4Error(ErrorRaised);
}
public PrimaryKeyForm(Form parent, List <TableClass> tables, TableClass tableObject, DBRegistrationClass dbReg)
{
InitializeComponent();
this.MdiParent = parent;
_dataFilled = false;
_dbReg = dbReg;
if (tableObject == null)
{
tableObject = new TableClass
{
primary_constraint = new PrimaryKeyClass
{
Name = "NEW_PK",
FieldNames = new Dictionary <string, string> {
{ "ID", "ID" }
},
Sorting = eSort.ASC
}
};
BearbeitenMode = StateClasses.EditStateClass.eBearbeiten.eInsert;
}
else if (tableObject.primary_constraint == null)
{
//Tabelle hatte noch keine PK
tableObject.primary_constraint = new PrimaryKeyClass
{
Name = "NEW_PK",
FieldNames = new Dictionary <string, string> {
{ "ID", "ID" }
},
Sorting = eSort.ASC
};
BearbeitenMode = StateClasses.EditStateClass.eBearbeiten.eInsert;
}
else
{
BearbeitenMode = StateClasses.EditStateClass.eBearbeiten.eEdit;
}
_tableObject = tableObject;
_localNotify.Register4Error(Notify_OnRaiseErrorHandler);
_localNotify.Register4Info(Notify_OnRaiseInfoHandler);
_tables = tables;
FillTablesToCombo();
FillSortingToCombo();
FillTableFieldsToCombo();
if (tableObject == null)
{
_tableObject = cbSourceTable.SelectedItem as TableClass;
if (_tableObject.primary_constraint == null)
{
_tableObject.primary_constraint = new PrimaryKeyClass();
_tableObject.primary_constraint.Name = "NEW_PK";
_tableObject.primary_constraint.FieldNames = new Dictionary <string, string>();
_tableObject.primary_constraint.FieldNames.Add(cbFields.Items[0].ToString(), cbFields.Items[0].ToString());
_tableObject.primary_constraint.Sorting = eSort.ASC;
}
}
DataToEdit();
}
public EXPORTDataForm(Form parent, DBRegistrationClass drc)
{
InitializeComponent();
this.MdiParent = parent;
localNotify = new NotifiesClass()
{
//NotifyType = eNotifyType.ErrorWithoutMessage,
ErrorGranularity = eMessageGranularity.never
};
localNotify.Register4Info(InfoRaised);
localNotify.Register4Error(ErrorRaised);
DBReg = drc;
var viewobjects = StaticTreeClass.Instance().GetViewObjects(DBReg);
var tableObjects = StaticTreeClass.Instance().GetAllNonSystemTableObjectsComplete(DBReg);
var domainObjects = StaticTreeClass.Instance().GetDomainObjects(DBReg);
var generatorObjects = StaticTreeClass.Instance().GetGeneratorObjects(DBReg);
var indecesObjects = StaticTreeClass.Instance().GetIndecesObjects(DBReg);
var triggerObjects = StaticTreeClass.Instance().GetTriggerObjects(DBReg);
//var procedureObjects = StaticTreeClass.Instance().GetAllProcedureObjects(DBReg);
var procedureObjects = StaticTreeClass.Instance().GetProcedureObjects(DBReg);
var functionObjects = StaticTreeClass.Instance().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());
}