private void wizard1_BeforeSwitchPages(object sender, nHydrate.Wizard.Wizard.BeforeSwitchPagesEventArgs e) { var oldPage = wizard1.WizardPages[e.OldIndex]; var newPage = wizard1.WizardPages[e.NewIndex]; var importDomain = new nHydrate.DataImport.SqlClient.ImportDomain(); var databaseHelper = importDomain.DatabaseDomain; if ((oldPage == pageImport) && (e.NewIndex > e.OldIndex)) { //Test Connection var connectString = DatabaseConnectionControl1.ImportOptions.GetConnectionString(); var valid = databaseHelper.TestConnectionString(connectString); if (!valid) { MessageBox.Show("The information does not describe a valid connection string.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); e.Cancel = true; return; } //Load the dropdown var auditFields = new List <string>(); var list = importDomain.GetEntityList(connectString); cboTable.DataSource = list; cboTable.SelectedItem = list.FirstOrDefault(x => x.ToLower() == _entity.Name.ToLower()); } else if ((oldPage == pageChooseTable) && (e.NewIndex > e.OldIndex)) { //Verify that the table schema matches var connectionString = DatabaseConnectionControl1.ImportOptions.GetConnectionString(); var auditFields = new List <SpecialField>(); auditFields.Add(new SpecialField { Name = _entity.nHydrateModel.CreatedByColumnName, Type = SpecialFieldTypeConstants.CreatedBy }); auditFields.Add(new SpecialField { Name = _entity.nHydrateModel.CreatedDateColumnName, Type = SpecialFieldTypeConstants.CreatedDate }); auditFields.Add(new SpecialField { Name = _entity.nHydrateModel.ModifiedByColumnName, Type = SpecialFieldTypeConstants.ModifiedBy }); auditFields.Add(new SpecialField { Name = _entity.nHydrateModel.ModifiedDateColumnName, Type = SpecialFieldTypeConstants.ModifedDate }); auditFields.Add(new SpecialField { Name = _entity.nHydrateModel.TimestampColumnName, Type = SpecialFieldTypeConstants.Timestamp }); auditFields.Add(new SpecialField { Name = _entity.nHydrateModel.TenantColumnName, Type = SpecialFieldTypeConstants.Tenant }); var dsValues = databaseHelper.GetStaticData(connectionString, importDomain.GetEntity(connectionString, (string)cboTable.SelectedValue, auditFields)); this.LoadData(dsValues); } }
private int LoadSqlServer(string connectionString, List <SpecialField> auditFields) { var importDomain = new nHydrate.DataImport.SqlClient.ImportDomain(); this.NewDatabase = importDomain.Import(connectionString, auditFields); this.NewDatabase.CleanUp(); this.NewDatabase.SetupIdMap(this.CurrentDatabase); //nHydrate.DataImport.ImportDomain.ReMapIDs(this.CurrentDatabase, this.NewDatabase); //Load the tree this.Populate(); return(0); }
private int LoadSqlServer(string connectionString, List <SpecialField> auditFields) { var importDomain = new nHydrate.DataImport.SqlClient.ImportDomain(); this.NewDatabase = importDomain.Import(connectionString, auditFields); this.NewDatabase.CleanUp(); this.NewDatabase.SetupIdMap(this.CurrentDatabase); //nHydrate.DataImport.ImportDomain.ReMapIDs(this.CurrentDatabase, this.NewDatabase); //Remove tenant views NewDatabase.ViewList.Remove(x => x.Name.ToLower().StartsWith(_model.TenantPrefix.ToLower() + "_")); //Load the tree this.Populate(); return(0); }
private void cmdTestConnection_Click(object sender, EventArgs e) { try { //SQL if (optDatabaseTypeSQL.Checked) { DatabaseConnectionControl1.RefreshOptions(); var connectString = DatabaseConnectionControl1.ImportOptions.GetConnectionString(); var importDomain = new nHydrate.DataImport.SqlClient.ImportDomain(); var databaseHelper = importDomain.DatabaseDomain; var valid = databaseHelper.TestConnectionString(connectString); if (valid) { MessageBox.Show("Connection Succeeded.", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { MessageBox.Show("The information does not describe a valid connection string.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } } else if (optDatabaseTypePostgres.Checked) //Postgres { if (DslPackage.Objects.Postgres.ImportDomain.TestConnection(txtConnectionStringPostgres.Text)) { MessageBox.Show("Connection Succeeded.", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { MessageBox.Show("The information does not describe a valid connection string.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } } else { MessageBox.Show("Unknown database type.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } } catch (Exception ex) { MessageBox.Show("An error has occurred.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
//private void treeView1_AfterSelect(object sender, TreeViewEventArgs e) //{ // var d = e.Node.Tag as DataTreeItem; // if (d == null) txtChanged.Text = ""; // else txtChanged.Text = d.GetChangeText(); //} private void wizard1_BeforeSwitchPages(object sender, nHydrate.Wizard.Wizard.BeforeSwitchPagesEventArgs e) { if (wizard1.WizardPages[e.OldIndex] == pageConnection) { this.Cursor = Cursors.WaitCursor; try { DatabaseConnectionControl1.PersistSettings(); var connectionString = DatabaseConnectionControl1.ImportOptions.GetConnectionString(); var schemaModelHelper = new nHydrate.DataImport.SqlClient.SchemaModelHelper(); if (!schemaModelHelper.IsValidConnectionString(connectionString)) { this.Cursor = Cursors.Default; e.Cancel = true; MessageBox.Show("This not a valid connection string!", "Error!", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } //Setup new model var project = new nHydrate.DataImport.Database(); var auditFields = new List<SpecialField>(); auditFields.Add(new SpecialField { Name = _model.CreatedByColumnName, Type = SpecialFieldTypeConstants.CreatedBy }); auditFields.Add(new SpecialField { Name = _model.CreatedDateColumnName, Type = SpecialFieldTypeConstants.CreatedDate }); auditFields.Add(new SpecialField { Name = _model.ModifiedByColumnName, Type = SpecialFieldTypeConstants.ModifiedBy }); auditFields.Add(new SpecialField { Name = _model.ModifiedDateColumnName, Type = SpecialFieldTypeConstants.ModifedDate }); auditFields.Add(new SpecialField { Name = _model.TimestampColumnName, Type = SpecialFieldTypeConstants.Timestamp }); auditFields.Add(new SpecialField { Name = _model.TenantColumnName, Type = SpecialFieldTypeConstants.Tenant }); var pkey = ProgressHelper.ProgressingStarted("Importing...", true); try { var importDomain = new nHydrate.DataImport.SqlClient.ImportDomain(); this.NewDatabase = importDomain.Import(connectionString, auditFields); this.NewDatabase.CleanUp(); this.NewDatabase.SetupIdMap(this.CurrentDatabase); //nHydrate.DataImport.ImportDomain.ReMapIDs(this.CurrentDatabase, this.NewDatabase); //Remove tenant views NewDatabase.ViewList.Remove(x => x.Name.ToLower().StartsWith(_model.TenantPrefix.ToLower() + "_")); var errorCount = NewDatabase.StoredProcList.Count(x => x.InError); NewDatabase.StoredProcList.Remove(x => x.InError); //Load the tree this.Populate(); ProgressHelper.ProgressingComplete(pkey); if (errorCount > 0) MessageBox.Show("There were " + errorCount + " stored procedure(s) that could not be imported.", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning); } catch (Exception ex) { throw; } finally { ProgressHelper.ProgressingComplete(pkey); } if (!this.AreChanges()) { this.Cursor = Cursors.Default; e.Cancel = true; MessageBox.Show("This modelRoot is up-to-date. There are no changes to refresh.", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information); } } catch (Exception ex) { throw; } finally { this.Cursor = Cursors.Default; } } else if (wizard1.WizardPages[e.OldIndex] == pageConnection && wizard1.WizardPages[e.NewIndex] == pageEntities) { } else if (wizard1.WizardPages[e.OldIndex] == pageEntities && wizard1.WizardPages[e.NewIndex] == pageSummary) { //If there are no entities selected and relations are still checked then prompt var nodeCheckedList = tvwAdd.Nodes[0].Nodes.AsEnumerable<TreeNode>().Where(x => x.Checked).ToList(); nodeCheckedList.AddRange(tvwRefresh.Nodes[0].Nodes.AsEnumerable<TreeNode>().Where(x => x.Checked).ToList()); nodeCheckedList.AddRange(tvwDelete.Nodes[0].Nodes.AsEnumerable<TreeNode>().Where(x => x.Checked).ToList()); if (nodeCheckedList.Count == 0 && !chkIgnoreRelations.Checked) { var result = MessageBox.Show("There are no entities selected but relations will be refreshed. Do you want to turn off relation refreshing?", "Ignore Relations", MessageBoxButtons.YesNoCancel, MessageBoxIcon.Question); if (result == System.Windows.Forms.DialogResult.Yes) { chkIgnoreRelations.Checked = true; } else if (result == System.Windows.Forms.DialogResult.No) { //Do Nothing } else if (result == System.Windows.Forms.DialogResult.Cancel) { e.Cancel = true; return; } } //Moving the to the summary page CreateSummary(); } }
private void cmdTestConnection_Click(object sender, EventArgs e) { DatabaseConnectionControl1.RefreshOptions(); var connectString = DatabaseConnectionControl1.ImportOptions.GetConnectionString(); var importDomain = new nHydrate.DataImport.SqlClient.ImportDomain(); var databaseHelper = importDomain.DatabaseDomain; var valid = databaseHelper.TestConnectionString(connectString); if (valid) { MessageBox.Show("Connection Succeeded.", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { MessageBox.Show("The information does not describe a valid connection string.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void wizard1_BeforeSwitchPages(object sender, nHydrate.Wizard.Wizard.BeforeSwitchPagesEventArgs e) { var oldPage = wizard1.WizardPages[e.OldIndex]; var newPage = wizard1.WizardPages[e.NewIndex]; var importDomain = new nHydrate.DataImport.SqlClient.ImportDomain(); var databaseHelper = importDomain.DatabaseDomain; if ((oldPage == pageImport) && (e.NewIndex > e.OldIndex)) { //Test Connection var connectString = DatabaseConnectionControl1.ImportOptions.GetConnectionString(); var valid = databaseHelper.TestConnectionString(connectString); if (!valid) { MessageBox.Show("The information does not describe a valid connection string.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); e.Cancel = true; return; } //Load the dropdown var auditFields = new List<string>(); var list = importDomain.GetEntityList(connectString); cboTable.DataSource = list; cboTable.SelectedItem = list.FirstOrDefault(x => x.ToLower() == _entity.Name.ToLower()); } else if ((oldPage == pageChooseTable) && (e.NewIndex > e.OldIndex)) { //Verify that the table schema matches var connectionString = DatabaseConnectionControl1.ImportOptions.GetConnectionString(); var auditFields = new List<SpecialField>(); auditFields.Add(new SpecialField { Name = _entity.nHydrateModel.CreatedByColumnName, Type = SpecialFieldTypeConstants.CreatedBy }); auditFields.Add(new SpecialField { Name = _entity.nHydrateModel.CreatedDateColumnName, Type = SpecialFieldTypeConstants.CreatedDate }); auditFields.Add(new SpecialField { Name = _entity.nHydrateModel.ModifiedByColumnName, Type = SpecialFieldTypeConstants.ModifiedBy }); auditFields.Add(new SpecialField { Name = _entity.nHydrateModel.ModifiedDateColumnName, Type = SpecialFieldTypeConstants.ModifedDate }); auditFields.Add(new SpecialField { Name = _entity.nHydrateModel.TimestampColumnName, Type = SpecialFieldTypeConstants.Timestamp }); auditFields.Add(new SpecialField { Name = _entity.nHydrateModel.TenantColumnName, Type = SpecialFieldTypeConstants.Tenant }); var dsValues = databaseHelper.GetStaticData(connectionString, importDomain.GetEntity(connectionString, (string)cboTable.SelectedValue, auditFields)); this.LoadData(dsValues); } }