private void wizard1_Finish(object sender, EventArgs e) { if (chkMergeModule.Checked && cboModule.SelectedIndex == -1) { MessageBox.Show("The merge module checkbox is selected but there is no selected module.", "Invalid Merge Module", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } var modifiedState = ImportStateConstants.Modified; if (chkMergeModule.Checked) modifiedState = ImportStateConstants.Merge; #region Entities var usedItems = new List<string>(); foreach (var node in tvwAdd.Nodes[0].Nodes.AsEnumerable<TreeNode>()) { if (node.Checked) { usedItems.Add(((DataTreeItem)node.Tag).Name.ToLower()); this.NewDatabase.EntityList.FirstOrDefault(x => x.Name.ToLower() == ((DataTreeItem)node.Tag).Name.ToLower()).ImportState = ImportStateConstants.Added; } } foreach (var node in tvwRefresh.Nodes[0].Nodes.AsEnumerable<TreeNode>()) { if (node.Checked) { usedItems.Add(((DataTreeItem)node.Tag).Name.ToLower()); this.NewDatabase.EntityList.FirstOrDefault(x => x.Name.ToLower() == ((DataTreeItem)node.Tag).Name.ToLower()).ImportState = modifiedState; } } foreach (var node in tvwDelete.Nodes[0].Nodes.AsEnumerable<TreeNode>()) { if (node.Checked) //if NOT checked then used { usedItems.Add(((DataTreeItem)node.Tag).Name.ToLower()); //this.NewDatabase.EntityList.FirstOrDefault(x => x.Name.ToLower() == ((DataTreeItem)node.Tag).Name.ToLower()).ImportState = ImportStateConstants.Deleted; this.NewDatabase.EntityList.Add(new nHydrate.DataImport.Entity() { Name = ((DataTreeItem)node.Tag).Name, ImportState = ImportStateConstants.Deleted }); } } //Remove all other items from the NewDatbase //this.NewDatabase.EntityList.RemoveAll(x => !usedItems.Contains(x.Name.ToLower())); #endregion #region Views usedItems = new List<string>(); foreach (var node in tvwAdd.Nodes[1].Nodes.AsEnumerable<TreeNode>()) { if (node.Checked) { usedItems.Add(((DataTreeItem)node.Tag).Name.ToLower()); this.NewDatabase.ViewList.FirstOrDefault(x => x.Name.ToLower() == ((DataTreeItem)node.Tag).Name.ToLower()).ImportState = ImportStateConstants.Added; } } foreach (var node in tvwRefresh.Nodes[1].Nodes.AsEnumerable<TreeNode>()) { if (node.Checked) { usedItems.Add(((DataTreeItem)node.Tag).Name.ToLower()); this.NewDatabase.ViewList.FirstOrDefault(x => x.Name.ToLower() == ((DataTreeItem)node.Tag).Name.ToLower()).ImportState = modifiedState; } } foreach (var node in tvwDelete.Nodes[1].Nodes.AsEnumerable<TreeNode>()) { if (node.Checked) { usedItems.Add(((DataTreeItem)node.Tag).Name.ToLower()); //this.NewDatabase.ViewList.FirstOrDefault(x => x.Name.ToLower() == ((DataTreeItem)node.Tag).Name.ToLower()).ImportState = ImportStateConstants.Deleted; this.NewDatabase.ViewList.Add(new nHydrate.DataImport.View() { Name = ((DataTreeItem)node.Tag).Name, ImportState = ImportStateConstants.Deleted }); } } //Remove all other items from the NewDatbase //this.NewDatabase.ViewList.RemoveAll(x => !usedItems.Contains(x.Name.ToLower())); #endregion #region Stored Procedures usedItems = new List<string>(); foreach (var node in tvwAdd.Nodes[2].Nodes.AsEnumerable<TreeNode>()) { if (node.Checked) { usedItems.Add(((DataTreeItem)node.Tag).Name.ToLower()); this.NewDatabase.StoredProcList.FirstOrDefault(x => x.Name.ToLower() == ((DataTreeItem)node.Tag).Name.ToLower()).ImportState = ImportStateConstants.Added; } } foreach (var node in tvwRefresh.Nodes[2].Nodes.AsEnumerable<TreeNode>()) { if (node.Checked) { usedItems.Add(((DataTreeItem)node.Tag).Name.ToLower()); this.NewDatabase.StoredProcList.FirstOrDefault(x => x.Name.ToLower() == ((DataTreeItem)node.Tag).Name.ToLower()).ImportState = modifiedState; } } foreach (var node in tvwDelete.Nodes[2].Nodes.AsEnumerable<TreeNode>()) { if (node.Checked) { usedItems.Add(((DataTreeItem)node.Tag).Name.ToLower()); //this.NewDatabase.StoredProcList.FirstOrDefault(x => x.Name.ToLower() == ((DataTreeItem)node.Tag).Name.ToLower()).ImportState = ImportStateConstants.Deleted; this.NewDatabase.StoredProcList.Add(new nHydrate.DataImport.StoredProc() { Name = ((DataTreeItem)node.Tag).Name, ImportState = ImportStateConstants.Deleted }); } } //Remove all other items from the NewDatbase //this.NewDatabase.StoredProcList.RemoveAll(x => !usedItems.Contains(x.Name.ToLower())); #endregion #region Functions usedItems = new List<string>(); foreach (var node in tvwAdd.Nodes[3].Nodes.AsEnumerable<TreeNode>()) { if (node.Checked) { usedItems.Add(((DataTreeItem)node.Tag).Name.ToLower()); this.NewDatabase.FunctionList.FirstOrDefault(x => x.Name.ToLower() == ((DataTreeItem)node.Tag).Name.ToLower()).ImportState = ImportStateConstants.Added; } } foreach (var node in tvwRefresh.Nodes[3].Nodes.AsEnumerable<TreeNode>()) { if (node.Checked) { usedItems.Add(((DataTreeItem)node.Tag).Name.ToLower()); this.NewDatabase.FunctionList.FirstOrDefault(x => x.Name.ToLower() == ((DataTreeItem)node.Tag).Name.ToLower()).ImportState = modifiedState; } } foreach (var node in tvwDelete.Nodes[3].Nodes.AsEnumerable<TreeNode>()) { if (node.Checked) { usedItems.Add(((DataTreeItem)node.Tag).Name.ToLower()); //this.NewDatabase.FunctionList.FirstOrDefault(x => x.Name.ToLower() == ((DataTreeItem)node.Tag).Name.ToLower()).ImportState = ImportStateConstants.Deleted; this.NewDatabase.FunctionList.Add(new nHydrate.DataImport.Function() { Name = ((DataTreeItem)node.Tag).Name, ImportState = ImportStateConstants.Deleted }); } } //Remove all other items from the NewDatbase //this.NewDatabase.FunctionList.RemoveAll(x => !usedItems.Contains(x.Name.ToLower())); #endregion this.NewDatabase.IgnoreRelations = chkIgnoreRelations.Checked; this.Status = ImportReturnConstants.Success; this.DialogResult = System.Windows.Forms.DialogResult.OK; }
private void wizard1_Finish(object sender, EventArgs e) { var modifiedState = ImportStateConstants.Modified; #region Entities var usedItems = new List <string>(); foreach (var node in tvwAdd.Nodes[0].Nodes.AsEnumerable <TreeNode>()) { if (node.Checked) { usedItems.Add(((DataTreeItem)node.Tag).Name.ToLower()); this.NewDatabase.EntityList.FirstOrDefault(x => x.Name.ToLower() == ((DataTreeItem)node.Tag).Name.ToLower()).ImportState = ImportStateConstants.Added; } } foreach (var node in tvwRefresh.Nodes[0].Nodes.AsEnumerable <TreeNode>()) { if (node.Checked) { usedItems.Add(((DataTreeItem)node.Tag).Name.ToLower()); this.NewDatabase.EntityList.FirstOrDefault(x => x.Name.ToLower() == ((DataTreeItem)node.Tag).Name.ToLower()).ImportState = modifiedState; } } foreach (var node in tvwDelete.Nodes[0].Nodes.AsEnumerable <TreeNode>()) { if (node.Checked) //if NOT checked then used { usedItems.Add(((DataTreeItem)node.Tag).Name.ToLower()); //this.NewDatabase.EntityList.FirstOrDefault(x => x.Name.ToLower() == ((DataTreeItem)node.Tag).Name.ToLower()).ImportState = ImportStateConstants.Deleted; this.NewDatabase.EntityList.Add(new nHydrate.DataImport.Entity() { Name = ((DataTreeItem)node.Tag).Name, ImportState = ImportStateConstants.Deleted }); } } //Remove all other items from the NewDatbase //this.NewDatabase.EntityList.RemoveAll(x => !usedItems.Contains(x.Name.ToLower())); #endregion #region Views usedItems = new List <string>(); foreach (var node in tvwAdd.Nodes[1].Nodes.AsEnumerable <TreeNode>()) { if (node.Checked) { usedItems.Add(((DataTreeItem)node.Tag).Name.ToLower()); this.NewDatabase.ViewList.FirstOrDefault(x => x.Name.ToLower() == ((DataTreeItem)node.Tag).Name.ToLower()).ImportState = ImportStateConstants.Added; } } foreach (var node in tvwRefresh.Nodes[1].Nodes.AsEnumerable <TreeNode>()) { if (node.Checked) { usedItems.Add(((DataTreeItem)node.Tag).Name.ToLower()); this.NewDatabase.ViewList.FirstOrDefault(x => x.Name.ToLower() == ((DataTreeItem)node.Tag).Name.ToLower()).ImportState = modifiedState; } } foreach (var node in tvwDelete.Nodes[1].Nodes.AsEnumerable <TreeNode>()) { if (node.Checked) { usedItems.Add(((DataTreeItem)node.Tag).Name.ToLower()); //this.NewDatabase.ViewList.FirstOrDefault(x => x.Name.ToLower() == ((DataTreeItem)node.Tag).Name.ToLower()).ImportState = ImportStateConstants.Deleted; this.NewDatabase.ViewList.Add(new nHydrate.DataImport.View() { Name = ((DataTreeItem)node.Tag).Name, ImportState = ImportStateConstants.Deleted }); } } //Remove all other items from the NewDatbase //this.NewDatabase.ViewList.RemoveAll(x => !usedItems.Contains(x.Name.ToLower())); #endregion this.NewDatabase.IgnoreRelations = chkIgnoreRelations.Checked; this.Status = ImportReturnConstants.Success; this.DialogResult = System.Windows.Forms.DialogResult.OK; }