public void GroupbyOneColumnSortSubList()
{
var rs = new ReportSettings();
var gc = new GroupColumn()
{
ColumnName = "GroupItem",
SortDirection = ListSortDirection.Ascending,
GroupSortColumn = new SortColumn()
{
ColumnName = "Randomint",
SortDirection = ListSortDirection.Ascending
}
};
rs.GroupColumnsCollection.Add(gc);
var collectionSource = new CollectionDataSource(list, rs);
collectionSource.Bind();
var testKey = String.Empty;
var testSubKey = -1;
var groupedList = collectionSource.GroupedList;
foreach (var element in groupedList)
{
Assert.That(element.Key, Is.GreaterThan(testKey));
testKey = element.Key.ToString();
foreach (Contributor sub in element)
{
Assert.That(sub.RandomInt, Is.GreaterThanOrEqualTo(testSubKey));
testSubKey = sub.RandomInt;
}
testSubKey = -1;
}
}
public void DataItemWithNoColumnNameHasErrorMessageInDbValue()
{
var baseRow = new BaseRowItem();
var dataItem = new BaseDataItem()
{
};
baseRow.Items.Add(dataItem);
var row = new System.Collections.Generic.List <IPrintableObject>();
row.Add(baseRow);
var reportSettings = new ReportSettings();
var collectionSource = new CollectionDataSource(list, reportSettings);
collectionSource.Bind();
foreach (var element in collectionSource.SortedList)
{
collectionSource.Fill(row, element);
var r = (BaseRowItem)row[0];
foreach (var result in r.Items)
{
Assert.That(((BaseDataItem)result).DBValue.StartsWith("Missing"), Is.EqualTo(true));
}
}
}
public void FillDataIncludedInRow()
{
var baseRow = new BaseRowItem();
var dataItemsCollection = CreateDataItems();
baseRow.Items.AddRange(dataItemsCollection);
var row = new System.Collections.Generic.List <IPrintableObject>();
row.Add(baseRow);
var reportSettings = new ReportSettings();
var collectionSource = new CollectionDataSource(list, reportSettings);
collectionSource.Bind();
int i = 0;
foreach (var element in collectionSource.SortedList)
{
collectionSource.Fill(row, element);
var r = (BaseRowItem)row[0];
foreach (var result in r.Items)
{
Assert.That(((BaseDataItem)result).DBValue, Is.Not.Empty);
}
i++;
}
Assert.That(i, Is.EqualTo(collectionSource.Count));
}
void CreateDataSource()
{
DataSource = new CollectionDataSource(List, ReportModel.ReportSettings);
if (DataSourceContainsData())
{
DataSource.Bind();
}
}
public void RowContainsRowAndItem()
{
var row = new System.Collections.Generic.List <IPrintableObject>();
var gItem = new BaseDataItem()
{
ColumnName = "GroupItem"
};
row.Add(gItem);
var baseRow = new BaseRowItem();
var ric = new System.Collections.Generic.List <IPrintableObject>()
{
new BaseDataItem()
{
ColumnName = "Lastname"
},
new BaseDataItem()
{
ColumnName = "Firstname"
}
};
baseRow.Items.AddRange(ric);
row.Add(baseRow);
var rs = new ReportSettings();
var collectionSource = new CollectionDataSource(list, rs);
collectionSource.Bind();
int i = 0;
foreach (var element in collectionSource.SortedList)
{
collectionSource.Fill(row, element);
var res = (BaseDataItem)row.Find(c => ((BaseDataItem)c).ColumnName == "GroupItem");
Assert.That(res.DBValue, Is.Not.Empty);
i++;
}
/*
* do {
* collectionSource.Fill(row);
* var res = (BaseDataItem)row.Find(c => ((BaseDataItem)c).ColumnName == "GroupItem");
* Assert.That(res.DBValue,Is.Not.Empty);
* i ++;
* }while (collectionSource.MoveNext());
*/
Assert.That(i, Is.EqualTo(collectionSource.Count));
}
public void CreateExportlist()
{
collection = new Collection <ExportText>();
collection.Add(new ExportText()
{
Text = String.Empty
});
helper = new AggregateFuctionHelper();
aggregateCollection = helper.AggregateCollection;
dataSource = new CollectionDataSource(aggregateCollection, new ReportSettings());
dataSource.Bind();
visitor = new ExpressionVisitor(new ReportSettings());
visitor.SetCurrentDataSource(dataSource.SortedList);
}
public void SortOneColumnAscending()
{
var ric = new System.Collections.Generic.List <IPrintableObject>()
{
new BaseDataItem()
{
ColumnName = "Lastname"
},
new BaseDataItem()
{
ColumnName = "Firstname"
}
};
var rs = new ReportSettings();
rs.SortColumnsCollection.Add(new SortColumn("Lastname", ListSortDirection.Ascending));
var collectionSource = new CollectionDataSource(list, rs);
collectionSource.Bind();
string compare = String.Empty;
int i = 0;
foreach (var element in collectionSource.SortedList)
{
collectionSource.Fill(ric, element);
// Console.WriteLine("first : <{0}> Last <{1}> ",((BaseDataItem)ric[0]).DBValue,((BaseDataItem)ric[1]).DBValue);
Assert.That(((BaseDataItem)ric[0]).DBValue, Is.GreaterThanOrEqualTo(compare));
compare = ((BaseDataItem)ric[0]).DBValue;
i++;
}
/*
* do {
* collectionSource.Fill(ric);
* Console.WriteLine("first : <{0}> Last <{1}> ",((BaseDataItem)ric[0]).DBValue,
* ((BaseDataItem)ric[1]).DBValue);
* Assert.That(((BaseDataItem)ric[0]).DBValue,Is.GreaterThanOrEqualTo(compare));
* compare = ((BaseDataItem)ric[0]).DBValue;
*
* i ++;
* }while (collectionSource.MoveNext());
*
*/
Assert.That(i, Is.EqualTo(collectionSource.Count));
}
public void GroupbyOneColumn()
{
var rs = new ReportSettings();
rs.GroupColumnsCollection.Add(new GroupColumn("GroupItem", 1, ListSortDirection.Ascending));
var collectionSource = new CollectionDataSource(list, rs);
collectionSource.Bind();
var testKey = String.Empty;
var groupedList = collectionSource.GroupedList;
foreach (var element in groupedList)
{
Assert.That(element.Key, Is.GreaterThan(testKey));
testKey = element.Key.ToString();
}
}
public void CreateExportlist()
{
reportItemCollection = new Collection <ExportText>();
reportItemCollection.Add(new ExportText()
{
Text = String.Empty
});
var contributorList = new ContributorsList();
list = contributorList.ContributorCollection;
reportSettings = new ReportSettings();
reportSettings.GroupColumnsCollection.Add(
new GroupColumn("groupItem", 1, ListSortDirection.Ascending)
);
dataSource = new CollectionDataSource(list, reportSettings);
dataSource.Bind();
}
public void GroupbyOneColumnAndFill()
{
var dataItemsCollection = CreateDataItems();
var reportsettings = new ReportSettings();
reportsettings.GroupColumnsCollection.Add(new GroupColumn("GroupItem", 1, ListSortDirection.Ascending));
//repiortsettings.GroupColumnsCollection.Add( new GroupColumn("RandomInt",1,ListSortDirection.Ascending));
var collectionSource = new CollectionDataSource(list, reportsettings);
collectionSource.Bind();
int i = 0;
foreach (var element in collectionSource.GroupedList)
{
Console.WriteLine("Key {0} ", element.Key);
foreach (var l in element)
{
collectionSource.Fill(dataItemsCollection, l);
Console.WriteLine("first : <{0}> Last <{1}> Group <{2}> Randomint <{3}>", ((BaseDataItem)dataItemsCollection[0]).DBValue,
((BaseDataItem)dataItemsCollection[1]).DBValue,
((BaseDataItem)dataItemsCollection[2]).DBValue,
((BaseDataItem)dataItemsCollection[3]).DBValue);
i++;
}
}
/*
* do {
* collectionSource.Fill(dataItemsCollection);
* Console.WriteLine("first : <{0}> Last <{1}> Group <{2}> Randomint <{3}>",((BaseDataItem)dataItemsCollection[0]).DBValue,
* ((BaseDataItem)dataItemsCollection[1]).DBValue,
* ((BaseDataItem)dataItemsCollection[2]).DBValue,
* ((BaseDataItem)dataItemsCollection[3]).DBValue);
* i ++;
* }while (collectionSource.MoveNext());
*/
Assert.That(i, Is.EqualTo(collectionSource.Count));
}
public void TypeOfReportItemIsString()
{
var ric = new System.Collections.Generic.List <IPrintableObject>()
{
new BaseDataItem()
{
ColumnName = "Lastname"
},
new BaseDataItem()
{
ColumnName = "Firstname"
}
};
var collectionSource = new CollectionDataSource(list, new ReportSettings());
collectionSource.Bind();
var result = collectionSource.SortedList.FirstOrDefault();
collectionSource.Fill(ric, result);
foreach (BaseDataItem element in ric)
{
Assert.That(element.DataType, Is.EqualTo("System.String"));
}
}
