protected void m_grid_RowCommand(object sender, GridViewCommandEventArgs e)
        {
            try
            {
                string commandName = e.CommandName;
                GridViewRow row = m_grid.FooterRow;
                if (commandName == "Insert")
                {
                    clsPhongBan objPhongBan= new clsPhongBan();

                    string TenPhongBanCha = ((DropDownList)row.FindControl("txtIPhongBanCha")).Text;

                    string TenDonVi = ((DropDownList)row.FindControl("txtIDonVi")).Text;
                    string TenPhongBan = ((TextBox)row.FindControl("txtITenPhongBan")).Text;
                    string DiaChi = ((TextBox)row.FindControl("txtIDiaChi")).Text;
                    string ChucDanhPhuTrach = ((TextBox)row.FindControl("txtIChucDanhPhuTrach")).Text;
                    string NhanVienPhuTrach = ((DropDownList)row.FindControl("txtITenDayDu")).Text;

                    objPhongBan.PhongBan_Parent_Id = TenPhongBanCha;
                    objPhongBan.DonVi_Id = TenDonVi;
                    objPhongBan.TenPhongBan = TenPhongBan;
                    objPhongBan.DiaChi = DiaChi;
                    objPhongBan.NhanVien_PhuTrach_Id = NhanVienPhuTrach;
                    objPhongBan.ChucDanhPhuTrach = ChucDanhPhuTrach;

                    int _result = objPhongBan.Insert();
                    if (_result >= 1)
                    {
                        ltlAnnouncement.Text = "Thêm mới phòng ban '" + TenPhongBan + "' thành công!";
                    }
                    if (_result == -1)
                    {
                        ltlAnnouncement.Text = "Phòng ban '" + TenPhongBan + "' đã tồn tại, bạn nên kiểm tra lại!";
                    }
                    if (_result == 0)
                    {
                        ltlAnnouncement.Text = "Có lỗi trong quá trình thêm mới!";
                    }
                    bindData(-1);
                }
            }
            catch (Exception ex)
            {
                ltlAnnouncement.Text = "Khong them moi duoc du lieu. Vui long lien he voi quan tri<br>" + ex.Message;
            }
        }
        protected void m_grid_RowDeleting(object sender, GridViewDeleteEventArgs e)
        {
            try
            {
                int id = e.RowIndex;
                m_grid.EditIndex = id;

                Guid delId = new Guid(m_grid.DataKeys[e.RowIndex].Value.ToString());
                if (m_grid.DataKeys[e.RowIndex].Value.ToString() != "")
                {
                    clsPhongBan objPhongBan = new clsPhongBan();
                    objPhongBan.PhongBan_Id= m_grid.DataKeys[e.RowIndex].Value.ToString();
                    int status_Delete = objPhongBan.Delete();
                    if (status_Delete == 1)
                    {
                        ltlAnnouncement.Text = "Xóa thành công phòng ban!";
                    }
                    if (status_Delete <= 0)
                    {
                        ltlAnnouncement.Text = "Không xóa được phòng ban đã chọn.";
                    }
                }
            }
            catch (Exception ex)
            {
                ltlAnnouncement.Text = "Lỗi trong quá trình xóa nhóm người dùng: " + ex.ToString();
            }
            bindData(-1);
        }
        private void bindData(int index)
        {
            try
            {
                //LAY DANH SACH CAC QUOC GIA RA

                clsPhongBan objPhongBan = new clsPhongBan();
                dsGroup = objPhongBan.Select();
                objPhongBan.PhongBan_Id= "0";

                m_grid.EditIndex = index;
                m_grid.DataSource = dsGroup;
                bool add = false;
                if (dsGroup.Rows.Count <= 0)
                {
                    dsGroup.Rows.Add(dsGroup.NewRow());
                    add = true;

                }
              //
                m_grid.DataBind();
                if(add)
                    m_grid.Rows[0].Visible = false;
                if (m_grid.Rows.Count > 0)
                {
                    string confirm = "return confirm('Bạn thật sự muốn xóa row này?')";

                    for (int i = 0; i < m_grid.Rows.Count; i++)
                    {
                        GridViewRow row = m_grid.Rows[i];
                        LinkButton lbutton1 = (LinkButton)row.FindControl("cmdDelete");
                        if (lbutton1 != null)
                        {
                            lbutton1.Visible = D_Option;
                            lbutton1.Attributes.Add("onclick", confirm);
                            //lbutton1.Enabled = D_Option;
                        }

                        LinkButton lbutton2 = (LinkButton)row.FindControl("cmdEdit");
                        if (lbutton2 != null)
                            lbutton2.Visible = U_Option;
                    }
                }

                //XET QUYETN CHO CHUC NANG INSERT
                GridViewRow row1 = m_grid.FooterRow;
                if (row1 != null)
                {
                    row1.Visible = I_Option;
                }
            }
            catch (Exception ex)
            {
            }
        }
        protected void m_grid_RowUpdating(object sender, GridViewUpdateEventArgs e)
        {
            try
            {
                int id = e.RowIndex;
                m_grid.EditIndex = id;
                GridViewRow row = m_grid.Rows[id];
                string TenPhongBanCha= ((DropDownList)row.FindControl("txtUPhongBanCha")).Text;

                string TenDonVi = ((DropDownList)row.FindControl("txtUDonVi")).Text;
               string TenPhongBan = ((TextBox)row.FindControl("txtUTenPhongBan")).Text;
               string DiaChi = ((TextBox)row.FindControl("txtUDiaChi")).Text;
               string ChucDanhPhuTrach = ((TextBox)row.FindControl("txtUChucDanhPhuTrach")).Text;
               string NhanVienPhuTrach= ((DropDownList)row.FindControl("txtUTenDayDu")).Text;

              //  short updateId = Int16.Parse(m_grid.DataKeys[id].Value.ToString());
                if (m_grid.DataKeys[id].Value.ToString()!= "")
                {
                    clsPhongBan objPhongBan = new clsPhongBan();

                    objPhongBan.PhongBan_Id = m_grid.DataKeys[id].Value.ToString();
                    objPhongBan.PhongBan_Parent_Id = TenPhongBanCha;
                    objPhongBan.DonVi_Id = TenDonVi;
                    objPhongBan.TenPhongBan = TenPhongBan;
                    objPhongBan.DiaChi = DiaChi;
                    objPhongBan.NhanVien_PhuTrach_Id = NhanVienPhuTrach;
                    objPhongBan.ChucDanhPhuTrach= ChucDanhPhuTrach;

                    int _result = objPhongBan.Update();
                    if (_result == 1)
                    {
                        ltlAnnouncement.Text = "Sửa phòng ban '" + TenPhongBan + "' thành công!";
                    }
                    if (_result < 0)
                    {
                        ltlAnnouncement.Text = "Có lỗi trong quá trình sửa phòng ban!";
                    }
                }
            }
            catch (Exception ex)
            {
                ltlAnnouncement.Text = "Khong cap nhat duoc du lieu. Vui long lien he voi quan tri<br>" + ex.Message;
            }

            bindData(-1);
        }