internal static IEnumerable <Expression <Func <ChileLot, LabReportChileLotReturn> > > SplitSelectLabReportChileLot(IQueryable <ProductionBatch> productionBatches, IQueryable <LotProductionResults> lotProdcutionResuls, IQueryable <ChileLotProduction> chileLotProduction)
{
var chileProductKey = ProductProjectors.SelectProductKey();
var packSchedule = PackScheduleProjectors.SelectBaseWithCustomer();
var productionResult = LotProductionResultsProjectors.SelectBase();
var attribute = LotAttributeProjectors.Select <WeightedLotAttributeReturn>();
var lotTotes = PickedInventoryItemProjectors.SelectPickedLot();
var customerAllowance = LotCustomerAllowanceProjectors.Select();
return(new[]
{
SelectLotBase().Merge(Projector <ChileLot> .To(c => new LabReportChileLotReturn
{
LoBac = c.AllAttributesAreLoBac
}), c => c.Lot).ExpandAll(),
Projector <ChileLot> .To(c => new LabReportChileLotReturn
{
UnresolvedDefects = c.Lot.LotDefects.Where(d => d.Resolution == null).Select(d => d.Description),
WeightedAttributes = c.Lot.Attributes.Select(a => attribute.Invoke(a)),
CustomerAllowances = c.Lot.CustomerAllowances.Select(a => customerAllowance.Invoke(a))
}),
Projector <ChileLot> .To(c => new LabReportChileLotReturn
{
WeightedAttributes = c.Lot.Attributes.Select(a => new WeightedLotAttributeReturn
{
HasResolvedDefects = c.Lot.AttributeDefects.Any(d => d.AttributeShortName == a.AttributeShortName) &&
c.Lot.AttributeDefects.Where(d => d.AttributeShortName == a.AttributeShortName).All(d => d.LotDefect.Resolution != null)
})
}),
Projector <ChileLot> .To(c => new LabReportChileLotReturn
{
ChileProductKeyReturn = chileProductKey.Invoke(c.ChileProduct.Product),
PackScheduleBaseReturn = productionBatches.Where(b => b.LotDateCreated == c.LotDateCreated && b.LotDateSequence == c.LotDateSequence && b.LotTypeId == c.LotTypeId)
.Select(b => packSchedule.Invoke(b.PackSchedule)).FirstOrDefault()
}),
Projector <ChileLot> .To(c => new LabReportChileLotReturn
{
ProductionResultBaseReturn = lotProdcutionResuls.Where(r => r.LotDateCreated == c.LotDateCreated && r.LotDateSequence == c.LotDateSequence && r.LotTypeId == c.LotTypeId)
.Select(r => productionResult.Invoke(r)).FirstOrDefault(),
PickedLots = chileLotProduction.Where(r => r.LotDateCreated == c.LotDateCreated && r.LotDateSequence == c.LotDateSequence && r.LotTypeId == c.LotTypeId)
.SelectMany(r => r.PickedInventory.Items.Select(i => lotTotes.Invoke(i)))
})
});
}
