public void allocateBatch(Int64 ixPickBatch, String UserName)
{
//We check that the batch is not already allocated and activated - if so we do nothing
var pickBatch = _pickbatchesRepository.Get(ixPickBatch);
if (pickBatch.Statuses.sStatus == "Inactive")
{
//We get the orders associated with the batch
var ordersInBatch = _outboundordersRepository.IndexDb().Where(x => x.ixPickBatch == ixPickBatch && x.Statuses.sStatus == "Active").Select(x => new { x.ixOutboundOrder, x.ixFacility, x.ixCompany });
ordersInBatch.ToList().ForEach(x =>
{
var linesInOrders = _outboundorderlinesRepository.IndexDb().Where(l => l.ixOutboundOrder == x.ixOutboundOrder && l.Statuses.sStatus == "Active").Select(l => new { l.ixOutboundOrderLine, l.ixMaterial, l.nBaseUnitQuantityOrdered });
linesInOrders
.ToList().ForEach(l =>
{
var qtyAvailableToAllocate = getQtyAvailable(x.ixFacility, x.ixCompany, l.ixMaterial) - getQtyAllocated(x.ixFacility, x.ixCompany, l.ixMaterial);
if (qtyAvailableToAllocate > 0)
{
OutboundOrderLinesInventoryAllocationPost outboundOrderLineInventoryAllocation = new OutboundOrderLinesInventoryAllocationPost();
outboundOrderLineInventoryAllocation.ixOutboundOrderLine = l.ixOutboundOrderLine;
var orderLine = _outboundorderlinesRepository.GetPost(l.ixOutboundOrderLine);
if (qtyAvailableToAllocate >= l.nBaseUnitQuantityOrdered)
{
outboundOrderLineInventoryAllocation.nBaseUnitQuantityAllocated = l.nBaseUnitQuantityOrdered;
orderLine.ixStatus = _statusesRepository.IndexDb().Where(s => s.sStatus == "Allocated").Select(s => s.ixStatus).FirstOrDefault();
orderLine.UserName = UserName;
_outboundorderlinesService.Edit(orderLine);
}
else
{
outboundOrderLineInventoryAllocation.nBaseUnitQuantityAllocated = qtyAvailableToAllocate;
orderLine.ixStatus = _statusesRepository.IndexDb().Where(s => s.sStatus == "Partially Allocated").Select(s => s.ixStatus).FirstOrDefault();
orderLine.UserName = UserName;
_outboundorderlinesService.Edit(orderLine);
}
outboundOrderLineInventoryAllocation.ixStatus = _statusesRepository.IndexDb().Where(s => s.sStatus == "Active").Select(s => s.ixStatus).FirstOrDefault();
outboundOrderLineInventoryAllocation.UserName = UserName;
_outboundorderlinesinventoryallocationService.Create(outboundOrderLineInventoryAllocation);
}
}
);
}
);
}
}
public OutboundOrderLinesPost GetPost(Int64 ixOutboundOrderLine) => _outboundorderlinesRepository.GetPost(ixOutboundOrderLine);
