public void LoadData()
        {
            using (DBQuanLiHoiNghiEntities db = new DBQuanLiHoiNghiEntities())
            {
                SucChua = (from dd in db.DIADIEMTOCHUCs
                           where dd.IDDD == HoiNghi.IDDD
                           select dd).First().SUCCHUA;

                var ListUser = db.USERs;

                this.ListDangKyUser = new ObservableCollection <XacNhanDangKyUser>();


                foreach (var user in ListUser)
                {
                    foreach (var dangKy in db.DANGKITHAMGIAs)
                    {
                        if (dangKy.IDUSER == user.IDUSER && dangKy.IDHN == HoiNghi.IDHN)
                        {
                            if (user.HINHANH != string.Empty)
                            {
                                user.HINHANH = Path.GetFullPath(user.HINHANH);
                            }
                            else
                            {
                                user.HINHANH = Path.GetFullPath("Images/user_example.png");
                            }
                            XacNhanDangKyUser capQuyenUser = new XacNhanDangKyUser(user, dangKy, HoiNghi, SucChua);
                            ListDangKyUser.Add(capQuyenUser);
                        }
                    }
                }
            }
        }
        public void LoadDataByNameAndEmail(string name, string email)
        {
            using (DBQuanLiHoiNghiEntities db = new DBQuanLiHoiNghiEntities())
            {
                string sql      = "select* from [QuanLiHoiNghi].[dbo].[USER] ";
                string sqlName  = $" freetext(TENUSER, N'%{name}%')";
                string sqlEmail = $" EMAIL like N'%{email}%'";

                if (name != "" && email != "")
                {
                    sql += "where" + sqlName + "and" + sqlEmail;
                }
                else if (name != "")
                {
                    sql += "where" + sqlName;
                }
                else if (email != "")
                {
                    sql += "where" + sqlEmail;
                }

                var ListUser = db.USERs.SqlQuery(sql);

                this.ListDangKyUser = new ObservableCollection <XacNhanDangKyUser>();

                foreach (var user in ListUser)
                {
                    foreach (var dangKy in db.DANGKITHAMGIAs)
                    {
                        if (dangKy.IDUSER == user.IDUSER && dangKy.IDHN == HoiNghi.IDHN)
                        {
                            if (user.HINHANH != string.Empty)
                            {
                                user.HINHANH = Path.GetFullPath(user.HINHANH);
                            }
                            else
                            {
                                user.HINHANH = Path.GetFullPath("Images/user_example.png");
                            }
                            XacNhanDangKyUser capQuyenUser = new XacNhanDangKyUser(user, dangKy, HoiNghi, SucChua);
                            ListDangKyUser.Add(capQuyenUser);
                        }
                    }
                }
            }
        }