//--------------------------------------------------------------//
        //                            DIVISION                          //
        //--------------------------------------------------------------//


        //ADD NEW DIVISION
        private void AddDivision()
        {
            try
            {
                if (String.IsNullOrWhiteSpace(txtDivisioin.Text) || String.IsNullOrWhiteSpace(txtDeportId.Text))
                {
                    MessageBox.Show("Please enter division name and deport id!", "Division  Add", MessageBoxButtons.OK, MessageBoxIcon.Error);
                }
                else
                {
                    objSetting = new SettingClassBLL();
                    if (objSetting.DivivisionExist(txtDivisioin.Text) == false)
                    {
                        objSetting = new SettingClassBLL()
                        {
                            division = txtDivisioin.Text,
                            deportId = txtDeportId.Text
                        };

                        //ADD DIVISION
                        objSetting.AddNewDivision();
                        MessageBox.Show("Added Successfully!", "Division Add", MessageBoxButtons.OK, MessageBoxIcon.Information);
                        LoadDivisionDatas();
                        DeafultValueAddToStock(); //STOCK DEFAULT DATA INSERTING
                        ClearTextBoxces();        //CLEAR ALL TEXBOX AND COMBOBOX
                    }
                    else
                    {
                        MessageBox.Show("Division exist!", "Division Add", MessageBoxButtons.OK, MessageBoxIcon.Error);
                        ClearTextBoxces();//CLEAR ALL TEXBOX AND COMBOBOX
                    }
                }
                btnAddDivision.Text = "Add";
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message, "Division Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
        }
 //DIVISION DATA UPDATE
 private void UpdateDivision()
 {
     try
     {
         if (String.IsNullOrWhiteSpace(txtDivisioin.Text) || String.IsNullOrWhiteSpace(txtDeportId.Text))
         {
             MessageBox.Show("Please enter division name!", "Division  Update", MessageBoxButtons.OK, MessageBoxIcon.Error);
         }
         else
         {
             objSetting = new SettingClassBLL();
             if (objSetting.DivivisionExist(txtDivisioin.Text) == false)
             {
                 //UPDATE DIVISION
                 objSetting = new SettingClassBLL()
                 {
                     division    = txtDivisioin.Text,
                     oldDivision = dgvDivision.CurrentRow.Cells[0].Value.ToString(),
                     deportId    = txtDeportId.Text
                 };
                 objSetting.UpdateDivision();
                 MessageBox.Show("Division Update successfully!", "Division Update", MessageBoxButtons.OK, MessageBoxIcon.Information);
                 LoadDivisionDatas();
                 ClearTextBoxces();//CLEAR ALL TEXBOX AND COMBOBOX
             }
             else
             {
                 MessageBox.Show("Division exist!", "Division Add", MessageBoxButtons.OK, MessageBoxIcon.Error);
                 ClearTextBoxces();//CLEAR ALL TEXBOX AND COMBOBOX
             }
             ClearTextBoxces();
             btnAddDivision.Text = "Add";
         }
     }
     catch (Exception ex)
     {
         MessageBox.Show(ex.Message, "Division Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
     }
 }