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 { [RequiredColumn] [EntityRelationship(DeleteAction.Cascade)] public PurchaseOrderLink PurchaseOrderLink { get; set; } [EntityRelationship(DeleteAction.SetNull)] [EditorSequence(1)] [RequiredColumn] public override ProductLink Product { get; set; } [EntityRelationship(DeleteAction.SetNull)] [EditorSequence(2)] public ProductStyleLink Style { get; set; } [EditorSequence(3)] [RequiredColumn] [DimensionsEditor(typeof(StockDimensions))] public override StockDimensions Dimensions { get; set; } [EntityRelationship(DeleteAction.SetNull)] [EditorSequence(5)] public JobLink Job { get; set; } [MemoEditor(Visible = Visible.Default)] [EditorSequence(6)] public string Description { get; set; } [DoubleEditor(Visible = Visible.Default)] [EditorSequence(7)] public double Qty { get; set; } = 1; [CurrencyEditor(Visible = Visible.Optional)] [EditorSequence(8)] public double ForeignCurrencyCost { get; set; } [CurrencyEditor(Visible = Visible.Default)] [EditorSequence(9)] public double Cost { get; set; } [CurrencyEditor(Visible = Visible.Default, Summary = Summary.Sum)] [EditorSequence(10)] public double ExTax { get; set; } [EditorSequence(11)] public TaxCodeLink TaxCode { get; set; } [NullEditor] 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; } [EditorSequence("Additional",1)] [IntegerEditor(Visible = Visible.Optional)] public int PORevision { get; set; } [CodeEditor(Visible = Visible.Default, Editable = Editable.Enabled)] [EditorSequence("Additional",2)] public string SupplierCode { get; set; } [EditorSequence("Additional",3)] public PurchaseGLCodeLink PurchaseGL { get; set; } [EditorSequence("Additional",4)] public CostCentreLink CostCentre { get; set; } [DateTimeEditor(Visible = Visible.Default)] [EditorSequence("Additional",5)] public DateTime DueDate { get; set; } [EditorSequence("Additional",6)] [EntityRelationship(DeleteAction.SetNull)] public ConsignmentLink Consignment { get; set; } [EditorSequence("Additional",7)] public StockLocationLink StockLocation { get; set; } [DateTimeEditor(Visible = Visible.Default)] [EditorSequence("Additional",8)] public DateTime ReceivedDate { get; set; } [TextBoxEditor(Visible = Visible.Optional)] [EditorSequence("Additional",9)] public string ReceivedReference { get; set; } [CurrencyEditor(Visible = Visible.Optional, Editable = Editable.Hidden, Summary = Summary.Sum)] public double Balance { get; set; } [NullEditor] public string PostedReference { get; set; } [EntityRelationship(DeleteAction.SetNull)] [NullEditor] [Obsolete("Replaced with Product", true)] public ProductLink ProductLink { get { return Product; } set { Product = value; } } [EntityRelationship(DeleteAction.SetNull)] [NullEditor] [Obsolete("Replaced with Style", true)] public ProductStyleLink StyleLink { get { return Style; } set { Style = value; } } [NullEditor] [Obsolete("Replaced with Dimensions", true)] public double UnitSize { get; set; } [NullEditor] [Obsolete] public StockMovementLink StockMovement { 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; } 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) { base.DoPropertyChanged(name, before, after); if (bChanging) return; try { bChanging = true; if (name.Equals(nameof(Qty)) && after is double qty) ExTax = qty * Cost; else if (name.Equals(nameof(ForeignCurrencyCost)) && (after is double foreigncost) && PurchaseOrderLink.SupplierLink.Currency.ID != Guid.Empty) { Cost = foreigncost / (PurchaseOrderLink.SupplierLink.Currency.ExchangeRate.IsEffectivelyEqual(0.0) ? 1.0 : PurchaseOrderLink.SupplierLink.Currency.ExchangeRate); ExTax = Qty * Cost; } else if (name.Equals(nameof(Cost)) && (after is double cost)) { ExTax = cost * Qty; if (PurchaseOrderLink.SupplierLink.Currency.ID != Guid.Empty) ForeignCurrencyCost = cost * (PurchaseOrderLink.SupplierLink.Currency.ExchangeRate.IsEffectivelyEqual(0.0) ? 1.0 : PurchaseOrderLink.SupplierLink.Currency.ExchangeRate); } else if (name.Equals(nameof(ExTax)) && after is double extax) { if (Qty == 0) Qty = 1; Cost = extax / Qty; if (PurchaseOrderLink.SupplierLink.Currency.ID != Guid.Empty) ForeignCurrencyCost = Cost * (PurchaseOrderLink.SupplierLink.Currency.ExchangeRate.IsEffectivelyEqual(0.0) ? 1.0 : PurchaseOrderLink.SupplierLink.Currency.ExchangeRate); } 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; } } } }