/// <summary>
/// This happes when there is plenty of transaction at the same time
/// and will result a partial commit.
/// This fake rows should be deleted from DB.
/// </summary>
/// <param name="orderID"></param>
private void RemoveFakePartialCommitPickListDetails(int orderID)
{
var order = new Order();
order.LoadByPrimaryKey(orderID);
if (order.OrderStatusID == OrderStatus.Constant.ORDER_APPROVED)
{
var pickList = new PickList();
pickList.LoadByOrderID(order.ID);
if (pickList.RowCount == 0) //~ If there is no picklist, there is nothing to delete. ~//
{
return;
}
var picklistDetail = new PickListDetail();
picklistDetail.LoadByPickListID(pickList.ID);
picklistDetail.Rewind();
while (!picklistDetail.EOF)
{
PickListDetailDeleted.AddNewLog(picklistDetail, CurrentContext.UserId);
picklistDetail.MarkAsDeleted();
picklistDetail.MoveNext();
}
picklistDetail.Save();
pickList.MarkAsDeleted();
pickList.Save();
}
}
/// <summary>
/// Undo pick list that has been printed
/// </summary>
/// <param name="orderID">The order ID.</param>
public void CancelOrderWithPickList(int orderID)
{
// Create a pick list entry
Order ord = new Order();
PickList pl = new PickList();
PickListDetail pld = new PickListDetail();
ReceivePallet rp = new ReceivePallet();
ReceiveDoc rd = new ReceiveDoc();
PickFace pf = new PickFace();
PalletLocation palletLocation = new PalletLocation();
ord.LoadByPrimaryKey(orderID);
pl.LoadByOrderID(orderID);
pld.LoadByPickListID(pl.ID);
while (!pld.EOF)
{
rp.LoadByPrimaryKey(pld.ReceivePalletID);
rp.ReservedStock -= Convert.ToInt32(pld.QuantityInBU);
if (rp.ReservedStock < 0)
{
rp.ReservedStock = 0; //If there has been no reservation, allow to cancel the picklist too. No need for it to be blocked by the constraint.
}
rp.Save();
palletLocation.LoadByPrimaryKey(pld.PalletLocationID);
if (palletLocation.StorageTypeID.ToString() == StorageType.PickFace)
{
pf.LoadByPalletLocation(pld.PalletLocationID);
pf.Balance += Convert.ToInt32(pld.QuantityInBU);
pf.Save();
}
//Delete from picklistDetail and add to pickListDetailDeleted
PickListDetailDeleted.AddNewLog(pld, BLL.CurrentContext.UserId);
pld.MarkAsDeleted();
pld.MoveNext();
}
pld.Save();
ord.ChangeStatus(OrderStatus.Constant.CANCELED, CurrentContext.UserId);
pl.MarkAsDeleted();
pl.Save();
}
/// <summary>
/// This happes when there is plenty of transaction at the same time
/// and will result a partial commit.
/// This fake rows should be deleted from DB.
/// </summary>
/// <param name="orderID"></param>
private void RemoveFakePartialCommitPickListDetails(int orderID)
{
var order = new Order();
order.LoadByPrimaryKey(orderID);
if (order.OrderStatusID == OrderStatus.Constant.ORDER_APPROVED)
{
var pickList = new PickList();
pickList.LoadByOrderID(order.ID);
if (pickList.RowCount == 0) //~ If there is no picklist, there is nothing to delete. ~//
return;
var picklistDetail = new PickListDetail();
picklistDetail.LoadByPickListID(pickList.ID);
picklistDetail.Rewind();
while (!picklistDetail.EOF)
{
PickListDetailDeleted.AddNewLog(picklistDetail, CurrentContext.UserId);
picklistDetail.MarkAsDeleted();
picklistDetail.MoveNext();
}
picklistDetail.Save();
pickList.MarkAsDeleted();
pickList.Save();
}
}
/// <summary>
/// Releases the reservation.
/// </summary>
public void ReleaseReservation()
{
PickList pickList = new PickList();
pickList.LoadByOrderID(this.ID);
if (pickList.RowCount == 0) //If there is no picklist, there is nothing to release.
return;
PickListDetail pld = new PickListDetail();
pld.LoadByPickListID(pickList.ID);
pld.Rewind();
while (!pld.EOF)
{
ReceivePallet receivePallet = new ReceivePallet();
receivePallet.LoadByPrimaryKey(pld.ReceivePalletID);
ReceiveDoc rdoc = new ReceiveDoc();
rdoc.LoadByPrimaryKey(pld.ReceiveDocID);
receivePallet.ReservedStock = receivePallet.ReservedStock - Convert.ToInt32(pld.QuantityInBU);
if (receivePallet.ReservedStock < 0)
receivePallet.ReservedStock = 0;
receivePallet.Save();
//Delete from picklistDetail and add to pickListDetailDeleted
PickListDetailDeleted.AddNewLog(pld, BLL.CurrentContext.UserId);
pld.MarkAsDeleted();
pld.MoveNext();
//Delete issues if the order has any
var iss = new Issue();
iss.GetIssueByOrderID(this.ID);
iss.Rewind();
if (iss.RowCount > 0)
{
while (!iss.EOF)
{
iss.MarkAsDeleted();
iss.MoveNext();
}
iss.Save();
}
}
pld.Save();
pickList.MarkAsDeleted();
pickList.Save();
}
/// <summary>
/// Undo pick list that has been printed
/// </summary>
/// <param name="orderID">The order ID.</param>
public void CancelOrderWithPickList(int orderID)
{
// Create a pick list entry
Order ord = new Order();
PickList pl = new PickList();
PickListDetail pld = new PickListDetail();
ReceivePallet rp = new ReceivePallet();
ReceiveDoc rd = new ReceiveDoc();
PickFace pf = new PickFace();
PalletLocation palletLocation = new PalletLocation();
ord.LoadByPrimaryKey(orderID);
pl.LoadByOrderID(orderID);
pld.LoadByPickListID(pl.ID);
while (!pld.EOF)
{
rp.LoadByPrimaryKey(pld.ReceivePalletID);
rp.ReservedStock -= Convert.ToInt32(pld.QuantityInBU);
if (rp.ReservedStock < 0)
rp.ReservedStock = 0; //If there has been no reservation, allow to cancel the picklist too. No need for it to be blocked by the constraint.
rp.Save();
palletLocation.LoadByPrimaryKey(pld.PalletLocationID);
if (palletLocation.StorageTypeID.ToString() == StorageType.PickFace)
{
pf.LoadByPalletLocation(pld.PalletLocationID);
pf.Balance += Convert.ToInt32(pld.QuantityInBU);
pf.Save();
}
//Delete from picklistDetail and add to pickListDetailDeleted
PickListDetailDeleted.AddNewLog(pld, BLL.CurrentContext.UserId);
pld.MarkAsDeleted();
pld.MoveNext();
}
pld.Save();
ord.ChangeStatus(OrderStatus.Constant.CANCELED,CurrentContext.UserId);
pl.MarkAsDeleted();
pl.Save();
}