public void MoveDown(TreeNode tnReg)
{
if (tnReg == null)
{
return;
}
if (tnReg.NextNode == null)
{
return;
}
int inx1 = Databases.FindIndex(x => x.Alias == tnReg.NextNode.Text);
int inx2 = Databases.FindIndex(x => x.Alias == tnReg.Text);
DBRegistrationClass dbr1 = (DBRegistrationClass)Databases[inx1].Clone();
DBRegistrationClass dbr2 = (DBRegistrationClass)Databases[inx2].Clone();
int pos = dbr1.Position;
dbr1.Position = dbr2.Position;
dbr2.Position = pos;
Databases[inx1] = dbr2;
Databases[inx2] = dbr1;
DataState = EditStateClass.eDataState.UnSaved;
}
public string GetErrorCodeString(string errorString, DBRegistrationClass DBReg)
{
if (!errorString.Contains("No message for error code"))
{
return(errorString);
}
int inx1 = errorString.IndexOf("error code ");
int inx2 = errorString.LastIndexOf(" found");
string estr = errorString.Substring(inx1 + 11, inx2 - inx1 - 11);
long.TryParse(estr, out long ecc);
string err = string.Empty;
if ((ecc > 0) && (DBReg.GetErrorCodes().Errors.Count > 0))
{
if (DBReg.GetErrorCodes().Errors.TryGetValue(ecc, out err))
{
return(errorString.Replace($@"{ecc} found", $@"Error Code:{err}").Replace("No message for error code", ""));
}
}
return(errorString);
}
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;
}
private void hotSpot1_Click_1(object sender, EventArgs e)
{
txtOpenResult.Text = String.Empty;
pnlConnectState.BackColor = System.Drawing.Color.Yellow;
DBRegistrationClass dbr = new DBRegistrationClass();
dbr = DBReg.Clone();
dbr.User = txtUserName.Text;
dbr.Password = txtPassword.Text;
var con = new FbConnection(ConnectionStrings.Instance.MakeConnectionString(dbr));
try
{
Stopwatch sw = new Stopwatch();
sw.Start();
if (con.State != ConnectionState.Open)
{
con.Close();
}
con.Open();
Thread.Sleep(100);
if (con.State == ConnectionState.Open)
{
pnlConnectState.BackColor = System.Drawing.Color.Green;
Application.DoEvents();
con.Close();
txtOpenResult.Text = "succeeded";
}
}
catch (Exception ex)
{
pnlConnectState.BackColor = System.Drawing.Color.Red;
txtOpenResult.Text = ex.Message;
Application.DoEvents();
}
}
public DatabaseConfigForm(Form parent, DBRegistrationClass reg, TreeView aktTree, int aktPosition, EditStateClass.eBearbeiten bMode)
{
InitializeComponent();
this.MdiParent = parent;
if (reg == null)
{
//Insert neuer Knoten
SetBearbeitenMode(EditStateClass.eBearbeiten.eInsert);
_dbReg = reg;
var newNode = new TreeNode();
_dbReg.SetNode(newNode);
aktTree.Nodes.Insert(aktPosition, newNode);
NewDataToEdit();
}
else if (bMode == EditStateClass.eBearbeiten.eInsert)
{
//Neuer TreeKnoten als Cloned anfügen
_dbReg = reg;
var newNode = new TreeNode
{
Name = "DATABASE"
};
_dbReg.SetNode(newNode);
aktTree.Nodes.Insert(aktPosition, newNode);
SetBearbeitenMode(bMode);
DataToEdit();
}
else
{
_dbReg = reg;
SetBearbeitenMode(bMode);
DataToEdit();
}
}
public SQLViewForm1(DBRegistrationClass ca, List <TableClass> actTables, Form mdiParent = null, eColorDesigns appDesign = eColorDesigns.Gray, eColorDesigns developDesign = eColorDesigns.Gray, bool testMode = false)
{
MdiParent = mdiParent;
_dbReg = ca;
_actTables = actTables;
_appDesign = appDesign;
_developDesign = developDesign;
InitializeComponent();
var nf = new NotifiesClass();
nf.gaugeNotify.OnRaiseGaugeHandler += new NotifyGauge.RaiseGaugeHandler(GaugeRaised);
_localNotifies.AddNotify(nf, "SQLViewForm");
_localNotifies.AddNotify(NotifiesClass.Instance(), "GLOBAL");
_sqLcommand = new SQLCommandsClass(_dbReg, _localNotifies.Find("SQLViewForm"));
tabPageSucceeded.Text = "commands succeded DESC";
Meldungen();
Errors();
History();
ClearDevelopDesign(_developDesign);
SetDesign(_appDesign);
cbTestlauf.Checked = testMode;
cbTestlauf.Visible = testMode;
}
public CreateNewTableForm(DBRegistrationClass dbReg, Form parent, NotifiesClass lnotify)
{
InitializeComponent();
MdiParent = parent;
_dbReg = dbReg;
_tableObject = new TableClass();
_tableObject.Name = "NEW_TABLE";
_fieldObject = new TableFieldClass();
_fieldObject.Name = "ID";
//_fieldObject.RawType = "INTEGER";
_fieldObject.Domain.Name = "ID";
_fieldObject.Domain.RawType = "INTEGER";
_localTableNotify = lnotify;
_dataFilled = false;
DataToEdit();
cbPrimaryKey.Enabled = true;
_localTableNotify.Notify.OnRaiseInfoHandler += new NotifyInfos.RaiseNotifyHandler(TableInfoRaised);
_localNotify.Notify.OnRaiseInfoHandler += new NotifyInfos.RaiseNotifyHandler(InfoRaised);
_localNotify.Notify.OnRaiseErrorHandler += new NotifyInfos.RaiseNotifyHandler(ErrorRaised);
}
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 void SetRegistration(DBRegistrationClass drc)
{
DBReg = drc;
}
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
{
BearbeitenMode = StateClasses.EditStateClass.eBearbeiten.eEdit;
}
_tableObject = tableObject;
_localNotify.Notify.OnRaiseErrorHandler += Notify_OnRaiseErrorHandler;
_localNotify.Notify.OnRaiseInfoHandler += 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 SQLForm(Form parent, DBRegistrationClass drc)
{
InitializeComponent();
this.MdiParent = parent;
DRC = drc;
}
private FbConnection CreateConnection(string sqlCmd, FbConnection fbConn)
{
/*
* CONNECT 'LOCALHOST:D:\Data\test.fdb' USER 'SYSDBA' PASSWORD 'masterkey';
*/
string sql = sqlCmd.ToUpper();
string location = "D:\\Data\\test111.FDB";
string user = "******";
string password = "******";
int inx = sql.IndexOf("CONNECT ", StringComparison.Ordinal);
if (inx >= 0)
{
string cmd3 = sqlCmd.Substring(inx + 8);
int inx2 = cmd3.IndexOf(" ", StringComparison.Ordinal);
string arg = cmd3.Substring(0, inx2);
int inx3 = arg.IndexOf(":\\", StringComparison.Ordinal);
int inx4 = arg.IndexOf(":", StringComparison.Ordinal);
if (inx4 < inx3)
{
//server
location = arg.Substring(inx4 + 1);
location = location.Replace("'", "");
}
else
{
//nur dateipfad
location = arg.Replace("'", "");
}
}
inx = sql.IndexOf("USER ", StringComparison.Ordinal);
if (inx >= 0)
{
var cmd3 = sqlCmd.Substring(inx + 5);
int inx2 = cmd3.IndexOf(" ", StringComparison.Ordinal);
var arg = cmd3.Substring(0, inx2);
user = arg.Replace("'", "");
}
inx = sql.IndexOf("PASSWORD ", StringComparison.Ordinal);
if (inx >= 0)
{
var cmd3 = sqlCmd.Substring(inx + 9);
var arg = cmd3.Substring(0);
password = arg.Replace("'", "");
}
var drc = new DBRegistrationClass
{
DatabasePath = location,
Dialect = 3,
Password = password,
User = user,
Alias = "ConScript",
CharSet = "UTF8",
Server = "localhost",
ConnectionType = eConnectionType.server
};
string connstr = ConnectionStrings.Instance().MakeConnectionString(drc);
if (fbConn?.State == System.Data.ConnectionState.Open)
{
fbConn.Close();
}
fbConn = new FbConnection(connstr);
fbConn.Open();
_parentNotifies?.AddToINFO(StaticFunctionsClass.DateTimeNowStr() + " ...Opening database via script" + drc);
_parentNotifies?.AddToINFO(StaticFunctionsClass.DateTimeNowStr() + " ...Database state:" + fbConn.State.ToString());
return(fbConn);
}
private void DoCreateAlter(IList <string> cmd, DBRegistrationClass DBReg, NotifiesClass _localNofity, string Name)
{
var SQLcommand = new SQLCommandsClass(DBReg, _localNofity);
var ri = SQLcommand.ExecuteCommand(cmd, true);
}
public FORMULAREditForm(Form parent, DBRegistrationClass drc)
{
_drc = drc;
MdiParent = parent;
Init();
}
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 BinariesForm(Form parent, DBRegistrationClass drc)
{
InitializeComponent();
this.MdiParent = parent;
_dbReg = drc;
}
public AutocompleteClass(FastColoredTextBox txt, DBRegistrationClass dbReg)
{
_txtBox = txt;
_dbReg = dbReg;
}
public SQLCommandsReturnInfoClass DropIndex(string name, DBRegistrationClass dbReg, NotifiesClass notify)
{
string cmd = SQLPatterns.DropIndexPattern.Replace(SQLPatterns.IndexKey, name);
return(ExecSql(cmd, dbReg, notify));
}
public SQLCommandsReturnInfoClass DropPrimaryKeyConstraint(string name, string tablename, string fieldname, DBRegistrationClass dbReg, NotifiesClass notify)
{
string cmd = SQLPatterns.DropPrimaryKeyConstraintPattern.Replace(SQLPatterns.ConstraintKey, name).Replace(SQLPatterns.TableKey, tablename);
return(ExecSql(cmd, dbReg, notify));
}
public AutocompleteClass(DBRegistrationClass dbReg)
{
_dbReg = dbReg;
}
public DBMonitoringForm(Form parent, DBRegistrationClass drc)
{
InitializeComponent();
DBReg = drc;
this.MdiParent = parent;
}
public ConstraintsForm(Form parent, TableClass tableObject, List <TableClass> tables, DBRegistrationClass dbReg, ConstraintsClass constraintObject)
{
InitializeComponent();
this.MdiParent = parent;
_dbReg = dbReg;
_tables = tables;
_constraintObject = constraintObject;
OldConstraintName = _constraintObject.Name;
_tableObject = tableObject;
_constraintObject.TableName = _tableObject.Name;
_localNotify.Notify.OnRaiseErrorHandler += Notify_OnRaiseErrorHandler;
_localNotify.Notify.OnRaiseInfoHandler += Notify_OnRaiseInfoHandler;
}
