← Back to branch summary

~halega/+junk/sharpdevelop

« back to all changes in this revision

Viewing changes to src/AddIns/Misc/Reports/ICSharpCode.Reports.Core/Test/ICSharpCode.Reports.Core.Test/DataManager/TableStragy/GroupTableFixture.cs

  • Committer: sk
  • Date: 2011-09-10 05:17:57 UTC
  • Revision ID: halega@halega.com-20110910051757-qfouz1llya9m6boy
4.1.0.7915 Release Candidate 1

Show diffs side-by-side

added added

removed removed

Lines of Context:
src/AddIns/Misc/Reports/ICSharpCode.Reports.Core/Test/ICSharpCode.Reports.Core.Test/DataManager/TableStragy/GroupTableFixture.cs
 
1
// Copyright (c) AlphaSierraPapa for the SharpDevelop Team (for details please see \doc\copyright.txt)
 
2
// This code is distributed under the GNU LGPL (for details please see \doc\license.txt)
 
3
 
 
4
using System;
 
5
using System.ComponentModel;
 
6
using System.Data;
 
7
 
 
8
using ICSharpCode.Reports.Core.Test.TestHelpers;
 
9
using NUnit.Framework;
 
10
 
 
11
namespace ICSharpCode.Reports.Core.Test.DataManager.TableStrategy
 
