using System; using System.Collections.Generic; using System.Linq; using System.Linq.Expressions; using InABox.Core; using PRSClasses; namespace Comal.Classes { public class PurchaseOrderItemFormCount : CoreAggregate { public override Expression> Aggregate => x => x.ID; public override AggregateCalculation Calculation => AggregateCalculation.Count; public override Dictionary>, Expression>> Links => new Dictionary>, Expression>>() { { PurchaseOrderItemForm => PurchaseOrderItemForm.Parent.ID, PurchaseOrderItem => PurchaseOrderItem.ID } }; } public class PurchaseOrderItemOpenForms : CoreAggregate { public override Expression> Aggregate => x => x.ID; public override AggregateCalculation Calculation => AggregateCalculation.Count; public override Dictionary>, Expression>> Links => new Dictionary>, Expression>>() { { PurchaseOrderItemForm => PurchaseOrderItemForm.Parent.ID, PurchaseOrderItem => PurchaseOrderItem.ID } }; public override Filter Filter => new Filter(x => x.FormCompleted).IsEqualTo(DateTime.MinValue) .Or(x => x.FormData).IsEqualTo(""); } [UserTracking(typeof(Bill))] [Caption("Purchase Order Items")] public class PurchaseOrderItem : StockEntity, IRemotable, IPersistent, IOneToMany, ITaxable, IOneToMany, IOneToMany, ILicense, IJobMaterial, IPostableFragment { [EntityRelationship(DeleteAction.SetNull)] [NullEditor] [Obsolete("Replaced with Product", true)] public ProductLink ProductLink { get { return Product; } set { Product = value; } } [EntityRelationship(DeleteAction.SetNull)] [EditorSequence(1)] [RequiredColumn] public override ProductLink Product { get; set; } [EntityRelationship(DeleteAction.SetNull)] [NullEditor] [Obsolete("Replaced with Style", true)] public ProductStyleLink StyleLink { get { return Style; } set { Style = value; } } [EntityRelationship(DeleteAction.SetNull)] [EditorSequence(2)] public ProductStyleLink Style { get; set; } [EntityRelationship(DeleteAction.SetNull)] [EditorSequence(3)] public JobLink Job { get; set; } [MemoEditor(Visible = Visible.Default)] [EditorSequence(4)] public string Description { get; set; } [CodeEditor(Visible = Visible.Default, Editable = Editable.Enabled)] [EditorSequence(5)] public string SupplierCode { get; set; } [DoubleEditor(Visible = Visible.Default)] [EditorSequence(6)] public double Qty { get; set; } = 1; [NullEditor] [Obsolete("Replaced with Dimensions", true)] public double UnitSize { get; set; } [EditorSequence(7)] [RequiredColumn] [DimensionsEditor(typeof(StockDimensions), AllowEditingUnit = false)] public override StockDimensions Dimensions { get; set; } [CurrencyEditor(Visible = Visible.Default)] [EditorSequence(8)] public double Cost { get; set; } [EditorSequence(10)] public TaxCodeLink TaxCode { get; set; } [EditorSequence(11)] public PurchaseGLCodeLink PurchaseGL { get; set; } [EditorSequence(12)] public CostCentreLink CostCentre { get; set; } [EditorSequence(14)] [CurrencyEditor(Visible = Visible.Optional, Editable = Editable.Hidden, Summary = Summary.Sum)] public double Balance { get; set; } [EditorSequence(15)] [EntityRelationship(DeleteAction.SetNull)] public ConsignmentLink Consignment { get; set; } [DateTimeEditor(Visible = Visible.Default)] [EditorSequence(16)] public DateTime ReceivedDate { get; set; } [TextBoxEditor(Visible = Visible.Optional)] [EditorSequence(17)] public string ReceivedReference { get; set; } [EditorSequence(18)] [IntegerEditor(Visible = Visible.Optional)] public int PORevision { get; set; } [DateTimeEditor(Visible = Visible.Default)] [EditorSequence(19)] public DateTime DueDate { get; set; } [NullEditor] [Obsolete] public StockMovementLink StockMovement { get; set; } [EntityRelationship(DeleteAction.Cascade)] public PurchaseOrderLink PurchaseOrderLink { get; set; } [NullEditor] [EntityRelationship(DeleteAction.SetNull)] public BillLineLink BillLine { get; set; } [NullEditor] [EntityRelationship(DeleteAction.SetNull)] public ManufacturingPacketLink Packet { get; set; } [NullEditor] [Aggregate(typeof(PurchaseOrderItemFormCount))] public int FormCount { get; set; } [NullEditor] [Aggregate(typeof(PurchaseOrderItemOpenForms))] public int OpenForms { get; set; } public StockLocationLink StockLocation { get; set; } [CurrencyEditor(Visible = Visible.Default, Summary = Summary.Sum)] [EditorSequence(9)] public double ExTax { get; set; } [EditorSequence(11)] [DoubleEditor(Visible = Visible.Default, Editable = Editable.Hidden)] public double TaxRate { get; set; } [EditorSequence(12)] [CurrencyEditor(Visible = Visible.Default, Summary = Summary.Sum)] public double Tax { get; set; } [EditorSequence(13)] [CurrencyEditor(Visible = Visible.Default, Summary = Summary.Sum)] public double IncTax { get; set; } [NullEditor] public string PostedReference { get; set; } static PurchaseOrderItem() { LinkedProperties.Register(x => x.Product, x => x.Code, x => x.SupplierCode); LinkedProperties.Register(x => x.Product, x => x.Name, x => x.Description); LinkedProperties.Register(x => x.Product.TaxCode, x => x.ID, x => x.TaxCode.ID); LinkedProperties.Register(x => x.Product.TaxCode, x => x.Code, x => x.TaxCode.Code); LinkedProperties.Register(x => x.Product.TaxCode, x => x.Description, x => x.TaxCode.Description); LinkedProperties.Register(x => x.Product.TaxCode, x => x.Rate, x => x.TaxCode.Rate); LinkedProperties.Register(x => x.TaxCode, x => x.Rate, x => x.TaxRate); LinkedProperties.Register(x => x.Product.PurchaseGL, x => x.ID, x => x.PurchaseGL.ID); LinkedProperties.Register(x => x.Product.CostCentre, x => x.ID, x => x.CostCentre.ID); LinkedProperties.Register(x => x.Product.DefaultInstance.Style, x => x.ID, x => x.Style.ID); LinkedProperties.Register(x => x.Product.DefaultInstance.Style, x => x.Code, x => x.Style.Code); LinkedProperties.Register(x => x.Product.DefaultInstance.Style, x => x.Description, x => x.Style.Description); LinkedProperties.Register(x => x.Product.DefaultInstance, x => x.NettCost, x => x.Cost); StockEntity.LinkStockDimensions(); } private bool bChanging; protected override void DoPropertyChanged(string name, object? before, object? after) { if (bChanging) return; try { bChanging = true; if (name.Equals(nameof(Qty)) && after is double qty) ExTax = qty * Cost; else if (name.Equals(nameof(Cost)) && after is double cost) ExTax = Qty * cost; else if (name.Equals(nameof(ExTax)) && after is double extax) { if (Qty == 0) Qty = 1; Cost = extax / Qty; } else if (name.Equals(nameof(IncTax)) && after is double inctax) Balance = ReceivedDate.IsEmpty() ? inctax : 0.00F; else if (name.Equals(nameof(ReceivedDate)) && after is DateTime received) Balance = received.IsEmpty() ? IncTax : 0.00F; } finally { bChanging = false; } base.DoPropertyChanged(name, before, after); } } }