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(); } }
private void ConfirmQuantityAndLocation() { //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.PalletID = PalletID; pl.Confirmed = true; pl.Save(); pl.LoadByPrimaryKey(ProposedPalletLocationID); pl.SetColumnNull("PalletID"); pl.Save(); } else { XtraMessageBox.Show("Some Items/Pallets were not confirmed correctly because the newly selected pallet location was already occupied.", "Some Items were not confirmed."); } } else { pl.LoadByPrimaryKey(PalletLocationID); pl.PalletID = PalletID; pl.Confirmed = true; pl.Save(); } } BLL.ReceiveDoc recDoc = new ReceiveDoc(); recDoc.LoadByReferenceNo(reference); recDoc.ConfirmQuantityAndLocation(null); transaction.CommitTransaction(); XtraMessageBox.Show("Receipt Confirmed!", "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 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); } } }
/// <summary> /// Moves the specified from. /// </summary> /// <param name="from">From.</param> /// <param name="to">To.</param> /// <returns></returns> public static bool Move(int from, int to) { PalletLocation pl = new PalletLocation(); pl.LoadByPrimaryKey(from); if (!pl.IsColumnNull("PalletID")) { PalletLocation pl2 = new PalletLocation(); pl2.LoadByPrimaryKey(to); if (pl2.IsColumnNull("PalletID")) { pl2.PalletID = pl.PalletID; pl.SetColumnNull("PalletID"); pl.Save(); pl2.Confirmed = true; pl2.Save(); return true; } } return false; }