private void btnDelete_Click(object sender, EventArgs e)
        {
            if (txtCode.Text != "")
            {
                DLDesignation objDLDesignation = new DLDesignation();

                int ID = objDLDesignation.FetchIDbyCode(txtCode.Text);

                if (ID > 0)
                {
                    if (objDLDesignation.DeleteByID(ID) > 0)
                    {
                        MessageBox.Show("Record Deleted");
                        ClearControls();
                    }
                    else
                    {
                        MessageBox.Show("Record not Deleted");
                    }
                }
                else
                {
                    MessageBox.Show("Invalid Code");
                }
            }
            else
            {
                MessageBox.Show("Invalid Code");
            }
        }