Free cookie consent management tool by TermsFeed Policy Generator

source: branches/HeuristicLab.DataImporter/HeuristicLab.DataImporter.Command/Aggregation/DeleteRowsWithDuplicateKeyValuesCommand.cs @ 9277

Last change on this file since 9277 was 7625, checked in by mkommend, 13 years ago

#1734: merged changes in data importer from the heureka rep

File size: 2.8 KB
Line 
1#region License Information
2/* HeuristicLab
3 * Copyright (C) 2002-2012 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
22using System;
23using System.Collections.Generic;
24using System.Linq;
25using System.Text;
26using HeuristicLab.DataImporter.Data;
27using HeuristicLab.DataImporter.Data.CommandBase;
28using HeuristicLab.DataImporter.Data.Model;
29using HeuristicLab.Persistence.Default.CompositeSerializers.Storable;
30
31namespace HeuristicLab.DataImporter.Command {
32  [StorableClass]
33  [ViewableCommandInfoAttribute("Delete Rows", 1, ColumnGroupState.Sorted, "Aggregation", Position = 5)]
34  public class DeleteRowsWithDuplicateKeyValuesCommand : ColumnGroupCommandBase {
35    private Dictionary<int, IComparable[]> deletedRows;
36    private DeleteRowsWithDuplicateKeyValuesCommand()
37      : base(null, string.Empty) {
38      deletedRows = new Dictionary<int, IComparable[]>();
39    }
40
41    public DeleteRowsWithDuplicateKeyValuesCommand(DataSet dataSet, string columnGroupName)
42      : base(dataSet, columnGroupName) {
43      deletedRows = new Dictionary<int, IComparable[]>();
44    }
45
46    public override string Description {
47      get { return "Delete rows with duplicate key values"; }
48    }
49
50    public override void Execute() {
51      base.Execute();
52      if (!ColumnGroup.Columns.Any()) return;
53      if (!ColumnGroup.Sorted)
54        throw new CommandExecutionException("ColumnGroup must be sorted to delete rows with duplicate key.", this);
55
56      for (int i = 0; i < ColumnGroup.RowCount - 1; i++) {
57        if (ColumnGroup.KeyString(i) == ColumnGroup.KeyString(i + 1))
58          deletedRows[i + 1] = ColumnGroup.GetRow(i + 1);
59      }
60
61      foreach (int i in deletedRows.Keys.Reverse())
62        ColumnGroup.DeleteRow(i);
63
64      ColumnGroup.FireChanged();
65    }
66
67    public override void UndoExecute() {
68      base.UndoExecute();
69      foreach (KeyValuePair<int, IComparable[]> deletedRow in deletedRows)
70        ColumnGroup.InsertRow(deletedRow.Key, deletedRow.Value);
71      deletedRows.Clear();
72      ColumnGroup.FireChanged();
73
74    }
75  }
76}
Note: See TracBrowser for help on using the repository browser.