//Click event for btn_Add_DeleteSelected private void btn_Add_DeleteSelected_Click(object sender, EventArgs e) { //No db loaded, leave function if (GuiPrefs.OpenDBPath == "") { return; } int numrecords = dgv_Add_InventoryView.Rows.Count; int skutodel = -1; int scrolling = dgv_Add_InventoryView.FirstDisplayedScrollingRowIndex; for (int i = 0; i < numrecords; i++) { if (dgv_Add_InventoryView.Rows[i].Selected) { skutodel = Convert.ToInt16(dgv_Add_InventoryView[0, i].Value); break; } } if (skutodel >= 0) //Record selected, confirm and delete. { string str_delconfirm = String.Format("You are about to permanently delete " + "the record with SKU# {0} from the database.\n\n" + "-= DO NOT USE THIS SCREEN TO DISPENSE GLASSES =-\n\nAre you sure " + "you want to delete this record?", skutodel); string str_caption = String.Format("Confirm Delete - SKU# {0}", skutodel); if (MessageBox.Show(str_delconfirm, str_caption, MessageBoxButtons.YesNo, MessageBoxIcon.Warning, MessageBoxDefaultButton.Button2) == DialogResult.Yes) { Mydb.Delete((uint)skutodel, SSTable.Current); Mydb.GetCurrentInventory(); //Refreshes the list if (!GuiPrefs.NormalDatabase) { Mydb.Delete((uint)skutodel, SSTable.MergeItems); dt_Add_MergeTable.Clear(); Mydb.GetTable(dt_Add_MergeTable, SSTable.MergeItems); } if (scrolling < dgv_Add_InventoryView.Rows.Count - 1) { dgv_Add_InventoryView.FirstDisplayedScrollingRowIndex = scrolling; } IncrementOps(); //Increment ops by 1 if the appropriate prefs are set } } else //No record selected when button was pushed { MessageBox.Show("Please select a record to delete from the list.", "No Record Selected", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); } }
/// <summary> /// Click event for the Delete button in the Dispense tab. /// Deletes the items corresponding to each SKU in the listbox after confirmation. /// </summary> private void btn_D_Delete_Click(object sender, EventArgs e) { int tdskus = 0; if (deleteTable.Rows.Count > 0) { if (MessageBox.Show("You are about to permanently remove 1 or more records from inventory.\n\n-= DO NOT USE THIS BUTTON TO DISPENSE GLASSES =-\n\nAre you sure you want to proceed?", "Confirm Deletion", MessageBoxButtons.YesNo, MessageBoxIcon.Exclamation) == System.Windows.Forms.DialogResult.No) { return; } } foreach (DataRow dr in deleteTable.Rows) { Mydb.Delete(Convert.ToUInt16(dr[0]), SSTable.Current); tdskus++; } if (tdskus > 0) { //Clean up the controls and the form. deleteTable.Clear(); lbox_D_ToDelete.Items.Clear(); tb_D_SphereOD.Clear(); tb_D_CylOD.Clear(); tb_D_AxisOD.Clear(); tb_D_AddOD.Clear(); tb_D_SphereOS.Clear(); tb_D_CylOS.Clear(); tb_D_AxisOS.Clear(); tb_D_AddOS.Clear(); tb_D_Comment.Clear(); rb_D_NoTint.Checked = true; rb_D_LightTint.Checked = false; rb_D_DarkTint.Checked = false; rb_D_Small.Checked = true; rb_D_Medium.Checked = false; rb_D_Large.Checked = false; rb_D_Unisex.Checked = true; rb_D_Male.Checked = false; rb_D_Female.Checked = false; rb_D_Single.Checked = true; rb_D_Multi.Checked = false; tb_D_EnterSKUDel.Clear(); tb_D_EnterSKUDel.Focus(); //Reload the inventory display Mydb.GetCurrentInventory(); if (tdskus > 1) { MessageBox.Show(String.Format("Successfully deleted {0} pairs of glasses.", tdskus), "Delete Successful", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); } else { MessageBox.Show("Successfully deleted 1 pair of glasses.", "Delete Successful", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); } IncrementOps(tdskus); //Increment ops by the number of records deleted, if the appropriate prefs are set } else { MessageBox.Show("No glasses were deleted; no SKUs were specified.", "Delete Unsuccessful", MessageBoxButtons.OK, MessageBoxIcon.Information); } }