/// <summary> /// Converts a dictionary object to a query string representation such as: /// firstname=shannon&lastname=deminick /// </summary> /// <param name="items"></param> /// <param name="keysToIgnore">Any keys found in this collection will be removed from the output</param> /// <returns></returns> public static string ToQueryString(this FormDataCollection items, params string[] keysToIgnore) { if (items == null) return ""; if (items.Any() == false) return ""; var builder = new StringBuilder(); foreach (var i in items.Where(i => keysToIgnore.InvariantContains(i.Key) == false)) { builder.Append(string.Format("{0}={1}&", i.Key, i.Value)); } return builder.ToString().TrimEnd('&'); }
/// <summary> /// Converts a dictionary object to a query string representation such as: /// firstname=shannon&lastname=deminick /// </summary> /// <param name="items"></param> /// <param name="keysToIgnore">Any keys found in this collection will be removed from the output</param> /// <returns></returns> public static string ToQueryString(this FormDataCollection items, params string[] keysToIgnore) { if (items == null) { return(""); } if (items.Any() == false) { return(""); } var builder = new StringBuilder(); foreach (var i in items.Where(i => keysToIgnore.InvariantContains(i.Key) == false)) { builder.Append(string.Format("{0}={1}&", i.Key, i.Value)); } return(builder.ToString().TrimEnd(Constants.CharArrays.Ampersand)); }
public static IEnumerable<SearchResult> PerformMemberSearch(string filter, FormDataCollection queryStrings, out int totalRecordCount, string memberType = "", int pageNumber = 0, int pageSize = 0, string orderBy = "", Direction orderDirection = Direction.Ascending) { var internalSearcher = ExamineManager.Instance.SearchProviderCollection[Constants.Examine.InternalMemberSearcher]; ISearchCriteria criteria = internalSearcher.CreateSearchCriteria().RawQuery(" +__IndexType:member"); //build a lucene query if (string.IsNullOrWhiteSpace(filter) && !queryStrings.Any(qs => qs.Key.StartsWith("f_") && !string.IsNullOrWhiteSpace(qs.Value))) { // Generic get everything... criteria.RawQuery("a* b* c* d* e* f* g* h* i* j* k* l* m* n* o* p* q* r* s* t* u* v* w* x* y* z*"); } else { // the __nodeName will be boosted 10x without wildcards // then __nodeName will be matched normally with wildcards // the rest will be normal without wildcards if (!string.IsNullOrWhiteSpace(filter)) { var sb = new StringBuilder(); sb.Append("+("); //node name exactly boost x 10 sb.AppendFormat("__nodeName:{0}^10.0 ", filter.ToLower()); //node name normally with wildcards sb.AppendFormat(" __nodeName:{0}* ", filter.ToLower()); var basicFields = new List<string>() { "id", "_searchEmail", "email", "loginName" }; var userFields = ExamineManager.Instance.IndexProviderCollection["InternalMemberIndexer"].IndexerData.UserFields.Select(x => x.Name); basicFields.AddRange(userFields); foreach (var field in basicFields.Distinct()) { //additional fields normally sb.AppendFormat("{0}:{1} ", field, filter); } sb.Append(")"); criteria.RawQuery(sb.ToString()); } // Now specific field searching. - these should be ANDed and grouped. foreach (var qs in queryStrings.Where(q => q.Key.StartsWith("f_") && !string.IsNullOrWhiteSpace(q.Value))) { // Got a filter. string alias = qs.Key.Substring(2); var values = queryStrings.GetValue<string>(qs.Key).Split(','); if (values.Length > 0) { criteria.GroupedOr(new[] { alias }, values); } } } //must match index type if (!string.IsNullOrWhiteSpace(memberType)) { criteria.NodeTypeAlias(memberType); } //// Order the results //// Examine Sorting seems too unreliable, particularly on nodeName //if (orderDirection == Direction.Ascending) { // criteria.OrderBy(orderBy.ToLower() == "name" ? "nodeName" : "email"); //} else { // criteria.OrderByDescending(orderBy.ToLower() == "name" ? "nodeName" : "email"); //} var result = internalSearcher.Search(criteria); totalRecordCount = result.TotalItemCount; // Order the results var orderedResults = orderDirection == Direction.Ascending ? result.OrderBy(o => orderBy.ToLower() == "name" ? o.Fields["nodeName"] : o.Fields["email"]) : result.OrderByDescending(o => orderBy.ToLower() == "name" ? o.Fields["nodeName"] : o.Fields["email"]); if (pageSize > 0) { int skipCount = (pageNumber > 0 && pageSize > 0) ? Convert.ToInt32((pageNumber - 1) * pageSize) : 0; if (result.TotalItemCount < skipCount) { skipCount = result.TotalItemCount / pageSize; } return orderedResults.Skip(skipCount).Take(pageSize); } return orderedResults; }
/// <summary> /// Checks if the collection contains the key /// </summary> /// <param name="items"></param> /// <param name="key"></param> /// <returns></returns> public static bool HasKey(this FormDataCollection items, string key) { return(items.Any(x => x.Key.InvariantEquals(key))); }
public static IEnumerable <SearchResult> PerformMemberSearch(string filter, FormDataCollection queryStrings, out int totalRecordCount, string memberType = "", int pageNumber = 0, int pageSize = 0, string orderBy = "", Direction orderDirection = Direction.Ascending) { var internalSearcher = ExamineManager.Instance.SearchProviderCollection[Constants.Examine.InternalMemberSearcher]; ISearchCriteria criteria = internalSearcher.CreateSearchCriteria().RawQuery(" +__IndexType:member"); var basicFields = new List <string>() { "id", "_searchEmail", "email", "loginName" }; //build a lucene query if (string.IsNullOrWhiteSpace(filter) && !queryStrings.Any(qs => qs.Key.StartsWith("f_") && !string.IsNullOrWhiteSpace(qs.Value))) { // Generic get everything... criteria.RawQuery("a* b* c* d* e* f* g* h* i* j* k* l* m* n* o* p* q* r* s* t* u* v* w* x* y* z*"); } else { // the __nodeName will be boosted 10x without wildcards // then __nodeName will be matched normally with wildcards // the rest will be normal without wildcards if (!string.IsNullOrWhiteSpace(filter)) { var sb = new StringBuilder(); sb.Append("+("); //node name exactly boost x 10 sb.AppendFormat("__nodeName:{0}^10.0 ", filter.ToLower()); //node name normally with wildcards sb.AppendFormat(" __nodeName:{0}* ", filter.ToLower()); foreach (var field in basicFields) { //additional fields normally sb.AppendFormat("{0}:{1} ", field, filter); } sb.Append(")"); criteria.RawQuery(sb.ToString()); } // Now specific field searching. - these should be ANDed and grouped. foreach (var qs in queryStrings.Where(q => q.Key.StartsWith("f_") && !string.IsNullOrWhiteSpace(q.Value))) { // Got a filter. string alias = qs.Key.Substring(2); var values = queryStrings.GetValue <string>(qs.Key).Split(','); if (values.Length > 0) { criteria.GroupedOr(new[] { alias }, values); } } } //must match index type if (!string.IsNullOrWhiteSpace(memberType)) { criteria.NodeTypeAlias(memberType); } //// Order the results //// Examine Sorting seems too unreliable, particularly on nodeName //if (orderDirection == Direction.Ascending) { // criteria.OrderBy(orderBy.ToLower() == "name" ? "nodeName" : "email"); //} else { // criteria.OrderByDescending(orderBy.ToLower() == "name" ? "nodeName" : "email"); //} var result = internalSearcher.Search(criteria); totalRecordCount = result.TotalItemCount; // Order the results var orderedResults = orderDirection == Direction.Ascending ? result.OrderBy(o => orderBy.ToLower() == "name" ? o.Fields["nodeName"] : o.Fields["email"]) : result.OrderByDescending(o => orderBy.ToLower() == "name" ? o.Fields["nodeName"] : o.Fields["email"]); if (pageSize > 0) { int skipCount = (pageNumber > 0 && pageSize > 0) ? Convert.ToInt32((pageNumber - 1) * pageSize) : 0; if (result.TotalItemCount < skipCount) { skipCount = result.TotalItemCount / pageSize; } return(orderedResults.Skip(skipCount).Take(pageSize)); } return(orderedResults); }