12
{
 
13
        
 
14
        [TestFixture]
 
15
        public class GroupTableFixture
 
16
        {
 
17
                
 
18
                DataTable table;
 
19
                
 
20
                [Test]
 
21
                public void AddGroupColumn ()
 
22
                {
 
23
                        GroupColumn gc = new GroupColumn("GroupItem",1,ListSortDirection.Ascending);
 
24
                        ReportSettings rs = new ReportSettings();
 
25
                        
 
26
                        rs.GroupColumnsCollection.Add(gc);
 
27
                        Assert.AreEqual(1,rs.GroupColumnsCollection.Count);
 
28
                }
 
29
                
 
30
                
 
31
                [Test]
 
32
                public void AvaiableFieldsShouldSet()
 
33
                {
 
34
                        var dataNavigator = PrepareStringGrouping();
 
35
                        dataNavigator.MoveNext();
 
36
                        IDataNavigator child = dataNavigator.GetChildNavigator;
 
37
                        AvailableFieldsCollection availableFieldsCollection = child.AvailableFields;
 
38
                        Assert.That(availableFieldsCollection,Is.Not.Null);
 
39
                        Assert.That(availableFieldsCollection.Count,Is.GreaterThan(0));
 
40
                }
 
41
                
 
42
                
 
43
                #region Group by String
 
44
                
 
45
                [Test]
 
46
                public void HasChildren()
 
47
                {
 
48
                        var dataNavigator = PrepareStringGrouping();
 
49
                        while (dataNavigator.MoveNext()) {
 
50
                                Assert.That(dataNavigator.HasChildren,Is.True);
 
51
                        }
 
52
                }
 
53
                
 
54
                [Test]
 
55
                public void ReadChildCount ()
 
56
                {
 
57
                        var dataNavigator = PrepareStringGrouping();
 
58
                        while (dataNavigator.MoveNext())
 
59
                        {
 
60
                                if (dataNavigator.HasChildren)
 
61
                                {
 
62
                                        var childNavigator = dataNavigator.GetChildNavigator;
 
63
                                        Assert.That(childNavigator.Count,Is.GreaterThan(0));
 
64
                                }
 
65
                        }
 
66
                }
 
67
                
 
68
                
 
69
                [Test]
 
70
                public void CeckGrouping()
 
71
                {
 
72
                        var dataNavigator = PrepareStringGrouping();
 
73
                        string compare = string.Empty;
 
74
                        
 
75
                        while (dataNavigator.MoveNext())
 
76
                        {
 
77
                                DataRow dr = dataNavigator.Current as DataRow;
 
78
                                var result = dr[3].ToString();
 
79
                                Assert.That (compare,Is.LessThan(result));
 
80
                                compare =  result;
 
81
                        }
 
82
                }
 
83
                        
 
84
                
 
85
                [Test]
 
86
                public void FillChild()
 
87
                {
 
88
                        var dataNavigator = PrepareStringGrouping();
 
89
                        string compare = string.Empty;
 
90
                        
 
91
                        while (dataNavigator.MoveNext())
 
92
                        {
 
93
                                DataRow dr = dataNavigator.Current as DataRow;
 
94
                                Assert.That (compare,Is.LessThan(dr[3].ToString()));
 
95
                                if (dataNavigator.HasChildren)
 
96
                                {
 
97
                                        var childNavigator = dataNavigator.GetChildNavigator;
 
98
                                        do
 
99
                                        {
 
100
                                                Assert.That(dataNavigator.HasChildren,Is.True);
 
101
                                                DataRow r = childNavigator.Current as DataRow;
 
102
                                                Assert.That( r[3].ToString(),Is.Not.Empty);
 
103
//                                              string v2 = r["last"].ToString() + " GroupVal :" +  r[3].ToString();
 
104
//                                              Console.WriteLine(v2);
 
105
                                        }
 
106
                                        while (childNavigator.MoveNext());
 
107
                                }
 
108
                                compare =  dr[3].ToString();
 
109
                        }
 
110
                }
 
111
                
 
112
                
 
113
                [Test]
 
114
                public void SortChildrenDescending()
 
115
                {
 
116
                        ReportSettings rs = new ReportSettings();
 
117
                        GroupColumn gc = new GroupColumn("GroupItem",1,ListSortDirection.Ascending);
 
118
                        rs.GroupColumnsCollection.Add(gc);
 
119
                        
 
120
                        SortColumn sc = new SortColumn("Last",ListSortDirection.Descending);
 
121
                        rs.SortColumnsCollection.Add(sc);
 
122
                        IDataManager dm = ICSharpCode.Reports.Core.DataManager.CreateInstance(this.table,rs);
 
123
                        var dataNavigator = dm.GetNavigator;
 
124
                        
 
125
                        string compare = String.Empty;
 
126
                        
 
127
                        while (dataNavigator.MoveNext())
 
128
                        {
 
129
                                DataRow dr = dataNavigator.Current as DataRow;
 
130
                                var result = dr[3].ToString();
 
131
                                Assert.That(compare,Is.LessThan(result));
 
132
                                if (dataNavigator.HasChildren)
 
133
                                {
 
134
                                        string compareChild = String.Empty;
 
135
                                        var childNavigator = dataNavigator.GetChildNavigator;
 
136
                                        do
 
137
                                        {
 
138
                                                DataRow childRow = childNavigator.Current as DataRow;
 
139
                                                var childResult = childRow[1].ToString();
 
140
                                                if (!String.IsNullOrEmpty(compareChild)) {
 
141
                                                        Assert.LessOrEqual(childResult,compareChild);
 
142
                                                }
 
143
//                                              Console.WriteLine("\t{0}",childResult);
 
144
                                                compareChild = childResult;
 
145
                                        }
 
146
                                        while (childNavigator.MoveNext());
 
147
                                }
 
148
                                compare = result;
 
149
                        }
 
150
                }
 
151
                
 
152
                
 
153
                #endregion
 
154
                
 
155
                #region GroupbyDataTime
 
156
                
 
157
                [Test]
 
158
                public void DateTimeCanFillChild()
 
159
                {
 
160
                        var dataNavigator = PrepareDateTimeGrouping();
 
161
                        var compare = System.DateTime.MinValue;
 
162
                        
 
163
                        while (dataNavigator.MoveNext()) 
 
164
                        {
 
165
                                
 
166
                                DataRow dr = dataNavigator.Current as DataRow;
 
167
                                var result = Convert.ToDateTime(dr[5]);
 
168
                                Assert.That (compare,Is.LessThan(result));
 
169
                                
 
170
                                if (dataNavigator.HasChildren)
 
171
                                {
 
172
                                        var childNavigator = dataNavigator.GetChildNavigator;
 
173
                                        do
 
174
                                        {
 
175
                                                Assert.That(dataNavigator.HasChildren,Is.True);
 
176
                                                DataRow r = childNavigator.Current as DataRow;
 
177
                                                Assert.That( r[3].ToString(),Is.Not.Empty);
 
178
//                                              string v2 = r["last"].ToString() + " GroupVal :" +  r[5].ToString();
 
179
//                                              Console.WriteLine(v2);
 
180
                                        }
 
181
                                        while (childNavigator.MoveNext());
 
182
                                }
 
183
                                compare =  Convert.ToDateTime(dr[5]);
 
184
                        }
 
185
                }
 
186
                
 
187
                
 
188
                [Test]
 
189
                public void DataTimeHasChildren()
 
190
                {
 
191
                        var dataNav = PrepareDateTimeGrouping();
 
192
                        while (dataNav.MoveNext()) {
 
193
                                Assert.That(dataNav.HasChildren,Is.True);
 
194
                        }
 
195
                }
 
196
                
 
197
                #endregion
 
198
                
 
199
                #region Try make recursive with ChildNavigator
 
200
        
 
201
                [Test]
 
202
                public void GetChildNavigator ()
 
203
                {
 
204
//                      Console.WriteLine("Start Recusive Version");
 
205
                        var dataNavigator = PrepareStringGrouping();
 
206
                        
 
207
                        while (dataNavigator.MoveNext()) {
 
208
                                if (dataNavigator.HasChildren) {
 
209
                                        DataRow r = dataNavigator.Current as DataRow;
 
210
                                        
 
211
                                        string v2 = r["last"].ToString() + " GroupVal :" +  r[3].ToString() ;
 
212
                                        IDataNavigator child = dataNavigator.GetChildNavigator;
 
213
                                        
 
214
//                                      Console.WriteLine(v2);
 
215
                                        Assert.That (child,Is.Not.Null);
 
216
                                        RecursiveCall(child);
 
217
                                }
 
218
                        }
 
219
                }
 
220
                
 
221
                
 
222
                private void RecursiveCall (IDataNavigator startNavigator)
 
223
                {
 
224
                        do
 
225
                        {
 
226
                                DataRow r = startNavigator.Current as DataRow;
 
227
                                string v1 = r["last"].ToString() + " :" +  r[3].ToString();
 
228
                                Console.WriteLine("\t {0}",v1);
 
229
                                if (startNavigator.HasChildren) {
 
230
                                        IDataNavigator child = startNavigator.GetChildNavigator;
 
231
                                        Console.WriteLine("header {0} - Child_Count:{1}",v1,child.Count);
 
232
                                        RecursiveCall (child);
 
233
                                }
 
234
                                
 
235
                        } while (startNavigator.MoveNext());
 
236
                }
 
237
        
 
238
                
 
239
                #endregion
 
240
                
 
241
                
 
242
                private IDataNavigator PrepareStringGrouping ()
 
243
                {
 
244
                        GroupColumn gc = new GroupColumn("GroupItem",1,ListSortDirection.Ascending);
 
245
                        ReportSettings rs = new ReportSettings();
 
246
                        rs.GroupColumnsCollection.Add(gc);
 
247
                        IDataManager dm = ICSharpCode.Reports.Core.DataManager.CreateInstance(this.table,rs);
 
248
                        return dm.GetNavigator;
 
249
                }
 
250
                
 
251
                
 
252
                private IDataNavigator PrepareDateTimeGrouping ()
 
253
                {
 
254
                        ReportSettings rs = new ReportSettings();
 
255
                        GroupColumn gc = new GroupColumn("RandomDate",1,ListSortDirection.Ascending);
 
256
                        rs.GroupColumnsCollection.Add(gc);
 
257
                        IDataManager dm = ICSharpCode.Reports.Core.DataManager.CreateInstance(this.table,rs);
 
258
                        return dm.GetNavigator;
 
259
                }
 
260
                
 
261
                
 
262
                [TestFixtureSetUp]
 
263
                public void Init()
 
264
                {
 
265
                        ContributorsList contributorsList = new ContributorsList();
 
266
                        this.table = contributorsList.ContributorTable;
 
267
                }
 
268
                
 
269
                
 
270
                [TestFixtureTearDown]
 
271
                public void Dispose()
 
272
                {
 
273
                        // TODO: Add tear down code.
 
274
                }
 
275
        }
 
276
}