internal static IEnumerable <Expression <Func <InventoryShipmentOrder, InternalOrderAcknowledgementReturn> > > SplitSelectAcknowledgement(IQueryable <SalesOrder> salesOrders) { var key = SelectKey(); var shipment = ShipmentInformationProjectors.SelectShipmentInformation(); var pickOrderItem = InventoryPickOrderItemProjectors.SplitSelect(); var customerNotes = CustomerProjectors.SelectNotes(); var salesOrder = SalesOrderProjectors.SelectWarehouseAcknowlegement(); return(new Projectors <InventoryShipmentOrder, InternalOrderAcknowledgementReturn> { o => new InternalOrderAcknowledgementReturn { InventoryShipmentOrderKeyReturn = key.Invoke(o), MovementNumber = o.MoveNum, OrderType = o.OrderType, PurchaseOrderNumber = o.PurchaseOrderNumber, DateReceived = o.DateReceived, RequestedBy = o.RequestedBy, TakenBy = o.TakenBy, OriginFacility = o.SourceFacility.Name }, o => new InternalOrderAcknowledgementReturn { ShipmentInformation = shipment.Invoke(o.ShipmentInformation) }, { pickOrderItem, p => Projector <InventoryShipmentOrder> .To(o => new InternalOrderAcknowledgementReturn { PickOrderItems = o.InventoryPickOrder.Items.Select(i => p.Invoke(i)) }) }, o => new InternalOrderAcknowledgementReturn { TotalQuantity = o.InventoryPickOrder.Items.Select(i => i.Quantity).DefaultIfEmpty(0).Sum(), NetWeight = o.InventoryPickOrder.Items.Select(i => i.Quantity * i.PackagingProduct.Weight).DefaultIfEmpty(0).Sum(), TotalGrossWeight = o.InventoryPickOrder.Items.Select(i => i.Quantity * (i.PackagingProduct.Weight + i.PackagingProduct.PackagingWeight)).DefaultIfEmpty(0).Sum(), PalletWeight = o.InventoryPickOrder.Items.Select(i => i.Quantity * (i.PackagingProduct.PalletWeight)).DefaultIfEmpty(0).Sum(), EstimatedShippingWeight = o.InventoryPickOrder.Items.Select(i => i.Quantity * (i.PackagingProduct.Weight + i.PackagingProduct.PackagingWeight + i.PackagingProduct.PalletWeight)).DefaultIfEmpty(0).Sum() }, o => new InternalOrderAcknowledgementReturn { CustomerNotes = o.InventoryPickOrder.Items.Select(i => i.Customer).Distinct() .Where(c => c != null && c.Notes.Any()) .Select(c => customerNotes.Invoke(c)) }, o => new InternalOrderAcknowledgementReturn { SalesOrder = salesOrders.Where(c => c.DateCreated == o.DateCreated && c.Sequence == o.Sequence) .Select(c => salesOrder.Invoke(c)).FirstOrDefault() } }); }
internal static IEnumerable <Expression <Func <InventoryPickOrder, InventoryPickOrderReturn> > > SplitSelectDetails() { var key = SelectKey(); return(new Projectors <InventoryPickOrder, InventoryPickOrderReturn> { o => new InventoryPickOrderReturn { InventoryPickOrderKeyReturn = key.Invoke(o) }, { InventoryPickOrderItemProjectors.SplitSelect(), s => o => new InventoryPickOrderReturn { PickOrderItems = o.Items.Select(i => s.Invoke(i)) } } }); }
internal static IEnumerable <Expression <Func <SalesOrderItem, SalesOrderItemReturn> > > SplitSelect() { var key = SelectKey(); var contractItemKey = SelectContractItemKey(); return(new Projectors <SalesOrderItem, SalesOrderItemReturn> { { InventoryPickOrderItemProjectors.SplitSelect(), p => p.Translate().To <SalesOrderItem, SalesOrderItemReturn>(i => i.InventoryPickOrderItem) }, i => new SalesOrderItemReturn { SalesOrderItemKeyReturn = key.Invoke(i), ContractItemKeyReturn = contractItemKey.Invoke(i), PriceBase = i.PriceBase, PriceFreight = i.PriceFreight, PriceTreatment = i.PriceTreatment, PriceWarehouse = i.PriceWarehouse, PriceRebate = i.PriceRebate } }); }