Exercise - Using Groups result

Your ProductsReport class should look like :

using System;
using System.Collections.Generic;
using System.Text;
using System.Drawing;
using Firefly.Box;
using ENV;
using ENV.Data;
using ENV.Printing;

namespace Northwind.Exercises
{
    public class ProductsReport : BusinessProcessBase
    {
        PrinterWriter _printer;
        Printing.ProductsReportLayout _layout;

        public readonly Models.Products Products = new Models.Products();
        public readonly Models.Categories Categories = new Models.Categories();
        public readonly NumberColumn TotallItemsPerCategory = new NumberColumn();
        public readonly NumberColumn TotalValuePerCategory = new NumberColumn();
 
        public ProductsReport()
        {
            From = Products;
            Relations.Add(Categories, RelationType.Find,
                Categories.CategoryID.IsEqualTo(Products.CategoryID));
 
-           OrderBy.Add(Products.ProductName);
            OrderBy.Add(Products.CategoryID);
            Groups[Products.CategoryID].Enter += () =>
            {
                _layout.CategoryHeader.WriteTo(_printer);
                TotallItemsPerCategory.Value = 0;
                TotalValuePerCategory.Value = 0;
            };
            Groups[Products.CategoryID].Leave += () =>
            {
                _layout.CategoryFooter.WriteTo(_printer);
            };
        }

        protected override void OnLoad()
        {
            _layout = new Printing.ProductsReportLayout(this);
-           _printer = new PrinterWriter { PrintPreview = true };
            _printer = new PrinterWriter { PrintPreview = true,PageHeader = _layout.ReportHeader,PageFooter=_layout.ReportFooter };
            Streams.Add(_printer);
        }

        protected override void OnLeaveRow()
        {
            _layout.Body.WriteTo(_printer);
            TotallItemsPerCategory.Value++;
            TotalValuePerCategory.Value += Products.UnitPrice;
        }

        public void Run()
        {
            Execute();
        }
        internal Date GetCurrentDate() => Date.Now;
        internal Number GetCureentPage() => _printer.Page;
    }
} 

The layout should look like :

---

Help us improve, Edit this page on GitHub
or email us at info@fireflymigration.com