/// <summary>
        /// Update the form based on the selected shelf
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void listView1_SelectedIndexChanged(object sender, EventArgs e)
        {
            if (lstShelfs.SelectedItems.Count > 0)
            {
                int selected = Convert.ToInt32(lstShelfs.SelectedItems[0].Tag);
                Shelf slf = new Shelf();
                slf.LoadByPrimaryKey(selected);
                txtShelf.Text = slf.ShelfCode;
                cboStore.SelectedValue = slf.StoreID.ToString();
                if (slf.IsColumnNull("ShelfStorageType"))
                {
                    slf.ShelfStorageType = 1;
                }

                cboType.SelectedValue = slf.ShelfStorageType;

                _shelfId = slf.ID;
                btnLocationsave.Text = "Update";
            }
        }
        private void gridBinLocationView_FocusedRowChanged(object sender,
                                                           DevExpress.XtraGrid.Views.Base.FocusedRowChangedEventArgs e)
        {
            DataRow dr = gridBinLocationView.GetFocusedDataRow();

            if (dr != null)
            {
                int selected = Convert.ToInt32(dr["ID"]);
                Shelf slf = new Shelf();
                slf.LoadByPrimaryKey(selected);
                if (slf.RowCount > 0)
                {
                    txtShelf.Text = slf.ShelfCode;
                    if (!slf.IsColumnNull("StoreID"))
                        cboStore.SelectedValue = slf.StoreID.ToString();
                    if (!slf.IsColumnNull("ShelfStorageType"))
                    {
                        cboType.SelectedValue = slf.ShelfStorageType;
                    }
                    shelfId = slf.ID;
                }
                btnLocationsave.Text = "Update";
            }
        }