private void btnRelocatePallet_Click(object sender, EventArgs e)
{
//Get the chosen pallet Location
BLL.PalletLocation palletLocation = new BLL.PalletLocation();
palletLocation.LoadByPrimaryKey(Convert.ToInt16(lkAvailablePalletLocation.EditValue));
//Get the chosen misplaced receivepallet entry
DataRow dr = grdViewMisplacedItems.GetFocusedDataRow();
int receivePalletID = Convert.ToInt32(dr["ID"]);
BLL.ReceivePallet rp = new BLL.ReceivePallet();
rp.LoadByPrimaryKey(receivePalletID);
if (palletLocation.IsColumnNull("PalletID"))
{
palletLocation.PalletID = rp.PalletID;
palletLocation.Save();
}
else
{
rp.PalletID = palletLocation.PalletID;
rp.Save();
}
int storeID = Convert.ToInt16(lkStoreLocation.EditValue);
LoadMisplacedItems(storeID);
XtraMessageBox.Show("Placed!!");
}
internal static PickListDetail GeneratePickListDetail(ReceivePallet receivePallet, int pickListId, decimal qtyInBU)
{
ReceiveDoc receiveDoc = new ReceiveDoc();
receiveDoc.LoadByPrimaryKey(receivePallet.ReceiveID);
decimal pack = qtyInBU / Convert.ToDecimal(receiveDoc.QtyPerPack);
PickListDetail pkDetail = new PickListDetail();
pkDetail.AddNew();
pkDetail.PickListID = pickListId;
pkDetail.ItemID = receiveDoc.ItemID;
PalletLocation palletLocation = new PalletLocation();
palletLocation.loadByPalletID(receivePallet.PalletID);
int palletLocationId;
try
{
palletLocationId = palletLocation.ID;
}
catch (Exception exp)
{
palletLocationId = receivePallet.PalletLocationID;
palletLocation.LoadByPrimaryKey(palletLocationId);
}
pkDetail.PalletLocationID = palletLocationId;
if (!receiveDoc.IsColumnNull("BatchNo"))
{
pkDetail.BatchNumber = receiveDoc.BatchNo;
}
if (!receiveDoc.IsColumnNull("ExpDate"))
{
pkDetail.ExpireDate = receiveDoc.ExpDate;
}
pkDetail.StoreID = receiveDoc.StoreID;
pkDetail.UnitID = receiveDoc.UnitID;
pkDetail.ReceiveDocID = receiveDoc.ID;
if (!receiveDoc.IsColumnNull("Cost"))
{
pkDetail.Cost = Convert.ToDouble(pack) * Math.Round(receiveDoc.Cost, BLL.Settings.NoOfDigitsAfterTheDecimalPoint);
pkDetail.UnitPrice = Math.Round(receiveDoc.Cost, BLL.Settings.NoOfDigitsAfterTheDecimalPoint);
}
pkDetail.Packs = pack;
pkDetail.QtyPerPack = receiveDoc.QtyPerPack;
pkDetail.QuantityInBU = qtyInBU;
pkDetail.StoreID = receiveDoc.StoreID;
pkDetail.ReceivePalletID = receivePallet.ID;
pkDetail.ManufacturerID = receiveDoc.ManufacturerId;
pkDetail.BoxLevel = 0;
pkDetail.DeliveryNote = true;
pkDetail.PhysicalStoreID = palletLocation.PhysicalStoreID;
pkDetail.Save();
return(pkDetail);
}
/// <summary>
/// Get dtail items for Pick face
/// </summary>
/// <param name="pickfaceId"></param>
/// <param name="palletLocationId"></param>
/// <returns></returns>
public DataTable GetDetailItemsFor(int pickfaceId, int palletLocationId)
{
this.FlushData();
PalletLocation pl = new PalletLocation();
pl.LoadByPrimaryKey(palletLocationId);
if (!pl.IsColumnNull("PalletID"))
{
string query = HCMIS.Repository.Queries.PickFace.SelectGetDetailItemsFor(pl.PalletID);
this.LoadFromRawSql(query);
}
return this.DataTable;
}
/// <summary>
/// Get dtail items for Pick face
/// </summary>
/// <param name="pickfaceId"></param>
/// <param name="palletLocationId"></param>
/// <returns></returns>
public DataTable GetDetailItemsFor(int pickfaceId, int palletLocationId)
{
this.FlushData();
PalletLocation pl = new PalletLocation();
pl.LoadByPrimaryKey(palletLocationId);
if (!pl.IsColumnNull("PalletID"))
{
string query = HCMIS.Repository.Queries.PickFace.SelectGetDetailItemsFor(pl.PalletID);
this.LoadFromRawSql(query);
}
return(this.DataTable);
}
/// <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();
}
public static PickListDetail GeneratePickListDetail(decimal pack, double?unitPrice, int receiveDocId, int manufacturerId,
int receivePalletId, int qtyPerPack, int activityId, int unitId,
int itemId, int picklistId, int palletId, string expireDate,
string batchNumber)
{
PalletLocation plocation = new PalletLocation();
PickListDetail pkDetail = new PickListDetail();
pkDetail.AddNew();
pkDetail.PickListID = picklistId;
pkDetail.ItemID = itemId;
PalletLocation palletLocation = new PalletLocation();
palletLocation.loadByPalletID(palletId);
pkDetail.PalletLocationID = palletLocation.ID;
pkDetail.BatchNumber = batchNumber;
if (expireDate != "")
{
pkDetail.ExpireDate = DateTime.Parse(expireDate);
}
pkDetail.StoreID = activityId;
pkDetail.UnitID = unitId;
pkDetail.ReceiveDocID = receiveDocId;
if (unitPrice != null)
{
pkDetail.Cost = Convert.ToDouble(pack) * Math.Round(unitPrice.Value, BLL.Settings.NoOfDigitsAfterTheDecimalPoint);
pkDetail.UnitPrice = Math.Round(unitPrice.Value, BLL.Settings.NoOfDigitsAfterTheDecimalPoint);
}
pkDetail.Packs = pack;
pkDetail.QtyPerPack = qtyPerPack;
pkDetail.QuantityInBU = pack * qtyPerPack;
pkDetail.StoreID = activityId;
pkDetail.ReceivePalletID = receivePalletId;
pkDetail.ManufacturerID = manufacturerId;
pkDetail.BoxLevel = 0;
pkDetail.DeliveryNote = true;
plocation.LoadByPrimaryKey(pkDetail.PalletLocationID);
pkDetail.PhysicalStoreID = plocation.PhysicalStoreID;
pkDetail.Save();
return(pkDetail);
}
public static PickListDetail GeneratePickListDetail(decimal pack, double? unitPrice, int receiveDocId, int manufacturerId,
int receivePalletId, int qtyPerPack, int activityId, int unitId,
int itemId, int picklistId, int palletId, string expireDate,
string batchNumber)
{
PalletLocation plocation = new PalletLocation();
PickListDetail pkDetail = new PickListDetail();
pkDetail.AddNew();
pkDetail.PickListID = picklistId;
pkDetail.ItemID = itemId;
PalletLocation palletLocation = new PalletLocation();
palletLocation.loadByPalletID(palletId);
pkDetail.PalletLocationID = palletLocation.ID;
pkDetail.BatchNumber = batchNumber;
if (expireDate != "")
pkDetail.ExpireDate = DateTime.Parse(expireDate);
pkDetail.StoreID = activityId;
pkDetail.UnitID = unitId;
pkDetail.ReceiveDocID = receiveDocId;
if (unitPrice != null)
{
pkDetail.Cost = Convert.ToDouble(pack) * Math.Round(unitPrice.Value, BLL.Settings.NoOfDigitsAfterTheDecimalPoint);
pkDetail.UnitPrice = Math.Round(unitPrice.Value, BLL.Settings.NoOfDigitsAfterTheDecimalPoint);
}
pkDetail.Packs = pack;
pkDetail.QtyPerPack = qtyPerPack;
pkDetail.QuantityInBU = pack * qtyPerPack;
pkDetail.StoreID = activityId;
pkDetail.ReceivePalletID = receivePalletId;
pkDetail.ManufacturerID = manufacturerId;
pkDetail.BoxLevel = 0;
pkDetail.DeliveryNote = true;
plocation.LoadByPrimaryKey(pkDetail.PalletLocationID);
pkDetail.PhysicalStoreID = plocation.PhysicalStoreID;
pkDetail.Save();
return pkDetail;
}
private void tsmSplit_Click(object sender, EventArgs e)
{
var pl = new PalletLocation();
prev = gridItemMovementView.FocusedValue;
if (gridItemMovementView.FocusedValue != null && prev != DBNull.Value && Convert.ToInt32(gridItemMovementView.FocusedValue)>0)
{
pl.LoadByPrimaryKey(Convert.ToInt32(gridItemMovementView.FocusedValue));
if (prev != DBNull.Value && !pl.IsColumnNull("PalletID"))
{
var sp = new SplitPallet();
sp.LoadPalletLocation(pl.PalletID, (int) lkRackID2.EditValue);
sp.ShowDialog();
lkRackID2_EditValueChanged(new object(), new EventArgs());
}
}
}
private void repositoryItemButtonEdit1_DoubleClick(object sender, EventArgs e)
{
Pallet pallet = new Pallet();
PalletLocation pl = new PalletLocation();
if (gridItemMovementView.FocusedValue != null )
{
prev = gridItemMovementView.FocusedValue;
pl.LoadByPrimaryKey(Convert.ToInt32(gridItemMovementView.FocusedValue));
if (!pl.IsColumnNull("PalletID"))
{
pallet.GetAllItemsInPallet(pl.PalletID);
gridControl2.DataSource = pallet.DefaultView;
pallet.GetAllItemsInPalletSKUTotal(pl.PalletID);
Label l = new Label();
l.Dock = DockStyle.Bottom;
XtraForm f = new XtraForm();
//gridControl2.Parent = null;
f.ShowInTaskbar = false;
f.Width = gridControl2.Width;
if (pallet.RowCount > 0 && !pallet.IsColumnNull("Total"))
{
l.Text = string.Format("Total SKU: {0}", pallet.GetColumn("Total").ToString());
}
else
{
l.Text = "Total SKU: 0";
}
f.Controls.Add(l);
pallet.LoadByPrimaryKey(pl.PalletID);
if (!pallet.IsColumnNull("PalletNo"))
{
f.Text = String.Format("Pallet Number: {0}", pallet.PalletNo);
}
f.Controls.Add(gridControl2);
f.StartPosition = FormStartPosition.CenterScreen;
f.ShowDialog();
}
}
}
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>
/// Moves the specified pick list ID.
/// </summary>
/// <param name="PickListID">The pick list ID.</param>
public static void Move(int PickListID)
{
DataView dv = GetTransferReportForStore();
PalletLocation pl = new PalletLocation();
foreach (DataRowView dr in dv)
{
int amount = Convert.ToInt32(dr["packs"]);
int palletLocationID = Convert.ToInt32(dr["PalletLocationID"]);
ReceivePallet rp = new ReceivePallet();
ReceiveDoc rdoc = new ReceiveDoc();
rp.LoadByPrimaryKey(Convert.ToInt32(dr["ReceivePalletID"]));
rdoc.LoadByPrimaryKey(rp.ReceiveID);
amount *= rdoc.QtyPerPack;
int qPalletLocationID = PalletLocation.GetTransferPalletLocation(Convert.ToInt32(dr["PhysicalStoreID"]));
pl.LoadByPrimaryKey(qPalletLocationID);
if (pl.IsColumnNull("PalletID"))
{
Pallet p = new Pallet();
p.AddNew();
p.StorageTypeID = Convert.ToInt32(StorageType.Quaranteen);
p.Save();
pl.PalletID = p.ID;
pl.Save();
}
ReceivePallet rp2 = new ReceivePallet();
ReceiveDoc rd = new ReceiveDoc();
rd.LoadByPrimaryKey(rp.ReceiveID);
rp2.AddNew();
rp2.PalletID = pl.PalletID;
rp2.ReceiveID = rp.ReceiveID;
// calculate the new balance
BLL.ItemManufacturer im = new BLL.ItemManufacturer();
//im.LoadDefaultReceiving(rd.ItemID, Convert.ToInt32(dr["ManufacturerID"]));
if (dr["BoxLevel"] == DBNull.Value)
{
dr["BoxLevel"] = 0;
}
im.LoadIMbyLevel(rd.ItemID, Convert.ToInt32(dr["ManufacturerID"]), Convert.ToInt32(dr["BoxLevel"]));
int packqty = (amount / im.QuantityInBasicUnit);
rp2.ReservedStock = 0;
rp.ReservedStock -= amount;
BLL.ReceivePallet.MoveBalance(rp, rp2, amount);
//rp2.Balance = amount;
//rp.Balance -= rp2.Balance;
//rp.Save();
//rp2.Save();
pl.Confirmed = false;
pl.Save();
if (rp.Balance == 0)
{
PalletLocation.GarbageCollection();
}
}
}
/// <summary>
/// Generate the pick list
/// </summary>
/// <param name="orderId">The order id.</param>
/// <param name="bgWorker">The bg worker.</param>
/// <returns></returns>
public DataView GetPalletLocationChoice(int userID, int orderId, BackgroundWorker bgWorker)
{
var order = new Order();
// Load the order
order.LoadByPrimaryKey(orderId);
//TODO: check if the order is already approved or not.
// if not please return from here
// Load the order details
var orderDetail = new OrderDetail();
orderDetail.LoadAllByOrderID(orderId);
orderDetail.AddColumn("ActivityConcat", typeof(string));
// prepare the pick list data table with the proper fields
_pickList = GetPickListTable();
_replenishmentList = new DataTable();
_replenishmentList.Columns.Add("ItemID", typeof(int));
_replenishmentList.Columns.Add("StoreID", typeof(int));
int count = 0;
// iterate through the order detail and make the pick list
while (!orderDetail.EOF)
{
DateTime startTime = DateTime.Now;
System.Console.WriteLine("Processing - " + orderDetail.ItemID);
// check if there are enough priced items of the same or more quantity in the store
int? unitID = null;
if (!orderDetail.IsColumnNull("UnitID"))
{
unitID = orderDetail.UnitID;
}
if (!orderDetail.IsColumnNull("StockedOut") && (!orderDetail.StockedOut ||(orderDetail.ApprovedQuantity > 0 && orderDetail.Quantity > orderDetail.ApprovedQuantity)))
{
DateTime? preferredExpiry = new DateTime();
if (orderDetail.IsColumnNull("PreferredManufacturerID"))
orderDetail.PreferredManufacturerID = -1;
if (orderDetail.IsColumnNull("PreferredPhysicalStoreID"))
orderDetail.PreferredPhysicalStoreID = -1;
if (orderDetail.IsColumnNull("PreferredExpiryDate"))
preferredExpiry = null;
else
{
preferredExpiry = orderDetail.PreferredExpiryDate;
}
if (!orderDetail.IsColumnNull("ApprovedQuantity") && (orderDetail.ApprovedQuantity > 0 && !orderDetail.IsColumnNull("StoreID")))
{
AddToPickListFor(userID, orderDetail.ID, orderDetail.ItemID, unitID, orderDetail.ApprovedQuantity, orderDetail.StoreID,
orderDetail.PreferredManufacturerID, orderDetail.PreferredPhysicalStoreID,
!orderDetail.IsColumnNull("DeliveryNote") && orderDetail.DeliveryNote,
preferredExpiry);
}
}
System.Console.WriteLine(string.Format("Took - {0}:{1} for Item ID = {2}", DateTime.Now.Subtract(startTime).Minutes, DateTime.Now.Subtract(startTime).Seconds, orderDetail.ItemID));
orderDetail.MoveNext();
count++;
bgWorker.ReportProgress(count, null);
}
// A quick hack just to show the pallet location on the order form
var pl = new PalletLocation();
var im = new ItemManufacturer();
foreach (DataRowView drv in _pickList.DefaultView)
{
int plid = Convert.ToInt32(drv["PalletLocationID"]);
pl.LoadByPrimaryKey(plid);
drv["PalletLocation"] = pl.FullName;
im.LoadIMbyLevel(Convert.ToInt32(drv["ItemID"]), Convert.ToInt32(drv["ManufacturerID"]),
Convert.ToInt32(drv["BoxLevel"]));
drv["QtyInSKU"] = im.RowCount > 0
? Convert.ToDecimal(drv["Pack"]) * im.QuantityInSku
: Convert.ToDecimal(drv["Pack"]);
drv["BoxSizeDisplay"] = im.RowCount > 0 ? im.LevelView2 : ""; //im.RightName;
drv["WarehouseName"] = pl.WarehouseName;
drv["PhysicalStoreName"] = pl.PhysicalStoreName;
var activity = new Activity();
activity.LoadByPrimaryKey(Convert.ToInt32(drv["StoreID"]));
drv["ActivityConcat"] = activity.FullActivityName;
drv["AccountName"] = activity.AccountName;
}
//foreach (DataRowView v in _pickList.DefaultView)
//{
//}
return _pickList.DefaultView;
}
/// <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();
}
internal static PickListDetail GeneratePickListDetail(ReceivePallet receivePallet, int pickListId,decimal qtyInBU)
{
ReceiveDoc receiveDoc = new ReceiveDoc();
receiveDoc.LoadByPrimaryKey(receivePallet.ReceiveID);
decimal pack = qtyInBU / Convert.ToDecimal(receiveDoc.QtyPerPack);
PickListDetail pkDetail = new PickListDetail();
pkDetail.AddNew();
pkDetail.PickListID = pickListId;
pkDetail.ItemID = receiveDoc.ItemID;
PalletLocation palletLocation = new PalletLocation();
palletLocation.loadByPalletID(receivePallet.PalletID);
int palletLocationId;
try
{
palletLocationId = palletLocation.ID;
}
catch (Exception exp)
{
palletLocationId = receivePallet.PalletLocationID;
palletLocation.LoadByPrimaryKey(palletLocationId);
}
pkDetail.PalletLocationID = palletLocationId;
if (!receiveDoc.IsColumnNull("BatchNo"))
pkDetail.BatchNumber = receiveDoc.BatchNo;
if (!receiveDoc.IsColumnNull("ExpDate"))
pkDetail.ExpireDate = receiveDoc.ExpDate;
pkDetail.StoreID = receiveDoc.StoreID;
pkDetail.UnitID = receiveDoc.UnitID;
pkDetail.ReceiveDocID = receiveDoc.ID;
if (!receiveDoc.IsColumnNull("Cost"))
{
pkDetail.Cost = Convert.ToDouble(pack) * Math.Round(receiveDoc.Cost, BLL.Settings.NoOfDigitsAfterTheDecimalPoint);
pkDetail.UnitPrice = Math.Round(receiveDoc.Cost, BLL.Settings.NoOfDigitsAfterTheDecimalPoint);
}
pkDetail.Packs = pack;
pkDetail.QtyPerPack = receiveDoc.QtyPerPack;
pkDetail.QuantityInBU = qtyInBU;
pkDetail.StoreID = receiveDoc.StoreID;
pkDetail.ReceivePalletID = receivePallet.ID;
pkDetail.ManufacturerID = receiveDoc.ManufacturerId;
pkDetail.BoxLevel = 0;
pkDetail.DeliveryNote = true;
pkDetail.PhysicalStoreID = palletLocation.PhysicalStoreID;
pkDetail.Save();
return pkDetail;
}
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();
}
}
private void btnMoveToQuaranteen_Click(object sender, EventArgs e)
{
if (ValidateMoveToQuaranteen())
{
if (DialogResult.Yes == XtraMessageBox.Show("Are you sure you want to move the items to Quarantine", "Confirmation", MessageBoxButtons.YesNo, MessageBoxIcon.Question))
{
InternalItemMovements ims = new InternalItemMovements();
PalletLocation pl = new PalletLocation();
int printNubmer = InternalTransfer.GetNewPrintNumber() + 1 ;
for (int i = 0; i < gridView3.RowCount; i++)
{
DataRow dr = gridView3.GetDataRow(i);
if (dr["Loss"] != DBNull.Value)
{
int amount = Convert.ToInt32(dr["Loss"]);
int palletLocationID = Convert.ToInt32(dr["PalletLocationID"]);
ReceivePallet rp = new ReceivePallet();
ReceiveDoc rdoc = new ReceiveDoc();
rp.LoadByPrimaryKey(Convert.ToInt32(dr["ReceivePalletID"]));
rdoc.LoadByPrimaryKey(rp.ReceiveID);
amount *= rdoc.QtyPerPack;
if (rp.Balance - amount < rp.ReservedStock)
{
//Item has been reserved for a facility. This needs to be handled.
DataTable dtble = rp.GetFacilitiesItemsReservedFor();
string facilities = "";
foreach(DataRow dRow in dtble.Rows)
{
if (dr != null)
facilities += dRow["Name"].ToString() + System.Environment.NewLine;
}
XtraMessageBox.Show("You cannot fill in a loss because the item in this location has been reserved to the following facilities:" + System.Environment.NewLine + facilities, "Exisiting reservations must be cancelled", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
return;
}
var receiveDocID = Convert.ToInt32(dr["ID"]);
var rec = new ReceiveDoc();
rec.LoadByPrimaryKey(receiveDocID);
int qPalletLocationID = PalletLocation.GetQuaranteenPalletLocation(rec.PhysicalStoreID);
pl.LoadByPrimaryKey(qPalletLocationID);
if (pl.IsColumnNull("PalletID"))
{
Pallet p = new Pallet();
p.AddNew();
p.StorageTypeID = Convert.ToInt32( StorageType.Quaranteen);
p.Save();
pl.PalletID = p.ID;
pl.Save();
}
ReceivePallet rp2 = new ReceivePallet();
ReceiveDoc rd = new ReceiveDoc();
rd.LoadByPrimaryKey(rp.ReceiveID);
rp2.AddNew();
rp2.PalletID = pl.PalletID;
rp2.ReceiveID = rp.ReceiveID;
rp2.PalletLocationID = pl.ID;
// calculate the new balance
BLL.ItemManufacturer im = new BLL.ItemManufacturer();
//im.LoadDefaultReceiving(rd.ItemID, Convert.ToInt32(dr["ManufacturerID"]));
if (dr["BoxLevel"] == DBNull.Value)
{
dr["BoxLevel"] = 0;
}
im.LoadIMbyLevel(rd.ItemID, Convert.ToInt32(dr["ManufacturerID"]), Convert.ToInt32(dr["BoxLevel"]));
int packqty = (amount / im.QuantityInBasicUnit);
rp2.ReservedStock = 0;
BLL.ReceivePallet.MoveBalance(rp, rp2, amount);
//rp2.Balance = amount;
//rp.Balance -= rp2.Balance;
//rp.Save();
//rp2.Save();
pl.Confirmed = false;
pl.Save();
if (rp.Balance == 0 )
{
PalletLocation.GarbageCollection();
}
InternalTransfer it = new InternalTransfer();
it.AddNew();
it.ItemID = rd.ItemID;
it.BoxLevel = im.PackageLevel;
if (!rd.IsColumnNull("ExpDate"))
{
it.ExpireDate = rd.ExpDate;
}
it.BatchNumber = rd.BatchNo;
it.ManufacturerID = im.ManufacturerID;
it.FromPalletLocationID = palletLocationID;
it.ToPalletLocationID = qPalletLocationID;
it.QtyPerPack = im.QuantityInBasicUnit;
it.Packs = packqty;
it.ReceiveDocID = rp.ReceiveID;
it.QuantityInBU = rp2.Balance; //it.Packs * it.QtyPerPack;
it.Type = "ToQuaranteen";
it.IssuedDate = DateTime.Today;
it.Status = 0;
it.PrintNumber = printNubmer;
it.Save();
}
}
gridConfirmationControl.DataSource = InternalTransfer.GetAllTransfers("ToQuaranteen");
PopulateItemDetails();
XtraMessageBox.Show("Your items are marked for movement to Quarantine, please go to Internal Movements page to confirm!", "Success", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
}
private void btnCommit_Click(object sender, EventArgs e)
{
if (ValidateQuarantine())
{
MyGeneration.dOOdads.TransactionMgr transaction = MyGeneration.dOOdads.TransactionMgr.ThreadTransactionMgr();
transaction.BeginTransaction();
if (DialogResult.Yes == XtraMessageBox.Show("Are you sure you want to commit the Loss and Adjustment on this screen?", "Confirmation", MessageBoxButtons.YesNo, MessageBoxIcon.Question))
{
// do the actual commit here.
int printNubmer = InternalTransfer.GetNewPrintNumber() + 1;
PalletLocation pl = new PalletLocation();
Pallet p = new Pallet();
ReceiveDoc rdoc = new ReceiveDoc();
ReceivePallet rp = new ReceivePallet();
for (int i = 0; i < gridView1.RowCount; i++)
{
DataRow dr = gridView1.GetDataRow(i);
Double writeoff = 0;
Double reLocate = 0;
try
{
if (dr["WriteOff"] != DBNull.Value)
{
writeoff = Double.Parse(dr["WriteOff"].ToString());
}
if (dr["ReLocate"] != DBNull.Value)
{
reLocate = Double.Parse(dr["ReLocate"].ToString());
}
}
catch (Exception exc)
{
}
if(dr["WriteOff"] != DBNull.Value & writeoff>0)
{
if (Double.Parse(dr["WriteOff"].ToString()) > Double.Parse(dr["Balance"].ToString()))
{
XtraMessageBox.Show("Couldn't commit to the numbers you specified. Please specify number less than the balance.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
int writeoffAmout = Convert.ToInt32(dr["WriteOff"]);
int qtyPerPack = Convert.ToInt32(dr["QtyPerPack"]);
writeoffAmout *= qtyPerPack;
rp.LoadByPrimaryKey(Convert.ToInt32(dr["ReceivePalletID"]));
rdoc.LoadByPrimaryKey(rp.ReceiveID);
string x = dr["NewPalletLocation"].ToString();
rp.Balance -= writeoffAmout;
try
{
// rp.ReceivedQuantity -= writeoffAmout;
}
catch { }
rdoc.QuantityLeft -= writeoffAmout;
ReceivePallet nrp =new ReceivePallet();
nrp.AddNew();
nrp.ReceiveID = rp.ReceiveID;
nrp.PalletID = pl.GetpalletidbyPalletLocationOrgetnew(int.Parse(dr["NewPalletLocation"].ToString()));
//nrp.ReceivedQuantity = rp.ReceivedQuantity;
nrp.Balance = writeoffAmout;
nrp.ReservedStock = 0;
//nrp.ReserveOrderID = rp.ReserveOrderID;
nrp.BoxSize = rp.BoxSize;
nrp.PalletLocationID = int.Parse(dr["NewPalletLocation"].ToString());
nrp.IsOriginalReceive = rp.IsOriginalReceive;
BLL.LossAndAdjustment d = new BLL.LossAndAdjustment();
d.AddNew();
d.GenerateRefNo();
d.ItemID = Convert.ToInt32(dr["ItemID"]);
d.ReasonId = Convert.ToInt32(dr["Reason"]);
d.RecID = rdoc.ID;
d.Quantity = writeoffAmout;
d.BatchNo = rdoc.BatchNo;
CalendarLib.DateTimePickerEx edate = new CalendarLib.DateTimePickerEx();
edate.Value = DateTime.Today;
//TODO: fix to an ethiopian date here
edate.CustomFormat = "MM/dd/yyyy";
d.Date = ConvertDate.DateConverter(edate.Text);
d.EurDate = DateTime.Today;
d.Cost = rdoc.IsColumnNull("Cost")? 0: Math.Abs(rdoc.Cost * writeoffAmout);
d.StoreId = rdoc.StoreID;
d.Losses = true;
//todo:
d.ApprovedBy = CurrentContext.UserId.ToString();
//d.Remarks
InternalTransfer it =new InternalTransfer();
it.AddNew();
it.ItemID = d.ItemID;
it.FromPalletLocationID = pl.GetPalletLocationIDByPalletID(int.Parse(dr["PalletID"].ToString()));
it.ToPalletLocationID = nrp.PalletLocationID;
it.BatchNumber = d.BatchNo;
if (!rdoc.IsColumnNull("ExpDate"))
{
it.ExpireDate = rdoc.ExpDate;
}
it.ReceiveDocID = rdoc.ID;
it.ManufacturerID = rdoc.ManufacturerId;
it.QtyPerPack = Convert.ToInt32(dr["QtyPerPack"]);
it.Packs = rdoc.NoOfPack;
it.QuantityInBU = nrp.Balance;
LossAndAdjustmentReason r = new LossAndAdjustmentReason();
it.Type = r.GetReasonByID(d.ReasonId);
// d.Save();
rdoc.Save();
rp.Save();
rdoc.QuantityLeft += writeoffAmout;
rdoc.Save();
nrp.Save();
it.Save();
int xs = it.ID;
}
else if (dr["ReLocate"] != DBNull.Value & reLocate > 0)
{
if (dr["ReLocate"] != DBNull.Value)
{
int amount = Convert.ToInt32(dr["ReLocate"]);
int qtyPerPack = Convert.ToInt32(dr["QtyPerPack"]);
amount *= qtyPerPack;
rp.LoadByPrimaryKey(Convert.ToInt32(dr["ReceivePalletID"]));
rdoc.LoadByPrimaryKey(rp.ReceiveID);
int palletLocationID = Convert.ToInt32(dr["PalletLocationID"]);
int qPalletLocationID =
PalletLocation.GetQuaranteenPalletLocationByPalletLocationID(palletLocationID);//PalletLocation.GetQuaranteenPalletLocation(Convert.ToInt32(dr["ID"]));
pl.LoadByPrimaryKey(qPalletLocationID);
ReceivePallet rp2 = new ReceivePallet();
ReceiveDoc rd = new ReceiveDoc();
Pallet pallet = new Pallet();
rp.LoadByPrimaryKey(Convert.ToInt32(dr["ReceivePalletID"]));
rd.LoadByPrimaryKey(rp.ReceiveID);
pallet.AddNew();
Item item = new Item();
item.LoadByPrimaryKey(rdoc.ItemID);
if (item.StorageTypeID.ToString() == StorageType.BulkStore)
{
pallet.PalletNo = Pallet.GetLastPanelNumber();
}
pallet.Save();
rp2.AddNew();
rp2.PalletID = pl.GetpalletidbyPalletLocationOrgetnew(int.Parse(dr["NewPalletLocation"].ToString()));//pallet.ID;
rp2.ReceiveID = rp.ReceiveID;
rp2.IsOriginalReceive = rp.IsOriginalReceive;
// calculate the new balance
BLL.ItemManufacturer im = new BLL.ItemManufacturer();
//im.LoadDefaultReceiving(rd.ItemID, Convert.ToInt32(dr["ManufacturerID"]));
//im.LoadIMbyLevel(rd.ItemID, Convert.ToInt32(dr["ManufacturerID"]), Convert.ToInt32(dr["BoxLevel"]));
//int packqty = (amount / im.QuantityInBasicUnit);
rd.QuantityLeft -= amount;
rp.Balance -= amount;
rd.Save();
rp.Save();
rd.QuantityLeft += amount;
rp2.Balance = amount;//packqty * im.QuantityInBasicUnit;
rd.Save();
rp2.BoxSize = rp.BoxSize;
rp2.ReservedStock = 0;
rp2.PalletLocationID= int.Parse(dr["NewPalletLocation"].ToString());
rp2.Save();
pl.Confirmed = false;
pl.Save();
// select the new pallet location here.
/* XtraForm xdb = new XtraForm();
xdb.Controls.Add(panelControl2);
Item itms= new Item();
itms.GetItemByPrimaryKey(Convert.ToInt32(dr["ItemID"]));
lblItemName.Text = itms.FullItemName;
panelControl2.Visible = true;
panelControl2.Dock = DockStyle.Fill;
xdb.Text = "Select Location for relocated Item";
lkLocation.Properties.DataSource = PalletLocation.GetAllFreeFor(Convert.ToInt32(dr["ItemID"]));
xdb.ShowDialog();
PalletLocation pl2 = new PalletLocation();
pl2.LoadByPrimaryKey(Convert.ToInt32(lkLocation.EditValue));
pl2.PalletID = pallet.ID;
pl2.Confirmed = false;
pl2.Save();
*/
InternalTransfer it = new InternalTransfer();
it.AddNew();
it.ItemID = rd.ItemID;
it.BoxLevel = 0;// im.PackageLevel;
//it.ExpireDate = rd.ExpDate;
if (!rd.IsColumnNull("ExpDate"))
{
it.ExpireDate = rd.ExpDate;
}
it.BatchNumber = rd.BatchNo;
it.ManufacturerID = Convert.ToInt32(dr["ManufacturerID"]);//im.ManufacturerID;
it.FromPalletLocationID = qPalletLocationID;
it.ToPalletLocationID = int.Parse(dr["NewPalletLocation"].ToString()); //pl2.ID;
it.QtyPerPack = 1;
//it.Packs = pack qty;
it.ReceiveDocID = rp.ReceiveID;
it.QuantityInBU = amount;// it.QtyPerPack;
it.Type = "ReLocation";
it.IssuedDate = DateTime.Today;
it.Status = 0;
it.PrintNumber = printNubmer;
it.Save();
}
}
}
transaction.CommitTransaction();
BindQuarantine();
XtraMessageBox.Show("Quarantine Write off/Adjustment was commitd.", "Success", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
}
/// <summary>
/// Saves the pallet locations in shelf.
/// </summary>
/// <param name="rows">The rows.</param>
/// <param name="cols">The cols.</param>
public void SavePalletLocationsInShelf(int rows, int cols)
{
// preserve the id of this shelf
int id = this.ID;
ShelfRowColumn src = new ShelfRowColumn();
// check if the existing rows are null;
if (this.IsColumnNull("Rows")) this.Rows = 0;
if (this.IsColumnNull("Columns")) this.Columns = 0;
this.Save();
bool isColumnsChanged = (this.Columns != cols);
bool isRowsChanged = (this.Rows != rows);
PalletLocation pl = new PalletLocation();
// Fix the row and columns if there are any new additions
for (int i = this.Columns; i < cols; i++)
{
src.AddNew();
src.ShelfID = id;
src.Type = "Column";
src.Index = i;
src.Label = (i + 1).ToString();
src.Save();
}
for (int i = this.Rows; i < rows; i++)
{
src.AddNew();
src.ShelfID = id;
src.Type = "Row";
src.Index = i;
src.Label = getChar(i).ToString();
src.Save();
}
if (rows > this.Rows)
{
for (int i = this.Rows; i < rows; i++)
{
for (int j = 0; j < cols; j++)
{
pl.AddNew();
pl.Column = j;
pl.Row = i;
pl.StorageTypeID = this.ShelfStorageType;
pl.ShelfID = id;
pl.LoadLabel();
pl.IsFullSize = true;
pl.IsExtended = false;
pl.IsEnabled = true;
pl.Width = this.Width;
pl.Height = 1;
pl.Length = 1;
pl.AvailableVolume = 0;
pl.UsedVolume = 0;
pl.Save();
}
}
}
else if (rows < this.Rows)
{
this.LoadFromRawSql(HCMIS.Repository.Queries.Shelf.DeleteSavePalletLocationsInShelf(rows, id));
this.LoadFromRawSql(HCMIS.Repository.Queries.Shelf.DeleteShelfRowColumnSavePalletLocationsInShelf(rows, id));
}
// if we have lost it for //rows < this.Rows
this.LoadByPrimaryKey(id);
if (cols > this.Columns)
{
for (int i = this.Columns; i < cols; i++)
{
for (int j = 0; j < this.Rows; j++)
{
{
pl.AddNew();
pl.Column = i;
pl.Row = j;
pl.StorageTypeID = this.ShelfStorageType;
pl.ShelfID = id;
pl.LoadLabel();
pl.IsFullSize = true;
pl.IsExtended = false;
pl.IsEnabled = true;
pl.Width = this.Width;
pl.Height = 1;
pl.Length = 1;
pl.AvailableVolume = 0;
pl.UsedVolume = 0;
pl.Save();
}
}
}
}
else if (cols < this.Columns)
{
this.LoadFromRawSql(HCMIS.Repository.Queries.Shelf.DeletePalletLocationSavePalletLocationsInShelf(cols, id));
this.LoadFromRawSql(HCMIS.Repository.Queries.Shelf.DeleteFromShelfRowColumnSavePalletLocationsInShelf(cols, id));
}
this.FlushData();
this.LoadByPrimaryKey(id);
this.Rows = rows;
this.Columns = cols;
this.Save();
if (isColumnsChanged)
{
FixLengthOfPalletLocations();
}
if (isRowsChanged)
{
FixHeightOfPalletLocations();
}
// make the approprait entry in the pick list locations
if (this.ShelfStorageType.ToString() == StorageType.PickFace)
{
PickFace.FixPickFaceEntries();
}
FixVolume();
//Find all Shelf pallet locations
Shelf shelf = new Shelf();
shelf.LoadFromRawSql(HCMIS.Repository.Queries.Shelf.SelectSavePalletLocationsInShelf(id));
while (!shelf.EOF)
{
PalletLocation plc = new PalletLocation();
plc.LoadByPrimaryKey(shelf.ID);
plc.Label = string.Format("{0}-{1}-{2}", this.ShelfCode, plc.Column + 1, getChar(plc.Row));
plc.Save();
shelf.MoveNext();
}
}
private void SaveOrder()
{
var order = GenerateOrder();
var picklist = PickList.GeneratePickList(order.ID);
int lineNo = 0;
// This is a kind of initializing the data table.
OrderDetail ord = new OrderDetail();
PickListDetail pkDetail = new PickListDetail();
DataView dv = orderGrid.DataSource as DataView;
foreach (DataRowView r in dv)
{
if (r["ApprovedPacks"] != null && r["ApprovedPacks"] != DBNull.Value && r["ApprovedPacks"].ToString()!= "")
if (Convert.ToInt32(r["ApprovedPacks"]) != 0)
{
lineNo = lineNo + 1;
int itemID = Convert.ToInt32(r["ItemID"]);
int unitID = Convert.ToInt32(r["UnitID"]);
ord.AddNew();
ord.OrderID = order.ID;
ord.ItemID = itemID;
if (r["ApprovedPacks"] != DBNull.Value)
{
ord.Pack = Convert.ToInt32(r["ApprovedPacks"]);
}
if (r["QtyPerPack"] != DBNull.Value)
{
ord.QtyPerPack = Convert.ToInt32(r["QtyPerPack"]);
}
ord.Quantity = Convert.ToInt32(r["ApprovedPacks"]) * Convert.ToInt32(r["QtyPerPack"]);
ord.ApprovedQuantity = Convert.ToInt32(r["ApprovedPacks"]) * Convert.ToInt32(r["QtyPerPack"]);
ord.UnitID = unitID;
ord.StoreID = Convert.ToInt32(lkAccountType.EditValue);
ord.Save();
pkDetail.AddNew();
pkDetail.PickListID = picklist.ID;
pkDetail.ItemID = itemID;
pkDetail.PalletLocationID = Convert.ToInt32(r["LocationID"]);
pkDetail.BatchNumber = r["BatchNo"].ToString();
if (r["ExpDate"] != DBNull.Value)
pkDetail.ExpireDate = DateTime.Parse(r["ExpDate"].ToString());
pkDetail.StoreID = Convert.ToInt32(r["StoreID"]);
pkDetail.UnitID = unitID;
pkDetail.ReceiveDocID = Convert.ToInt32(r["ReceiveDocID"]);
if (r["UnitPrice"] != DBNull.Value)
{
pkDetail.Cost = Convert.ToInt32(r["ApprovedPacks"]) * Convert.ToDouble(r["UnitPrice"]);
pkDetail.UnitPrice = Convert.ToDouble(r["UnitPrice"]);
}
pkDetail.Packs = Convert.ToInt32(r["ApprovedPacks"]);
pkDetail.QtyPerPack = Convert.ToInt32(r["QtyPerPack"]);
pkDetail.QuantityInBU = Convert.ToInt32(r["ApprovedPacks"]) * Convert.ToInt32(r["QtyPerPack"]);
pkDetail.StoreID = Convert.ToInt32(r["StoreID"]);
pkDetail.ReceivePalletID = Convert.ToInt32(r["ReceivingLocationID"]);
pkDetail.ManufacturerID = Convert.ToInt32(r["ManufacturerID"]);
pkDetail.BoxLevel = 0;
pkDetail.DeliveryNote = true;
pkDetail.Save();
//To Print The Picklist
//Then reserve Items
ReceivePallet receivepallet = new ReceivePallet();
receivepallet.LoadByPrimaryKey(Convert.ToInt32(r["ReceivingLocationID"]));
receivepallet.ReservedStock = receivepallet.ReservedStock + Convert.ToInt32(r["ApprovedPacks"]);
receivepallet.Save();
DataRow drvpl = dvPickList.NewRow();
drvpl["FullItemName"] = r["FullItemName"];
drvpl["StockCode"] = r["StockCode"];
drvpl["BatchNo"] = r["BatchNo"];
if (r["ExpDate"] != DBNull.Value)
drvpl["ExpDate"] = Convert.ToDateTime(r["ExpDate"]).ToString("MMM/yyyy");
else
drvpl["ExpDate"] = DBNull.Value;
drvpl["LineNum"] = lineNo + 1;
drvpl["ManufacturerName"] = r["Manufacturer"];
drvpl["Pack"] = r["ApprovedPacks"];
drvpl["UnitPrice"] = r["UnitPrice"];
drvpl["Unit"] = r["Unit"];
drvpl["PalletLocation"] = r["Location"];
drvpl["QtyInSKU"] = Convert.ToInt32(r["ApprovedPacks"]);
if (r["UnitPrice"] != DBNull.Value)
drvpl["CalculatedCost"] = Convert.ToInt32(r["ApprovedPacks"]) * Convert.ToDouble(r["UnitPrice"]);
PalletLocation palletLocation = new PalletLocation();
palletLocation.LoadByPrimaryKey(pkDetail.PalletLocationID);
drvpl["WarehouseName"] = palletLocation.WarehouseName;
drvpl["PhysicalStoreName"] = palletLocation.PhysicalStoreName;
var activity = new Activity();
activity.LoadByPrimaryKey(pkDetail.StoreID);
drvpl["ActivityConcat"] = activity.FullActivityName;
drvpl["AccountName"] = activity.AccountName;
dvPickList.Rows.Add(drvpl);
}
}
if (lineNo == 0)
throw new System.ArgumentException("Please review your list,you haven't approved any Quantity");
var plr = HCMIS.Desktop.Reports.WorkflowReportFactory.CreatePicklistReport(order, lkForHub.Text,
dvPickList.DefaultView);
plr.PrintDialog();
if (!BLL.Settings.IsCenter)
{
if (TransferTypeID == 3)
{
XtraMessageBox.Show("Your Store To Store Transfer will be Printed now", "Store To Store Transfer");
Transfer.Move(picklist.ID);
HCMIS.Desktop.Reports.StoreTransferPrintOut STM =
new HCMIS.Desktop.Reports.StoreTransferPrintOut();
STM.LoadByPickListID(picklist.ID);
STM.PrintDialog();
}
else if (TransferTypeID == 2)
{
XtraMessageBox.Show(ReceiveDoc.ReceiveFromAccountTransfer(picklist.ID,
Convert.ToInt32(lkForHub.EditValue),
CurrentContext.LoggedInUserName,
CurrentContext.UserId));
}
}
else
{
XtraMessageBox.Show("Picklist Prepared!", "Successful", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Moves the specified pick list ID.
/// </summary>
/// <param name="PickListID">The pick list ID.</param>
public static void Move(int PickListID)
{
DataView dv = GetTransferReportForStore();
PalletLocation pl = new PalletLocation();
foreach (DataRowView dr in dv)
{
int amount = Convert.ToInt32(dr["packs"]);
int palletLocationID = Convert.ToInt32(dr["PalletLocationID"]);
ReceivePallet rp = new ReceivePallet();
ReceiveDoc rdoc = new ReceiveDoc();
rp.LoadByPrimaryKey(Convert.ToInt32(dr["ReceivePalletID"]));
rdoc.LoadByPrimaryKey(rp.ReceiveID);
amount *= rdoc.QtyPerPack;
int qPalletLocationID = PalletLocation.GetTransferPalletLocation(Convert.ToInt32(dr["PhysicalStoreID"]));
pl.LoadByPrimaryKey(qPalletLocationID);
if (pl.IsColumnNull("PalletID"))
{
Pallet p = new Pallet();
p.AddNew();
p.StorageTypeID = Convert.ToInt32(StorageType.Quaranteen);
p.Save();
pl.PalletID = p.ID;
pl.Save();
}
ReceivePallet rp2 = new ReceivePallet();
ReceiveDoc rd = new ReceiveDoc();
rd.LoadByPrimaryKey(rp.ReceiveID);
rp2.AddNew();
rp2.PalletID = pl.PalletID;
rp2.ReceiveID = rp.ReceiveID;
// calculate the new balance
BLL.ItemManufacturer im = new BLL.ItemManufacturer();
//im.LoadDefaultReceiving(rd.ItemID, Convert.ToInt32(dr["ManufacturerID"]));
if (dr["BoxLevel"] == DBNull.Value)
{
dr["BoxLevel"] = 0;
}
im.LoadIMbyLevel(rd.ItemID, Convert.ToInt32(dr["ManufacturerID"]), Convert.ToInt32(dr["BoxLevel"]));
int packqty = (amount / im.QuantityInBasicUnit);
rp2.ReservedStock = 0;
rp.ReservedStock -= amount;
BLL.ReceivePallet.MoveBalance(rp, rp2, amount);
//rp2.Balance = amount;
//rp.Balance -= rp2.Balance;
//rp.Save();
//rp2.Save();
pl.Confirmed = false;
pl.Save();
if (rp.Balance == 0)
{
PalletLocation.GarbageCollection();
}
}
}
private void btnRelocatePallet_Click(object sender, EventArgs e)
{
//Get the chosen pallet Location
BLL.PalletLocation palletLocation = new BLL.PalletLocation();
palletLocation.LoadByPrimaryKey(Convert.ToInt16(lkAvailablePalletLocation.EditValue));
//Get the chosen misplaced receivepallet entry
DataRow dr = grdViewMisplacedItems.GetFocusedDataRow();
int receivePalletID = Convert.ToInt32(dr["ID"]);
BLL.ReceivePallet rp = new BLL.ReceivePallet();
rp.LoadByPrimaryKey(receivePalletID);
if (palletLocation.IsColumnNull("PalletID"))
{
palletLocation.PalletID = rp.PalletID;
palletLocation.Save();
}
else
{
rp.PalletID = palletLocation.PalletID;
rp.Save();
}
int storeID = Convert.ToInt16(lkStoreLocation.EditValue);
LoadMisplacedItems(storeID);
XtraMessageBox.Show("Placed!!");
}
/// <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>
/// 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();
}
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);
}
}
}
private void BtnMovePalletClick(object sender, EventArgs e)
{
DataRow dr = gridPalletMovementView.GetFocusedDataRow();
if (dr != null)
{
PalletLocation pl = new PalletLocation();
pl.LoadByPrimaryKey(Convert.ToInt32(dr["FromID"]));
PalletLocation pl2 = new PalletLocation();
pl2.LoadByPrimaryKey(Convert.ToInt32(dr["ToID"]));
if (pl2.IsColumnNull("PalletID"))
{
pl2.PalletID = pl.PalletID;
pl.SetColumnNull("PalletID");
pl2.Save();
pl.Save();
XtraMessageBox.Show("The pallet Movement is confirmed!", "Confirmation", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
BindPalletMovement();
}
}
/// <summary>
/// Saves the pallet locations in shelf.
/// </summary>
/// <param name="rows">The rows.</param>
/// <param name="cols">The cols.</param>
public void SavePalletLocationsInShelf(int rows, int cols)
{
// preserve the id of this shelf
int id = this.ID;
ShelfRowColumn src = new ShelfRowColumn();
// check if the existing rows are null;
if (this.IsColumnNull("Rows"))
{
this.Rows = 0;
}
if (this.IsColumnNull("Columns"))
{
this.Columns = 0;
}
this.Save();
bool isColumnsChanged = (this.Columns != cols);
bool isRowsChanged = (this.Rows != rows);
PalletLocation pl = new PalletLocation();
// Fix the row and columns if there are any new additions
for (int i = this.Columns; i < cols; i++)
{
src.AddNew();
src.ShelfID = id;
src.Type = "Column";
src.Index = i;
src.Label = (i + 1).ToString();
src.Save();
}
for (int i = this.Rows; i < rows; i++)
{
src.AddNew();
src.ShelfID = id;
src.Type = "Row";
src.Index = i;
src.Label = getChar(i).ToString();
src.Save();
}
if (rows > this.Rows)
{
for (int i = this.Rows; i < rows; i++)
{
for (int j = 0; j < cols; j++)
{
pl.AddNew();
pl.Column = j;
pl.Row = i;
pl.StorageTypeID = this.ShelfStorageType;
pl.ShelfID = id;
pl.LoadLabel();
pl.IsFullSize = true;
pl.IsExtended = false;
pl.IsEnabled = true;
pl.Width = this.Width;
pl.Height = 1;
pl.Length = 1;
pl.AvailableVolume = 0;
pl.UsedVolume = 0;
pl.Save();
}
}
}
else if (rows < this.Rows)
{
this.LoadFromRawSql(HCMIS.Repository.Queries.Shelf.DeleteSavePalletLocationsInShelf(rows, id));
this.LoadFromRawSql(HCMIS.Repository.Queries.Shelf.DeleteShelfRowColumnSavePalletLocationsInShelf(rows, id));
}
// if we have lost it for //rows < this.Rows
this.LoadByPrimaryKey(id);
if (cols > this.Columns)
{
for (int i = this.Columns; i < cols; i++)
{
for (int j = 0; j < this.Rows; j++)
{
{
pl.AddNew();
pl.Column = i;
pl.Row = j;
pl.StorageTypeID = this.ShelfStorageType;
pl.ShelfID = id;
pl.LoadLabel();
pl.IsFullSize = true;
pl.IsExtended = false;
pl.IsEnabled = true;
pl.Width = this.Width;
pl.Height = 1;
pl.Length = 1;
pl.AvailableVolume = 0;
pl.UsedVolume = 0;
pl.Save();
}
}
}
}
else if (cols < this.Columns)
{
this.LoadFromRawSql(HCMIS.Repository.Queries.Shelf.DeletePalletLocationSavePalletLocationsInShelf(cols, id));
this.LoadFromRawSql(HCMIS.Repository.Queries.Shelf.DeleteFromShelfRowColumnSavePalletLocationsInShelf(cols, id));
}
this.FlushData();
this.LoadByPrimaryKey(id);
this.Rows = rows;
this.Columns = cols;
this.Save();
if (isColumnsChanged)
{
FixLengthOfPalletLocations();
}
if (isRowsChanged)
{
FixHeightOfPalletLocations();
}
// make the approprait entry in the pick list locations
if (this.ShelfStorageType.ToString() == StorageType.PickFace)
{
PickFace.FixPickFaceEntries();
}
FixVolume();
//Find all Shelf pallet locations
Shelf shelf = new Shelf();
shelf.LoadFromRawSql(HCMIS.Repository.Queries.Shelf.SelectSavePalletLocationsInShelf(id));
while (!shelf.EOF)
{
PalletLocation plc = new PalletLocation();
plc.LoadByPrimaryKey(shelf.ID);
plc.Label = string.Format("{0}-{1}-{2}", this.ShelfCode, plc.Column + 1, getChar(plc.Row));
plc.Save();
shelf.MoveNext();
}
}
private void ReturnToStoreForQuantityEdit()
{
//TODO: finish updating the changed locations
MyGeneration.dOOdads.TransactionMgr transaction = MyGeneration.dOOdads.TransactionMgr.ThreadTransactionMgr();
transaction.BeginTransaction();
try
{
PalletLocation pl = new PalletLocation();
String reference = gridReceiveView.GetFocusedDataRow()["RefNo"].ToString();
// pl.ConfirmAllReceived(reference);
if (gridDetailView.DataSource == null)
return;
foreach (DataRowView drv in gridDetailView.DataSource as DataView)
{
int PalletLocationID = Convert.ToInt32(drv["PalletLocationID"]);
int ProposedPalletLocationID = Convert.ToInt32(drv["ProposedPalletLocationID"]);
int PalletID = Convert.ToInt32(drv["PalletID"]);
int receiveID = Convert.ToInt32(drv["ReceiveID"]);
if (PalletLocationID != ProposedPalletLocationID)
{
pl.LoadByPrimaryKey(PalletLocationID);
if (pl.IsColumnNull("PalletID"))
{
pl.Confirmed = false;
pl.Save();
}
}
else
{
pl.LoadByPrimaryKey(PalletLocationID);
pl.Confirmed = false;
pl.Save();
}
}
BLL.ReceiveDoc recDoc = new ReceiveDoc();
recDoc.LoadByReferenceNo(reference);
recDoc.SetStatusAsReceived(null);
transaction.CommitTransaction();
XtraMessageBox.Show("Receipt Returned!", "Success", System.Windows.Forms.MessageBoxButtons.OK, System.Windows.Forms.MessageBoxIcon.Information);
BindFormContents();
}
catch (Exception exp)
{
transaction.RollbackTransaction();
XtraMessageBox.Show(exp.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
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");
}
}
private void btnConsolidate_Click(object sender, EventArgs e)
{
DataRow dr = gridView4.GetFocusedDataRow();
if (dr != null)
{
if (DialogResult.Yes == XtraMessageBox.Show("Are you sure you want to consolidate the two pallets? you will not be able to undo this change.", "Confirmation", MessageBoxButtons.YesNo, MessageBoxIcon.Question))
{
DataRow dr2 = gridView3.GetFocusedDataRow();
PalletLocation pl = new PalletLocation();
pl.LoadByPrimaryKey( Convert.ToInt32(dr2["ID"]) );
int sourcePalletID = pl.PalletID;
pl.LoadByPrimaryKey(Convert.ToInt32(dr["ID"]));
int destinationPalletID = pl.PalletID;
ReceivePallet rp = new ReceivePallet();
rp.Consolidate(sourcePalletID, destinationPalletID);
pl.LoadByPrimaryKey(Convert.ToInt32(dr2["ID"]));
pl.SetColumnNull("PalletID");
pl.Save();
XtraMessageBox.Show("Items Consolidated.", "Items Consolidated");
gridView5_RowClick(null, null);
}
}
}
private bool IsPutawayValid()
{
// Check if there is any Empty Put away location
Dictionary<int, string> keyed = new Dictionary<int, string>();
Boolean isValid = true;
// Validate Non Palletized locations
foreach (DataRow dr in _dtPutAwayNonPalletized.Rows)
{
dr.ClearErrors();
if (dr["PutAwayLocation"] == null || dr["PutAwayLocation"].ToString() == "")
{
dr.SetColumnError("PutAwayLocation", "Cannot be null");
isValid = false;
}
if (dr["Palletized Quantity"] == null || dr["Palletized Quantity"].ToString() == "")
{
dr.SetColumnError("Palletized Quantity", "Cannot be null");
isValid = false;
}
}
//validate Palletized putaway
foreach (DataRow dr in _dtPutAwayPalletized.Rows)
{
dr.ClearErrors();
if (dr["PutAwayLocation"] == null)
{
dr.SetColumnError("PutAwayLocation", "Cannot be null");
isValid = false;
}
else
{
//If it is not free, different pallets cannot be put on the same location.
int putAwayLocation = int.Parse(dr["PutAwayLocation"].ToString());
BLL.PalletLocation pl = new PalletLocation();
pl.LoadByPrimaryKey(putAwayLocation);
BLL.Shelf shelf = new Shelf();
shelf.LoadByPrimaryKey(pl.ShelfID);
if (shelf.ShelfStorageType.ToString() != BLL.StorageType.Free)
{
try
{
keyed.Add(Convert.ToInt32(dr["PutAwayLocation"]), "");
}
catch
{
dr.SetColumnError("PutAwayLocation", "Different Pallets put on the same Location");
isValid = false;
}
}
else
{
////If the location type is free. We allow consolidation
DataRow[] rows =
_dtPalletizedItemList.Select(string.Format("PalletNumber={0}", dr["PalletNumber"].ToString()));
foreach (DataRow row in rows)
{
row["Consolidate"] = true;
row["IsStoredInFreeStorageType"] = true;
}
}
}
}
return isValid;
}
private void gridView2_CustomDrawCell(object sender, DevExpress.XtraGrid.Views.Base.RowCellCustomDrawEventArgs e)
{
DataRow dr = gridItemMovementView.GetDataRow(e.RowHandle);
int index = (e.Column.Caption == "") ? 1 : Convert.ToInt32(e.Column.Caption) - 1;
if (dr[String.Format("Pallet{0}", index)] != DBNull.Value)
{
e.DisplayText = dr["Pallet" + index].ToString();
}
else
{
e.DisplayText = dr[String.Format("Pallet{0}", index)].ToString();
}
Rectangle box = e.Bounds;
string balanceField = string.Format("ItemID{0}", index);
if (dr.IsNull(String.Format("PercentageUsed{0}", index)))
{
box.Width = 0;
}
else
{
int width = Convert.ToInt32(Convert.ToDouble(box.Width) * Convert.ToDouble(dr[String.Format("PercentageUsed{0}", index)]) / 100);
if (width > box.Width)
{
width = box.Width;
}
box.Width = width;
}
if (box.Width > 0)
{
Brush b = new SolidBrush(Color.FromArgb(51, 153, 255));
e.Graphics.FillRectangle(b, box);
box.X += box.Width;
box.Width = e.Bounds.Width - box.Width;
b = new SolidBrush(Color.FromArgb(173, 216, 239));
e.Graphics.FillRectangle(b, box);
}
else if (box.Width == 0 && dr[balanceField] != DBNull.Value && Convert.ToInt32(dr[balanceField]) > 0)
{
// this is when we are not sure abou the volume of the items
Brush b = new SolidBrush(Color.FromArgb(173, 216, 239));
e.Graphics.FillRectangle(b, e.Bounds);
}
if ((gridItemMovementView.FocusedValue != null && e.CellValue != DBNull.Value &&
e.CellValue is int && Convert.ToInt32(e.CellValue) > 0 &&
gridItemMovementView.FocusedValue != DBNull.Value &&
gridItemMovementView.FocusedValue is int &&
Convert.ToInt32(gridItemMovementView.FocusedValue) > 0) || (gridItemMovementView.FocusedValue == null) && Convert.ToInt32(e.CellValue) > 0)
{
var pl = new PalletLocation();
pl.LoadByPrimaryKey(Convert.ToInt32(e.CellValue));
if (pl.RowCount > 0 && !pl.IsColumnNull("PalletID") && e.Column.Name != "colRow")
{
Brush b = new SolidBrush(Color.FromArgb(173, 200, 0));
e.Graphics.FillRectangle(b, e.Bounds);
}
}
e.Handled = false;
}
private void PutAwayRecievedItems(bool reset)
{
if (_dtPutAwayNonPalletized == null || reset == true)
{
// Prep the data tables
_dtPutAwayNonPalletized = new DataTable();
_dtPutAwayPalletized = new DataTable();
_dtPutAwayPalletized.Columns.Add("ID");
_dtPutAwayPalletized.Columns.Add("Item Name");
_dtPutAwayPalletized.Columns.Add("PalletNumber");
_dtPutAwayPalletized.Columns.Add("Expiry Date", typeof(DateTime));
_dtPutAwayPalletized.Columns.Add("PutAwayLocation");
_dtPutAwayPalletized.Columns.Add("Consolidate", typeof(bool));
_dtPutAwayPalletized.Columns.Add("Notes");
_dtPutAwayPalletized.Columns.Add("Volume");
_dtPutAwayPalletized.Columns.Add("Stock Code");
_dtPutAwayNonPalletized.Columns.Add("ID");
_dtPutAwayNonPalletized.Columns.Add("Item Name");
_dtPutAwayNonPalletized.Columns.Add("Pack Qty", typeof(decimal));
_dtPutAwayNonPalletized.Columns.Add("Expiry Date", typeof(DateTime));
_dtPutAwayNonPalletized.Columns.Add("PutAwayLocation");
_dtPutAwayNonPalletized.Columns.Add("Batch No");
_dtPutAwayNonPalletized.Columns.Add("StorageType");
_dtPutAwayNonPalletized.Columns.Add("BoxLevel", typeof(int));
_dtPutAwayNonPalletized.Columns.Add("Index");
_dtPutAwayNonPalletized.Columns.Add("BasicUnitPerQ");
_dtPutAwayNonPalletized.Columns.Add("IsDamaged", typeof(bool));
_dtPutAwayNonPalletized.Columns.Add("Volume");
_dtPutAwayNonPalletized.Columns.Add("Manufacturer", typeof(int));
_dtPutAwayNonPalletized.Columns.Add("UnitID", typeof(int));
_dtPutAwayNonPalletized.Columns.Add("Stock Code");
_dtPutAwayNonPalletized.Columns.Add("GUID");
_dtPutAwayNonPalletized.Columns.Add("Palletized Quantity", typeof(decimal));
// import the neccessary data tables
_dtPalletizedItemList.DefaultView.Sort = "Ordering, PalletNumber";
int prevPalletID = 0;
int palletID = 0;
DataRow LastDr = null;
foreach (DataRowView drv in _dtPalletizedItemList.DefaultView)
{
DataRow dr = drv.Row;
palletID = Convert.ToInt32(drv["PalletNumber"]);
if (palletID != prevPalletID)
{
_dtPutAwayPalletized.ImportRow(dr);
LastDr = _dtPutAwayPalletized.Rows[_dtPutAwayPalletized.Rows.Count - 1];
LastDr.EndEdit();
if (Convert.ToBoolean(LastDr["Consolidate"]))
{
int plid;
LastDr["PutAwayLocation"] = plid = Convert.ToInt32(drv["PalletNumber"]);
PalletLocation plc = new PalletLocation();
plc.LoadByPrimaryKey(plid);
Pallet plt = new Pallet();
plt.LoadByPrimaryKey(plc.PalletID);
LastDr["PalletNumber"] = (!plt.IsColumnNull("PalletNo")) ? plt.PalletNo : 0;
}
}
else
{
// add the volume
LastDr["Volume"] = Convert.ToDouble(LastDr["Volume"]) + Convert.ToDouble(dr["Volume"]);
}
prevPalletID = palletID;
}
//int quarantine = PalletLocation.GetQuaranteenPalletLocation();
foreach (DataRowView drv in _dtNonPalletizedItemList.DefaultView)
{
_dtPutAwayNonPalletized.ImportRow(drv.Row);
DataRow dr = _dtPutAwayNonPalletized.Rows[_dtPutAwayNonPalletized.Rows.Count - 1];
dr.ClearErrors();
}
foreach (DataRowView dr in _dtPutAwayNonPalletized.DefaultView)
{
dr["Palletized Quantity"] = dr["Pack Qty"];
}
// Bind the data tables with the grids
//gridPutAwayPalletized.DataSource = _dtPutAwayPalletized;
//gridPutAwayPalletizedView.SelectRow(0);
gridPutAwayNonPalletized.DataSource = _dtPutAwayNonPalletized;
//gridPutAwayPalletizedView.SelectRow(0);
}
}
private void repositoryItemButtonEdit1_Click(object sender, EventArgs e)
{
if (BLL.Settings.UseNewUserManagement && !this.HasPermission("Move-Commodities"))
{
return;
}
PalletLocation pl = new PalletLocation();
if (gridItemMovementView.FocusedValue != null && prev != gridItemMovementView.FocusedValue)
{
prev = gridItemMovementView.FocusedValue;
pl.LoadByPrimaryKey(Convert.ToInt32(gridItemMovementView.FocusedValue));
PalletLocation pll = new PalletLocation();
pll.LoadByPrimaryKey(selectedPalletLocationID);
if (pll.RowCount > 0)
{
if (!pll.IsColumnNull("PalletID") && pl.IsColumnNull("PalletID"))
{
if(pll.StorageTypeID.ToString() == StorageType.PickFace)
{
XtraMessageBox.Show(
"You cannot use Internal Movements to move Pick Face Locations. Please use the customize drug list screen.","Error",MessageBoxButtons.OK,MessageBoxIcon.Stop);
}
else if(XtraMessageBox.Show("Are you sure you want to move pallet?","Confirmation",MessageBoxButtons.YesNo,MessageBoxIcon.Question) == System.Windows.Forms.DialogResult.Yes){
//TODO: implement the moving logic here.
if (PalletLocation.Move(pll.ID, pl.ID))
{
lkRackID2_EditValueChanged( new object(), new EventArgs() );
gridItemMovementView.RefreshRow( gridItemMovementView.FocusedRowHandle );
gridItemDetailByLocation.Refresh();
}
}
}
}
selectedPalletLocationID = Convert.ToInt32(gridItemMovementView.FocusedValue);
}
}
//, 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 splitMenu_Opening(object sender, CancelEventArgs e)
{
if (gridItemMovementView.FocusedValue != null && gridItemMovementView.FocusedValue != DBNull.Value &&
Convert.ToInt32(gridItemMovementView.FocusedValue) > 0)
{
var pl = new PalletLocation();
prev = gridItemMovementView.FocusedValue;
pl.LoadByPrimaryKey(Convert.ToInt32(gridItemMovementView.FocusedValue));
if (pl.IsColumnNull("PalletID"))
{
e.Cancel = true;
}
}
}
private void SavePutAwayItems()
{
PalletLocation pl = new PalletLocation();
Pallet pallet = new Pallet();
foreach (DataRow rw in _dtPutAwayPalletized.Rows)
{
pl.LoadByPrimaryKey(Convert.ToInt32(rw["PutAwayLocation"]));
if (pl.IsColumnNull("PalletID"))
{
pl.PalletID = GetPalletID(rw["PalletNumber"].ToString());
pl.Confirmed = false;
pallet.LoadByPrimaryKey(pl.PalletID);
pl.UsedVolume = pallet.CalculateCurrentVolume(pl.PalletID);
pl.Save();
}
else
{
}
}
}
private void btnSave_Click(object sender, EventArgs e)
{
int warehouseID = Convert.ToInt32(lkWarehouse.EditValue);
receiveDoc.Rewind();
var po = new BLL.PO();
var receiptInvoice = new BLL.ReceiptInvoice();
while (!receiveDoc.EOF)
{
//Handle the PO.
//int receiptID;
if (po.RowCount == 0 || po.StoreID != receiveDoc.StoreID)
{
Supplier supplier = new Supplier();
po = BLL.PO.CreatePOforStandard(OrderType.CONSTANTS.STANDARD_ORDER, receiveDoc.StoreID,
supplier.GetHubHomeOfficeSupplierID(), "",CurrentContext.LoggedInUser.ID);
//Should we receive it as hub to hub transfer? We're now using Standard order.
receipt = BLL.ReceiptInvoice.CreateAutomaticReceiptInvoiceForSTVTransfer(po.ID, warehouseID, STVNo,
CurrentContext.UserId);
}
receiveDoc.Quantity = receiveDoc.QtyPerPack * receiveDoc.NoOfPack;
receiveDoc.ReceiptID = receipt.ID;
receiveDoc.MoveNext();
}
receiveDoc.Save();
//Save the location
receiveDoc.Rewind();
BLL.ReceivePallet receivePallet = new ReceivePallet();
while (!receiveDoc.EOF)
{
//Save Location Information
BLL.PalletLocation palletLocation = new PalletLocation();
receivePallet.AddNew();
int palletLocationID = Convert.ToInt32(receiveDoc.GetColumn("PalletLocationID"));
receivePallet.PalletLocationID = palletLocationID;
palletLocation.LoadByPrimaryKey(palletLocationID);
receivePallet.PalletID = palletLocation.PalletID;
receivePallet.ReceivedQuantity = receiveDoc.Quantity;
receivePallet.Balance = receiveDoc.Quantity;
receivePallet.ReceiveID = receiveDoc.ID;
receivePallet.ReservedStock = 0;
//Save Discrepancy information if there is any
receiveDocShortage.Rewind();
while (receiveDocShortage.FindNextByGUID(receiveDoc.GetColumn("GUID").ToString()))
{
receiveDocShortage.ReceiveDocID = receiveDoc.ID;
if (receiveDocShortage.ShortageReasonID == ShortageReasons.Constants.DAMAGED)
{
receiveDoc.NoOfPack += receiveDocShortage.NoOfPacks;
receiveDoc.Quantity += receiveDocShortage.NoOfPacks*receiveDoc.QtyPerPack;
palletLocationID = Convert.ToInt32(receiveDocShortage.GetColumn("PalletLocationID"));
receivePallet.AddNew();
receivePallet.PalletLocationID = palletLocationID;
palletLocation.LoadByPrimaryKey(palletLocationID);
receivePallet.PalletID = palletLocation.PalletID;
receivePallet.ReceivedQuantity = receiveDocShortage.NoOfPacks*receiveDoc.QtyPerPack;
receivePallet.Balance = receiveDocShortage.NoOfPacks*receiveDoc.QtyPerPack;
receivePallet.ReceiveID = receiveDoc.ID;
receivePallet.ReservedStock = 0;
}
}
receiveDoc.MoveNext();
}
receivePallet.IsOriginalReceive = true;
receivePallet.Save();
}
private void UpdateQuantityAndPhysicalStores()
{
var dataTable = gridPutAwayNonPalletized.DataSource as DataTable;
decimal currentBonusInvQty = 0;
string currentGuiParam = "";
var orginalGuidCurrentInvQty = new Dictionary<string, decimal>();
if (dataTable != null)
foreach (DataRow drow in dataTable.Rows)
{
if (drow["IsDamaged"] != DBNull.Value && Convert.ToBoolean(drow["IsDamaged"])) continue;
var dr = _dtRecGrid.Select(String.Format("GUID = '{0}'", Convert.ToString(drow["GUID"])))[0];
bool currentRowIsOrginal = (dr["Copy"].ToString() == "Orginal" || dr["Copy"] == DBNull.Value);
currentGuiParam = currentRowIsOrginal ? "GUID" : "Copy";
if (drow["PutAwayLocation"] != DBNull.Value)
{
var plocation = new PalletLocation();
plocation.LoadByPrimaryKey(Convert.ToInt32(drow["PutAwayLocation"]));
dr["Store"] = (plocation.PhysicalStoreID);
}
if (drow["Palletized Quantity"] != DBNull.Value)
{
dr["Pack Qty"] = drow["Palletized Quantity"];
bool hasBonus = !srm && dr["InvoicedQty"] != DBNull.Value &&
(Convert.ToDecimal(dr["InvoicedQty"]) < Convert.ToDecimal(drow["Pack Qty"]));
if (hasBonus && !orginalGuidCurrentInvQty.Any())
GetCurrentBonusInvQty(out orginalGuidCurrentInvQty);
if (!hasBonus)
{
dr["InvoicedQty"] = (currentRowIsOrginal)
? Convert.ToDecimal(dr["Pack Qty"]) +
HasShortageQty(dr["GUID"].ToString())
: Convert.ToDecimal(dr["Pack Qty"]);
}
else
{
currentBonusInvQty = orginalGuidCurrentInvQty[dr[currentGuiParam].ToString()];
if (Convert.ToDecimal(dr["Pack Qty"]) >= currentBonusInvQty && currentBonusInvQty >= 0)
{
dr["InvoicedQty"] = currentBonusInvQty;
orginalGuidCurrentInvQty[dr[currentGuiParam].ToString()] -=
Convert.ToDecimal(dr["Pack Qty"]);
}
else
{
if (currentBonusInvQty <= 0)
dr["InvoicedQty"] = 0;
else
{
dr["InvoicedQty"] = (currentBonusInvQty >= Convert.ToDecimal(dr["Pack Qty"]))
? Convert.ToDecimal(dr["Pack Qty"])
: currentBonusInvQty;
orginalGuidCurrentInvQty[dr[currentGuiParam].ToString()] -=
Convert.ToDecimal(dr["Pack Qty"]);
}
}
}
}
}
}