private void UpdateChanges_Click(object sender, EventArgs e)
        {
            string imgloc;

            if (IsImgUploaded)
            {
                imgloc = Admin.SaveImage(o1.FileName);
            }
            else
            {
                imgloc = ProductImageEd.ImageLocation;
            }
            //update changes code goes here...
            Admin.UpdateProduct(ProductNameEd.Text, ProductIdEd.Text, DesignCodeEd.Text, ColorEd.Text, int.Parse(NumberOfPiecesEd.Text),
                                int.Parse(QuantityInStockEd.Text), double.Parse(ProductPriceEd.Text), KameezFabricEd.Text, ShalwarFabricEd.Text,
                                DupattaFabricEd.Text, EmbroideryStatusEd.GetItemChecked(0), EmbroideryStatusEd.GetItemChecked(1), EmbroideryStatusEd.GetItemChecked(2),
                                EmbroideryStatusEd.GetItemChecked(3), imgloc);


            EditItemBtn_Click(sender, e);
            o1.Dispose();
            // ProductImageEd.Image = initial;
            // ProductNameEd.Clear();
            // ProductIdEd.Clear();

            // ColorEd.Text = string.Empty;
            // ProductPriceEd.Clear();
            // QuantityInStockEd.Clear();

            // KameezFabricEd.Text = "";

            // ShalwarFabricEd.Text = "";

            // DupattaFabricEd.Text = "";
            // for (int i = 0; i < EmbroideryStatusEd.Items.Count; i++)
            // {
            //     EmbroideryStatusEd.SetItemChecked(i, false);
            // }
            // NumberOfPiecesEd.Clear();
            // DesignCodeEd.Clear();
            // textBox5.Clear();
            //// ProductImageEd.Image = ProductPicture.InitialImage;
            // ProductImageEd.Enabled = false;
            // ProductNameEd.Enabled = false;
            // ProductIdEd.Enabled = false;
            // ColorEd.Enabled = false;
            // ProductPriceEd.Enabled = false;
            // QuantityInStockEd.Enabled = false;
            // KameezFabricEd.Enabled = false;
            // ShalwarFabricEd.Enabled = false;
            // DupattaFabricEd.Enabled = false;
            // EmbroideryStatusEd.Enabled = false;
            // NumberOfPiecesEd.Enabled = false;
            // DesignCodeEd.Enabled = false;
            // UpdateChanges.Enabled = false;
            // DeleteItemEd.Enabled = false;
            // EditItem.Show();
            // EditItem.BringToFront();
        }
        private void EditItemBtn_Click(object sender, EventArgs e)
        {
            label8.Show();
            comboBox1.Items.Clear();
            comboBox1.Text = string.Empty;
            Admin.LaodProducts(comboBox1);
            ProductImageEd.Image = ProductImageEd.InitialImage;
            IsImgUploaded        = false;
            ProductNameEd.Clear();
            ProductIdEd.Clear();
            ColorEd.Items.Clear();
            ColorEd.Text = string.Empty;
            ProductPriceEd.Clear();
            QuantityInStockEd.Clear();
            KameezFabricEd.Items.Clear();
            KameezFabricEd.Text = "";
            ShalwarFabricEd.Items.Clear();
            ShalwarFabricEd.Text = "";
            DupattaFabricEd.Items.Clear();
            DupattaFabricEd.Text = "";
            for (int i = 0; i < EmbroideryStatusEd.Items.Count; i++)
            {
                EmbroideryStatusEd.SetItemChecked(i, false);
            }
            NumberOfPiecesEd.Clear();
            DesignCodeEd.Clear();


            ProductImageEd.Enabled     = false;
            ProductNameEd.Enabled      = false;
            ProductIdEd.Enabled        = false;
            ColorEd.Enabled            = false;
            ProductPriceEd.Enabled     = false;
            QuantityInStockEd.Enabled  = false;
            KameezFabricEd.Enabled     = false;
            ShalwarFabricEd.Enabled    = false;
            DupattaFabricEd.Enabled    = false;
            EmbroideryStatusEd.Enabled = false;
            NumberOfPiecesEd.Enabled   = false;
            DesignCodeEd.Enabled       = false;
            UpdateChanges.Enabled      = false;
            DeleteItemEd.Enabled       = false;
            EditItem.Show();
            EditItem.BringToFront();
        }