private void btnAdd_Click(object sender, EventArgs e)
        {
            try
            {
                if (
                    string.IsNullOrEmpty(txtCustomerName.Text)
                    )
                {
                    MessageBox.Show("Please Enter Information In All The Fields With '*' ..");
                }
                else
                {
                    AddUpdate add = new AddUpdate();
                    add.addUpdateCustomerDetails(
                        txtCustomerName.Text,
                        txtAddress.Text,
                        txtFaxNumber.Text,
                        txtRemarks.Text,
                        txtCustomerCOde.Text,
                        txtCity.Text,
                        txtAddress2.Text,
                        txtMobileNO.Text,
                        txtEmailID.Text,
                        0,
                        0                       // ADD
                        );

                    MessageBox.Show("Data Added");



                    txtCustomerName.Clear();
                    txtAddress.Clear();
                    txtFaxNumber.Clear();
                    txtRemarks.Clear();
                    txtCustomerCOde.Clear();
                    txtCity.Clear();
                    txtAddress2.Clear();
                    txtMobileNO.Clear();
                    txtEmailID.Clear();


                    Get get = new Get();
                    dgvAllCustomerDetails.DataSource = null;
                    dgvAllCustomerDetails.DataSource = get.getAllCustomerDetails();


                    this.idToUpdate = 0;
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }
        private void btnUpdate_Click(object sender, EventArgs e)
        {
            try
            {
                if (
                    string.IsNullOrEmpty(txtCustomerName.Text)
                    )
                {
                    MessageBox.Show("Select Record By Double Clicking..");
                }
                else
                {
                    AddUpdate add = new AddUpdate();
                    add.addUpdateCustomerDetails(
                        txtCustomerName.Text,
                        txtAddress.Text,
                        txtFaxNumber.Text,
                        txtRemarks.Text,
                        txtCustomerCOde.Text,
                        txtCity.Text,
                        txtAddress2.Text,
                        txtMobileNO.Text,
                        txtEmailID.Text,
                        this.idToUpdate,
                        1                       // UPDATE
                        );

                    MessageBox.Show("Data Updated");
                    txtCustomerName.Clear();
                    txtAddress.Clear();
                    txtFaxNumber.Clear();
                    txtRemarks.Clear();
                    txtCustomerCOde.Clear();
                    txtCity.Clear();
                    txtAddress2.Clear();
                    txtMobileNO.Clear();
                    txtEmailID.Clear();


                    Get get = new Get();
                    dgvAllCustomerDetails.DataSource = null;
                    dgvAllCustomerDetails.DataSource = get.getAllCustomerDetails();


                    this.idToUpdate = 0;
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }