/// <summary>
/// Fixes the pick face entries.
/// </summary>
public static void FixPickFaceEntries()
{
PickFace pf = new PickFace();
pf.LoadPalletLocationsWithoutEntries();
PickFace pfl = new PickFace();
while (!pf.EOF)
{
pfl.AddNew();
pfl.PalletLocationID = pf.ID;
pfl.Save();
pf.MoveNext();
}
pf.DeleteNonPickfaceEntries();
}
public static void FixPickFaceEntries()
{
PickFace pf = new PickFace();
pf.LoadPalletLocationsWithoutEntries();
PickFace pfl = new PickFace();
while (!pf.EOF)
{
pfl.AddNew();
pfl.PalletLocationID = pf.ID;
pfl.Save();
pf.MoveNext();
}
pf.DeleteNonPickfaceEntries();
}
/// <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();
}
private void OnReplenishClicked(object sender, EventArgs e)
{
PalletLocation pl = new PalletLocation();
PickFace pf = new PickFace();
DataRow dr = gridPickFaceStockLevelView.GetFocusedDataRow();
DataRow dr2 = gridReplenishmentChoiceView.GetFocusedDataRow();
if (dr2 != null)
{
// check if the replenishment is from allowed location.
//
if (!Convert.ToBoolean(dr2["CanReplenish"]))
{
XtraMessageBox.Show("Please choose replenishment from the first to expire items", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
pl.LoadByPrimaryKey(_palletLocationID);
pf.LoadByPrimaryKey(_pickFaceID);
if (pf.IsColumnNull("Balance"))
{
pf.Balance = 0;
}
if (pl.IsColumnNull("PalletID"))
{
Pallet pallet = new Pallet();
pallet.AddNew();
pallet.StorageTypeID = Convert.ToInt32(StorageType.PickFace);
pallet.Save();
pl.PalletID = pallet.ID;
pl.Save();
}
ReceivePallet rp = new ReceivePallet();
ReceivePallet rp2 = new ReceivePallet();
ReceiveDoc rd = new ReceiveDoc();
rp.LoadByPrimaryKey(Convert.ToInt32(dr2["ReceivePalletID"]));
rp2.AddNew();
rp2.IsOriginalReceive = false;
rp2.PalletID = pl.PalletID;
rp2.ReceiveID = rp.ReceiveID;
rp2.BoxSize = rp.BoxSize;
// calculate the new balance
BLL.ItemManufacturer im = new BLL.ItemManufacturer();
im.LoadIMbyLevel(_designatedItemID, Convert.ToInt32(dr2["ManufacturerID"]),Convert.ToInt32(dr2["BoxSize"]));
if (rp.IsColumnNull("ReservedStock"))
{
rp.ReservedStock = 0;
}
//if (rp.Balance - rp.ReservedStock < im.QuantityInBasicUnit )
//{
// XtraMessageBox.Show("You cannot replenish the pick face from this location because the items are reserved for Issue. Please replenish from another receive.","Warning",MessageBoxButtons.OK,MessageBoxIcon.Warning);
// return;
//}
BLL.ItemManufacturer imff = new BLL.ItemManufacturer();
imff.LoadOuterBoxForItemManufacturer(im.ItemID,im.ManufacturerID);
if (imff.PackageLevel > im.PackageLevel && rp.Balance < imff.QuantityInBasicUnit)
{
rp2.Balance = rp.Balance;
}
else if (rp.Balance - rp.ReservedStock > im.QuantityInBasicUnit)
{
rp2.ReceivedQuantity = rp2.Balance = im.QuantityInBasicUnit;
}
else
{
rp2.Balance = rp.Balance;
}
rp2.ReservedStock = 0;
rp.Balance -= rp2.Balance;
if (rp.IsColumnNull("ReceivedQuantity"))
{
rp.ReceivedQuantity = rp.Balance + rp2.Balance;
}
rp.ReceivedQuantity -= rp2.Balance;
rp.Save();
rp2.Save();
pl.Confirmed = false;
pl.Save();
pf.Balance += Convert.ToInt32(rp2.Balance);
pf.Save();
PalletLocation pl2 = new PalletLocation();
pl2.LoadLocationForPallet(rp.PalletID);
rd.LoadByPrimaryKey(rp2.ReceiveID);
// Now update the screen accordingly.
dr["Balance"] = pf.Balance;// Convert.ToInt32(dr["Balance"]) + rp2.Balance;
InternalTransfer it = new InternalTransfer();
it.AddNew();
it.ItemID = _designatedItemID;
it.BoxLevel = im.PackageLevel;
it.ExpireDate = rd.ExpDate;
it.BatchNumber = rd.BatchNo;
it.ManufacturerID = im.ManufacturerID;
it.FromPalletLocationID = pl2.ID;
it.ToPalletLocationID = _palletLocationID;
it.IssuedDate = DateTimeHelper.ServerDateTime;
it.QtyPerPack = im.QuantityInBasicUnit;
it.Packs = 1;
it.ReceiveDocID = rp.ReceiveID;
it.QuantityInBU = it.Packs * it.QtyPerPack;
it.Type = "PickFace";
it.Status = 0;
it.Save();
BindPickFaceDetailAndReplenismehmnent();
XtraMessageBox.Show("Your Pick Face is updated, please print the replenishment list and confirm the stock movement", "Confirmation", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Saves issue order details
/// </summary>
/// <param name="orderID"></param>
/// <param name="dvPickListMakeup"></param>
public void SavePickList(int orderID, DataView dvPickListMakeup, int userID)
{
//~ Check if This Order has a previous Printed Picklist with detail: Note a header only doesnt affect us! //
var pickList = new PickList();
pickList.LoadByOrderID(orderID);
if (pickList.RowCount > 0)
{
var pldetail = new PickListDetail();
pldetail.LoadByPickListID(pickList.ID);
if (pldetail.RowCount > 0)
{
RemoveFakePartialCommitPickListDetails(orderID);
var pickL = new PickList();
pickL.LoadByOrderID(orderID);
if (pickL.RowCount > 0)
{
throw new Exception("Picklist has already been printed for this Order ");
// This error has been apprearing for the last one year so funny! I hope it won't come again! day: 10/21/2014 @yido //
}
}
}
// Create a pick list entry
Order ord = new Order();
ord.LoadByPrimaryKey(orderID);
PickList pl = new PickList();
PalletLocation plocation = new PalletLocation();
plocation.LoadByPrimaryKey(Convert.ToInt32(dvPickListMakeup[0]["PalletLocationID"]));
pl.AddNew();
pl.OrderID = orderID;
pl.PickType = "Pick";
pl.PickedBy = userID;
pl.IsConfirmed = false;
pl.IssuedDate = DateTimeHelper.ServerDateTime;
pl.SavedDate = DateTimeHelper.ServerDateTime;
pl.PickedDate = DateTimeHelper.ServerDateTime;
pl.IsWarehouseConfirmed = 0;
pl.WarehouseID = plocation.WarehouseID;
pl.Save();
PickListDetail pld = new PickListDetail();
ReceivePallet rp = new ReceivePallet();
ReceiveDoc rd = new ReceiveDoc();
PickFace pf = new PickFace();
foreach (DataRowView drv in dvPickListMakeup)
{
pld.AddNew();
pld.PickListID = pl.ID;
pld.OrderDetailID = Convert.ToInt32(drv["OrderDetailID"]);
pld.ItemID = Convert.ToInt32(drv["ItemID"]);
pld.BatchNumber = (drv["BatchNo"].ToString());
if (drv["ExpDate"] != DBNull.Value)
{
pld.ExpireDate = Convert.ToDateTime(drv["ExpDate"]);
}
pld.ManufacturerID = Convert.ToInt32(drv["ManufacturerID"]);
pld.BoxLevel = Convert.ToInt32(drv["BoxLevel"]);
pld.QtyPerPack = Convert.ToInt32(drv["QtyPerPack"]);
pld.Packs = Convert.ToDecimal(drv["Pack"]);
pld.PalletLocationID = Convert.ToInt32(drv["PalletLocationID"]);
pld.QuantityInBU = Convert.ToDecimal(drv["QtyInBU"]);
pld.ReceiveDocID = Convert.ToInt32(drv["ReceiveDocID"]);
pld.ReceivePalletID = Convert.ToInt32(drv["ReceivePalletID"]);
if (drv["CalculatedCost"] != DBNull.Value)
{
pld.Cost = Convert.ToDouble(drv["CalculatedCost"]);
}
if (drv["UnitPrice"] != DBNull.Value)
{
pld.UnitPrice = Convert.ToDouble(drv["UnitPrice"]);
}
int ReceivePalletID = Convert.ToInt32(drv["ReceivePalletID"]);
rp.LoadByPrimaryKey(ReceivePalletID);
pld.StoreID = Convert.ToInt32(drv["StoreID"]);
if (drv["DeliveryNote"] != null)
{
pld.DeliveryNote = Convert.ToBoolean(drv["DeliveryNote"]);
}
else
{
pld.DeliveryNote = false;
}
if (rp.IsColumnNull("ReservedStock"))
{
rp.ReservedStock = Convert.ToDecimal(pld.QuantityInBU);
}
else
{
rp.ReservedStock += Convert.ToDecimal(pld.QuantityInBU);
}
if (drv["UnitID"] != DBNull.Value)
{
pld.UnitID = Convert.ToInt32(drv["UnitID"]);
}
plocation.LoadByPrimaryKey(Convert.ToInt32(drv["PalletLocationID"]));
pld.PhysicalStoreID = plocation.PhysicalStoreID;
rp.Save();
if (drv["StorageTypeID"].ToString() == StorageType.PickFace)
{
pf.LoadByPalletLocation(Convert.ToInt32(drv["PalletLocationID"]));
//pf.Balance -= Convert.ToDecimal(pld.QuantityInBU);
pf.Save();
}
}
pld.Save();
ord.ChangeStatus(OrderStatus.Constant.PICK_LIST_GENERATED, CurrentContext.UserId);
ord.Save();
}
/// <summary>
/// Loads the pick list from the pick face location
/// this is only called if a pick face location is set for the item
/// </summary>
/// <param name="itemId">The item id.</param>
/// <param name="unitID">The unit ID.</param>
/// <param name="innitallyApprovedQuantity">The innitally approved quantity.</param>
/// <param name="fromstore">The fromstore.</param>
/// <param name="isDeliveryNote">if set to <c>true</c> [is delivery note].</param>
private void LoadFromPickFace(int itemId, int? unitID, decimal innitallyApprovedQuantity, int fromstore, bool isDeliveryNote)
{
decimal approvedQuantity = innitallyApprovedQuantity;
var pf = new PickFace();
pf.LoadPickFaceFor(itemId, fromstore);
if (pf.RowCount > 0)
{
var rp = new ReceivePallet();
rp.LoadPickFaceAllItemsReadyToDispatch(itemId, unitID, fromstore);
var im = new ItemManufacturer();
var imff = new ItemManufacturer();
if (pf.IsColumnNull("Balance"))
{
pf.Balance = 0;
pf.Save();
}
if (pf.Balance >= approvedQuantity)
{
while (!rp.EOF)
{
int manufId = Convert.ToInt32(rp.GetColumn("ManufacturerID"));
im.LoadIMbyLevel(itemId, manufId, Convert.ToInt32(rp.GetColumn("BoxLevel")));
int boxLevel = im.PackageLevel;
int buinsku = Convert.ToInt32(rp.GetColumn("QtyPerPack"));//imff.LoadSKUUnit(itemId, manufId);
while (boxLevel >= 0 && approvedQuantity > 0)
{
long dispatchQuantity = Convert.ToInt32(rp.GetColumn("DispatchableStock"));
int bUsinBoxLevel = im.QuantityInBasicUnit;
decimal dispatch = (approvedQuantity / bUsinBoxLevel) * bUsinBoxLevel;
if (dispatch > dispatchQuantity)
{
dispatch = dispatchQuantity;
}
while (dispatch / bUsinBoxLevel < 1 && im.PackageLevel > 0)
{
im.LoadIMbyLevel(im.ItemID, im.ManufacturerID, im.PackageLevel - 1);
bUsinBoxLevel = im.QuantityInBasicUnit;
}
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];
// only Adjust the entries that matter to the pick list
SetPriceAndQuantity(dr, dispatch, buinsku, rp, itemId, isDeliveryNote);
approvedQuantity -= dispatch;
}
boxLevel--;
im.LoadIMbyLevel(itemId, manufId, boxLevel);
}
rp.MoveNext();
}
}
}
}
/// <summary>
/// Saves issue order details
/// </summary>
/// <param name="orderID"></param>
/// <param name="dvPickListMakeup"></param>
public void SavePickList(int orderID, DataView dvPickListMakeup, int userID)
{
//~ Check if This Order has a previous Printed Picklist with detail: Note a header only doesnt affect us! //
var pickList = new PickList();
pickList.LoadByOrderID(orderID);
if(pickList.RowCount>0)
{
var pldetail = new PickListDetail();
pldetail.LoadByPickListID(pickList.ID);
if (pldetail.RowCount > 0)
{
RemoveFakePartialCommitPickListDetails(orderID);
var pickL = new PickList();
pickL.LoadByOrderID(orderID);
if (pickL.RowCount > 0)
{
throw new Exception("Picklist has already been printed for this Order ");
// This error has been apprearing for the last one year so funny! I hope it won't come again! day: 10/21/2014 @yido //
}
}
}
// Create a pick list entry
Order ord = new Order();
ord.LoadByPrimaryKey(orderID);
PickList pl = new PickList();
PalletLocation plocation = new PalletLocation();
plocation.LoadByPrimaryKey(Convert.ToInt32(dvPickListMakeup[0]["PalletLocationID"]));
pl.AddNew();
pl.OrderID = orderID;
pl.PickType = "Pick";
pl.PickedBy = userID;
pl.IsConfirmed = false;
pl.IssuedDate = DateTimeHelper.ServerDateTime;
pl.SavedDate = DateTimeHelper.ServerDateTime;
pl.PickedDate = DateTimeHelper.ServerDateTime;
pl.IsWarehouseConfirmed = 0;
pl.WarehouseID = plocation.WarehouseID;
pl.Save();
PickListDetail pld = new PickListDetail();
ReceivePallet rp = new ReceivePallet();
ReceiveDoc rd = new ReceiveDoc();
PickFace pf = new PickFace();
foreach (DataRowView drv in dvPickListMakeup)
{
pld.AddNew();
pld.PickListID = pl.ID;
pld.OrderDetailID = Convert.ToInt32(drv["OrderDetailID"]);
pld.ItemID = Convert.ToInt32(drv["ItemID"]);
pld.BatchNumber = (drv["BatchNo"].ToString());
if (drv["ExpDate"] != DBNull.Value)
{
pld.ExpireDate = Convert.ToDateTime(drv["ExpDate"]);
}
pld.ManufacturerID = Convert.ToInt32(drv["ManufacturerID"]);
pld.BoxLevel = Convert.ToInt32(drv["BoxLevel"]);
pld.QtyPerPack = Convert.ToInt32(drv["QtyPerPack"]);
pld.Packs = Convert.ToDecimal(drv["Pack"]);
pld.PalletLocationID = Convert.ToInt32(drv["PalletLocationID"]);
pld.QuantityInBU = Convert.ToDecimal(drv["QtyInBU"]);
pld.ReceiveDocID = Convert.ToInt32(drv["ReceiveDocID"]);
pld.ReceivePalletID = Convert.ToInt32(drv["ReceivePalletID"]);
if (drv["CalculatedCost"] != DBNull.Value)
pld.Cost = Convert.ToDouble(drv["CalculatedCost"]);
if (drv["UnitPrice"] != DBNull.Value)
pld.UnitPrice = Convert.ToDouble(drv["UnitPrice"]);
int ReceivePalletID = Convert.ToInt32(drv["ReceivePalletID"]);
rp.LoadByPrimaryKey(ReceivePalletID);
pld.StoreID = Convert.ToInt32(drv["StoreID"]);
if (drv["DeliveryNote"] != null)
pld.DeliveryNote = Convert.ToBoolean(drv["DeliveryNote"]);
else
pld.DeliveryNote = false;
if (rp.IsColumnNull("ReservedStock"))
{
rp.ReservedStock = Convert.ToDecimal(pld.QuantityInBU);
}
else
{
rp.ReservedStock += Convert.ToDecimal(pld.QuantityInBU);
}
if (drv["UnitID"] != DBNull.Value)
{
pld.UnitID = Convert.ToInt32(drv["UnitID"]);
}
plocation.LoadByPrimaryKey(Convert.ToInt32(drv["PalletLocationID"]));
pld.PhysicalStoreID = plocation.PhysicalStoreID;
rp.Save();
if (drv["StorageTypeID"].ToString() == StorageType.PickFace)
{
pf.LoadByPalletLocation(Convert.ToInt32(drv["PalletLocationID"]));
//pf.Balance -= Convert.ToDecimal(pld.QuantityInBU);
pf.Save();
}
}
pld.Save();
ord.ChangeStatus(OrderStatus.Constant.PICK_LIST_GENERATED,CurrentContext.UserId);
ord.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();
}
//, string guid)
private void SavePalletization(ReceiveDoc rec, DataRowView drow)
{
if ((rec.Quantity == 0 && !rec.IsColumnNull("ShortageReasonID") && rec.ShortageReasonID == ShortageReasons.Constants.NOT_RECEIVED) || (rec.Quantity == 0 && rec.IsColumnNull("ShortageReasonID")))
{
HandleFullNotReceivedAndMultipleBatchPalletlization(rec,drow);
return;
}
string guid;
BLL.ReceivePallet rp = new ReceivePallet();
Pallet pallet = new Pallet();
PalletLocation pl = new PalletLocation();
ItemUnit itemUnit = new ItemUnit();
BLL.ItemManufacturer im = new BLL.ItemManufacturer();
guid = rec.GetColumn("GUID").ToString();
var isDamaged = Convert.ToBoolean(rec.GetColumn("IsDamaged"));
//DataRow[] r = _dtPalletizedItemList.Select(string.Format("Index = '{0}'", i));
DataRow[] r =
_dtPalletizedItemList.Select(string.Format("GUID = '{0}' AND IsDamaged = {1}", guid, isDamaged));
if (r.Length > 0)
{
foreach (DataRow rw in r)
{
rp.AddNew();
rp.IsOriginalReceive = true;
if (Convert.ToBoolean(rw["Consolidate"]))
{
try
{
DataRow dr =
_dtPutAwayPalletized.Select(string.Format("PalletNumber={0}",
Convert.ToInt32(rw["PalletNumber"])))[0]; //Assuming we only need one.
if (rw["IsStoredInFreeStorageType"] != null)
{
if (Convert.ToBoolean(rw["IsStoredInFreeStorageType"]) == true)
{
pl.LoadByPrimaryKey(Convert.ToInt32(dr["PutAwayLocation"]));
}
}
}
catch
{
pl.LoadByPalletNumber(Convert.ToInt32(rw["PalletNumber"]));
}
try
{
rp.PalletID = pl.PalletID;
rp.PalletLocationID = pl.ID;
}
catch
{
rp.PalletID = GetPalletID(rw["PalletNumber"].ToString());
try
{
rp.PalletLocationID = PalletLocation.GetPalletLocationID(rp.PalletID);
}
catch
{
DataRow dr =
_dtPutAwayPalletized.Select(string.Format("PalletNumber={0}",
Convert.ToInt32(rw["PalletNumber"])))[0];
pl.LoadByPrimaryKey(Convert.ToInt32(dr["PutAwayLocation"]));
pl.PalletID = rp.PalletID;
pl.Save();
rp.PalletLocationID = pl.ID;
}
}
//// if the putaway is on a pick face, increase the amount stored on the pick face
//if (pl.StorageTypeID.ToString() == StorageType.PickFace)
//{
// PickFace pf = new PickFace();
// pf.LoadPickFaceFor(rec.ItemID, Convert.ToInt32(cboStores.EditValue));
// if (pf.RowCount > 0)
// {
// if (pf.IsColumnNull("Balance"))
// {
// pf.Balance = 0;
// }
// pf.Balance += Convert.ToInt32(rp.Balance);
// pf.Save();
// }
//}
}
else
{
var palletNumber = Convert.ToInt32(rw["PalletNumber"]);
DataRow dr = _dtPutAwayPalletized.Select(string.Format("PalletNumber={0}", palletNumber))[0];
//Assuming we only need one.
pl.LoadByPrimaryKey(Convert.ToInt32(dr["PutAwayLocation"]));
rp.PalletID = GetPalletID(rw["PalletNumber"].ToString());
pl.PalletID = rp.PalletID;
rp.PalletLocationID = pl.ID; //PalletLocation.GetPalletLocationID(rp.PalletID);
pl.Save();
}
rp.ReservedStock = 0;
im.LoadIMbyLevel(Convert.ToInt32(rw["ID"]), Convert.ToInt32(rw["Manufacturer"]),
Convert.ToInt32(rw["BoxLevel"]));
int qtyPerPack = im.QuantityInBasicUnit;
if (rw["UnitID"] != DBNull.Value)
{
itemUnit.LoadByPrimaryKey(Convert.ToInt32(rw["UnitID"]));
qtyPerPack = itemUnit.QtyPerUnit;
}
rp.ReceivedQuantity = rp.Balance = (Convert.ToDecimal(rw["Pack Qty"]) * Convert.ToDecimal(qtyPerPack));
rp.BoxSize = Convert.ToInt32(rw["BoxLevel"]);
if (rec.IsColumnNull("PhysicalStoreID") && !rp.IsColumnNull("PalletLocationID"))
{
PalletLocation l = new PalletLocation();
l.LoadByPrimaryKey(rp.PalletLocationID);
rec.PhysicalStoreID = (l.PhysicalStoreID);
PhysicalStore physicalStore = new PhysicalStore();
physicalStore.LoadByPrimaryKey(l.PhysicalStoreID);
rec.InventoryPeriodID = physicalStore.CurrentInventoryPeriodID;
}
if (Convert.ToBoolean(rw["Consolidate"]))
{
try
{
// if the putaway is on a pick face, increase the amount stored on the pick face
if (pl.StorageTypeID.ToString() == StorageType.PickFace)
{
PickFace pf = new PickFace();
pf.LoadPickFaceFor(rec.ItemID, Convert.ToInt32(lkAccounts.EditValue));
if (pf.RowCount > 0)
{
if (pf.IsColumnNull("Balance"))
{
pf.Balance = 0;
}
pf.Balance += Convert.ToInt32(rp.Balance);
pf.Save();
}
}
}
catch
{
}
}
}
}
//r = _dtPutAwayNonPalletized.Select(string.Format("Index = '{0}'", i));
string filterQuery = _revDocRelatePalletGuid.ContainsKey(guid)
? string.Format("{0} AND IsDamaged = {1}", GetFilterByGuid(_revDocRelatePalletGuid[guid]), isDamaged)
: string.Format("GUID = '{0}' AND IsDamaged = {1} ", guid, isDamaged);
r = _dtPutAwayNonPalletized.Select(filterQuery);
if (r.Length > 0)
{
// Save the palletization and the putaway here,// this was supposed to be out of here but it is easlier to implement here.
foreach (DataRow rw in r)
{
pl.LoadByPrimaryKey(Convert.ToInt32(rw["PutAwayLocation"]));
if (pl.IsColumnNull("PalletID"))
{
pallet.AddNew();
pallet.Save();
}
else
{
pallet.LoadByPrimaryKey(pl.PalletID);
}
rp.AddNew();
rp.IsOriginalReceive = true;
rp.PalletID = pallet.ID;
rp.PalletLocationID = pl.ID;
// rp.ReceiveID = rec.ID;
rp.ReservedStock = 0;
im.LoadIMbyLevel(Convert.ToInt32(rw["ID"]), Convert.ToInt32(rw["Manufacturer"]),
Convert.ToInt32(rw["BoxLevel"]));
int qtyPerPack = im.QuantityInBasicUnit;
if (rw["UnitID"] != DBNull.Value)
{
itemUnit.LoadByPrimaryKey(Convert.ToInt32(rw["UnitID"]));
qtyPerPack = itemUnit.QtyPerUnit;
}
rp.ReceivedQuantity =
rp.Balance = (Convert.ToDecimal(rw["Palletized Quantity"]) * Convert.ToDecimal(qtyPerPack));
rp.BoxSize = Convert.ToInt32(rw["BoxLevel"]);
//Get the putaway location
pl.Save();
if (pl.IsColumnNull("PalletID"))
{
pl.PalletID = pallet.ID;
pl.Confirmed = false;
pl.Save();
}
}
}
if (rec.IsColumnNull("PhysicalStoreID") && !rp.IsColumnNull("PalletLocationID"))
{
PalletLocation l = new PalletLocation();
l.LoadByPrimaryKey(rp.PalletLocationID);
PhysicalStore physicalStore = new PhysicalStore();
physicalStore.LoadByPrimaryKey(l.PhysicalStoreID);
rec.PhysicalStoreID = (l.PhysicalStoreID);
// we can take any of the pallet location physical store. as we have one entry on receiveDoc per Store.
if (physicalStore.IsColumnNull("CurrentInventoryPeriodID"))
{
XtraMessageBox.Show(string.Format("Please Set InventoryPeriod for '{0}' PhysicalStore!",
physicalStore.Name), "Empty InventoryPeriod", MessageBoxButtons.OK, MessageBoxIcon.Error);
throw new Exception(string.Format("Please Set InventoryPeriod for '{0}' PhysicalStore!",
physicalStore.Name));
}
rec.InventoryPeriodID = physicalStore.CurrentInventoryPeriodID;
}
rec.Save();
rp.Rewind();
while (!rp.EOF)
{
rp.ReceiveID = rec.ID;
rp.MoveNext();
}
rp.Save();
SavePutAwayItems();
}
private void tpDelete_Click(object sender, EventArgs e)
{
DataRow dr = gridViewBinCard.GetFocusedDataRow();
if (Convert.ToInt32(dr["Precedance"]) != 3)
{
XtraMessageBox.Show("You cannot delete this");
return;
}
if (CurrentContext.LoggedInUser.UserType == UserType.Constants.DISTRIBUTION_MANAGER_WITH_DELETE)
{
if (
XtraMessageBox.Show(
"Are you sure you want to delete this transaction? You will not be able to undo this.",
"Confirmation", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
MyGeneration.dOOdads.TransactionMgr tranMgr =
MyGeneration.dOOdads.TransactionMgr.ThreadTransactionMgr();
try
{
tranMgr.BeginTransaction();
ReceiveDoc rdoc = new ReceiveDoc();
ReceivePallet rp = new ReceivePallet();
IssueDoc idoc = new IssueDoc();
PickListDetail pld = new PickListDetail();
int issueID = Convert.ToInt32(dr["ID"]);
//pld.LoadByOrderAndItem(Convert.ToInt32(dr["OrderID"]), Convert.ToInt32(dr["ItemID"]),
// Convert.ToInt32(dr["Quantity"]));
idoc.LoadByPrimaryKey(issueID);
pld.LoadByPrimaryKey(idoc.PLDetailID);
string RefNo = idoc.RefNo;
rdoc.LoadByPrimaryKey(idoc.RecievDocID);
//if (pld.RowCount == 0)
//{
// pld.LoadByOrderAndItem(Convert.ToInt32(dr["OrderID"]), Convert.ToInt32(dr["ItemID"]));
//}
rp.LoadByPrimaryKey(pld.ReceivePalletID);
PalletLocation pl = new PalletLocation();
pl.loadByPalletID(rp.PalletID);
if (pl.RowCount == 0)
{
pl.LoadByPrimaryKey(pld.PalletLocationID);
if (pl.IsColumnNull("PalletID"))
{
pl.PalletID = rp.PalletID;
pl.Save();
}
//rp.LoadNonZeroRPByReceiveID(rdoc.ID);
}
if (rp.RowCount == 0)
{
XtraMessageBox.Show("You cannot delete this item, please contact the administrator", "Error");
return;
}
if (rp.RowCount > 0)
{
rdoc.QuantityLeft += idoc.Quantity;
rp.Balance += idoc.Quantity;
pld.QuantityInBU = 0;
// are we adding it the pick face?
// if so add it to the balance of the pick face also
pl.loadByPalletID(rp.PalletID);
if (pl.RowCount == 0)
{
PutawayLocation plocation = new PutawayLocation(rdoc.ItemID);
// we don't have a location for this yet,
// select a new location
//PutawayLocataion pl = new PutawayLocataion();
if (plocation.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{
pl.LoadByPrimaryKey(plocation.PalletLocationID);
if (pl.RowCount > 0)
{
pl.PalletID = rp.PalletID;
pl.Save();
}
}
}
if (pl.RowCount > 0)
{
PickFace pf = new PickFace();
pf.LoadByPalletLocation(pl.ID);
if (pf.RowCount > 0)
{
pf.Balance += Convert.ToInt32(idoc.Quantity);
pf.Save();
}
IssueDocDeleted.AddNewLog(idoc, CurrentContext.UserId);
idoc.MarkAsDeleted();
rdoc.Save();
rp.Save();
idoc.Save();
// now refresh the window
XtraMessageBox.Show("Issue Deleted!", "Confirmation", MessageBoxButtons.OK,
MessageBoxIcon.Information);
tranMgr.CommitTransaction();
//TODO: refresh the list
// gridViewReferences_FocusedRowChanged(null, null);
}
}
else
{
XtraMessageBox.Show(
"This delete is not successfull because a free pick face location was not selected. please select a free location and try again.",
"Error Deleteing issue transaction", MessageBoxButtons.OK, MessageBoxIcon.Error);
tranMgr.RollbackTransaction();
}
}
catch
{
XtraMessageBox.Show("This delete is not successfull", "Warning ...", MessageBoxButtons.OK,
MessageBoxIcon.Warning);
tranMgr.RollbackTransaction();
}
}
}
else
{
XtraMessageBox.Show(
"You cannot delete this transaction because you don't have previlage. Please contact the administrator if you thing this is an error.",
"Delete is not allowed");
}
}
public static void DeleteIssueDoc(int issueID)
{
MyGeneration.dOOdads.TransactionMgr tranMgr =
MyGeneration.dOOdads.TransactionMgr.ThreadTransactionMgr();
try
{
tranMgr.BeginTransaction();
var pld = new PickListDetail();
var rdoc = new ReceiveDoc();
var rp = new ReceivePallet();
var idoc = new IssueDoc();
idoc.LoadByPrimaryKey(issueID);
pld.LoadByPrimaryKey(idoc.PLDetailID);
rdoc.LoadByPrimaryKey(idoc.RecievDocID);
rp.LoadByPrimaryKey(pld.ReceivePalletID);
var pl = new PalletLocation();
pl.loadByPalletID(rp.PalletID);
if (pl.RowCount == 0)
{
pl.LoadByPrimaryKey(pld.PalletLocationID);
if (pl.IsColumnNull("PalletID"))
{
pl.PalletID = rp.PalletID;
pl.Save();
}
}
if (rp.RowCount == 0)
{
XtraMessageBox.Show("You cannot delete this item, please contact the administrator", "Error");
return;
}
if (rp.RowCount > 0)
{
// in error cases this could lead to a number greater than the received quantity
// instead of being an error, it should just delete the respective issue and
// adjust the remaining quantity to the received quantity.
if (rdoc.QuantityLeft + idoc.Quantity > rdoc.Quantity)
{
rdoc.QuantityLeft = rp.Balance = rdoc.Quantity;
}
else
{
rdoc.QuantityLeft += idoc.Quantity;
rp.Balance += idoc.Quantity;
}
//Delete from picklistDetail and add to pickListDetailDeleted
PickListDetailDeleted.AddNewLog(pld, BLL.CurrentContext.UserId);
pld.MarkAsDeleted();
// are we adding it the pick face?
// if so add it to the balance of the pick face also
pl.loadByPalletID(rp.PalletID);
if (pl.RowCount == 0)
{
var plocation = new PutawayLocation(rdoc.ItemID);
// we don't have a location for this yet,
// select a new location
//PutawayLocataion pl = new PutawayLocataion();
if (plocation.ShowDialog() == DialogResult.OK)
{
pl.LoadByPrimaryKey(plocation.PalletLocationID);
if (pl.RowCount > 0)
{
pl.PalletID = rp.PalletID;
pl.Save();
}
}
}
if (pl.RowCount > 0)
{
var pf = new PickFace();
pf.LoadByPalletLocation(pl.ID);
if (pf.RowCount > 0)
{
pf.Balance += Convert.ToInt32(idoc.Quantity);
pf.Save();
}
IssueDocDeleted.AddNewLog(idoc, CurrentContext.UserId);
idoc.MarkAsDeleted();
rdoc.Save();
rp.Save();
idoc.Save();
pld.Save();
// now refresh the window
XtraMessageBox.Show("Issue Deleted!", "Confirmation", MessageBoxButtons.OK,
MessageBoxIcon.Information);
tranMgr.CommitTransaction();
}
}
else
{
XtraMessageBox.Show(
"This delete is not successfull because a free pick face location was not selected. please select a free location and try again.",
"Error Deleteing issue transaction", MessageBoxButtons.OK, MessageBoxIcon.Error);
tranMgr.RollbackTransaction();
}
}
catch
{
XtraMessageBox.Show("This delete is not successfull", "Warning ...", MessageBoxButtons.OK,
MessageBoxIcon.Warning);
tranMgr.RollbackTransaction();
}
}
public void DeleteAnIssue(int issueDociD)
{
ReceiveDoc rdoc = new ReceiveDoc();
ReceivePallet rp = new ReceivePallet();
IssueDoc idoc = new IssueDoc();
idoc.LoadByPrimaryKey(issueDociD);
if (idoc.IsThereSRM)
{
throw new Exception("There is an SRM for this issue. You can't void it.");
}
PickListDetail pld = new PickListDetail();
//pld.LoadByOrderAndItem(idoc.OrderID, idoc.ItemID, idoc.NoOfPack);
pld.LoadByPrimaryKey(idoc.PLDetailID);
string RefNo = idoc.RefNo;
rdoc.LoadByPrimaryKey(idoc.RecievDocID);
//if (pld.RowCount == 0)
//{
// pld.LoadByOrderAndItem(idoc.OrderID, idoc.ItemID);
//}
rp.LoadByReceiveDocID(idoc.RecievDocID);
PalletLocation pl = new PalletLocation();
pl.loadByPalletID(rp.PalletID);
if (pl.RowCount == 0)
{
pl.LoadByPrimaryKey(pld.PalletLocationID);
if (pl.IsColumnNull("PalletID"))
{
pl.PalletID = rp.PalletID;
pl.Save();
}
}
if (rp.RowCount == 0)
{
XtraMessageBox.Show("You cannot delete this item, please contact the administrator", "Error");
return;
}
if (rp.RowCount > 0)
{
rdoc.QuantityLeft += idoc.Quantity;
rp.Balance += idoc.Quantity;
//Delete from picklistDetail and add to pickListDetailDeleted
PickListDetailDeleted.AddNewLog(pld, BLL.CurrentContext.UserId);
pld.MarkAsDeleted();
// are we adding it the pick face?
// if so add it to the balance of the pick face also
pl.loadByPalletID(rp.PalletID);
if (pl.RowCount == 0)
{
PutawayLocation plocation = new PutawayLocation(rdoc.ItemID);
// we don't have a location for this yet,
// select a new location
//PutawayLocataion pl = new PutawayLocataion();
if (plocation.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{
pl.LoadByPrimaryKey(plocation.PalletLocationID);
if (pl.RowCount > 0)
{
pl.PalletID = rp.PalletID;
pl.Save();
}
}
}
if (pl.RowCount > 0)
{
PickFace pf = new PickFace();
pf.LoadByPalletLocation(pl.ID);
if (pf.RowCount > 0)
{
pf.Balance += Convert.ToInt32(idoc.Quantity);
pf.Save();
}
IssueDocDeleted.AddNewLog(idoc, CurrentContext.UserId);
idoc.MarkAsDeleted();
rdoc.Save();
rp.Save();
idoc.Save();
pld.Save();
}
else
{
XtraMessageBox.Show(
"This delete is not successful because a free pick face location was not selected. please select a free location and try again.", "Error Deleteing issue transaction", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}