private void categoryShowDataGridView_CellMouseDoubleClick(object sender, DataGridViewCellMouseEventArgs e)
        {
            updateRowIndex = e.RowIndex;
            DataGridViewRow row = categoryShowDataGridView.Rows[updateRowIndex];

            categoryNameTextBox.Text = row.Cells[1].Value.ToString();

            CategorySaveButton.Hide();
            UpdateButton.Show();
        }
        private void CategoryUpdateButton_Click(object sender, EventArgs e)
        {
            try
            {
                DataGridViewRow row = categoryShowDataGridView.Rows[updateRowIndex];
                category.Id   = (int)row.Cells[0].Value;
                category.Name = categoryNameTextBox.Text;


                if (category.Exists())
                {
                    MessageBox.Show("Already Exist");
                }
                else
                {
                    if (category.Update())
                    {
                        MessageBox.Show("updated");
                    }
                    else
                    {
                        MessageBox.Show("Not updated");
                    }

                    UpdateButton.Hide();
                }


                dataTable = category.ShowAllCategory();

                categoryShowDataGridView.DataSource = dataTable;
            }
            catch (Exception exp)
            {
                MessageBox.Show(exp.Message);
            }
            categoryNameTextBox.Text = "";
            UpdateButton.Hide();
            CategorySaveButton.Show();
        }