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;
}
