/// <summary> /// Click event handler of Connect button. /// </summary> /// <param name="sender">Sender</param> /// <param name="e">Event argument</param> /// <exception cref="Exception"></exception> private void BtnConnect_Click(object sender, EventArgs e) { try { if (ddlDb.SelectedValue == null || ddlDb.SelectedValue.ToString() == string.Empty) { throw new InvalidOperationException("Invalid database"); } var req = ddlAuth.SelectedIndex == 0 ? new ConnectionRequest(txtServer.Text.Trim(), ddlDb.SelectedValue.ToString()) : new ConnectionRequest(txtServer.Text.Trim(), txtUser.Text.Trim(), txtPass.Text.Trim()); if (!req.TryConnect()) { throw new InvalidOperationException("Sql Connection failed."); } ConnectionSuccess = true; ConnReq = req; AppStatic.DbConnectionString = req.SqlConn.ConnectionString; AppStatic.Database = req.SqlConn.Database; AppStatic.Server = req.SqlConn.DataSource; DialogResult = DialogResult.OK; Close(); } catch (Exception ex) { ConnectionSuccess = false; ErrorViewerForm.ShowError(ex, this); DialogResult = DialogResult.Cancel; } }
/// <summary> /// Load event handler of Main Form. /// </summary> /// <param name="sender">Sender.</param> /// <param name="e">Event Argument.</param> private void MainForm_Load(object sender, EventArgs e) { try { if (AppStatic.DBConnectionString.Length == 0) { var sqlConnForm = new SQLConnectionForm(); if (sqlConnForm.ShowDialog(this) == DialogResult.OK && sqlConnForm.ConnectionSuccess) { AppStatic.DBConnectionString = sqlConnForm.ConnReq.SqlConn.ConnectionString; AppStatic.Database = sqlConnForm.ConnReq.SqlConn.Database; AppStatic.Server = sqlConnForm.ConnReq.SqlConn.DataSource; FormLoad(); } else { this.Close(); } } } catch (Exception ex) { ErrorViewerForm.ShowError(ex, this); } }
/// <summary> /// Save to file menu-item click event handler. /// </summary> /// <param name="sender">Sender.</param> /// <param name="e">Event Argument.</param> private void saveToFileToolStripMenuItem_Click(object sender, EventArgs e) { try { SaveCode(); } catch (Exception ex) { ErrorViewerForm.ShowError(ex, this); } }
private void cSharpCodeControl_MouseClick(object sender, MouseEventArgs e) { try { if (e.Button == MouseButtons.Right) { textBoxContextMenu.Show(cSharpCodeControl, e.Location); } } catch (Exception ex) { ErrorViewerForm.ShowError(ex, this); } }
/// <summary> /// Enter event handler of Database combobox. /// </summary> /// <param name="sender">Sender</param> /// <param name="e">Event argument</param> private void ddlDb_Enter(object sender, EventArgs e) { try { ConnectionRequest serverConnReq = GetServerConnection(); var sqlHelp = new SQLHelper(serverConnReq.SqlConn.ConnectionString); var databases = sqlHelp.GetDatabaseList(); ddlDb.DataSource = databases; } catch (Exception ex) { ErrorViewerForm.ShowError(ex, this); } }
/// <summary> /// Generate Simple Typed Datatable menu-item click evennt handler. /// </summary> /// <param name="sender">Sender.</param> /// <param name="e">Event Argument.</param> private void GenerateSimpleTypedDatatableToolStripMenuItem_Click(object sender, EventArgs e) { try { tabPage1.Text = @"Simple Typed Datatable"; _creator = null; _creator = new TypedDatatableCreator(); classGeneratorSetting.ApplySettings(); } catch (Exception ex) { ErrorViewerForm.ShowError(ex, this); } }
/// <summary> /// Generate C# Class menu-item click event handler. /// </summary> /// <param name="sender">Sender.</param> /// <param name="e">Event Argument.</param> private void PocoGenerateMenuItem_Click(object sender, EventArgs e) { try { tabPage1.Text = @"C# Class"; _creator = null; _creator = new CSharpClassCreator(); classGeneratorSetting.ApplySettings(); } catch (Exception ex) { ErrorViewerForm.ShowError(ex, this); throw; } }
/// <summary> /// Database change menu-item click event handler. /// </summary> /// <param name="sender">Sender.</param> /// <param name="e">Event Argument.</param> private void dbConnectionStripMenuItem_Click(object sender, EventArgs e) { try { var sqlConnForm = new SQLConnectionForm(); if (sqlConnForm.ShowDialog(this) == DialogResult.OK && sqlConnForm.ConnectionSuccess) { AppStatic.DBConnectionString = sqlConnForm.ConnReq.SqlConn.ConnectionString; AppStatic.Database = sqlConnForm.ConnReq.SqlConn.Database; AppStatic.Server = sqlConnForm.ConnReq.SqlConn.DataSource; FormLoad(); } } catch (Exception ex) { ErrorViewerForm.ShowError(ex, this); } }
/// <summary> /// Settings changed event handler. /// </summary> /// <param name="sender">Sender.</param> /// <param name="e">Event Argument.</param> private void CreatorSettings_ClassSettingChangedEventHandler(ClassGeneratorSettings sender, ClassGeneratorSettingsEventArgs e) { try { _settings = null; if (string.IsNullOrWhiteSpace(e.ClassName)) { e.ClassName = dbTreeView.GetSelectedDbItem().ToPascalCase(); } if (_creator == null) { return; } tabControl.Visible = true; _settings = CSharpSettings.GetCSharpSettings(e); var sql = new SqlHelper(AppStatic.DbConnectionString); var code = _creator.GenerateCSharpCode ( _settings, sql.GetClrProperties ( dbTreeView.GetSelectedDbItemSchema(), dbTreeView.GetSelectedDbItem(), dbTreeView.GetDbObjectType() ) ); cSharpCodeControl.Text = code; tabPage1.Text = $@"{tabPage1.Text.Split (new[] { " (" }, StringSplitOptions.RemoveEmptyEntries)[0]} ({dbTreeView.GetSelectedNode()})"; } catch (Exception ex) { ErrorViewerForm.ShowError(ex, this); } }
/// <summary> /// Click event handler of Connect button. /// </summary> /// <param name="sender">Sender</param> /// <param name="e">Event argument</param> private void btnConnect_Click(object sender, EventArgs e) { ConnectionRequest req = null; try { if (ddlDb.SelectedValue == null || ddlDb.SelectedValue.ToString() == string.Empty) { throw new Exception("Invalid database"); } if (this.ddlAuth.SelectedIndex == 0)//Win auth { req = new ConnectionRequest(txtServer.Text.Trim(), ddlDb.SelectedValue.ToString()); } else { req = new ConnectionRequest(txtServer.Text.Trim(), txtUser.Text.Trim(), txtPass.Text.Trim()); } if (!req.TryConnect()) { throw new Exception("Sql Connection failed."); } this.ConnectionSuccess = true; this.ConnReq = req; AppStatic.DBConnectionString = req.SqlConn.ConnectionString; AppStatic.Database = req.SqlConn.Database; AppStatic.Server = req.SqlConn.DataSource; this.DialogResult = DialogResult.OK; this.Close(); } catch (Exception ex) { this.ConnectionSuccess = false; ErrorViewerForm.ShowError(ex, this); ///MessageHelper.ShowError(ex.Message, this); this.DialogResult = DialogResult.Cancel; } }
/// <summary> /// Settings changed event handler. /// </summary> /// <param name="sender">Sender.</param> /// <param name="e">Event Argument.</param> private void creatorSettings_ClassSettingChangedEventHandler(ClassGeneratorSettings sender, ClassGeneratorSettingsEventArgs e) { try { if (settings != null) { settings = null; } if (e.ClassName.Length == 0) { e.ClassName = dbTreeView.GetSelectedDbItem(); } if (creator == null) { return; } tabControl.Visible = true; settings = CSharpSettings.GetCSharpSettings(e); SQLHelper sql = new SQLHelper(AppStatic.DBConnectionString); var code = creator.GenerateCSharpCode( settings , sql.GetClrProperties( dbTreeView.GetSelectedDbItemSchema() , dbTreeView.GetSelectedDbItem() , dbTreeView.GetDBObjectType() ) ); cSharpCodeControl.Text = code; tabPage1.Text = $"{tabPage1.Text.Split(new string[] { " (" }, StringSplitOptions.RemoveEmptyEntries)[0]} ({dbTreeView.GetSelectedNode()})"; } catch (Exception ex) { ErrorViewerForm.ShowError(ex, this); } }