private void gvDesignation_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
        {
            if (e.ColumnIndex > 0)
            {

                string strCode = gvDesignation.Rows[e.RowIndex].Cells[e.ColumnIndex].Value.ToString();
                string designationID = gvDesignation.Rows[e.RowIndex].Cells[0].Value.ToString();

                ELDesignation objELDesignation = new ELDesignation();
                DLDesignation objDLDesignation = new DLDesignation();

                objELDesignation = objDLDesignation.FetchDesignationsByID(Convert.ToInt32(designationID));

                if (objELDesignation != null)
                {
                    lblDesignationID.Text = objELDesignation.ID.ToString();
                    txtCode.Text = objELDesignation.Code;
                    txtName.Text = objELDesignation.Name;
                    chkIsActive.Checked = Convert.ToBoolean(objELDesignation.IsActive);
                }
            }
            gvDesignation.Visible = false;
        }