public NodeTab(IEventAggregator eventAggregator, NodeExcel nodeExcel, MainViewModel viewModel) : base(eventAggregator)
{
this.viewModel = viewModel;
NodeExcel = nodeExcel;
AddTable = new DelegateCommand(DoAddTable);
AddTables = new DelegateCommand(DoAddTables);
Request = new AddTablesAndColumnsRequest();
}
private void DoAddTables()
{
AddTablesAndColumnsRequest.Raise(new AddTablesAndColumnsConfirmation(viewModel.DataViewModel)
{
Title = "Adding tables and columns..."
}, (result) =>
{
if (result != null && result.Confirmed && result.SelectedSprint != null && result.SelectedSprint.DbSchemaTables != null)
{
foreach (var t in result.SelectedSprint.DbSchemaTables)
{
if (t.IsChecked && t.IsVisible)
{
var newDBTable = new NodeDbTable(EventAggregator, this, viewModel)
{
Name = t.Name
};
if (t.Columns != null)
{
newDBTable.Nodes = new ObservableCollection <NodeDbColumn>();
foreach (var c in t.Columns)
{
if (c.IsChecked && c.IsVisible)
{
var newCol = new NodeDbColumn(EventAggregator, newDBTable, viewModel)
{
Name = c.Name
};
newDBTable.Nodes.Add(newCol);
}
}
}
this.Nodes.Add(newDBTable);
}
}
}
});
}
