private void Button1_Click(object sender, EventArgs e)
{
var baseSql = $"create proc {nameTextBox.Text} (";
foreach (DataGridViewRow row in procedureParametersDataGrid.Rows)
{
if (!row.IsNewRow)
{
baseSql += $"@{row.Cells["ParameterName"].Value} {row.Cells["DataType"].Value},";
}
}
var newSql = baseSql.Remove(baseSql.Length - 1);
newSql += $") as {procedureDefinitionTextBox.Text}";
var ddlViewer = new DdlViewer(baseSql);
ddlViewer.ShowDialog();
if (ddlViewer.DialogResult != DialogResult.OK)
{
return;
}
CurrentInformation.ConnectionProperties.Connection.Execute(baseSql);
TreeViewConnectionBootstrapper.Init(CurrentInformation.ConnectionProperties, TreeView);
}
private void Button1_Click(object sender, EventArgs e)
{
string baseSql = $"create view {nameTextBox.Text} as {sqlTextBox.Text}";
var ddlViewer = new DdlViewer(baseSql);
ddlViewer.ShowDialog();
if (ddlViewer.DialogResult != DialogResult.OK)
{
return;
}
CurrentInformation.ConnectionProperties.Connection.Execute(baseSql);
TreeViewConnectionBootstrapper.Init(CurrentInformation.ConnectionProperties, TreeView);
}
private void DeleteToolStripMenuItem_Click(object sender, EventArgs e)
{
string sql = "";
if (CurrentInformation.ObjectType.Equals("Connection"))
{
CurrentInformation.Connections.RemoveAll(connection => connection.Name == CurrentInformation.ObjectName);
return;
}
if (CurrentInformation.ObjectType.Equals("Table"))
{
sql = $"drop table {CurrentInformation.ObjectName}";
}
else if (CurrentInformation.ObjectType.Equals("Trigger"))
{
sql = $"drop trigger {CurrentInformation.ObjectName}";
}
else if (CurrentInformation.ObjectType.Equals("Function"))
{
sql = $"drop function {CurrentInformation.ObjectName}";
}
else if (CurrentInformation.ObjectType.Equals("StoredProcedure"))
{
sql = $"drop proc {CurrentInformation.ObjectName}";
}
else if (CurrentInformation.ObjectType.Equals("View"))
{
sql = $"drop view {CurrentInformation.ObjectName}";
}
var ddlViewer = new DdlViewer(sql);
ddlViewer.ShowDialog();
if (ddlViewer.DialogResult == DialogResult.OK)
{
CurrentInformation.ConnectionProperties.Connection.Execute(sql);
connectionsTreeView.Nodes.Remove(connectionsTreeView.SelectedNode);
}
}
private void Button1_Click(object sender, EventArgs e)
{
var baseSql = $"create table {nameTextBox.Text} (";
foreach (DataGridViewRow row in tableDefinitionDataGrid.Rows)
{
if (row.IsNewRow)
{
continue;
}
baseSql += $"{row.Cells["FieldName"].Value} {row.Cells["DataType"].Value}";
if (row.Cells["NotNull"].Value != null && (bool)row.Cells["NotNull"].Value)
{
baseSql += " NOT NULL";
}
if (row.Cells["PrimaryKey"].Value != null && (bool)row.Cells["PrimaryKey"].Value)
{
baseSql += " PRIMARY KEY";
}
baseSql += ",";
}
baseSql += ");";
var ddlViewer = new DdlViewer(baseSql);
ddlViewer.ShowDialog();
if (ddlViewer.DialogResult != DialogResult.OK)
{
return;
}
CurrentInformation.ConnectionProperties.Connection.Execute(baseSql);
TreeViewConnectionBootstrapper.Init(CurrentInformation.ConnectionProperties, TreeView);
tableDefinitionDataGrid.DataSource = null;
}
