/// <summary>
/// Adds to pick list for an order detail.
/// </summary>
/// <param name="orderDetailID">The order detail ID.</param>
/// <param name="itemId">The item id.</param>
/// <param name="unitID">The unit ID.</param>
/// <param name="initalApprovedQuantity">The inital approved quantity.</param>
/// <param name="storeID">The store ID.</param>
/// <param name="preferedManufacturer">The prefered manufacturer.</param>
/// <param name="preferredPhysicalStore">The preferred physical store.</param>
/// <param name="isDeliveryNote">if set to <c>true</c> [is delivery note].</param>
/// <param name="preferredExpiry">The preferred expiry.</param>
/// <exception cref="System.Exception"></exception>
private void AddToPickListFor(int userID, int orderDetailID, int itemId, int? unitID, decimal initalApprovedQuantity, int storeID, int preferedManufacturer, int preferredPhysicalStore, bool isDeliveryNote, DateTime? preferredExpiry)
{
bool deliveryNoteWarning = false;
if (isDeliveryNote && !BLL.Settings.HandleDeliveryNotes)
{
//If the request is for delivery notes but the delivery notes haven't been enabled, then let's change the delivery note bit but also set a warning bit so that we can report it to the user if there are no priced items available. (i.e. In case the picklist comes out empty, we report an error)
deliveryNoteWarning = true;
isDeliveryNote = false;
}
decimal approvedQuantity = initalApprovedQuantity;
bool belowBoxPickedFromRack = false;
//if (preferedManufacturer == -1)
//{
var rp = new ReceivePallet();
var palletLoc = new PalletLocation();
var im = new ItemManufacturer();
var pf = new PickFace();
int buinsku = 0;
// no manufacturer is preferred so just do the pick list
// select items that have balance, with sales price and that do have
rp.LoadNonPickFaceAllItemsReadyToDispatch(userID, itemId, unitID, storeID, preferedManufacturer,
preferredPhysicalStore, isDeliveryNote, preferredExpiry);
//If the delivery note warning bit has been set and there are no priced items in the databasee,
//let's throw an error to the users so that they know the cause of the problem.
//The solution is to either not choose delivery notes or on the approval stage or enable delivery notes in the settings.
if (rp.RowCount == 0 && deliveryNoteWarning)
{
throw new Exception("Delivery Notes Preference has been set but delivery notes are not enabled for this database.");
}
// get how much of it is on the pick face
//TOFIX: this doesn't have to rely on the quantity on the pick face
pf.LoadPickFaceFor(itemId, storeID);
// Just to be safe
rp.Rewind();
if (rp.RowCount == 0)
{
// this means there is no item to issue other than on the pick face
// try issuing from the pick face
LoadFromPickFace(itemId, unitID, approvedQuantity, storeID, isDeliveryNote);
return;
}
while (!rp.EOF)
{
// get the current manufacturer
int manufId = Convert.ToInt32(rp.GetColumn("ManufacturerID"));
// what is the dispatch able quantity in the current record?
decimal dispatchableQuantity = Convert.ToDecimal(rp.GetColumn("DispatchableStock"));
palletLoc.loadByPalletID(rp.PalletID);
// check if the item is from the rack or the low quantity storage place.
// if it is from the rack, make sure the packs column counts in cartons
// if it is not, count in number of packs/SKU or Level 0 only
if (palletLoc.RowCount > 0 && palletLoc.StorageTypeID.ToString() == StorageType.StackedStorage)
{
im.LoadIMbyLevel(itemId, manufId, 0);
}
else if ((palletLoc.RowCount > 0 && palletLoc.StorageTypeID.ToString() != StorageType.BulkStore) ||
(pf.RowCount == 0 && palletLoc.StorageTypeID.ToString() == StorageType.BulkStore))
{
im.LoadIMbyLevel(itemId, manufId, 0);
}
else
{
im.LoadIMbyLevel(itemId, manufId, Convert.ToInt32(rp.GetColumn("BoxLevel")));
}
// just incase there are open cartons on the rack, handle them here.
if (im.RowCount > 0 && (im.QuantityInBasicUnit > dispatchableQuantity && im.PackageLevel > 0))
{
im.LoadIMbyLevel(itemId, manufId, 0);
}
// hold what level we are about to issue,
// which level of carton and the basic unit in that carton.
int bUsinBoxLevel;
buinsku = Convert.ToInt32(rp.GetColumn("QtyPerPack"));// imff.LoadSKUUnit(im.ItemID, im.ManufacturerID);
if (unitID != null)
{
ItemUnit iu = new ItemUnit();
iu.LoadByPrimaryKey(unitID.Value);
bUsinBoxLevel = iu.QtyPerUnit;
if (buinsku != bUsinBoxLevel)
{
// This defintely is an error,
//TODO: do something about it ;)
buinsku = bUsinBoxLevel;
}
}
else
{
bUsinBoxLevel = im.QuantityInBasicUnit;
}
// get the maximum amount of item that can be fulfilled under the current box level
decimal dispatch = (approvedQuantity / bUsinBoxLevel) * bUsinBoxLevel;
if (dispatch > dispatchableQuantity)
{
// if the dispatch able quantity is less than what is requested,
// only give what we have.
dispatch = dispatchableQuantity;
}
else if (dispatch == 0)
{
break;
}
if (dispatchableQuantity > approvedQuantity)
{
// check if the dispatch is possible with existing pick face items
decimal remaining = approvedQuantity - dispatch;
// TODO: Explain WTF all this condition is
// I assume at this point that it is checking if the remaining amount should be fulfilled from the pick face or not
//
if (((pf.RowCount == 0 || pf.IsColumnNull("Balance")) && remaining == 0) ||
((pf.RowCount > 0 && !pf.IsColumnNull("Balance") && pf.Balance >= remaining)))
{
// do this if we should go to the pick face for any reason.
if (dispatch > 0)
{
// do the pick list entries here
_pickList.ImportRow(rp.CurrentDataRow);
// pick the currently inserted entry and adjust all the numbers in it.
DataRow dr = _pickList.Rows[_pickList.Rows.Count - 1];
dr["OrderDetailID"] = orderDetailID;
// only Adjust the entries that matter to the pick list
SetPriceAndQuantity(dr, dispatch, buinsku, rp, itemId, isDeliveryNote);
approvedQuantity -= dispatch;
// add the items from the pick face
}
//TODO: implement the pick face logic here.
LoadFromPickFace(itemId, unitID, approvedQuantity, storeID, isDeliveryNote);
return;
}
else
{
// do the bulk pick list and entries here
if (dispatch > 0)
{
_pickList.ImportRow(rp.CurrentDataRow);
// pick the currently inserted entry and adjust all the numbers in it.
DataRow dr = _pickList.Rows[_pickList.Rows.Count - 1];
dr["OrderDetailID"] = orderDetailID;
// only Adjust the entries that matter to the pick list
SetPriceAndQuantity(dr, dispatch, buinsku, rp, itemId, isDeliveryNote);
approvedQuantity -= dispatch;
// the order couldn't be done at this time because the pickface has to be reprenished,
// Mark the ReplenishmentList and continue with the other pick list items.
// return this message to the user and continue to the next level
// do the pick list entries here
}
}
}
else
// if we are here, it means that the dispatch able quantity is equal to what we have or greater than the request
{
// dispatch the existing quantity and continue with the other entries in the receive pallet
_pickList.ImportRow(rp.CurrentDataRow);
// pick the currently inserted entry and adjust all the numbers in it.
DataRow dr = _pickList.Rows[_pickList.Rows.Count - 1];
dr["OrderDetailID"] = orderDetailID;
// only Adjust the entries that matter to the pick list
SetPriceAndQuantity(dr, dispatch, buinsku, rp, itemId, isDeliveryNote);
approvedQuantity -= dispatch;
belowBoxPickedFromRack = true;
}
rp.MoveNext();
}
if (!belowBoxPickedFromRack && approvedQuantity > 0)
{
LoadFromPickFace(itemId, unitID, approvedQuantity, storeID, isDeliveryNote);
}
if (approvedQuantity > buinsku && approvedQuantity > 0 &&
((pf.RowCount == 0 || pf.IsColumnNull("Balance")) || (approvedQuantity > pf.Balance)))
{
//TODO: if this was the last entry in the rp pallet, then it means that the pick face needs to be replenished,\
// Implement that logic here.
// this means the pick face has been setup.
DataRowView drv = _replenishmentList.DefaultView.AddNew();
drv["ItemID"] = itemId;
drv["StoreID"] = storeID;
drv.EndEdit();
}
}