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 ObservableCollection <XacNhanDangKyUser> loadPage(int pageNumber, int numItemInPage)
{
var resulf = new ObservableCollection <XacNhanDangKyUser>();
PagingInfo.ItemInPerPage = numItemInPage;
if (PagingInfo.TotalPage > 0)
{
if (pageNumber > PagingInfo.TotalPage)
{
pageNumber = 1;
}
if (pageNumber < 1)
{
pageNumber = PagingInfo.TotalPage;
}
PagingInfo.CurrentPage = pageNumber;
var list = ListDangKyUser.Skip((pageNumber - 1) * PagingInfo.ItemInPerPage).Take(PagingInfo.ItemInPerPage);
foreach (var item in list)
{
resulf.Add(item);
}
}
else
{
PagingInfo.CurrentPage = 0;
}
return(resulf);
}
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);
}
}
}
}
}
