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;
}
