protected virtual void Dispose(bool disposing)
{
if (disposing)
{
if (this.reportItemCollection != null)
{
this.reportItemCollection.Clear();
this.reportItemCollection = null;
}
if (this.availableFieldsCollection != null)
{
this.availableFieldsCollection.Clear();
this.availableFieldsCollection = null;
}
if (this.SqlQueryParameters != null)
{
this.SqlQueryParameters.Clear();
this.SqlQueryParameters = null;
}
}
// Release unmanaged resources.
// Set large fields to null.
// Call Dispose on your base class.
}
public static ReportModel CreateModel (string reportName)
{
ReportStructure structure = CreateReportStructure(reportName);
AvailableFieldsCollection abstractColumns = new AvailableFieldsCollection();
AbstractColumn a1 = new AbstractColumn("Field1",typeof(System.String));
structure.AvailableFieldsCollection.Add(a1);
ICSharpCode.Reports.Core.BaseDataItem bri = new ICSharpCode.Reports.Core.BaseDataItem();
bri.Name ="Field1";
structure.ReportItemCollection.Add(bri);
ReportModel m = structure.CreateAndFillReportModel();
ICSharpCode.Core.Properties customizer = new ICSharpCode.Core.Properties();
customizer.Set("Generator", structure);
customizer.Set("ReportLayout",GlobalEnums.ReportLayout.ListLayout);
IReportGenerator generator = new GeneratePushDataReport(m,customizer);
generator.GenerateReport();
ReportLoader rl = new ReportLoader();
object root = rl.Load(generator.XmlReport.DocumentElement);
ReportModel model = root as ReportModel;
if (model != null) {
model.ReportSettings.FileName = GlobalValues.PlainFileName;
FilePathConverter.AdjustReportName(model);
} else {
throw new InvalidReportModelException();
}
return model;
}
public void FindKeyNotExist()
{
this.itemCollection = this.PlainCollection();
AbstractColumn r = itemCollection.Find("t5");
Assert.IsNull(r);
}
public static ReportModel CreateModel (string reportName,bool createGrouping)
{
ReportStructure reportStructure = CreateReportStructure(reportName);
AvailableFieldsCollection abstractColumns = new AvailableFieldsCollection();
AbstractColumn a1 = new AbstractColumn("Field1",typeof(System.String));
reportStructure.AvailableFieldsCollection.Add(a1);
ICSharpCode.Reports.Core.BaseDataItem bri = new ICSharpCode.Reports.Core.BaseDataItem();
bri.Name ="Field1";
reportStructure.ReportItemCollection.Add(bri);
if (createGrouping) {
reportStructure.Grouping = "group";
}
ReportModel m = reportStructure.CreateAndFillReportModel();
IReportGenerator generator = new GeneratePushDataReport(m,reportStructure);
generator.GenerateReport();
ReportLoader rl = new ReportLoader();
object root = rl.Load(generator.XmlReport.DocumentElement);
ReportModel model = root as ReportModel;
if (model != null) {
model.ReportSettings.FileName = GlobalValues.PlainFileName;
FilePathConverter.AdjustReportName(model);
} else {
throw new InvalidReportModelException();
}
return model;
}
public void PlainCollectionFind()
{
this.itemCollection = this.PlainCollection();
AbstractColumn r = itemCollection.Find("t2");
Assert.AreEqual("t2", r.ColumnName);
}
public void Constructor()
{
AvailableFieldsCollection it = new AvailableFieldsCollection();
Assert.IsNotNull(it, "Should not be 'null'");
Assert.AreEqual(0, it.Count, "Count should be '0'");
}
private void WriteResult()
{
if (this.resultDataSet != null)
{
// check reordering of columns
DataGridViewColumn[] displayCols;
DataGridViewColumnCollection dc = this.grdQuery.Columns;
displayCols = new DataGridViewColumn[dc.Count];
for (int i = 0; i < dc.Count; i++)
{
if (dc[i].Visible)
{
displayCols[dc[i].DisplayIndex] = dc[i];
}
}
ReportItemCollection sourceItems = WizardHelper.ReportItemCollection(this.resultDataSet);
AvailableFieldsCollection abstractColumns = WizardHelper.AvailableFieldsCollection(this.resultDataSet);
ReportItemCollection destItems = new ReportItemCollection();
// only checked columns are used in the report
foreach (DataGridViewColumn cc in displayCols)
{
DataGridViewColumnHeaderCheckBoxCell hc = (DataGridViewColumnHeaderCheckBoxCell)cc.HeaderCell;
if (hc.Checked)
{
BaseReportItem br = (BaseReportItem)sourceItems.Find(cc.HeaderText);
destItems.Add(br);
}
}
reportStructure.ReportItemCollection.Clear();
reportStructure.ReportItemCollection.AddRange(destItems);
/*
* if ((this.sqlParamsCollection != null) && (this.sqlParamsCollection.Count > 0)) {
* reportStructure.SqlQueryParameters.AddRange(sqlParamsCollection);
* }
*/
if (abstractColumns != null)
{
reportStructure.AvailableFieldsCollection.Clear();
reportStructure.AvailableFieldsCollection.AddRange(abstractColumns);
}
/*
* if ((this.sqlParamsCollection != null) && (this.sqlParamsCollection.Count > 0)) {
* reportStructure.SqlQueryParameters.Clear();
* reportStructure.SqlQueryParameters.AddRange(sqlParamsCollection);
* }
*/
}
base.EnableNext = true;
base.EnableFinish = true;
}
public void AvaiableFields_Should_Be_Set()
{
var dataNavigator = PrepareStringGrouping();
dataNavigator.MoveNext();
IDataNavigator child = dataNavigator.GetChildNavigator();
AvailableFieldsCollection availableFieldsCollection = child.AvailableFields;
Assert.That(availableFieldsCollection, Is.Not.Null);
Assert.That(availableFieldsCollection.Count, Is.GreaterThan(0));
}
private AvailableFieldsCollection AvailableFieldsCollectionFromTable (DataTable table)
{
AvailableFieldsCollection av = new AvailableFieldsCollection();
AbstractColumn ac = null;
foreach (DataColumn dc in resultDataSet.Tables[0].Columns) {
Console.WriteLine("{0} - {1}",dc.ColumnName,dc.DataType);
ac = new AbstractColumn(dc.ColumnName,dc.DataType);
av.Add(ac);
}
return av;
}
private AvailableFieldsCollection AvailableFieldsCollectionFromTable(DataTable table)
{
AvailableFieldsCollection av = new AvailableFieldsCollection();
AbstractColumn ac = null;
foreach (DataColumn dc in resultDataSet.Tables[0].Columns)
{
Console.WriteLine("{0} - {1}", dc.ColumnName, dc.DataType);
ac = new AbstractColumn(dc.ColumnName, dc.DataType);
av.Add(ac);
}
return(av);
}
///<summary>
/// Build a <see cref="ColumnCollection"></see> this collection holds all the fields
/// comming from the DataSource
///</summary>
internal static AvailableFieldsCollection AvailableFieldsCollection(DataSet dataSet)
{
if (dataSet == null) {
throw new ArgumentNullException("dataSet");
}
AvailableFieldsCollection collection = new AvailableFieldsCollection();
foreach (DataTable dataTable in dataSet.Tables) {
foreach (DataColumn col in dataTable.Columns) {
collection.Add (new AbstractColumn(col.ColumnName,col.DataType));
}
}
return collection;
}
private AvailableFieldsCollection PlainCollection()
{
AvailableFieldsCollection ri = new AvailableFieldsCollection();
AbstractColumn t1 = new AbstractColumn();
t1.ColumnName = "t1";
ri.Add(t1);
t1 = new AbstractColumn();
t1.ColumnName = "t2";
ri.Add(t1);
t1 = new AbstractColumn();
t1.ColumnName = "t3";
ri.Add(t1);
return ri;
}
private AvailableFieldsCollection PlainCollection()
{
AvailableFieldsCollection ri = new AvailableFieldsCollection();
AbstractColumn t1 = new AbstractColumn();
t1.ColumnName = "t1";
ri.Add(t1);
t1 = new AbstractColumn();
t1.ColumnName = "t2";
ri.Add(t1);
t1 = new AbstractColumn();
t1.ColumnName = "t3";
ri.Add(t1);
return(ri);
}
/*
* private AvailableFieldsCollection ColumnsFromTable (DataTable table)
* {
* AvailableFieldsCollection av = new AvailableFieldsCollection();
* AbstractColumn ac = null;
* foreach (DataColumn dc in resultDataSet.Tables[0].Columns) {
* Console.WriteLine("{0} - {1}",dc.ColumnName,dc.DataType);
* ac = new AbstractColumn(dc.ColumnName,dc.DataType);
* av.Add(ac);
* }
* return av;
* }
*/
#region DataGridView
void FillDataGrid(string fileName)
{
this.resultDataSet = new DataSet();
this.resultDataSet.Locale = CultureInfo.CurrentCulture;
resultDataSet.ReadXml(fileName);
this.grdQuery.DataSource = resultDataSet.Tables[0];
this.abstractColumns = WizardHelper.AbstractColumnsFromDataSet(this.resultDataSet);
foreach (DataGridViewColumn dd in this.grdQuery.Columns)
{
DataGridViewColumnHeaderCheckBoxCell cb = new DataGridViewColumnHeaderCheckBoxCell();
cb.CheckBoxAlignment = HorizontalAlignment.Left;
cb.Checked = true;
dd.HeaderCell = cb;
}
base.EnableFinish = true;
}
///<summary>
/// Build a <see cref="ColumnCollection"></see> this collection holds all the fields
/// comming from the DataSource
///</summary>
internal static AvailableFieldsCollection AvailableFieldsCollection(DataSet dataSet)
{
if (dataSet == null)
{
throw new ArgumentNullException("dataSet");
}
AvailableFieldsCollection collection = new AvailableFieldsCollection();
foreach (DataTable dataTable in dataSet.Tables)
{
foreach (DataColumn col in dataTable.Columns)
{
collection.Add(new AbstractColumn(col.ColumnName, col.DataType));
}
}
return(collection);
}
public static ReportModel CreateModel(string reportName, bool createGrouping)
{
ReportStructure structure = CreateReportStructure(reportName);
AvailableFieldsCollection abstractColumns = new AvailableFieldsCollection();
AbstractColumn a1 = new AbstractColumn("Field1", typeof(System.String));
structure.AvailableFieldsCollection.Add(a1);
ICSharpCode.Reports.Core.BaseDataItem bri = new ICSharpCode.Reports.Core.BaseDataItem();
bri.Name = "Field1";
structure.ReportItemCollection.Add(bri);
if (createGrouping)
{
structure.Grouping = "group";
}
ReportModel m = structure.CreateAndFillReportModel();
ICSharpCode.Core.Properties customizer = new ICSharpCode.Core.Properties();
customizer.Set("Generator", structure);
customizer.Set("ReportLayout", GlobalEnums.ReportLayout.ListLayout);
IReportGenerator generator = new GeneratePushDataReport(m, customizer);
generator.GenerateReport();
ReportLoader rl = new ReportLoader();
object root = rl.Load(generator.XmlReport.DocumentElement);
ReportModel model = root as ReportModel;
if (model != null)
{
model.ReportSettings.FileName = GlobalValues.PlainFileName;
FilePathConverter.AdjustReportName(model);
}
else
{
throw new InvalidReportModelException();
}
return(model);
}
void FillDataGrid(string fileName)
{
this.resultDataSet = new DataSet();
this.resultDataSet.Locale = CultureInfo.CurrentCulture;
resultDataSet.ReadXml (fileName);
this.grdQuery.DataSource = resultDataSet.Tables[0];
this.abstractColumns = WizardHelper.AvailableFieldsCollection(this.resultDataSet);
foreach (DataGridViewColumn dd in this.grdQuery.Columns) {
DataGridViewColumnHeaderCheckBoxCell cb = new DataGridViewColumnHeaderCheckBoxCell();
cb.CheckBoxAlignment = HorizontalAlignment.Left;
cb.Checked = true;
dd.HeaderCell = cb;
}
base.EnableFinish = true;
}
void BaseValues()
{
this.useStandardPrinter = true;
this.graphicsUnit = GraphicsUnit.Pixel;
this.padding = new Padding(5);
this.defaultFont = GlobalValues.DefaultFont;
this.reportType = GlobalEnums.ReportType.FormSheet;
this.dataModel = GlobalEnums.PushPullModel.FormSheet;
this.pageSize = GlobalValues.DefaultPageSize;
this.topMargin = GlobalValues.DefaultPageMargin.Left;
this.bottomMargin = GlobalValues.DefaultPageMargin.Bottom;
this.leftMargin = GlobalValues.DefaultPageMargin.Left;
this.rightMargin = GlobalValues.DefaultPageMargin.Right;
this.availableFields = new AvailableFieldsCollection();
this.groupingsCollection = new ColumnCollection();
this.sortingCollection = new SortColumnCollection();
this.parameterCollection = new ParameterCollection();
}
public void FindWithNameIsNull()
{
itemCollection = this.PlainCollection();
AbstractColumn r = itemCollection.Find(null);
}
void BaseValues()
{
this.UseStandardPrinter = true;
this.GraphicsUnit = GraphicsUnit.Pixel;
this.Padding = new Padding(5);
this.DefaultFont = GlobalValues.DefaultFont;
this.ReportType = GlobalEnums.ReportType.FormSheet;
this.DataModel = GlobalEnums.PushPullModel.FormSheet;
this.CommandType = System.Data.CommandType.Text;
this.ConnectionString = String.Empty;
this.CommandText = String.Empty;
this.TopMargin = GlobalValues.DefaultPageMargin.Left;
this.BottomMargin = GlobalValues.DefaultPageMargin.Bottom;
this.LeftMargin = GlobalValues.DefaultPageMargin.Left;
this.RightMargin = GlobalValues.DefaultPageMargin.Right;
this.availableFields = new AvailableFieldsCollection();
this.groupingsCollection = new GroupColumnCollection();
this.sortingCollection = new SortColumnCollection();
this.parameterCollection = new ParameterCollection();
this.NoDataMessage = "No Data for this Report";
}
public void FindKeyNotExist ()
{
this.itemCollection = this.PlainCollection();
AbstractColumn r = itemCollection.Find("t5");
Assert.IsNull(r);
}
public void PlainCollectionFind ()
{
this.itemCollection = this.PlainCollection();
AbstractColumn r = itemCollection.Find("t2");
Assert.AreEqual("t2",r.ColumnName);
}
public void FindWithNameIsEmpty()
{
itemCollection = this.PlainCollection();
AbstractColumn r = itemCollection.Find(String.Empty);
}
protected virtual void Dispose(bool disposing){
if (disposing) {
if (this.reportItemCollection != null) {
this.reportItemCollection.Clear();
this.reportItemCollection = null;
}
if (this.availableFieldsCollection != null) {
this.availableFieldsCollection.Clear();
this.availableFieldsCollection = null;
}
if (this.queryParameters != null) {
this.queryParameters.Clear();
this.queryParameters = null;
}
}
// Release unmanaged resources.
// Set large fields to null.
// Call Dispose on your base class.
}
public void Constructor ()
{
AvailableFieldsCollection it = new AvailableFieldsCollection();
Assert.IsNotNull(it,"Should not be 'null'");
Assert.AreEqual(0,it.Count,"Count should be '0'");
}
public override bool ReceiveDialogMessage(DialogMessage message)
{
if (customizer == null)
{
customizer = (Properties)base.CustomizationObject;
reportStructure = (ReportStructure)customizer.Get("Generator");
}
if (message == DialogMessage.Activated)
{
this.model = reportStructure.CreateAndFillReportModel();
this.resultDataSet = FillGrid();
if (this.resultDataSet != null)
{
this.grdQuery.DataSource = this.resultDataSet.Tables[0];
foreach (DataGridViewColumn dd in this.grdQuery.Columns)
{
DataGridViewColumnHeaderCheckBoxCell cb = new DataGridViewColumnHeaderCheckBoxCell();
cb.CheckBoxAlignment = HorizontalAlignment.Right;
cb.Checked = true;
dd.HeaderCell = cb;
dd.SortMode = DataGridViewColumnSortMode.NotSortable;
}
this.grdQuery.AllowUserToOrderColumns = true;
}
base.EnableNext = true;
base.EnableFinish = true;
}
else if (message == DialogMessage.Finish)
{
if (this.resultDataSet != null)
{
// check reordering of columns
DataGridViewColumn[] displayCols;
DataGridViewColumnCollection dc = this.grdQuery.Columns;
displayCols = new DataGridViewColumn[dc.Count];
for (int i = 0; i < dc.Count; i++)
{
if (dc[i].Visible)
{
displayCols[dc[i].DisplayIndex] = dc[i];
}
}
// only checked columns are used in the report
ReportItemCollection sourceItems = WizardHelper.DataItemsFromDataSet(this.resultDataSet);
AvailableFieldsCollection abstractColumns = WizardHelper.AbstractColumnsFromDataSet(this.resultDataSet);
ReportItemCollection destItems = new ReportItemCollection();
foreach (DataGridViewColumn cc in displayCols)
{
DataGridViewColumnHeaderCheckBoxCell hc = (DataGridViewColumnHeaderCheckBoxCell)cc.HeaderCell;
if (hc.Checked)
{
BaseReportItem br = (BaseReportItem)sourceItems.Find(cc.HeaderText);
destItems.Add(br);
}
}
reportStructure.ReportItemCollection.AddRange(destItems);
if ((this.sqlParamsCollection != null) && (this.sqlParamsCollection.Count > 0))
{
reportStructure.SqlQueryParameters.AddRange(sqlParamsCollection);
}
if (abstractColumns != null)
{
reportStructure.AvailableFieldsCollection.AddRange(abstractColumns);
}
}
base.EnableNext = true;
base.EnableFinish = true;
}
return(true);
}
public void FindWithNameIsNull ()
{
itemCollection = this.PlainCollection();
AbstractColumn r = itemCollection.Find(null);
}
public void FindWithNameIsEmpty ()
{
itemCollection = this.PlainCollection();
AbstractColumn r = itemCollection.Find(String.Empty);
}
