private void buttonDelete_Click(object sender, EventArgs e)
        {
            if (proGrid1.SelectedRows.Count <= 0)
            {
                return;
            }

            DialogResult deleteConfrm = MessageBox.Show("Are you sure?", "Confirmation", MessageBoxButtons.YesNoCancel, MessageBoxIcon.Question);

            if (deleteConfrm != DialogResult.Yes)
            {
                return;
            }

            DAL.ProductPrice productPrice = new ProductPrice();
            string           ids          = "";

            for (int i = 0; i < proGrid1.SelectedRows.Count; i++)
            {
                ids += proGrid1.SelectedRows[i].Cells["ColId"].Value.ToString() + ", ";
            }
            ids = ids.Substring(0, ids.Length - 2);

            if (productPrice.Delete(ids))
            {
                MessageBox.Show("Product price is deleted");
                buttonSearch.PerformClick();
            }
            else
            {
                MessageBox.Show(productPrice.Error);
            }
        }
        private void btnDelete_Click(object sender, EventArgs e)
        {
            ProductPrice productPrice = new ProductPrice();

            if (myGrid2.SelectedRows.Count <= 0)
            {
                return;
            }
            productPrice.ProductId = Convert.ToInt32(myGrid2.SelectedRows[0].Cells["colProductId"].Value);
            productPrice.UnitId    = Convert.ToInt32(myGrid2.SelectedRows[0].Cells["colUnitId"].Value);

            if (productPrice.Delete())
            {
                MessageBox.Show("Product Deleted");
                btnSearch.PerformClick();
            }
            else
            {
                MessageBox.Show(productPrice.Error);
            }
        }