private async Task LoadUsers(UsersSearchRequest request = null) { var userEntities = await _usersService.Get <List <Model.Models.User> >(request); allUsersDataGrid.AutoGenerateColumns = false; allUsersDataGrid.DataSource = userEntities; }
public ActionResult GetUserMessageList(QueryUsersConditionView conditions) { var req = new UsersSearchRequest { UserName = conditions.ContainsUserName, UserStateId = conditions.SearchUserStateId, CurrentPageIndex = conditions.CurrentPageIndex }; var resp = _adminUserService.GetSearchUsersBy(req); var resultView = new UserSeachResultView(); var allUserStateSelectedList = GetAllUserStatesSelectListDataSource();//获取所有的用户状态SelectList集合 if (resp.Succeed) { SetAllUsersStateSelectedListToViewData(allUserStateSelectedList); //设置用户状态下拉列表的数据源到ViewData resultView.Users = resp.Users; //设置显示分页数据源 resultView.PaginatorModel = new PaginatorModel { TotalPages = resp.TotalPages, CurrentPageIndex = conditions.CurrentPageIndex }; } else { return(Json(new { color = StyleConstants.RedColor, message = resp.Message }, JsonRequestBehavior.AllowGet)); } return(PartialView("ListUserMessagePartial", resultView)); }
public UsersSearchResponse GetUsersSearchResponse(UsersSearchRequest searchRequest) { int fromRow = (searchRequest.PageNo - 1) * searchRequest.PageSize; int toRow = searchRequest.PageSize; var key = searchRequest.DomainKey; Expression <Func <AspNetUser, bool> > query = s => ( searchRequest.Name == null || s.FirstName.Contains(searchRequest.Name) || s.LastName.Contains(searchRequest.Name)) && (searchRequest.Username == null || s.UserName.Contains(searchRequest.Username)) && (searchRequest.Email == null || s.Email.Contains(searchRequest.Email)) && (searchRequest.UserRole == "SystemAdministrator" && s.AspNetRoles.All(x => x.Name == "Admin") || s.AspNetRoles.All(x => x.Name == "Client") ); IEnumerable <AspNetUser> users = searchRequest.IsAsc ? DbSet .Where(query) .OrderBy(orderClause[searchRequest.OrderByColumn]) .Skip(fromRow) .Take(toRow) .ToList() : DbSet .Where(query) .OrderByDescending(orderClause[searchRequest.OrderByColumn]) .Skip(fromRow) .Take(toRow) .ToList(); return(new UsersSearchResponse { Users = users, TotalCount = DbSet.Count(query), FilteredCount = DbSet.Count(query) }); }
public IEnumerable <UserListItem> Search(UsersSearchRequest request) { // Returns IEnumerable instead IQueryable because // filter and Sorting on User Role cannot be translated to SQL //Build Query var query = _userRepo.FindAll() .AsNoTracking() .IgnoreQueryFilters() .Where(q => !q.IsDeleted); if (request.OrganizationId != null) { query = query.Where(q => q.OrganizationId == request.OrganizationId); } if (request.CustomerId != null) { query = query.Where(q => q.Customers.Any(c => c.CustomerId == (int)request.CustomerId)); } if (request.DivisionId != null) //TODO: check if query by DivisionId is correct { query = query.Where(q => q.Customers.Any(c => c.Customer.Divisions.Any(d => d.Id == (int)request.DivisionId))); } return(query.ProjectTo <UserListItem>(Mapper.ConfigurationProvider).ToList()); }
void DealWithContainsUserName(UsersSearchRequest req, IList <Func <User, bool> > ps) { if (!string.IsNullOrEmpty(req.UserName)) { ps.Add(m => m.UserName.Contains(req.UserName)); } }
void DealWithEqualsUserStateId(UsersSearchRequest req, IList <Func <User, bool> > ps) { if (req.UserStateId > 0) { ps.Add(m => m.StateId == req.UserStateId); } }
SearchUserResponse IAdminUserService.GetSearchUsersBy(UsersSearchRequest req) { var resp = new SearchUserResponse(); IEnumerable <User> users = new List <User>(); IList <Func <User, bool> > ps = new List <Func <User, bool> >(); try { DealWithContainsUserName(req, ps); DealWithEqualsUserStateId(req, ps); var numberOfResultsPrePage = ApplicationSettingsFactory.GetApplicationSettings().NumberOfResultsPrePage;//获取每页记录数 users = _userDAL.FindBy(ps, req.CurrentPageIndex, numberOfResultsPrePage); if (HasNoSearchResult(users)) { resp.Message = NoRecordsMessage; } else { resp.TotalResultCount = _userDAL.GetCountByContains(ps); resp.Users = users.ConvertToUsersInfoViewList(); resp.Succeed = true; } } catch (Exception ex) { resp.Message = "搜索用户列表信息发生错误"; Log(ex); } return(resp); }
public dynamic SearchUsersByName(DBC dbc, UsersSearchRequest request, List <string> errors) { Shared.SearchByName searchByName = new Shared.SearchByName(); string firstName = !string.IsNullOrWhiteSpace(request.FirstName) ? request .FirstName .ToLower() .Replace(" ", "") : string.Empty; string lastName = !string.IsNullOrEmpty(request.LastName) ? request .LastName .ToLower() .Replace(" ", "") : string.Empty; if (!string.IsNullOrWhiteSpace(firstName) && !string.IsNullOrWhiteSpace(lastName)) { if (dbc .Users .Where(x => x.FirstName == firstName && x.LastName == lastName) .Any()) { return(dbc .Users .Where(x => x.FirstName == firstName && x.LastName == lastName) .ToList()); } else { errors.Add($"No users found with a first name of '{request.FirstName}' and a last name of '{request.LastName}'."); return(errors); } } else if (!string.IsNullOrWhiteSpace(firstName) && string.IsNullOrWhiteSpace(lastName)) { return(searchByName.SearchEntitiesByName(dbc, "Users", "FirstName", firstName, errors)); } else if (string.IsNullOrWhiteSpace(firstName) && !string.IsNullOrWhiteSpace(lastName)) { return(searchByName.SearchEntitiesByName(dbc, "Users", "LastName", lastName, errors)); } else { errors.Add("No users found."); } return(errors); }
private async void SearchBtn_Click(object sender, EventArgs e) { var searchRequest = new UsersSearchRequest() { SearchTerm = searchTextBox.Text, ShowDisabledUsers = disabledUsersCheckBox.Checked }; await LoadUsers(searchRequest); }
private async void btnShow_Click(object sender, EventArgs e) { var search = new UsersSearchRequest() { FirstName = txtSearch.Text }; var result = await _apiService.Get <List <Model.Users> >(search); dgvUsers.AutoGenerateColumns = false; dgvUsers.DataSource = result; }
private async void btnShow_Click(object sender, EventArgs e) { UsersSearchRequest searchRequest = new UsersSearchRequest() { FirstName = txtFilter.Text, LastName = txtFilter.Text }; var list = await _userService.Get <List <Model.User> >(searchRequest); dgvUsers.DataSource = list; }
public UsersSearchResponse SearchUser(ISession session, UsersSearchRequest request) { var response = request.CreateResponse <UsersSearchResponse>(); using (var uow = UnitOfWorkFactory.Create()) { var users = uow.UsersRepository.AllMatching(UserSpecification.NameLike(request.QueryString), 20); var userDtos = users.ProjectedAsCollection <UserDto>(); response.Result = userDtos.ToArray(); } return(response); }
public dynamic GetUser(UsersSearchRequest request) { UserSearchSummary userSearchSummary = new UserSearchSummary(); if (CheckClientSecret()) { return(userSearchSummary.SearchByUser(request)); } else { return(new HttpResponseMessage(System.Net.HttpStatusCode.BadRequest)); } }
public UsersListViewModel Get([FromUri] UsersSearchRequest searchRequest) { if (searchRequest == null || !ModelState.IsValid) { throw new HttpException((int)HttpStatusCode.BadRequest, "Invalid Request"); } var response = usersService.GetAllUsers(searchRequest); return(new UsersListViewModel { Data = response.Users.Select(x => x.MapUserFromServerToClient()).ToList(), recordsFiltered = response.FilteredCount, recordsTotal = response.TotalCount }); }
public List <Model.User> GetAll(UsersSearchRequest request) { var query = _rentSiteContext.User.AsQueryable(); if (!string.IsNullOrWhiteSpace(request?.FirstName) || !string.IsNullOrWhiteSpace(request?.LastName)) { query = query.Where(x => x.FirstName == request.FirstName || x.LastName == request.LastName); } var entities = query.ToList(); var result = _mapper.Map <List <Model.User> >(entities); return(result); }
public List <Model.Users> Get(UsersSearchRequest request) { var query = _context.Users.AsQueryable(); if (!string.IsNullOrWhiteSpace(request?.FirstName)) { query = query.Where(x => x.FirstName.StartsWith(request.FirstName)); } if (!string.IsNullOrWhiteSpace(request?.LastName)) { query = query.Where(x => x.LastName.StartsWith(request.LastName)); } var list = query.ToList(); return(_mapper.Map <List <Model.Users> >(list)); }
public List <Model.Users> Get(UsersSearchRequest request) { var query = _context.Users.AsQueryable(); if (!string.IsNullOrWhiteSpace(request?.Search)) { query = query.Where(x => x.Username.Contains(request.Search) || x.Email.Contains(request.Search) || x.Name.Contains(request.Search) || x.LastName.Contains(request.Search) ); } query = query.Include(x => x.Role); var list = query.ToList(); return(_mapper.Map <List <Model.Users> >(list)); }
public async Task <IWrappedResponse> All(UsersSearchRequest request) { var actions = new List <ResourceAction>(); var resourceType = PermissionResourceType.Organization; var referenceId = 0; if (request.OrganizationId != null) { referenceId = (int)request.OrganizationId; resourceType = PermissionResourceType.Organization; actions = Common.Enumerations.ResourceActions.Organization.Admin .Union(Common.Enumerations.ResourceActions.Organization.Standard).Distinct().ToList(); } else if (request.CustomerId != null) { referenceId = (int)request.CustomerId; resourceType = PermissionResourceType.Customer; actions = Common.Enumerations.ResourceActions.Customer.Admin .Union(Common.Enumerations.ResourceActions.Customer.Standard).Distinct().ToList(); } else if (request.DivisionId != null) { referenceId = (int)request.DivisionId; resourceType = PermissionResourceType.Division; actions = Common.Enumerations.ResourceActions.Customer.Admin .Union(Common.Enumerations.ResourceActions.Customer.Standard).Distinct().ToList(); } else { return(Failed <IEnumerable <GroupPermission> >()); } var permissions = actions.Select(action => new GroupPermission() { Action = action.ToString(), Resource = resourceType, ReferenceId = referenceId }).AsEnumerable(); return(Ok(permissions)); }
public async Task <List <User> > Get(UsersSearchRequest search) { var query = _context.Users.Include(x => x.UserRoles).ThenInclude(x => x.Role).AsQueryable(); if (search.ShowDisabledUsers) { query = query.Where(user => user.Archived); } if (!string.IsNullOrEmpty(search.SearchTerm)) { string term = search.SearchTerm; query = query.Where(user => (user.FirstName.StartsWith(term) || user.FirstName.Contains(term)) || (user.LastName.StartsWith(term) || user.LastName.Contains(term)) || (user.Email.StartsWith(term) || user.Email.Contains(term)) || (user.Username.StartsWith(term) || user.Username.Contains(term))); } var entities = await query.ToListAsync(); return(_mapper.Map <List <Model.Models.User> >(entities)); }
//[HasPermission(typeof(CanReadVoucherRequirement))] TODO User management Permissions public Task <ActionResult <IEnumerable <GroupPermission> > > All([FromQuery] UsersSearchRequest request) { return(this._permissionsService.All(request).Convert <IEnumerable <GroupPermission> >(this)); }
public ActionResult <IList <Model.User> > GetAll([FromQuery] UsersSearchRequest request) { return(_userService.GetAll(request)); }
public async Task <IWrappedResponse> All(UsersSearchRequest request) { var query = Search(request); return(Ok(query.AsEnumerable <UserListItem>())); }
public UsersSearchResponse GetAllUsers(UsersSearchRequest searchRequest) { return(userRepository.GetUsersSearchResponse(searchRequest)); }
public Task <UsersSearchResponse> SearchUser(UsersSearchRequest request) { return(ConnectionManager.SendRequestAndWaitResponse <UsersSearchResponse>(request)); }
//[HasPermission(typeof(CanReadVoucherRequirement))] TODO User management Permissions public Task <ActionResult <IEnumerable <UserListItem> > > All([FromQuery] UsersSearchRequest request) { return(this._userService.All(request).Convert <IEnumerable <UserListItem> >(this)); }
//[HasPermission(typeof(CanReadVoucherRequirement))] TODO User management Permissions public object Get([FromQuery] UsersSearchRequest request, DataSourceLoadOptions loadOptions) { return(DataSourceLoader.Load(_userService.Search(request), loadOptions)); }
public async Task <List <Model.Models.User> > Get([FromQuery] UsersSearchRequest request) { return(await _service.Get(request)); }
public dynamic SearchByUser(UsersSearchRequest request) { SearchByID searchByID = new SearchByID(); SearchByName searchByName = new SearchByName(); SearchByRegion searchByRegion = new SearchByRegion(); SearchBySubscriptionType searchBySubscriptionType = new SearchBySubscriptionType(); SearchByActiveSubscription searchByActiveSubscription = new SearchByActiveSubscription(); List <string> errors = new List <string>(); List <User> matchedUsers = new List <User>(); DBC dbc = DBC.DatabaseConnection(); if (!string.IsNullOrEmpty(request.UserID)) { return(searchByID.SearchEntitiesByID(dbc, "Users", request.UserID, errors)); } if (!string.IsNullOrWhiteSpace(request.FirstName) || !string.IsNullOrWhiteSpace(request.LastName)) { var result = searchByName.SearchUsersByName(dbc, request, errors); if (result.GetType() == typeof(List <User>)) { matchedUsers = result; } else { foreach (string error in (List <string>)result) { errors.Add(error); } } } if (!string.IsNullOrWhiteSpace(request.Region)) { var result = searchByRegion.SearchUsersByRegion(dbc, request.Region, errors, matchedUsers); if (result.GetType() == typeof(List <User>)) { matchedUsers = result; } else { foreach (string error in (List <string>)result) { errors.Add(error); } } } if (!string.IsNullOrWhiteSpace(request.SubscriptionType)) { var result = searchBySubscriptionType .SearchUsersBySubscriptionType(dbc, request.SubscriptionType, errors, matchedUsers); if (result.GetType() == typeof(List <User>)) { matchedUsers = result; } else { foreach (string error in (List <string>)result) { errors.Add(error); } } } if (request.ActiveSubscription != null) { var result = searchByActiveSubscription .SearchUsersByActiveSubscription(dbc, request.ActiveSubscription, errors, matchedUsers); if (result.GetType() == typeof(List <User>)) { List <UserDTO> userDTOs = new List <UserDTO>(); foreach (User user in result) { userDTOs.Add(new UserDTO(user, dbc)); } return(userDTOs); } else { matchedUsers = new List <User>(); errors = result; } } if (matchedUsers.Any()) { List <UserDTO> userDTOs = new List <UserDTO>(); foreach (User user in matchedUsers) { userDTOs.Add(new UserDTO(user, dbc)); } return(userDTOs); } else if (errors.Any()) { return(errors); } else { return(new NoParameterUserResponse("No users found. Please check your request for validity against the fields below.")); } }