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);
}
}
