/// <summary>
/// Undo pick list that has been printed
/// </summary>
/// <param name="orderID">The order ID.</param>
public void CancelOrderWithPickList(int orderID)
{
// Create a pick list entry
Order ord = new Order();
PickList pl = new PickList();
PickListDetail pld = new PickListDetail();
ReceivePallet rp = new ReceivePallet();
ReceiveDoc rd = new ReceiveDoc();
PickFace pf = new PickFace();
PalletLocation palletLocation = new PalletLocation();
ord.LoadByPrimaryKey(orderID);
pl.LoadByOrderID(orderID);
pld.LoadByPickListID(pl.ID);
while (!pld.EOF)
{
rp.LoadByPrimaryKey(pld.ReceivePalletID);
rp.ReservedStock -= Convert.ToInt32(pld.QuantityInBU);
if (rp.ReservedStock < 0)
{
rp.ReservedStock = 0; //If there has been no reservation, allow to cancel the picklist too. No need for it to be blocked by the constraint.
}
rp.Save();
palletLocation.LoadByPrimaryKey(pld.PalletLocationID);
if (palletLocation.StorageTypeID.ToString() == StorageType.PickFace)
{
pf.LoadByPalletLocation(pld.PalletLocationID);
pf.Balance += Convert.ToInt32(pld.QuantityInBU);
pf.Save();
}
//Delete from picklistDetail and add to pickListDetailDeleted
PickListDetailDeleted.AddNewLog(pld, BLL.CurrentContext.UserId);
pld.MarkAsDeleted();
pld.MoveNext();
}
pld.Save();
ord.ChangeStatus(OrderStatus.Constant.CANCELED, CurrentContext.UserId);
pl.MarkAsDeleted();
pl.Save();
}
/// <summary>
/// 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();
}
/// <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 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);
}
}
}
private void BindPalletLocationForEdit(object sender, EventArgs e)
{
// Keep the reference of the current popup control so that the cancel logic works just fine.
CurrentPopup = (PopupContainerEdit)sender;
//Get the selected row
DataRow dr = detailView.GetFocusedDataRow();
int palletLocationID = Convert.ToInt32(dr["PalletLocationID"]);
// Enable and disable optional fields
String SType = dr["STI"].ToString();
if (SType == "")
{
SType = dr["ShelfStorageType"].ToString();
}
cmbFixedPrefered.Enabled = true;
if (SType == StorageType.BulkStore)
{
//lstPreferedItems.Visible = true;
//lblPreferredItem.Visible = true;
//cmbFixedPrefered.Enabled = false;
lblFixedPickItem.Visible = false;
cmbFixedPrefered.Visible = false;
}
else if (SType == StorageType.PickFace)
{
lblFixedPickItem.Text = "Pick Item";
lstPreferedItems.Visible = false;
lblPreferredItem.Visible = false;
cmbFixedPrefered.Properties.DataSource = Item.GetItems(StorageType.BulkStore);
PickFace pf = new PickFace();
pf.LoadByPalletLocation(palletLocationID);
if (pf.RowCount >0 && !pf.IsColumnNull("DesignatedItem"))
{
cmbFixedPrefered.EditValue = pf.DesignatedItem;
}
else
{
cmbFixedPrefered.EditValue = null;
}
lblFixedPickItem.Visible = true;
cmbFixedPrefered.Visible = true;
}
else
{
cmbFixedPrefered.Properties.DataSource = Item.GetItems(dr["STI"].ToString());
BLL.ItemPrefferedLocation ipl = new ItemPrefferedLocation();
ipl.LoadByRackID( palletLocationID );
if (ipl.RowCount > 0)
{
cmbFixedPrefered.EditValue = ipl.ItemID;
}
else
{
cmbFixedPrefered.EditValue = null;
}
lblFixedPickItem.Text = "Fixed Item";
lblFixedPickItem.Visible = true;
cmbFixedPrefered.Visible = true;
lstPreferedItems.Visible = false;
lblPreferredItem.Visible = false;
}
// Bind the available variables
txtPalletLocationLabel.Text = dr["Label"].ToString();
chkEnabled.Checked = Convert.ToBoolean(dr["IsEnabled"]);
}