public int RefreshFields() { if (string.IsNullOrEmpty(ViewObject.Name)) { return(lvFields.Items.Count); } string cmd = SQLStatementsClass.Instance().GetViewFields(DBReg.Version, ViewObject.Name); ViewFieldClass vf = null; lvFields.Items.Clear(); dgExportGrid.Rows.Clear(); try { var con = new FbConnection(ConnectionStrings.Instance().MakeConnectionString(DBReg)); con.Open(); var fcmd = new FbCommand(cmd, con); var dread = fcmd.ExecuteReader(); if (dread.HasRows) { while (dread.Read()) { object ob = dread.GetValue(0); object ob_field_position = dread.GetValue(1); string fieldstr = ob.ToString(); string posstr = ob_field_position.ToString(); string typename = dread.GetValue(3).ToString(); string typelength = dread.GetValue(4).ToString(); vf = new ViewFieldClass() { Name = fieldstr.Trim() }; string[] obarr = { posstr.Trim(), fieldstr.Trim(), typename.Trim(), typelength.Trim() }; object[] obarr_export = { posstr.Trim(), fieldstr.Trim(), true, true }; var lvi = new ListViewItem(obarr) { Tag = vf, Checked = true }; lvFields.Items.Add(lvi); dgExportGrid.Rows.Add(obarr_export); } } con.Close(); } catch (Exception ex) { NotifiesClass.Instance().AddToERROR(BasicClassLibrary.StaticFunctionsClass.DateTimeNowStr() + " ViewManagerForm->RefreshDependenciesFrom->" + ex.Message); } return(lvFields.Items.Count); }
public int RefreshDependenciesFrom() { dsDependencies.Clear(); dgvDependencies.AutoGenerateColumns = true; string cmd_index = SQLStatementsClass.Instance().GetViewManagerDependenciesFROM(DBReg.Version, ViewObject.Name); try { var con = new FbConnection(ConnectionStrings.Instance().MakeConnectionString(DBReg)); FbDataAdapter ds = new FbDataAdapter(cmd_index, con); ds.Fill(dsDependencies); con.Close(); } catch (Exception ex) { NotifiesClass.Instance().AddToERROR(BasicClassLibrary.StaticFunctionsClass.DateTimeNowStr() + " ViewManagerForm->RefreshDependenciesFrom->" + ex.Message); } bsDependencies.DataMember = "Table"; return(dsDependencies.Tables[0].Rows.Count); }
public int RefreshDependenciesTo() { string cmd = SQLStatementsClass.Instance().GetDepentenciesGenerators(_dbReg.Version, GeneratorObject.Name); try { dsDependenciesTo.Clear(); dgvDependenciesTo.AutoGenerateColumns = true; var con = new FbConnection(ConnectionStrings.Instance().MakeConnectionString(_dbReg)); var ds = new FbDataAdapter(cmd, con); ds.Fill(dsDependenciesTo); con.Close(); bsDependenciesTo.DataMember = "Table"; return(dsDependenciesTo.Tables[0].Rows.Count); } catch (Exception ex) { NotifiesClass.Instance().AddToERROR($@"{StaticFunctionsClass.DateTimeNowStr()} GeneratorForm -> RefreshDependenciesTo: {ex.Message}"); } return(0); }
public int RefreshMonitorConnections() { GetConnections(); try { string cmd_index = SQLStatementsClass.Instance().GetMonitorConnections(DBReg.Version, cbAllConnections.Checked); dsMonConnections.Clear(); dgvMonConnections.AutoGenerateColumns = true; var con = new FbConnection(ConnectionStrings.Instance().MakeConnectionString(DBReg)); var ds = new FbDataAdapter(cmd_index, con); ds.Fill(dsMonConnections); con.Close(); bsMonConnections.DataMember = "Table"; return(dsMonConnections.Tables[0].Rows.Count); } catch (Exception ex) { NotifiesClass.Instance().AddToERROR(AppStaticFunctionsClass.GetFormattedError($@"{Name}-> RefreshMonitorConnections()", ex)); } bsMonConnections.DataMember = "Table"; return(dsMonConnections.Tables[0].Rows.Count); }
public int RefreshDependencies() { dsDependencies.Clear(); dgvDependenciesTo.AutoGenerateColumns = true; string cmd_index = SQLStatementsClass.Instance().GetFieldDependencies(_dbReg.Version, TableObject.Name, FieldObject.Name); try { var con = new FbConnection(ConnectionStrings.Instance().MakeConnectionString(_dbReg)); FbDataAdapter ds = new FbDataAdapter(cmd_index, con); ds.Fill(dsDependencies); con.Close(); bsDependencies.DataMember = "Table"; bsDependencies.DataSource = dsDependencies; return(dsDependencies.Tables[0].Rows.Count); } catch (Exception ex) { NotifiesClass.Instance().AddToERROR($"{StaticFunctionsClass.DateTimeNowStr()}->FieldForm->RefreshDependencies->{ex.Message}"); } return(0); }