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); } } }