public ActionResult DeleteConfirmed(long id)
{
OutboundOrderLinePackingPost outboundorderlinepacking = _outboundorderlinepackingService.GetPost(id);
outboundorderlinepacking.UserName = User.Identity.Name;
_outboundorderlinepackingService.Delete(outboundorderlinepacking);
return(RedirectToAction("Index"));
}
public ActionResult Edit(long id)
{
OutboundOrderLinePackingPost outboundorderlinepacking = _outboundorderlinepackingService.GetPost(id);
if (outboundorderlinepacking == null)
{
return(NotFound());
}
ViewBag.ixHandlingUnit = new SelectList(_outboundorderlinepackingService.selectHandlingUnits().Select(x => new { x.ixHandlingUnit, x.sHandlingUnit }), "ixHandlingUnit", "sHandlingUnit", outboundorderlinepacking.ixHandlingUnit);
ViewBag.ixOutboundOrderLine = new SelectList(_outboundorderlinepackingService.selectOutboundOrderLines().Select(x => new { x.ixOutboundOrderLine, x.sOutboundOrderLine }), "ixOutboundOrderLine", "sOutboundOrderLine", outboundorderlinepacking.ixOutboundOrderLine);
ViewBag.ixStatus = new SelectList(_outboundorderlinepackingService.selectStatuses().Select(x => new { x.ixStatus, x.sStatus }), "ixStatus", "sStatus", outboundorderlinepacking.ixStatus);
return(View(outboundorderlinepacking));
}
public ActionResult Edit([Bind("ixOutboundOrderLinePack,sOutboundOrderLinePack,ixOutboundOrderLine,ixHandlingUnit,nBaseUnitQuantityPacked,ixStatus")] OutboundOrderLinePackingPost outboundorderlinepacking)
{
if (ModelState.IsValid)
{
outboundorderlinepacking.UserName = User.Identity.Name;
_outboundorderlinepackingService.Edit(outboundorderlinepacking);
return(RedirectToAction("Index"));
}
ViewBag.ixHandlingUnit = new SelectList(_outboundorderlinepackingService.selectHandlingUnits().Select(x => new { x.ixHandlingUnit, x.sHandlingUnit }), "ixHandlingUnit", "sHandlingUnit", outboundorderlinepacking.ixHandlingUnit);
ViewBag.ixOutboundOrderLine = new SelectList(_outboundorderlinepackingService.selectOutboundOrderLines().Select(x => new { x.ixOutboundOrderLine, x.sOutboundOrderLine }), "ixOutboundOrderLine", "sOutboundOrderLine", outboundorderlinepacking.ixOutboundOrderLine);
ViewBag.ixStatus = new SelectList(_outboundorderlinepackingService.selectStatuses().Select(x => new { x.ixStatus, x.sStatus }), "ixStatus", "sStatus", outboundorderlinepacking.ixStatus);
return(View(outboundorderlinepacking));
}
public Task Delete(OutboundOrderLinePackingPost outboundorderlinepackingPost)
{
// Additional validations
// Pre-process
// Process
this._outboundorderlinepackingRepository.RegisterDelete(outboundorderlinepackingPost);
try
{
this._outboundorderlinepackingRepository.Commit();
}
catch (Exception ex)
{
this._outboundorderlinepackingRepository.Rollback();
// Log exception
throw;
}
// Post-process
return(Task.CompletedTask);
}
public Task <Int64> Create(OutboundOrderLinePackingPost outboundorderlinepackingPost)
{
// Additional validations
// Pre-process
// Process
this._outboundorderlinepackingRepository.RegisterCreate(outboundorderlinepackingPost);
try
{
this._outboundorderlinepackingRepository.Commit();
}
catch (Exception ex)
{
this._outboundorderlinepackingRepository.Rollback();
// Log exception
throw;
}
// Post-process
return(Task.FromResult(outboundorderlinepackingPost.ixOutboundOrderLinePack));
}
private async Task <DialogTurnResult> donePrompt(
WaterfallStepContext step,
CancellationToken cancellationToken = default(CancellationToken))
{
var sPackToHandlingUnit = (string)step.Result;
((PickBatchPickingPost)step.Values[DialogKey]).sPackToHandlingUnit = sPackToHandlingUnit;
//Custom Code Start | Added Code Block
//If the handling unit does not exist we create it
long ixHandlingUnit = 0;
if (!_movequeuesService.HandlingUnitsDb().Where(x => x.sHandlingUnit.Trim() == sPackToHandlingUnit.Trim()).Any())
{
HandlingUnitsPost handlingUnitsPost = new HandlingUnitsPost();
handlingUnitsPost.sHandlingUnit = sPackToHandlingUnit.Trim();
handlingUnitsPost.ixHandlingUnitType = _commonLookUps.getHandlingUnitTypes().Where(x => x.sHandlingUnitType == "Carton").Select(x => x.ixHandlingUnitType).FirstOrDefault();
handlingUnitsPost.UserName = step.Context.Activity.Conversation.Id;
ixHandlingUnit = _handlingunitsService.Create(handlingUnitsPost).Result;
}
else
{
ixHandlingUnit = _movequeuesService.HandlingUnitsDb().Where(x => x.sHandlingUnit == sPackToHandlingUnit.Trim()).Select(x => x.ixHandlingUnit).FirstOrDefault();
}
((PickBatchPickingPost)step.Values[DialogKey]).ixHandlingUnit = ixHandlingUnit;
var inventoryUnitPicked = _inventoryunitsService.GetPost((long)step.Values[PickedInventoryUnitKey]);
inventoryUnitPicked.ixHandlingUnit = ixHandlingUnit;
inventoryUnitPicked.UserName = step.Context.Activity.Conversation.Id;
await _inventoryunitsService.Edit(inventoryUnitPicked, _commonLookUps.getInventoryUnitTransactionContext().Where(x => x.sInventoryUnitTransactionContext == "Inventory Adjustment").Select(x => x.ixInventoryUnitTransactionContext).FirstOrDefault());
//We create the packing record
var orderLinesToPack = ((List <Tuple <Int64, double> >)step.Values[LineQtysPickedKey]).GroupBy(x => x.Item1).Select(x => new { ixOutboundOrderLine = x.Key, Total = x.Sum(s => s.Item2) }).ToList();
orderLinesToPack.ForEach(x =>
{
//We check if there is an existing pack record we can use
if (
_outboundorderlinepackingService.IndexDb().Where(p =>
p.ixHandlingUnit == ((PickBatchPickingPost)step.Values[DialogKey]).ixHandlingUnit &&
p.ixOutboundOrderLine == x.ixOutboundOrderLine
).Any()
)
{
var outboundorderlinepack = _outboundorderlinepackingService.GetPost(_outboundorderlinepackingService.IndexDb().Where(p =>
p.ixHandlingUnit == ((PickBatchPickingPost)step.Values[DialogKey]).ixHandlingUnit &&
p.ixOutboundOrderLine == x.ixOutboundOrderLine
).Select(p => p.ixOutboundOrderLinePack).FirstOrDefault()
);
outboundorderlinepack.nBaseUnitQuantityPacked += x.Total;
outboundorderlinepack.UserName = step.Context.Activity.Conversation.Id;
_outboundorderlinepackingService.Edit(outboundorderlinepack);
}
else
{
var outboundorderlinepack = new OutboundOrderLinePackingPost();
outboundorderlinepack.ixOutboundOrderLine = x.ixOutboundOrderLine;
outboundorderlinepack.ixHandlingUnit = ((PickBatchPickingPost)step.Values[DialogKey]).ixHandlingUnit;
outboundorderlinepack.nBaseUnitQuantityPacked = x.Total;
outboundorderlinepack.ixStatus = _commonLookUps.getStatuses().Where(s => s.sStatus == "Active").Select(s => s.ixStatus).FirstOrDefault();
outboundorderlinepack.UserName = step.Context.Activity.Conversation.Id;
_outboundorderlinepackingService.Create(outboundorderlinepack);
}
}
);
//Custom Code End
return(await step.EndDialogAsync(
(PickBatchPickingPost)step.Values[DialogKey],
cancellationToken));
}
private async Task <DialogTurnResult> PackToHandlingUnitPrompt(
WaterfallStepContext step,
CancellationToken cancellationToken = default(CancellationToken))
{
var nBaseUnitQuantityPicked = step.Result;
((PickBatchPickingPost)step.Values[DialogKey]).nBaseUnitQuantityPicked = Convert.ToDouble(nBaseUnitQuantityPicked);
//Custom Code Start | Added Code Block
step.Values[IsCompleteInventoryUnitPickKey] = _picking.isCompleteInventoryUnitPick((InventoryUnits)step.Values[PickSuggestionKey], Convert.ToDouble(nBaseUnitQuantityPicked));
step.Values[IsHandlingUnitPickKey] = _picking.isHandlingUnitPick((InventoryUnits)step.Values[PickSuggestionKey], Convert.ToDouble(nBaseUnitQuantityPicked));
//We adjust the queued qty down
var inventoryUnitPickedFrom = _inventoryunitsService.GetPost(((InventoryUnits)step.Values[PickSuggestionKey]).ixInventoryUnit);
inventoryUnitPickedFrom.nBaseUnitQuantityQueued -= (double)step.Values[PickSuggestionQtyKey];
inventoryUnitPickedFrom.UserName = step.Context.Activity.Conversation.Id;
await _inventoryunitsService.Edit(inventoryUnitPickedFrom, _commonLookUps.getInventoryUnitTransactionContext().Where(x => x.sInventoryUnitTransactionContext == "Inventory Adjustment").Select(x => x.ixInventoryUnitTransactionContext).FirstOrDefault());
var currentBotUserData = await _botSpielUserStateAccessors.BotUserDataAccessor.GetAsync(step.Context, () => _botUserData);
//If we pick complete inventory unit we move it to the picker else we adjust and create/consolidate and then move to the picker
if ((bool)step.Values[IsCompleteInventoryUnitPickKey])
{
//We now create and execute the move queue for the pickup
step.Values[PickedInventoryUnitKey] = ((InventoryUnits)step.Values[PickSuggestionKey]).ixInventoryUnit;
MoveQueuesPost moveQueuePost = new MoveQueuesPost();
if (_picking.isHandlingUnitPick((InventoryUnits)step.Values[PickSuggestionKey], Convert.ToDouble(nBaseUnitQuantityPicked)))
{
moveQueuePost.ixMoveQueueType = _commonLookUps.getMoveQueueTypes().Where(x => x.sMoveQueueType == "Unit Pickup - Consolidated Drop").Select(x => x.ixMoveQueueType).FirstOrDefault();
}
else
{
moveQueuePost.ixMoveQueueType = _commonLookUps.getMoveQueueTypes().Where(x => x.sMoveQueueType == "Consolidated Pickup - Consolidated Drop").Select(x => x.ixMoveQueueType).FirstOrDefault();
}
moveQueuePost.ixMoveQueueContext = _commonLookUps.getMoveQueueContexts().Where(x => x.sMoveQueueContext == "Picking").Select(x => x.ixMoveQueueContext).FirstOrDefault();
moveQueuePost.ixSourceInventoryUnit = ((InventoryUnits)step.Values[PickSuggestionKey]).ixInventoryUnit;
moveQueuePost.ixTargetInventoryUnit = ((InventoryUnits)step.Values[PickSuggestionKey]).ixInventoryUnit;
moveQueuePost.ixSourceInventoryLocation = ((InventoryUnits)step.Values[PickSuggestionKey]).ixInventoryLocation;
moveQueuePost.ixTargetInventoryLocation = currentBotUserData.ixInventoryLocation;
moveQueuePost.ixSourceHandlingUnit = ((InventoryUnits)step.Values[PickSuggestionKey]).ixHandlingUnit > 0 ? ((InventoryUnits)step.Values[PickSuggestionKey]).ixHandlingUnit : null;
moveQueuePost.ixTargetHandlingUnit = ((InventoryUnits)step.Values[PickSuggestionKey]).ixHandlingUnit > 0 ? ((InventoryUnits)step.Values[PickSuggestionKey]).ixHandlingUnit : null;
moveQueuePost.sPreferredResource = step.Context.Activity.Conversation.Id;
moveQueuePost.nBaseUnitQuantity = Convert.ToDouble(nBaseUnitQuantityPicked);
moveQueuePost.dtStartedAt = DateTime.Now;
moveQueuePost.ixPickBatch = ((PickBatchPickingPost)step.Values[DialogKey]).ixPickBatch;
moveQueuePost.ixStatus = _commonLookUps.getStatuses().Where(x => x.sStatus == "Active").Select(x => x.ixStatus).FirstOrDefault();
moveQueuePost.UserName = step.Context.Activity.Conversation.Id;
var ixMoveQueue = await _movequeuesService.Create(moveQueuePost);
//We now complete the move queue for the pickup
var moveQueuePickUp = _movequeuesService.GetPost(ixMoveQueue);
moveQueuePickUp.dtCompletedAt = DateTime.Now;
moveQueuePickUp.ixStatus = _commonLookUps.getStatuses().Where(x => x.sStatus == "Complete").Select(x => x.ixStatus).FirstOrDefault();
moveQueuePickUp.UserName = moveQueuePost.UserName;
await _movequeuesService.Edit(moveQueuePickUp);
}
else
{
//Now we adjust the iu remaining down
inventoryUnitPickedFrom.nBaseUnitQuantity -= Convert.ToDouble(nBaseUnitQuantityPicked);
inventoryUnitPickedFrom.UserName = step.Context.Activity.Conversation.Id;
await _inventoryunitsService.Edit(inventoryUnitPickedFrom, _commonLookUps.getInventoryUnitTransactionContext().Where(x => x.sInventoryUnitTransactionContext == "Inventory Adjustment").Select(x => x.ixInventoryUnitTransactionContext).FirstOrDefault());
//Now we either create or edit an iu for the qty picked
inventoryUnitPickedFrom.nBaseUnitQuantity = Convert.ToDouble(nBaseUnitQuantityPicked);
inventoryUnitPickedFrom.UserName = step.Context.Activity.Conversation.Id;
inventoryUnitPickedFrom.ixInventoryLocation = currentBotUserData.ixInventoryLocation;
if (_inventoryunitsService.IndexDb().Where(x =>
x.ixFacility == inventoryUnitPickedFrom.ixFacility &&
x.ixCompany == inventoryUnitPickedFrom.ixCompany &&
x.ixMaterial == inventoryUnitPickedFrom.ixMaterial &&
x.ixInventoryState == inventoryUnitPickedFrom.ixInventoryState &&
x.ixHandlingUnit == inventoryUnitPickedFrom.ixHandlingUnit &&
x.ixInventoryLocation == inventoryUnitPickedFrom.ixInventoryLocation &&
x.sBatchNumber == inventoryUnitPickedFrom.sBatchNumber &&
x.dtExpireAt == inventoryUnitPickedFrom.dtExpireAt && x.ixStatus == 5
).Select(x => x.ixInventoryUnit).Any()
)
{
//We edit the iu
inventoryUnitPickedFrom.ixInventoryUnit = _inventoryunitsService.IndexDb().Where(x =>
x.ixFacility == inventoryUnitPickedFrom.ixFacility &&
x.ixCompany == inventoryUnitPickedFrom.ixCompany &&
x.ixMaterial == inventoryUnitPickedFrom.ixMaterial &&
x.ixInventoryState == inventoryUnitPickedFrom.ixInventoryState &&
x.ixHandlingUnit == inventoryUnitPickedFrom.ixHandlingUnit &&
x.ixInventoryLocation == inventoryUnitPickedFrom.ixInventoryLocation &&
x.sBatchNumber == inventoryUnitPickedFrom.sBatchNumber &&
x.dtExpireAt == inventoryUnitPickedFrom.dtExpireAt && x.ixStatus == 5
).Select(x => x.ixInventoryUnit).FirstOrDefault();
inventoryUnitPickedFrom.nBaseUnitQuantity = _inventoryunitsService.GetPost(inventoryUnitPickedFrom.ixInventoryUnit).nBaseUnitQuantity + Convert.ToDouble(nBaseUnitQuantityPicked);
await _inventoryunitsService.Edit(inventoryUnitPickedFrom, _commonLookUps.getInventoryUnitTransactionContext().Where(x => x.sInventoryUnitTransactionContext == "Inventory Adjustment").Select(x => x.ixInventoryUnitTransactionContext).FirstOrDefault());
step.Values[PickedInventoryUnitKey] = inventoryUnitPickedFrom.ixInventoryUnit;
}
else
{
//We create an iu
step.Values[PickedInventoryUnitKey] = await _inventoryunitsService.Create(inventoryUnitPickedFrom, _commonLookUps.getInventoryUnitTransactionContext().Where(x => x.sInventoryUnitTransactionContext == "Inventory Adjustment").Select(x => x.ixInventoryUnitTransactionContext).FirstOrDefault());
}
}
//We now allocate the picked qty to open allocation lines
step.Values[LineQtysPickedKey] = new List <Tuple <Int64, double> >();
var pickedQtyNotAllocated = Convert.ToDouble(nBaseUnitQuantityPicked);
_outboundorderlinesinventoryallocationService.IndexDbPost().Where(x => (x.nBaseUnitQuantityAllocated - x.nBaseUnitQuantityPicked) > 0).OrderBy(x => (x.nBaseUnitQuantityAllocated - x.nBaseUnitQuantityPicked) > 0).ToList()
.Join(_picking.getOrderLinesInBatchForMaterial(((PickBatchPickingPost)step.Values[DialogKey]).ixPickBatch, ((InventoryUnits)step.Values[PickSuggestionKey]).ixMaterial), ol => ol.ixOutboundOrderLine, olb => olb, (ol, olb) => new { Ol = ol, Olb = olb }).ToList()
.ForEach(y =>
{
if ((y.Ol.nBaseUnitQuantityAllocated - y.Ol.nBaseUnitQuantityPicked) <= pickedQtyNotAllocated && pickedQtyNotAllocated > 0)
{
((List <Tuple <Int64, double> >)step.Values[LineQtysPickedKey]).Add(new Tuple <long, double>(y.Ol.ixOutboundOrderLine, y.Ol.nBaseUnitQuantityAllocated - y.Ol.nBaseUnitQuantityPicked));
y.Ol.nBaseUnitQuantityPicked += y.Ol.nBaseUnitQuantityAllocated - y.Ol.nBaseUnitQuantityPicked;
pickedQtyNotAllocated -= y.Ol.nBaseUnitQuantityAllocated - y.Ol.nBaseUnitQuantityPicked;
y.Ol.UserName = step.Context.Activity.Conversation.Id;
_outboundorderlinesinventoryallocationService.Edit(y.Ol);
}
else if ((y.Ol.nBaseUnitQuantityAllocated - y.Ol.nBaseUnitQuantityPicked) > pickedQtyNotAllocated && pickedQtyNotAllocated > 0)
{
((List <Tuple <Int64, double> >)step.Values[LineQtysPickedKey]).Add(new Tuple <long, double>(y.Ol.ixOutboundOrderLine, pickedQtyNotAllocated));
y.Ol.nBaseUnitQuantityPicked += pickedQtyNotAllocated;
pickedQtyNotAllocated -= pickedQtyNotAllocated;
y.Ol.UserName = step.Context.Activity.Conversation.Id;
_outboundorderlinesinventoryallocationService.Edit(y.Ol);
}
}
);
//Custom Code End
//We have to figure out whether this is a pick of a complete Handling Unit.
//Custom Code Start | Replaced Code Block
//Replaced Code Block Start
//return await step.PromptAsync(
// PackToHandlingUnitPromptId,
// new PromptOptions
// {
// Prompt = MessageFactory.Text($"Please enter a PackToHandlingUnit:"),
// RetryPrompt = MessageFactory.Text("I didn't understand. Please try again."),
// },
// cancellationToken);
//Replaced Code Block End
if ((bool)step.Values[IsHandlingUnitPickKey])
{
((PickBatchPickingPost)step.Values[DialogKey]).sPackToHandlingUnit = ((InventoryUnits)step.Values[PickSuggestionKey]).HandlingUnits.sHandlingUnit;
((PickBatchPickingPost)step.Values[DialogKey]).ixHandlingUnit = ((InventoryUnits)step.Values[PickSuggestionKey]).HandlingUnits.ixHandlingUnit;
//We create the packing record
var orderLinesToPack = ((List <Tuple <Int64, double> >)step.Values[LineQtysPickedKey]).GroupBy(x => x.Item1).Select(x => new { ixOutboundOrderLine = x.Key, Total = x.Sum(s => s.Item2) }).ToList();
orderLinesToPack.ForEach(x =>
{
//We check if there is an existing pack record we can use
if (
_outboundorderlinepackingService.IndexDb().Where(p =>
p.ixHandlingUnit == ((PickBatchPickingPost)step.Values[DialogKey]).ixHandlingUnit &&
p.ixOutboundOrderLine == x.ixOutboundOrderLine
).Any()
)
{
var outboundorderlinepack = _outboundorderlinepackingService.GetPost(_outboundorderlinepackingService.IndexDb().Where(p =>
p.ixHandlingUnit == ((PickBatchPickingPost)step.Values[DialogKey]).ixHandlingUnit &&
p.ixOutboundOrderLine == x.ixOutboundOrderLine
).Select(p => p.ixOutboundOrderLinePack).FirstOrDefault()
);
outboundorderlinepack.nBaseUnitQuantityPacked += x.Total;
outboundorderlinepack.UserName = step.Context.Activity.Conversation.Id;
_outboundorderlinepackingService.Edit(outboundorderlinepack);
}
else
{
var outboundorderlinepack = new OutboundOrderLinePackingPost();
outboundorderlinepack.ixOutboundOrderLine = x.ixOutboundOrderLine;
outboundorderlinepack.ixHandlingUnit = ((PickBatchPickingPost)step.Values[DialogKey]).ixHandlingUnit;
outboundorderlinepack.nBaseUnitQuantityPacked = x.Total;
outboundorderlinepack.ixStatus = _commonLookUps.getStatuses().Where(s => s.sStatus == "Active").Select(s => s.ixStatus).FirstOrDefault();
outboundorderlinepack.UserName = step.Context.Activity.Conversation.Id;
_outboundorderlinepackingService.Create(outboundorderlinepack);
}
}
);
return(await step.EndDialogAsync(
(PickBatchPickingPost)step.Values[DialogKey],
cancellationToken));
}
else
{
return(await step.PromptAsync(
PackToHandlingUnitPromptId,
new PromptOptions
{
//Custom Code Start | Replaced Code Block
//Replaced Code Block Start
//Prompt = MessageFactory.Text($"Please enter a PackToHandlingUnit:"),
//Replaced Code Block End
Prompt = MessageFactory.Text($"Please enter/scan the Pack To Handling Unit:"),
//Custom Code End
RetryPrompt = MessageFactory.Text("I didn't understand. Please try again."),
},
cancellationToken));
}
//Custom Code End
}
public void RegisterDelete(OutboundOrderLinePackingPost outboundorderlinepackingPost)
{
_context.OutboundOrderLinePackingPost.Remove(outboundorderlinepackingPost);
}
public void RegisterEdit(OutboundOrderLinePackingPost outboundorderlinepackingPost)
{
_context.Entry(outboundorderlinepackingPost).State = EntityState.Modified;
}
public void RegisterCreate(OutboundOrderLinePackingPost outboundorderlinepackingPost)
{
_context.OutboundOrderLinePackingPost.Add(outboundorderlinepackingPost);
}
