public ImageController(UserFilters uf, OssObjectSet OssObjectSet, BaiDuApiHelper BaiDuApiHelper, SqlHelper sqlhelper) { this.uf = uf; this.ossObjectSet = OssObjectSet; this.baiDuApiHelper = BaiDuApiHelper; this.SQLHelper = sqlhelper; }
/// <summary> /// 分页搜索 /// </summary> /// <param name="filters">查询过滤参数</param> /// <returns></returns> public async Task <PagedResult <UserDto> > SearchAsync(UserFilters filters) { if (filters == null) { return(new PagedResult <UserDto>(1, 0)); } var query = _context.Users.AsQueryable(); if (filters.keywords.IsNotBlank()) { query = query.Where(x => x.LoginName.Contains(filters.keywords) || x.RealName.Contains(filters.keywords)); } return(await query.OrderByDescending(x => x.CreateDateTime) .Select(x => new UserDto { Id = x.Id, LoginName = x.LoginName, RealName = x.RealName, Email = x.Email, DepartmentName = x.Department.FullName, IsSuperMan = x.IsSuperMan, CreateDateTime = x.CreateDateTime }).PagingAsync(filters.page, filters.rows)); }
public ConsumerDealService(DealLocatorDbContext context) { _context = context; _deals = new List <Deal>(); _filteredDeals = new List <FilterDeal>(); UserFilters = new UserFilters(); }
private async Task CreateMap() { UserFilters = await GetLocation(); await GetDeals(); //Map.Pins = Pins; //foreach (var item in Pins) //{ // Map.Pins.Add(item); //} var pin = new CustomPin { Type = PinType.Generic, Position = new Position(UserFilters.Location.Latitude, UserFilters.Location.Longitude), Label = "Your Position", Address = "" }; // CustomPins.Add(pin); Map.Pins.Add(pin); Map.MoveToRegion(MapSpan.FromCenterAndRadius(new Position(UserFilters.Location.Latitude, UserFilters.Location.Longitude), Distance.FromMiles(5))); }
/// <summary> /// Searches for a filter implementation in the known <see cref="PhpFilter"/> descendants. /// </summary> /// <param name="filter">The name of the filter (may contain wildcards).</param> /// <param name="instantiate"><c>true</c> to fille <paramref name="instance"/> with a new instance of that filter.</param> /// <param name="instance">Filled with a new instance of an implemented filter if <paramref name="instantiate"/>.</param> /// <param name="parameters">Additional parameters for the filter.</param> /// <returns><c>true</c> if a filter with the given name was found.</returns> internal static bool GetFilter(string filter, bool instantiate, out PhpFilter instance, object parameters) { instance = null; foreach (IFilterFactory factory in systemFilters) { if (factory.GetImplementedFilter(filter, instantiate, out instance, parameters)) { if (instance != null) { instance.FilterName = filter; } return(true); } } // Note: the registered filter names may be wildcards - use fnmatch. if ((UserFilters != null) && (UserFilters.Contains(filter))) { if (instantiate) { // EX: [PhpFilter.GetFilter] create a new user filter; and support the WILDCARD naming too. } return(true); } return(false); }
/// <summary> /// 分页搜索 /// </summary> /// <param name="filters">查询过滤参数</param> /// <returns></returns> public async Task <PagedResult <UserDto> > Search(UserFilters filters) { if (filters == null) { return(new PagedResult <UserDto>(1, 0)); } using (var scope = _dbContextScopeFactory.CreateReadOnly()) { var db = scope.DbContexts.Get <JuCheapContext>(); var query = db.Users .WhereIf(filters.keywords.IsNotBlank(), x => x.LoginName.Contains(filters.keywords) || x.RealName.Contains(filters.keywords)); return(await query.OrderByCustom(filters.sidx, filters.sord) .Select(x => new UserDto { Id = x.Id, LoginName = x.LoginName, RealName = x.RealName, Email = x.Email, CreateDateTime = x.CreateDateTime, DepartmentName = x.Department != null ? x.Department.FullName : string.Empty }).PagingAsync(filters.page, filters.rows)); } }
/// <summary> /// 分页搜索 /// </summary> /// <param name="filters">查询过滤参数</param> /// <returns></returns> public async Task <PagedResult <UserDto> > SearchAsync(UserFilters filters) { if (filters == null) { return(new PagedResult <UserDto>(1, 0)); } var query = _context.Users.Where(item => !item.IsDeleted); if (filters.keywords.IsNotBlank()) { query = query.Where(item => item.LoginName.Contains(filters.keywords) || item.RealName.Contains(filters.keywords)); } return(await query.OrderByDescending(item => item.CreateDateTime) .Select(item => new UserDto { Id = item.Id, LoginName = item.LoginName, RealName = item.RealName, Email = item.Email, CreateDateTime = item.CreateDateTime }).PagingAsync(filters.page, filters.rows)); }
/// <summary> /// 分页搜索 /// </summary> /// <param name="filters">查询过滤参数</param> /// <returns></returns> public async Task <PagedResult <UserDto> > SearchAsync(UserFilters filters) { if (filters == null) { return(new PagedResult <UserDto>(1, 0)); } using (var scope = _dbContextScopeFactory.CreateReadOnly()) { var db = scope.DbContexts.Get <JuCheapContext>(); var dbSet = db.Set <UserEntity>(); var query = dbSet.Where(item => !item.IsDeleted); if (filters.keywords.IsNotBlank()) { query = query.Where(item => item.LoginName.Contains(filters.keywords) || item.RealName.Contains(filters.keywords)); } return(await query.OrderBy(item => item.CreateDateTime) .Select(item => new UserDto { Id = item.Id, LoginName = item.LoginName, RealName = item.RealName, Email = item.Email, CreateDateTime = item.CreateDateTime }).PagingAsync(filters.page, filters.rows)); } }
public HttpResponseMessage GetUsers(string searchText, UserFilters filter, int pageIndex, int pageSize, string sortColumn, bool sortAscending) { try { int totalRecords; var getUsersContract = new GetUsersContract { SearchText = searchText, PageIndex = pageIndex, PageSize = pageSize, SortColumn = sortColumn, SortAscending = sortAscending, PortalId = PortalController.GetEffectivePortalId(PortalId), Filter = filter }; var results = Components.UsersController.Instance.GetUsers(getUsersContract, UserInfo.IsSuperUser, out totalRecords); var response = new { Results = results, TotalResults = totalRecords }; return(Request.CreateResponse(HttpStatusCode.OK, response)); } catch (Exception ex) { Logger.Error(ex); return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ex.Message)); } }
private async void buttonFilter_Click(object sender, EventArgs e) { var filters = new UserFilters(); filters.Username = textUsername.Text; filters.Email = textEmail.Text; await LoadUsers(filters); }
public async Task <List <DealDTO> > GetDeals(UserFilters userFilters) { UserFilters = userFilters; await FilterDealsByCategory(); ConvertToLocationDTO(); return(await CheckConsumerIsInRange()); }
private static bool AllTrue(UserFilters condition, AzureUser user) { foreach (UserFilters t in condition.GetInvocationList()) { if (!t(user)) { return(false); } } return(true); }
private async Task LoadUsers(UserFilters filters = null) { try { var users = await http.Get <List <UserView> >(filters); usersGrid.DataSource = users; } catch (Exception ex) { MessageBox.Show(ex.Message, "Error"); } }
private static List <AzureUser> GetFiltered(this List <AzureUser> users, UserFilteringParams filters) { UserFilters condition = null; if (!string.IsNullOrEmpty(filters.Status)) { condition += (AzureUser user) => FilterUserByStatus(user, filters.Status); } if (filters.Role != null && filters.Role.Any()) { condition += (AzureUser user) => filters.Role.Select(role => role.ToLower()).Contains(user.Role?.ToLower()); } if (filters.State != null && filters.State.Any()) { condition += (AzureUser user) => filters.State.Select(state => state.ToLower()).Contains(user.State?.ToLower()); } if (filters.City != null && filters.City.Any()) { condition += (AzureUser user) => filters.City.Select(city => city.ToLower()).Contains(user.City?.ToLower()); } if (filters.UserName != null) { condition += (AzureUser user) => user.DisplayName.ToLower().Contains(filters.UserName.ToLower()); } if (filters.UsersId != null && filters.UsersId.Any()) { condition += (AzureUser user) => filters.UsersId.Contains(user.ObjectId); } if (filters.CompanyId != null && filters.CompanyId.Any()) { condition += (AzureUser user) => filters.CompanyId.Contains(user.CompanyId?.ToLower()); } if (filters.BranchesId != null && filters.BranchesId.Any()) { condition += (AzureUser user) => user.BranchId.HasValue ? filters.BranchesId.Contains(user.BranchId.Value) : false; } if (condition != null) { return(users.Where(user => AllTrue(condition, user)).ToList()); } return(users); }
public async static Task <List <DealDTO> > GetDeals(UserFilters userFilters) { HttpClient httpClient = GetClient(); string APiUrl = ""; APiUrl += $"?lat={userFilters.Location.Latitude}&"; APiUrl += $"lon={userFilters.Location.Longitude}&"; APiUrl += $"range={userFilters.Range}&"; APiUrl += $"category={userFilters.Category}"; string response = await httpClient.GetStringAsync(APiUrl); return(JsonConvert.DeserializeObject <List <DealDTO> >(response)); }
public static UserFilters Insert(int formID, int userID, string filter, string filterDescription) { using(GRASPEntities db = new GRASPEntities()) { UserFilters newUF = new UserFilters(); newUF.UserFilterCreateDate = DateTime.Now; newUF.UserFilterIsEnabled = 1; newUF.UserFilterString = filter; newUF.UserFilterDescription = filterDescription; newUF.formID = formID; newUF.userID = userID; db.UserFilters.Add(newUF); db.SaveChanges(); return newUF; } }
/// <summary> /// Registers a user stream filter. /// </summary> /// <param name="filter">The name of the filter (may contain wildcards).</param> /// <param name="classname">The PHP user class (derived from <c>php_user_filter</c>) implementing the filter.</param> /// <returns><c>true</c> if the filter was succesfully added, <c>false</c> if the filter of such name already exists.</returns> public static bool AddUserFilter(string filter, string classname) { // Note: have to check for wildcard conflicts too (?) PhpFilter instance; if (GetFilter(filter, false, out instance, null)) { // EX: [PhpFilter.Register] stringtable - filter already exists, check the filter name string? return(false); } // Check the given filter for validity? UserFilters.Add(filter, classname); return(true); }
//CRUDowe operacje: //Add <- Przez AccountService //GetPaged (Read) //GetById //Update <- tylko dla wlasnego konta, bez pol do authentyfikacji //Delete <- brak mozliwosci usuniecia konta //TODO dodac walidacje otzrymywanego modelu przed wykonaniem serwisu //wejscie na strone Index wyswietli wszystkich uzytkownikow i pozwoli ich sortowac filtrowac i kilknac w guzik zobacz... public WResult <UserIndexModel> GetPaged(UserFilters filters) { using (var uow = new UnitOfWork()) { var users = uow.Users.GetPage(filters); var userPage = new UserIndexModel() { Users = UsersMapper.Default.Map <List <UserInfoModel> >(users), Filters = filters }; uow.Complete(); return(new WResult <UserIndexModel>(ValidationStatus.Succeded, errors: null, userPage)); } }
public async Task <IActionResult> GetListWithKeywords(UserFilters filters) { filters.page = 1; filters.rows = 10; //客服权限只能搜索开发者 if (User.Identity.HaveServiceRight()) { filters.DepartmentIdList = new List <string> { "3137bf53a9d140ef90a663113fea5406" }; //开发部门id } var result = await _userService.SearchAsync(filters); return(Json(new { value = result.rows })); }
public async Task <ActionResult> GetUsers(string q) { var filter = new UserFilters { page = 1, rows = 1000, keywords = q }; var result = await _userService.SearchAsync(filter); var users = new { results = result.rows.Select(x => new { id = x.Id, text = x.LoginName }) }; return(Json(users)); }
public IEnumerable <User> GetAll(UserFilters filters) { var query = _db.Users.AsQueryable(); if (!string.IsNullOrWhiteSpace(filters.Email) && !string.IsNullOrWhiteSpace(filters.Username)) { query = query.Where(x => (x.Email == filters.Email) || (x.Username == filters.Username)); } else if (!string.IsNullOrWhiteSpace(filters.Email)) { query = query.Where(x => x.Email == filters.Email); } else if (!string.IsNullOrWhiteSpace(filters.Username)) { query = query.Where(x => x.Username == filters.Username); } return(query.ToList()); }
public async Task <UserPaginationViewModel> GetByPage( UserFilters filters, int currentPage, int pageSize, string orderByPropertyName, bool isAsc) { var specifications = new UserSpecifications(filters.TrueName, filters.Gender, filters.IsEnabled); var users = await _userRepository.GetAll().Where(specifications.Expression) .SortByProperty(orderByPropertyName, isAsc) .Skip(pageSize * (currentPage - 1)) .Take(pageSize).ToListAsync(); var total = _userRepository.GetAll().Where(specifications.Expression).Count(); var results = users.Select(x => _mapper.Map <UserPageViewModel>(x)).ToList(); return(new UserPaginationViewModel(results, currentPage, pageSize, total)); }
public async Task Should_Return_List_Of_Deals_Meeting_Filter_Requirements() { //Arrange var filters = new UserFilters() { Category = 0, Location = new LocationDTO() { Latitude = 51.692, Longitude = -3.339 }, Range = 10 }; //Act var result = await sut.GetDeals(filters); //Assert Assert.NotNull(result); Assert.IsAssignableFrom <List <DealDTO> >(result); }
private void FilterUpdate( ) { List <HistoricalTransaction> filteredTransactions = new List <HistoricalTransaction>( ); foreach (var transaction in Transactions) { FilterObject userFilterObject = UserFilters.FirstOrDefault(f => f.Value.ToString( ) == transaction.ActiveUserName.ToString( )); FilterObject tenantFilterObject = TenantFilters.FirstOrDefault(f => f.Value.ToString( ) == transaction.TenantName.ToString( )); FilterObject spidFilterObject = SpidFilters.FirstOrDefault(f => f.Value.ToString( ) == transaction.Spid.ToString( )); FilterObject programFilterObject = ProgramFilters.FirstOrDefault(f => f.Value.ToString( ) == transaction.ProgramName); FilterObject loginFilterObject = LoginFilters.FirstOrDefault(f => f.Value.ToString( ) == transaction.LoginName); if ((userFilterObject == null || userFilterObject.IsFiltered) && (tenantFilterObject == null || tenantFilterObject.IsFiltered) && (spidFilterObject == null || spidFilterObject.IsFiltered) && (programFilterObject == null || programFilterObject.IsFiltered) && (loginFilterObject == null || loginFilterObject.IsFiltered)) { filteredTransactions.Add(transaction); } } FilteredTransactions = filteredTransactions; }
public async Task Should_Return_Empty_List_If_All_Deals_Out_Of_Range() { //Arrange var filters = new UserFilters() { Category = 0, Location = new LocationDTO() { Latitude = 65.692, Longitude = -3.339 }, Range = 10 }; //Act var result = await sut.GetDeals(filters); //Assert Assert.NotNull(result); Assert.IsAssignableFrom <List <DealDTO> >(result); Assert.Empty(result); }
public async Task <List <DealDTO> > GetDeals( [FromQuery(Name = "lat")] string lat, [FromQuery(Name = "lon")] string lon, [FromQuery(Name = "range")] string range, [FromQuery(Name = "category")] string category) { UserFilters uf = new UserFilters(); uf.Category = int.Parse(category); uf.Range = int.Parse(range); uf.Location = new LocationDTO() { Latitude = double.Parse(lat), Longitude = double.Parse(lon) }; List <DealDTO> result = await consumerDealService.GetDeals(uf); return(result); }
public async Task <IEnumerable <UsersEntity> > GetAsync(UserFilters filters) { var queryResponse = await(from h in _db.Users select h).ToListAsync(); if (filters.Id.ValidField()) { queryResponse = queryResponse.Where(x => x.Id.Equals(filters.Id)).ToList(); } if (filters.Name.ValidField()) { queryResponse = queryResponse.Where(x => x.Name.Equals(filters.Name)).ToList(); } if (filters.Email.ValidField()) { queryResponse = queryResponse.Where(x => x.Email.Equals(filters.Email)).ToList(); } return(queryResponse); }
private void initUserFilters() { UserFilters = new UserFilters(); UserFilters.Range = int.Parse(Xamarin.Essentials.Preferences.Get("Range", "3")); UserFilters.Category = int.Parse(Xamarin.Essentials.Preferences.Get("Category", "0")); }
public async Task <JsonResult> GetListWithPager(UserFilters filters) { var result = await _userService.Search(filters); return(Json(result, JsonRequestBehavior.AllowGet)); }
public async Task <IActionResult> GetListWithPager(UserFilters filters) { var result = await _userService.SearchAsync(filters); return(Json(result)); }
public void SaveUserFilters(UserFilters item) { Session["__UserFilters"] = item; }