//כפתור עידכון מוצר
        private void BTN_UPDATE_PRODUCT_Click(object sender, EventArgs e)
        {
            Product product = new Product();
            var     tbl     = product.GetProducts();

            if (tbl.Rows.Count != 0)
            {
                FORM_NEW_PRODUCT fnp = new FORM_NEW_PRODUCT();
                fnp.LBL_PID.Text          = DGV_PRODUCTS.CurrentRow.Cells[0].Value.ToString();
                fnp.TB_NAME.Text          = DGV_PRODUCTS.CurrentRow.Cells[1].Value.ToString();
                fnp.TB_QUANTITY.Text      = DGV_PRODUCTS.CurrentRow.Cells[2].Value.ToString();
                fnp.TB_PRICE.Text         = DGV_PRODUCTS.CurrentRow.Cells[3].Value.ToString();
                fnp.TB_DESCRIPTION.Text   = DGV_PRODUCTS.CurrentRow.Cells[5].Value.ToString();
                fnp.TB_GUARANTEE.ReadOnly = false;
                fnp.TB_GUARANTEE.Text     = DGV_PRODUCTS.CurrentRow.Cells[6].Value.ToString();
                fnp.COMBO_CATEGORIES.Text = DGV_PRODUCTS.CurrentRow.Cells[7].Value.ToString();

                fnp.BTN_UPDATE.Visible = true;

                byte[]       img = (byte[])DGV_PRODUCTS.CurrentRow.Cells[4].Value;
                MemoryStream ms  = new MemoryStream(img);
                fnp.PB_BROWSE_IMAGE.Image = Image.FromStream(ms);
                fnp.ShowDialog();
                DGV_PRODUCTS.DataSource = product.GetProducts();
            }
            else
            {
                MessageBox.Show("אין מוצרים לעדכן", "עידכון מוצר");
            }
        }
        //כפתור מוצר חדש
        private void BTN_NEW_PRODUCT_Click(object sender, EventArgs e)
        {
            Product          product = new Product();
            FORM_NEW_PRODUCT fnp     = new FORM_NEW_PRODUCT();

            fnp.BTN_UPDATE.Visible = false;
            fnp.ShowDialog();
            DGV_PRODUCTS.DataSource = product.GetProducts();
        }