private void btnAdd_Click(object sender, EventArgs e)
        {
            try
            {
                if (string.IsNullOrEmpty(txtSubCategoryName.Text))
                {
                    MessageBox.Show("Please Enter Sub Category Name");
                }
                else
                {
                    AddUpdate add = new AddUpdate();
                    add.addUpdateSubCategories(
                        cmbCategories.Text,
                        txtSubCategoryName.Text,
                        txtSubCategoryDesc.Text,
                        0,
                        0
                        ); // 0 for add

                    Get get = new Get();
                    dgvAllSubCategoriesDetails.DataSource = null;
                    dgvAllSubCategoriesDetails.DataSource = get.getAllSubCategoriesDetails();

                    this.IDToUpdate_SubCategoires = 0;


                    txtSubCategoryName.Clear();
                    txtSubCategoryDesc.Clear();
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }
        private void btnUpdate_Click(object sender, EventArgs e)
        {
            try
            {
                if (string.IsNullOrEmpty(txtSubCategoryName.Text))
                {
                    MessageBox.Show("Please Select A Record To Update By Double Clicking..");
                }
                else
                {
                    if (this.IDToUpdate_SubCategoires == 0)
                    {
                        MessageBox.Show("Please Select A Record To Update By Double Clicking..");
                        return;
                    }
                    else
                    {
                        AddUpdate update = new AddUpdate();
                        update.addUpdateSubCategories(
                            cmbCategories.Text,
                            txtSubCategoryName.Text,
                            txtSubCategoryDesc.Text,
                            this.IDToUpdate_SubCategoires,
                            1
                            ); // 1 for UDPATE

                        Get get = new Get();
                        dgvAllSubCategoriesDetails.DataSource = null;
                        dgvAllSubCategoriesDetails.DataSource = get.getAllSubCategoriesDetails();

                        this.IDToUpdate_SubCategoires = 0;
                    }
                }
            }
            catch (Exception EX)
            {
                MessageBox.Show(EX.Message);
            }
        }