private void btnConfirm_Click(object sender, EventArgs e)
{
if (!String.IsNullOrEmpty(this.txtTableName.Text))
{
GenerateDDL();
if (!TableExists(this.txtTableName.Text))
{
try
{
string sql = this.generatedSQLRichTextBox.Text;
_sqliteManager.ExecuteNonQuery(sql);
MessageBox.Show("Table " + this.txtTableName.Text + " created successfully!");
this.Close();
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
var errorMessage = ex.Message;
if (ex.InnerException != null && ex.InnerException.Message != null)
{
errorMessage += ex.InnerException.Message;
}
MessageBox.Show(errorMessage);
}
}
else
{
MessageBox.Show("The table " + txtTableName.Text + " already exists.");
}
}
else
{
MessageBox.Show("Missing input table name.");
}
}
private void btnConfirm_Click(object sender, EventArgs e)
{
if (!String.IsNullOrEmpty(this.txtIndexName.Text))
{
GenerateDDL();
if (!IndexExists(this.txtIndexName.Text, comboBoxTables.Text))
{
try
{
string sql = this.GeneratedSQL.Text;
_sqliteManager.ExecuteNonQuery(sql);
MessageBox.Show("Index " + this.txtIndexName.Text + " created successfully.");
this.Close();
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
else
{
MessageBox.Show("Index " + txtIndexName.Text + " already exists.");
}
}
else
{
MessageBox.Show("Missing index name.");
}
}
private void btnAceptar_Click(object sender, EventArgs e)
{
if (!String.IsNullOrEmpty(this.txtName.Text) || !String.IsNullOrEmpty(this.comboBoxAction.Text) || !String.IsNullOrEmpty(this.txtCode.Text))
{
GenerateDDL();
if (!TriggerExists(this.comboBoxOnTable.Text, this.txtName.Text))
{
try
{
string sql = this.generatedDDLRichTextBox.Text;
_sqliteManager.ExecuteNonQuery(sql);
MessageBox.Show("Trigger " + this.txtName.Text + " created successfully!");
this.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
else
{
MessageBox.Show("Trigger " + txtName.Text + " already exists.");
}
}
else
{
MessageBox.Show("Missing input fields.");
}
}
private void okBtn_Click(object sender, EventArgs e)
{
if (!String.IsNullOrEmpty(txtViewName.Text))
{
GenerateDDL();
try
{
string sql = this.generatedDDLRichTextBox.Text;
_sqliteManager.ExecuteNonQuery(sql);
MessageBox.Show("View " + txtViewName.Text + " created succesfully.");
this.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
else
{
MessageBox.Show("Missing view name field.");
}
}
