public MessageModel <List <UserAdminListDTO> > GetUserFilterList(UserFilterListRequest request) { List <UserAdminListDTO> userList = userAdminService.GetUserFilterList(request); return(new MessageModel <List <UserAdminListDTO> > { Data = userList }); }
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); }