Пример #1
0
        private void btnDelete_Click(object sender, EventArgs e)
        {
            if (radPackages.Checked == false && radProducts.Checked == false && radSuppliers.Checked == false)
            {
                MessageBox.Show("Please select a database to delete from.", "Select a Database");
            }
            else if (radPackages.Checked)
            {
                string   i            = lstView.SelectedItem.ToString();
                string[] s            = i.Split('|');
                int      packageId    = Int32.Parse(s[0].Trim());
                string   nameSelected = s[1].Trim();

                currentPackage = PackagesDB.GetPackageById(packageId);

                DialogResult result = MessageBox.Show("Delete Packages " + nameSelected + "?",
                                                      "Confirm Delete", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
                if (result == DialogResult.Yes)
                {
                    try
                    {
                        if (!PackagesDB.DeletePackage(currentPackage))
                        {
                            MessageBox.Show("Another user has updated or deleted " +
                                            "that package.", "Database Error");
                            currentPackage = PackagesDB.GetPackageById(packageId);
                        }
                        else
                        {
                            this.DisplayPackages();
                        }
                    }
                    catch (Exception ex)
                    {
                        MessageBox.Show(ex.Message, ex.GetType().ToString());
                    }
                }
            }
            else if (radProducts.Checked)
            {
                string   i            = lstView.SelectedItem.ToString();
                string[] s            = i.Split('|');
                int      productId    = Int32.Parse(s[0].Trim());
                string   nameSelected = s[1].Trim();

                currentProduct = ProductsDB.GetProductById(productId);

                DialogResult result = MessageBox.Show("Delete Product " + nameSelected + "?",
                                                      "Confirm Delete", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
                if (result == DialogResult.Yes)
                {
                    try
                    {
                        if (!ProductsDB.DeleteProduct(currentProduct))
                        {
                            MessageBox.Show("Another user has updated or deleted " +
                                            "that package.", "Database Error");
                            currentProduct = ProductsDB.GetProductById(productId);
                        }
                        else
                        {
                            this.DisplayProducts();
                        }
                    }
                    catch (Exception ex)
                    {
                        MessageBox.Show(ex.Message, ex.GetType().ToString());
                    }
                }
            }
            else if (radSuppliers.Checked)
            {
                string   i            = lstView.SelectedItem.ToString();
                string[] s            = i.Split('|');
                int      supplierId   = Int32.Parse(s[0].Trim());
                string   nameSelected = s[1].Trim();

                currentSupplier = SuppliersDB.GetSupplierById(supplierId);

                DialogResult result = MessageBox.Show("Delete Supplier " + nameSelected + "?",
                                                      "Confirm Delete", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
                if (result == DialogResult.Yes)
                {
                    try
                    {
                        if (!SuppliersDB.DeleteSupplier(currentSupplier))
                        {
                            MessageBox.Show("Another user has updated or deleted " +
                                            "that package.", "Database Error");
                            currentSupplier = SuppliersDB.GetSupplierById(supplierId);
                        }
                        else
                        {
                            this.DisplaySuppliers();
                        }
                    }
                    catch (Exception ex)
                    {
                        MessageBox.Show(ex.Message, ex.GetType().ToString());
                    }
                }
            }
        }