prs/prs.classes/Entities/Product/TotalRequiredAggregate.cs

using System;
using System.Collections.Generic;
using System.Linq.Expressions;
using InABox.Core;

namespace Comal.Classes
{
    public class TotalRequiredAggregate : CoreAggregate<Product, JobRequisitionItem, double>
    {
        public override Expression<Func<JobRequisitionItem, double>> Aggregate => x => x.TotalQty;

        public override Dictionary<Expression<Func<JobRequisitionItem, object>>, Expression<Func<Product, object>>> Links =>
            new Dictionary<Expression<Func<JobRequisitionItem, object>>, Expression<Func<Product, object>>>()
            {
                { JobMaterialRequisitionItem => JobMaterialRequisitionItem.Product.ID, Product => Product.ID }
            };

        public override AggregateCalculation Calculation => AggregateCalculation.Sum;
    }
}