private void XtraSQLAddDataBase_Load(object sender, EventArgs e) { try { txtServerName.Text = SQl.ServerName; txtServerId.Text = SQl.ServerId.ToString(); if (dbs != null) { Text = "Edit DataBase"; txtDataBaseId.Value = dbs.DataBaseId; txtDataBaseName.Text = dbs.DataBaseName; txtDescription.Text = dbs.Description; } else { Text = "Add DataBase"; txtDataBaseId.Text = Convert.ToString(SQl.DataBase.Count + 1); txtDataBaseName.Properties.Items.AddRange(LinkToSQL.AddDatabaseNames(SQl.ServerName)); } } catch (Exception ex) { EventscadaException?.Invoke(this.GetType().Name, ex.Message); } }
private void AddTable_Load(object sender, EventArgs e) { try { if (db == null) { Text = "Add Table"; txtServerId.Text = Convert.ToString(ch.ServerId); txtServerName.Text = ch.ServerName; txtDataBaseId.Text = Convert.ToString(dv.DataBaseId); txtDataBaseName.Text = dv.DataBaseName; txtTableId.Text = Convert.ToString(dv.Tables.Count + 1); var linkToSql = new LinkToSQL(); txtTableName.Properties.Items.AddRange(linkToSql.AddTable(ch.ServerName, dv.DataBaseName)); } else { Text = "Edit Table"; txtTableId.Text = Convert.ToString(db.TableId); txtTableName.Text = db.TableName; txtDescription.Text = db.Description; } } catch (Exception ex) { EventscadaException?.Invoke(this.GetType().Name, ex.Message); } }
private void AddColumn_Load(object sender, EventArgs e) { try { txtSQLDataBase.Text = DBS.DataBaseName; txtSQLTable.Text = Tb.TableName; txtChannel.Properties.DataSource = objChannelManager.Channels.ToList(); txtChannel.Properties.DisplayMember = "ChannelName"; txtChannel.Properties.ValueMember = "ChannelId"; var linkToSql = new LinkToSQL(); txtColumnName.Properties.DataSource = linkToSql.AddColumn(txtSQLTable.Text, SQL.ServerName, DBS.DataBaseName); txtColumnName.Properties.DisplayMember = "ColumnName"; txtColumnName.Properties.ValueMember = "ColumnName"; if (Co == null) { Text = "Add Column"; } else { Text = "Edit Column"; txtTagName.Text = Co.TagName; txtColumnId.Text = Convert.ToString(Co.ColumnId); txtChannel.Text = Co.Channel; txtColumnName.Text = Co.ColumnName; txtDataBlock.Text = Co.DataBlock; txtDevice.Text = Co.Device; txtMode.Text = Co.Mode; txtTriggerType.Text = Co.TriggerType; txtDescription.Text = Co.Description; } } catch (Exception ex) { EventscadaException?.Invoke(this.GetType().Name, ex.Message); } }