public async Task <ProfileFilterModel> GetProfileFilter(ProfileListFilterModel filter, int page, int size)
{
var filterDefinition = CreateFilterDefinition(filter);
ProfileFilterModel result = new ProfileFilterModel();
Func <Expression <Func <Profile, object> >, string, Task> buildFilterCounts = async(field, attributeName) =>
{
var counts = new SortedDictionary <string, int>();
await _context.Profiles.Collection
.Aggregate()
.Match(filterDefinition)
.Unwind(field)
.Group(new BsonDocument {
{ "_id", $"$Supervisor.{Regex.Replace(attributeName, @"\s+", "")}" }, { "count", new BsonDocument("$sum", 1) }
})
.ForEachAsync(item => {
counts.Add(item.GetValue("_id").ToString(), item.GetValue("count").ToInt32());
});
result.Add(attributeName, counts);
};
await buildFilterCounts(p => p.Supervisor.AgeSpecialties, "Age Specialties");
await buildFilterCounts(p => p.Supervisor.Ethnicities, "Ethnicities");
await buildFilterCounts(p => p.Supervisor.Languages, "Languages");
await buildFilterCounts(p => p.Supervisor.Modalities, "Modalities");
await buildFilterCounts(p => p.Supervisor.Religions, "Religions");
await buildFilterCounts(p => p.Supervisor.SpecialInterests, "Special Interests");
await buildFilterCounts(p => p.Supervisor.Specialties, "Specialties");
await buildFilterCounts(p => p.Supervisor.Treatments, "Treatments");
return(result);
}
public List <string> GetListOfZipCodes(ProfileListFilterModel filter)
{
var result = new List <string>();
//var filterDefinition = Builders<LocationLookup>.Filter.Ne(p=>p.Supervisor, null);
if (!string.IsNullOrEmpty(filter.mfz))
{
var location = GetLongLat(filter.mfz);
var point = new GeoJson2DGeographicCoordinates(location.lg, location.lt);
var pnt = new GeoJsonPoint <GeoJson2DGeographicCoordinates>(point);
//Expression<Func<Profile,Profile>> fieldExpression = p => p.Supervisor.Addresses.Where(_ => _.Type.Equals("Primary"));
FieldDefinition <LocationLookup, string> field = "LocationLookup.Location";
//_context.Locations.Collection.Indexes.CreateOne(Builders<LocationLookup>.IndexKeys.Geo2DSphere(field));
//var filterDefinition = Builders<LocationLookup>.Filter.NearSphere(p => p.Location, pnt, filter.mfd*10);
var filterDefinition = Builders <LocationLookup> .Filter.NearSphere(field, pnt, filter.mfd *500);
var foo = _context.Locations.Collection.Find(filterDefinition);
//var s = "";
}
return(result);
}
private FilterDefinition <Profile> CreateFilterDefinition(ProfileListFilterModel filter)
{
//var f = GetListOfZipCodes(filter);
var filterDefinition = Builders <Profile> .Filter.Ne(p => p.Supervisor, null);
filterDefinition = filterDefinition & Builders <Profile> .Filter.Eq(p => p.Account.IsActive, true);
filterDefinition = filterDefinition & Builders <Profile> .Filter.Eq(p => p.Supervisor.IsActive, true);
if (filter != null)
{
if (!string.IsNullOrEmpty(filter.ke))
{
//filterDefinition = filterDefinition & Builders<Profile>.Filter.Text(filter.ke);
filterDefinition = filterDefinition & Builders <Profile> .Filter.Text(filter.ke, new TextSearchOptions { CaseSensitive = false });
}
// if(!string.IsNullOrEmpty(filter.mfz))
// {
// var location = GetLongLat(filter.mfz);
// var point = new GeoJson2DGeographicCoordinates(location.lg, location.lt);
// var pnt = new GeoJsonPoint<GeoJson2DGeographicCoordinates>(point);
// //Expression<Func<Profile,Profile>> fieldExpression = p => p.Supervisor.Addresses.Where(_ => _.Type.Equals("Primary"));
// FieldDefinition<Profile, string> field = "Supervisor.Addresses.Location";
// //filterDefinition = filterDefinition & Builders<Profile>.Filter.NearSphere(p => p.Supervisor.Addresses, pnt, filter.mfd);
// filterDefinition = Builders<Profile>.Filter.NearSphere(field, pnt, filter.mfd);
// //filterDefinition = filterDefinition & Builders<Profile>.Filter.NearSphere(p => p.Supervisor.Addresses.First().Location, pnt, filter.mfd);
// }
Action <Expression <Func <Profile, IEnumerable <string> > >, string[]> applyFilterDefinition = (fieldExpression, filterValue) =>
{
if (filterValue?.Length > 0)
{
filterDefinition = filterDefinition & Builders <Profile> .Filter.AnyIn(fieldExpression, filterValue);
}
};
applyFilterDefinition(p => p.Supervisor.AgeSpecialties, filter.agSp);
applyFilterDefinition(p => p.Supervisor.Ethnicities, filter.et);
applyFilterDefinition(p => p.Supervisor.Languages, filter.la);
applyFilterDefinition(p => p.Supervisor.Modalities, filter.mo);
applyFilterDefinition(p => p.Supervisor.Religions, filter.re);
applyFilterDefinition(p => p.Supervisor.SpecialInterests, filter.spIn);
applyFilterDefinition(p => p.Supervisor.Specialties, filter.sp);
applyFilterDefinition(p => p.Supervisor.Treatments, filter.tr);
}
return(filterDefinition);
}
public async Task <PagedResult <ProfileListItemModel> > GetProfiles(ProfileListFilterModel filter, int page, int size)
{
PagedResult <ProfileListItemModel> result = null;
var filterDefinition = CreateFilterDefinition(filter);
var cnt = await _context.Profiles.CountAsync(filterDefinition);
var profiles = _context.Profiles.Find(
filterDefinition: filterDefinition,
pageIndex: page,
size: size,
isDescending: false,
order: p => p.LastName);
var items = _mapper.Map <IEnumerable <ProfileListItemModel> >(profiles);
result = new PagedResult <ProfileListItemModel>(items, cnt);
return(result);
}
private FilterDefinition <Profile> BuildFilter(ProfileListFilterModel model)
{
var filterDefinition = Builders <Profile> .Filter.Ne(p => p.Supervisor, null);
return(filterDefinition);
}
