public List <UserAdminListDTO> GetUserFilterList(UserFilterListRequest request)
{
var resList = from u in dbContext.User
join a in dbContext.UserArc on u.Id equals a.UserId
join r in dbContext.UserRegisterType on u.Id equals r.UserId
select new { u.Id, a.ArcName, a.ArcNo, a.KycStatus, u.Level, r.RegisterTime };
resList = resList.Where(x => x.ArcName.Contains(request.Name) && x.ArcNo.Contains(request.ArcNo) &&
(TimeUtil.LongSpanToUtcDateTime(request.RegisterStartTime) <= x.RegisterTime) &&
(TimeUtil.LongSpanToUtcDateTime(request.RegisterEndTime) >= x.RegisterTime));
if (request.KycFormal || request.KycUnderReview || request.KycDraft || request.KycDisabled || request.LevelNormal ||
request.LevelVIP || request.LevelRisk)
{
resList = resList.Where(x => (request.KycFormal && (x.KycStatus == (short)KycStatusEnum.PASSED_KYC_FORMAL_MEMBER)) ||
(request.KycUnderReview && (x.KycStatus == (short)KycStatusEnum.WAITING_VERIFIED_KYC)) ||
(request.KycDraft && (x.KycStatus == (short)KycStatusEnum.DRAFT_MEMBER)) ||
(request.KycDisabled && (x.KycStatus == (short)KycStatusEnum.FAILED_KYC)) ||
(request.LevelNormal && (x.Level == (short)UserLevelEnum.NORMAL)) ||
(request.LevelVIP && (x.Level == (short)UserLevelEnum.VIP)) ||
(request.LevelRisk && (x.Level == (short)UserLevelEnum.RISK)));
}
List <UserAdminListDTO> userList = new List <UserAdminListDTO>();
foreach (var res in resList)
{
UserAdminListDTO dto = new UserAdminListDTO
{
Id = (int)res.Id,
Name = res.ArcName,
ArcNo = res.ArcNo,
KycStatus = res.KycStatus,
Level = res.Level,
RegisterTime = res.RegisterTime
};
userList.Add(dto);
}
return(userList);
}
public List <UserAdminListDTO> GetUserList()
{
var resList = from u in dbContext.User
join a in dbContext.UserArc on u.Id equals a.UserId
join r in dbContext.UserRegisterType on u.Id equals r.UserId
select new { u.Id, a.ArcName, a.ArcNo, a.KycStatus, u.Level, r.RegisterTime };
List <UserAdminListDTO> userList = new List <UserAdminListDTO>();
foreach (var res in resList)
{
UserAdminListDTO dto = new UserAdminListDTO
{
Id = (int)res.Id,
Name = res.ArcName,
ArcNo = res.ArcNo,
KycStatus = (short)res.KycStatus,
Level = res.Level,
RegisterTime = res.RegisterTime
};
userList.Add(dto);
}
return(userList);
}
