prs/prs.classes/Entities/Product/ProductLookups.cs

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

namespace Comal.Classes
{
    public class ProductLookups : EntityLookup<Product>, 
        ILookupDefinition<Product, StockMovement>, 
        ILookupDefinition<Product, EmployeeProduct>,
        ILookupDefinition<Product, StagingManufacturingPacketTreatment>,
        ILookupDefinition<Product, ManufacturingTreatment>,
        ILookupDefinition<Product, BillLine>

    {
        // EmployeeProduct records also require a Default Location to pull from
        public Filter<Product> DefineFilter(EmployeeProduct[] items)
        {
            return DefineFilter().And(x => x.NonStock).IsEqualTo(false).And(x => x.DefaultLocation).LinkValid();
        }

        Columns<EmployeeProduct> ILookupDefinition<Product, EmployeeProduct>.DefineFilterColumns()
            => new Columns<EmployeeProduct>();

        // You should not be able to create a stock movement for a non-stock item
        public Filter<Product> DefineFilter(StockMovement[] items)
        {
            return DefineFilter().And(x => x.NonStock).IsEqualTo(false);
        }
        
        Columns<StockMovement> ILookupDefinition<Product, StockMovement>.DefineFilterColumns()
            => new Columns<StockMovement>();
        
        // Filters for Manufacturing Treament Codes 
        public Filter<Product> DefineFilter(StagingManufacturingPacketTreatment[] items)
        {
            return DefineFilter().And(x => x.IsManufacturingTreatment).IsEqualTo(true);
        }

        Columns<StagingManufacturingPacketTreatment> ILookupDefinition<Product, StagingManufacturingPacketTreatment>.DefineFilterColumns()
            => new Columns<StagingManufacturingPacketTreatment>();
        
        // Filters for Manufacturing Treament Codes 
        public Filter<Product> DefineFilter(ManufacturingTreatment[] items)
        {
            return DefineFilter().And(x => x.IsManufacturingTreatment).IsEqualTo(true);
        }

        Columns<ManufacturingTreatment> ILookupDefinition<Product, ManufacturingTreatment>.DefineFilterColumns()
            => new Columns<ManufacturingTreatment>();

        public override Columns<Product> DefineColumns()
        {
            return new Columns<Product>(
                x => x.ID,
                x => x.Code,
                x => x.Name,
                x => x.TaxCode.ID,
                x => x.PurchaseGL.ID,
                x => x.NettCost, 
                x => x.Dimensions.Unit.ID, 
                x => x.Dimensions.Unit.Code, 
                x => x.Dimensions.Unit.Description, 
                x => x.Dimensions.Unit.HasLength,
                x => x.Dimensions.Unit.HasHeight, 
                x => x.Dimensions.Unit.HasQuantity, 
                x => x.Dimensions.Unit.HasWeight, 
                x => x.Dimensions.Unit.HasWidth, 
                x => x.Dimensions.Unit.Formula, 
                x => x.Dimensions.Unit.Format, 
                x => x.Dimensions.Height, 
                x => x.Dimensions.Length, 
                x => x.Dimensions.Quantity, 
                x => x.Dimensions.Weight, 
                x => x.Dimensions.Width, 
                x => x.Dimensions.Value, 
                x => x.Dimensions.UnitSize
            );
        }
        
        public override string FormatLookup(Dictionary<string, object?> values, IEnumerable<string> exclude)
        {
            return $"{values["Name"]}";
        }

        public override Filter<Product> DefineFilter()
        {
            return new Filter<Product>(x => x.Expired).IsEqualTo(DateTime.MinValue);
        }

        public override SortOrder<Product> DefineSortOrder()
        {
            return new SortOrder<Product>(x => x.Code);
        }

        public Filter<Product> DefineFilter(BillLine[] items)
        {
            return new Filter<Product>(x => x.NonStock);
        }

        public Columns<BillLine> DefineFilterColumns()
        {
            return new Columns<BillLine>();
        }
    }
}