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