[6134] | 1 | #region License Information
|
---|
| 2 | /* HeuristicLab
|
---|
| 3 | * Copyright (C) 2002-2011 Heuristic and Evolutionary Algorithms Laboratory (HEAL)
|
---|
| 4 | *
|
---|
| 5 | * This file is part of HeuristicLab.
|
---|
| 6 | *
|
---|
| 7 | * HeuristicLab is free software: you can redistribute it and/or modify
|
---|
| 8 | * it under the terms of the GNU General Public License as published by
|
---|
| 9 | * the Free Software Foundation, either version 3 of the License, or
|
---|
| 10 | * (at your option) any later version.
|
---|
| 11 | *
|
---|
| 12 | * HeuristicLab is distributed in the hope that it will be useful,
|
---|
| 13 | * but WITHOUT ANY WARRANTY; without even the implied warranty of
|
---|
| 14 | * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
|
---|
| 15 | * GNU General Public License for more details.
|
---|
| 16 | *
|
---|
| 17 | * You should have received a copy of the GNU General Public License
|
---|
| 18 | * along with HeuristicLab. If not, see <http://www.gnu.org/licenses/>.
|
---|
| 19 | */
|
---|
| 20 | #endregion
|
---|
| 21 |
|
---|
| 22 | using System;
|
---|
[6133] | 23 | using System.Collections.Generic;
|
---|
| 24 | using System.Linq;
|
---|
| 25 | using System.Text;
|
---|
| 26 | using System.Xml;
|
---|
| 27 | using HeuristicLab.DataImporter.Data.Model;
|
---|
| 28 | using HeuristicLab.DataImporter.Data.CommandBase;
|
---|
| 29 | using HeuristicLab.DataImporter.DbExplorer.Interfaces;
|
---|
| 30 | using HeuristicLab.Persistence.Default.CompositeSerializers.Storable;
|
---|
| 31 |
|
---|
| 32 | namespace HeuristicLab.DataImporter.DataProcessor.Command {
|
---|
| 33 | [StorableClass]
|
---|
| 34 | public class LoadColumnGroupsFromDBCommand : DatabaseCommandBase {
|
---|
| 35 | [Storable]
|
---|
| 36 | private List<DbTable> tables;
|
---|
| 37 |
|
---|
| 38 | private List<ColumnGroup> newColumnGroups;
|
---|
| 39 |
|
---|
| 40 | private LoadColumnGroupsFromDBCommand()
|
---|
| 41 | : base(null, null) {
|
---|
| 42 | this.newColumnGroups = new List<ColumnGroup>();
|
---|
| 43 | }
|
---|
| 44 |
|
---|
| 45 | public LoadColumnGroupsFromDBCommand(DataSet dataSet, IDbExplorer dbExplorer, IEnumerable<DbTable> tables)
|
---|
| 46 | : base(dataSet, dbExplorer) {
|
---|
| 47 | this.tables = new List<DbTable>(tables);
|
---|
| 48 | this.newColumnGroups = new List<ColumnGroup>();
|
---|
| 49 | }
|
---|
| 50 |
|
---|
| 51 | public override string Description {
|
---|
| 52 | get { return "Load ColumnGroups from database"; }
|
---|
| 53 | }
|
---|
| 54 |
|
---|
| 55 | public override void Execute() {
|
---|
| 56 | base.Execute();
|
---|
| 57 | if (DbExplorer == null || !DbExplorer.IsConnected)
|
---|
| 58 | throw new CommandExecutionException("Could not load data because no connection to the database exists", this);
|
---|
| 59 | ColumnGroup columnGroup;
|
---|
| 60 | foreach (DbTable table in tables) {
|
---|
| 61 | columnGroup = DbExplorer.CreateColumnGroup(table);
|
---|
| 62 | this.DataSet.AddColumnGroup(columnGroup);
|
---|
| 63 | newColumnGroups.Add(columnGroup);
|
---|
| 64 | }
|
---|
| 65 | this.DataSet.FireChanged();
|
---|
| 66 | }
|
---|
| 67 |
|
---|
| 68 | public override void UndoExecute() {
|
---|
| 69 | base.UndoExecute();
|
---|
| 70 | foreach (ColumnGroup columnGroup in newColumnGroups)
|
---|
| 71 | this.DataSet.RemoveColumnGroup(columnGroup);
|
---|
| 72 | newColumnGroups.Clear();
|
---|
| 73 | this.DataSet.FireChanged();
|
---|
| 74 | }
|
---|
| 75 | }
|
---|
| 76 | }
|
---|