internal static IEnumerable <Expression <Func <InventoryShipmentOrder, InventoryShipmentOrderPickSheetReturn> > > SplitSelectPickSheet()
        {
            var key           = SelectKey();
            var item          = PickedInventoryItemProjectors.SplitSelectPickSheetItem().Merge(); //Necessary to avoid likely EF-Split bug in subsequent group selection. -RI 2015/04/15
            var customerNotes = CustomerProjectors.SelectNotes();
            var shipment      = ShipmentInformationProjectors.SelectShipmentInformation();

            return(new Projectors <InventoryShipmentOrder, InventoryShipmentOrderPickSheetReturn>
            {
                o => new InventoryShipmentOrderPickSheetReturn
                {
                    OrderType = o.OrderType,
                    InventoryShipmentOrderKeyReturn = key.Invoke(o),
                    MovementNumber = o.MoveNum,
                    PurchaseOrderNumber = o.PurchaseOrderNumber,
                    ShipmentInformation = shipment.Invoke(o.ShipmentInformation)
                },
                o => new InventoryShipmentOrderPickSheetReturn
                {
                    CustomerNotes = o.InventoryPickOrder.Items.Select(i => i.Customer).Distinct()
                                    .Where(c => c != null && c.Notes.Any())
                                    .Select(c => customerNotes.Invoke(c))
                },
                o => new InventoryShipmentOrderPickSheetReturn
                {
                    Items = o.PickedInventory.Items.Select(i => item.Invoke(i))
                }
            });
        }
        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()
                }
            });
        }