/// <summary> /// Find all playlists in this account. /// </summary> /// <param name="pageSize">Number of playlists returned per page. A page is a subset of all of the playlists that /// satisfy the request. The maximum page size is 50.</param> /// <param name="pageNumber">The zero-indexed number of the page to return.</param> /// <param name="sortBy">The property that you'd like to sort the results by.</param> /// <param name="sortOrder">The order that you'd like the results sorted - ascending or descending.</param> /// <param name="videoFields">A list of the fields you wish to have populated in the Videos /// contained in the playlists. If you omit this parameter, the method returns the following fields of the /// Video: id, name, shortDescription, longDescription, creationDate, publisheddate, lastModifiedDate, linkURL, /// linkText, tags, videoStillURL, thumbnailURL, referenceId, length, economics, playsTotal, playsTrailingWeek. /// If you use a token with URL access, this method also returns the Videos' FLVURL, renditions, FLVFullLength, /// videoFullLength.</param> /// <param name="playlistFields">A list of the fields you wish to have populated in the Playlists /// contained in the returned object. If you omit this parameter, all playlist fields are returned.</param> /// <param name="customFields">A list of the custom fields you wish to have populated in the videos /// contained in the returned object. If you omit this parameter, no custom fields are returned, unless you include /// the value 'customFields' in the video_fields parameter.</param> /// <param name="getItemCount">If true, also return how many total results there are.</param> /// <returns>A collection of Playlists that is the specified subset of all the playlists in this account.</returns> public BrightcoveItemCollection<BrightcovePlaylist> FindAllPlaylists(int pageSize, int pageNumber, SortBy sortBy, SortOrder sortOrder, IEnumerable<string> videoFields, IEnumerable<string> playlistFields, IEnumerable<string> customFields, bool getItemCount) { NameValueCollection parms = BuildBasicReadParams("find_all_playlists"); parms.Add("page_size", pageSize.ToString()); parms.Add("page_number", pageNumber.ToString()); parms.Add("sort_by", sortBy.ToBrightcoveName()); parms.Add("sort_order", sortOrder.ToBrightcoveName()); parms.Add("get_item_count", getItemCount.ToString().ToLower()); if (videoFields != null) { parms.AddRange("video_fields", videoFields); } if (playlistFields != null) { parms.AddRange("playlist_fields", playlistFields); } if (customFields != null) { parms.AddRange("custom_fields", customFields); } return RunQuery<BrightcoveItemCollection<BrightcovePlaylist>>(parms); }
public async Task<List<CandidateUser>> GetCandidatesListBySearchModelAsync(int? minSalary, int? maxSalary, int? minExperienceInYears, int? maxExperienceInYears, SortBy sortBy, List<Skill> skills) { var filter = GetSalaryExperienceFilter(minSalary, maxSalary, minExperienceInYears, maxExperienceInYears); var skillsName = skills.Select(r => r.NameToLower).ToList(); var matchBson = GetMatchedSkillsStageBson(skillsName); var projectBson = GetCandidateProjectionBson(skillsName, skills.Count); var sortDefinition = GetCandidateSortDefinition(sortBy); var candidatesQuery = dbContext.CandidateUsers .Aggregate() .Match(filter) .Match(new BsonDocumentFilterDefinition<CandidateUser>(matchBson)) .Project(new BsonDocumentProjectionDefinition<CandidateUser, BsonDocument>(projectBson)) .Match(new BsonDocumentFilterDefinition<BsonDocument>(new BsonDocument("Matched", true))) .Project(new BsonDocumentProjectionDefinition<BsonDocument, CandidateUser>(new BsonDocument("Skills", 1).Add("Salary", 1).Add("ExperienceInYears", 1).Add("Name", 1).Add("ModificationDate",1).Add("ExperienceDescription", 1))); if (sortDefinition != null) { candidatesQuery = candidatesQuery.Sort(sortDefinition); } var candidates = await candidatesQuery.ToListAsync(); return candidates; }
public static string GetParametersString(int page, SortBy sort, OrderBy direction) { return string.Format("page={0}&sort={1}&direction={2}", page, sort.GetText(), direction.GetText()); }
public QueryStringFactoryTestsWithSort(SortBy sortBy, Order order, string expectedSortBy, string expectedOrder) { _sortBy = sortBy; _order = order; _expectedSortBy = expectedSortBy; _expectedOrder = expectedOrder; }
/// <summary> /// Get all articles for a given section. /// </summary> /// <param name="section"></param> /// <param name="sortBy"></param> /// <param name="sortDirection"></param> /// <returns></returns> public IList GetAllArticlesBySection(Section section, SortBy sortBy, SortDirection sortDirection) { string hql = "from Article a left join fetch a.Category where a.Section.Id = :sectionId " + GetOrderByClause(sortBy, sortDirection, "a"); IQuery q = this._sessionManager.OpenSession().CreateQuery(hql); q.SetInt32("sectionId", section.Id); return q.List(); }
public static ContactSorter GetSorter(SortBy sortBy) { switch (sortBy) { case SortBy.FirstName: return new FirstNameSorter(); break; case SortBy.LastName: return new LastNameSorter(); break; default: throw new ArgumentOutOfRangeException(); } }
public UserSettings() { Timeout = new List<string>() { "10 seconds","20 seconds","30 seconds" }; KeepItemsFor = new List<string>() { "6 hours","12 hours","1 day" }; _ignoreReadItems = true; _imagesEnabled = true; _sortItemsBy = SortBy.Date; }
public static IComparer SortOrder(SortBy s) { if (s == SortBy.FruitName) { return new SortByName(); } else if (s == SortBy.FruitPrice) { return new SortByPrice(); } else { //default order return new SortByName(); } }
/// <summary> /// Find all audio tracks in the Brightcove media library for this account. /// </summary> /// <param name="pageSize">Number of items returned per page. Maximum page size is 100.</param> /// <param name="pageNumber">The zero-indexed number of the page to return.</param> /// <param name="sortBy">The field by which to sort the results.</param> /// <param name="sortOrder">How to order the results: ascending or descending.</param> /// <param name="audioTrackFields">A list of the fields you wish to have populated in the audiotracks /// contained in the returned object.</param> /// <param name="getItemCount">If true, also return how many total results there are.</param> /// <returns>A collection of audio tracks matching the specified search criteria.</returns> public BrightcoveItemCollection<BrightcoveAudioTrack> FindAllAudioTracks(int pageSize, int pageNumber, SortBy sortBy, SortOrder sortOrder, IEnumerable<string> audioTrackFields, bool getItemCount) { NameValueCollection parms = BuildBasicReadParams("find_all_audiotracks"); parms.Add("get_item_count", getItemCount.ToString().ToLower()); parms.Add("page_size", pageSize.ToString()); parms.Add("page_number", pageNumber.ToString()); parms.Add("sort_by", sortBy.ToBrightcoveName()); parms.Add("sort_order", sortOrder.ToBrightcoveName()); if (audioTrackFields != null) { parms.AddRange("audiotrack_fields", audioTrackFields); } return RunQuery<BrightcoveItemCollection<BrightcoveAudioTrack>>(parms); }
/// <summary> /// Generates user reputation object /// </summary> /// <param name="creator"></param> /// <param name="modClass"></param> /// <param name="userId"></param> /// <returns></returns> public static UserReputationList GetUserReputationList(IDnaDataReaderCreator creator, int modClassId, int modStatus, int days, int startIndex, int itemsPerPage, SortBy sortBy, SortDirection sortDirection) { UserReputationList userRepList = new UserReputationList() { days = days, modClassId = modClassId, modStatus = modStatus, startIndex = startIndex, itemsPerPage = itemsPerPage, sortBy = sortBy, sortDirection = sortDirection }; using (IDnaDataReader dataReader = creator.CreateDnaDataReader("getuserreputationlist")) { dataReader.AddParameter("modClassId", modClassId); dataReader.AddParameter("modStatus", modStatus); dataReader.AddParameter("startIndex", startIndex); dataReader.AddParameter("itemsPerPage", itemsPerPage); dataReader.AddParameter("days", days); dataReader.AddParameter("sortby", sortBy.ToString()); dataReader.AddParameter("sortdirection", sortDirection.ToString()); dataReader.Execute(); while(dataReader.Read()) { var userRep = new UserReputation(); userRep.UserId = dataReader.GetInt32NullAsZero("userid"); userRep.ModClass = ModerationClassListCache.GetObject().ModClassList.FirstOrDefault(x => x.ClassId == dataReader.GetInt32NullAsZero("modclassid")); userRep.CurrentStatus = (ModerationStatus.UserStatus)dataReader.GetInt32NullAsZero("currentstatus"); userRep.ReputationDeterminedStatus = (ModerationStatus.UserStatus)dataReader.GetInt32NullAsZero("ReputationDeterminedStatus"); userRep.ReputationScore = dataReader.GetInt16("accumulativescore"); userRep.LastUpdated = new DateElement(dataReader.GetDateTime("lastupdated")); userRep.UserName = dataReader.GetStringNullAsEmpty("UserName"); userRepList.Users.Add(userRep); userRepList.totalItems = dataReader.GetInt32NullAsZero("total"); } } return userRepList; }
private void GetParameters() { _modClassId = 0; if(InputContext.DoesParamExist("s_modclassid", "s_modclassid")) { _modClassId = InputContext.GetParamIntOrZero("s_modclassid", "s_modclassid"); } _modStatus = (int)BBC.Dna.Moderation.Utils.ModerationStatus.UserStatus.Restricted; if(InputContext.DoesParamExist("s_modstatus", "s_modstatus")) { _modStatus = (int)Enum.Parse(typeof(BBC.Dna.Moderation.Utils.ModerationStatus.UserStatus), InputContext.GetParamStringOrEmpty("s_modstatus", "s_modstatus")); ; } _days =1; if(InputContext.DoesParamExist("s_days", "s_days")) { _days = InputContext.GetParamIntOrZero("s_days", "s_days"); } _startIndex = 0; if (InputContext.DoesParamExist("s_startIndex", "startIndex")) { _startIndex = InputContext.GetParamIntOrZero("s_startIndex", "s_startIndex"); } if (InputContext.DoesParamExist("s_sortby", "sortby")) { sortBy = (SortBy)Enum.Parse(typeof(SortBy), InputContext.GetParamStringOrEmpty("s_sortby", "")); } if (InputContext.DoesParamExist("s_sortdirection", "sortdirection")) { sortDirection = (SortDirection)Enum.Parse(typeof(SortDirection), InputContext.GetParamStringOrEmpty("s_sortdirection", "s_sortdirection")); } }
/// <summary> /// Advanced Search /// </summary> /// <param name="advancedSearch"> Object advandced search</param> /// <returns></returns> public List<SearchDocumentResult> AdvancedSearch(AdvancedSearchDto advancedSearch, SortBy sortBy) { var result = new List<SearchDocumentResult>(); if (advancedSearch != null) { try { string strResponse = string.Empty; // String search query string strQuery = BuildSearchQuery(advancedSearch); // String search option string strOption = BuildSearchOption(SearchOptionConst.And, false); // Call Amazon Cloud Search API Service AmazonCloudSearcher ObjCloudSearch = new AmazonCloudSearcher(); strResponse = ObjCloudSearch.SearchRequest(ApiEndpoint, ApiVersion, strQuery, strOption, "_all_fields,_score", SearchOptionConst.SortByScoreDesc, DataFormat.Json); result = GetSearchDocumentList(strResponse); return result; } catch (Exception e) { Log.Error("Advanced search error. Message: " + e.Message + " Stack trace: " + e.StackTrace); } } return null; }
public async Task<List<JobOffer>> GetOffersByOfferSearchModelAsync(List<Skill> skills, int? minSalary, int? maxSalary, string name, SortBy sortBy) { var filter = GetSalaryNameFilter(minSalary, maxSalary, name); var skillsName = skills.Select(r => r.NameToLower).ToList(); var matchBson = GetMatchedSkillsStageBson(skillsName); var projectBson = GetOfferProjectionBson(skillsName, skills.Count); var sortDefinition = GetSortDefinition(sortBy); var offersQuery = dbContext.JobOffers .Aggregate() .Match(filter) .Match(new BsonDocumentFilterDefinition<JobOffer>(matchBson)) .Project(new BsonDocumentProjectionDefinition<JobOffer, BsonDocument>(projectBson)) .Match(new BsonDocumentFilterDefinition<BsonDocument>(new BsonDocument("Matched", true))) .Project(new BsonDocumentProjectionDefinition<BsonDocument, JobOffer>(new BsonDocument("RecruiterId", 1).Add("Salary", 1).Add("Name", 1).Add("Skills", 1).Add("ModificationDate", 1).Add("Description", 1))); if (sortDefinition!=null) { offersQuery = offersQuery.Sort(sortDefinition); } var offers = await offersQuery.ToListAsync(); return offers; }
/// <summary> /// Obtain an unused ID to assign to a new player from the DB /// </summary> /// <returns></returns> public static int getUnusedID() { return((getPlayerCount() > 0) ? (int)getAllUsersCollection().Find(Query.Null).SetSortOrder(SortBy.Ascending("_id")).Last()["_id"] + 1 : 1); }
public IEnumerable <T> FindPaged <T>(QueryFilter filter, ObjectId rootId, bool deepSearch, SortBy sortBy, int pageSize) where T : IConfigurable, new() { T t = (default(T) == null) ? Activator.CreateInstance <T>() : default(T); IMailboxStoreType mailboxStoreType = t as IMailboxStoreType; return(mailboxStoreType.FindPaged <T>(this, filter, rootId, deepSearch, sortBy, pageSize)); }
public static void deleteTags(string Id) { MongoCollection <Tags> objCollection = db.GetCollection <Tags>("c_Tags"); var result = objCollection.FindAndRemove(Query.EQ("_id", ObjectId.Parse(Id)), SortBy.Ascending("_id")); }
/// <summary> /// Refreshes the GridFS file info from the server. /// </summary> public void Refresh() { using (_server.RequestStart(_serverInstance)) { var gridFS = new MongoGridFS(_server, _databaseName, _settings); var database = gridFS.GetDatabase(); var filesCollection = gridFS.GetFilesCollection(database); MongoCursor <BsonDocument> cursor; if (_id != null) { cursor = filesCollection.Find(Query.EQ("_id", _id)); } else if (_name != null) { cursor = filesCollection.Find(Query.EQ("filename", _name)).SetSortOrder(SortBy.Descending("uploadDate")); } else { throw new InvalidOperationException("Cannot refresh FileInfo when both Id and Name are missing."); } var fileInfo = cursor.SetLimit(1).FirstOrDefault(); CacheFileInfo(fileInfo); // fileInfo will be null if file does not exist } }
public SiblingInsertionAttribute(SortBy accordingTo) { AccordingTo = accordingTo; }
/// <summary> /// Retrieves the videos uploaded by the specified user id. This method can be used to find videos submitted using /// the consumer-generated media (CGM) module. /// </summary> /// <param name="userId">The id of the user whose videos we'd like to retrieve.</param> /// <param name="pageSize">Number of items returned per page. A page is a subset of all of the items that satisfy the /// request. The maximum page size is 100.</param> /// <param name="pageNumber">The zero-indexed number of the page to return.</param> /// <param name="sortBy">The field by which to sort the results.</param> /// <returns>An ItemCollection representing the requested page of Videos uploaded by the specified user, /// in the order specified.</returns> public BrightcoveItemCollection<BrightcoveVideo> FindVideosByUserId(string userId, int pageSize, int pageNumber, SortBy sortBy) { return FindVideosByUserId(userId, pageSize, pageNumber, sortBy, SortOrder.Ascending); }
private async Task <IEnumerable <T> > Find <T>(ObjectSerializer Serializer, IMongoCollection <BsonDocument> Collection, int Offset, int MaxCount, FilterDefinition <BsonDocument> BsonFilter, params string[] SortOrder) { IFindFluent <BsonDocument, BsonDocument> ResultSet = Collection.Find <BsonDocument>(BsonFilter); if (SortOrder.Length > 0) { SortDefinition <BsonDocument> SortDefinition = null; foreach (string SortBy in SortOrder) { if (SortDefinition is null) { if (SortBy.StartsWith("-")) { SortDefinition = Builders <BsonDocument> .Sort.Descending(Serializer.ToShortName(SortBy.Substring(1))); } else { SortDefinition = Builders <BsonDocument> .Sort.Ascending(Serializer.ToShortName(SortBy)); } } else { if (SortBy.StartsWith("-")) { SortDefinition = SortDefinition.Descending(Serializer.ToShortName(SortBy.Substring(1))); } else { SortDefinition = SortDefinition.Ascending(Serializer.ToShortName(SortBy)); } } } ResultSet = ResultSet.Sort(SortDefinition); } if (Offset > 0) { ResultSet = ResultSet.Skip(Offset); } if (MaxCount < int.MaxValue) { ResultSet = ResultSet.Limit(MaxCount); } IAsyncCursor <BsonDocument> Cursor = await ResultSet.ToCursorAsync(); LinkedList <T> Result = new LinkedList <T>(); BsonDeserializationArgs Args = new BsonDeserializationArgs() { NominalType = typeof(T) }; while (await Cursor.MoveNextAsync()) { foreach (BsonDocument Document in Cursor.Current) { BsonDocumentReader Reader = new BsonDocumentReader(Document); BsonDeserializationContext Context = BsonDeserializationContext.CreateRoot(Reader); T Obj = (T)Serializer.Deserialize(Context, Args); Result.AddLast(Obj); } } return(Result); }
public async Task <IActionResult> Index( int page = 1, string submit = null, SortBy sort = SortBy.IdDesc, DateTime?DateFrom = null, DateTime?DateTo = null, string Nature = null, int?CountyId = null, Guid?TypeId = null, string SourceName = null, string Street = null, string City = null, int?StateId = null, string PostalCode = null ) { // ViewModel var model = new PublicSearchViewModel() { DateFrom = DateFrom, DateTo = DateTo, CountyId = CountyId, Nature = Nature, TypeId = TypeId, SourceName = SourceName, Street = Street, City = City, StateId = StateId, PostalCode = PostalCode, Sort = sort, CountySelectList = await GetCountiesSelectListAsync(), ConcernSelectList = await GetAreasOfConcernSelectListAsync(), StateSelectList = await GetStatesSelectListAsync(), }; if (string.IsNullOrEmpty(submit)) { return(View(model)); } if (DateFrom.HasValue && DateTo.HasValue && DateFrom.Value > DateTo.Value) { var msg = "The beginning date must precede the end date."; ViewData["AlertMessage"] = new AlertViewModel(msg, AlertStatus.Error, "Error"); } else { // Search var complaints = _context.Complaints.AsNoTracking() .Where(e => !e.Deleted && e.ComplaintClosed); // Filters if (DateFrom.HasValue) { complaints = complaints .Where(e => DateFrom.Value <= e.DateReceived); } if (DateTo.HasValue) { complaints = complaints .Where(e => e.DateReceived.Date <= DateTo.Value); } if (CountyId.HasValue) { complaints = complaints .Where(e => e.ComplaintCountyId.HasValue && e.ComplaintCountyId.Value == CountyId.Value); } if (!string.IsNullOrEmpty(Nature)) { complaints = complaints .Where(e => e.ComplaintNature.ToLower().Contains(Nature.ToLower())); } if (TypeId.HasValue) { complaints = complaints .Where(e => (e.PrimaryConcernId.HasValue && e.PrimaryConcernId.Value == TypeId.Value) || (e.SecondaryConcernId.HasValue && e.SecondaryConcernId.Value == TypeId.Value)); } if (!string.IsNullOrEmpty(SourceName)) { complaints = complaints .Where(e => e.SourceFacilityName.ToLower().Contains(SourceName.ToLower())); } if (!string.IsNullOrEmpty(Street)) { complaints = complaints .Where(e => e.SourceStreet.ToLower().Contains(Street.ToLower()) || e.SourceStreet2.ToLower().Contains(Street.ToLower())); } if (!string.IsNullOrEmpty(City)) { complaints = complaints .Where(e => e.SourceCity.ToLower().Contains(City.ToLower()) || e.ComplaintCity.ToLower().Contains(City.ToLower())); } if (StateId.HasValue) { complaints = complaints .Where(e => e.SourceStateId.HasValue && e.SourceStateId.Value == StateId.Value); } if (!string.IsNullOrEmpty(PostalCode)) { complaints = complaints .Where(e => e.SourcePostalCode.ToLower().Contains(PostalCode.ToLower())); } // Count var count = await complaints.CountAsync().ConfigureAwait(false); // Sort switch (sort) { default: case SortBy.IdAsc: complaints = complaints.OrderBy(e => e.Id); break; case SortBy.IdDesc: complaints = complaints.OrderByDescending(e => e.Id); model.IdSortAction = SortBy.IdAsc; break; case SortBy.ReceivedDateAsc: complaints = complaints.OrderBy(e => e.DateReceived) .ThenBy(e => e.Id); break; case SortBy.ReceivedDateDesc: complaints = complaints.OrderByDescending(e => e.DateReceived) .ThenBy(e => e.Id); model.ReceivedDateSortAction = SortBy.ReceivedDateAsc; break; } // Include complaints = complaints .Include(e => e.CurrentOffice) .Include(e => e.SourceState); // Paging complaints = complaints .Skip((page - 1) * CTS.PageSize) .Take(CTS.PageSize); // Select var items = await complaints .Select(e => new PublicSearchResultsViewModel(e)) .ToListAsync().ConfigureAwait(false); model.Complaints = new PaginatedList <PublicSearchResultsViewModel>(items, count, page); } return(View(model)); }
internal IConfigurable[] Find <T>(QueryFilter filter, ObjectId rootId, bool deepSearch, SortBy sortBy) where T : IConfigurable, new() { return(this.DataProvider.Find <T>(filter, rootId, deepSearch, sortBy)); }
/// <summary> /// 按条件分页查询 /// </summary> /// <typeparam name="T"></typeparam> /// <param name="query">查询条件</param> /// <param name="pageIndex">页次</param> /// <param name="pageRow">每页显示记录数</param> /// <param name="total">总记录数</param> /// <returns></returns> public List <T> FindMoreForPageByCondi <T>(IMongoQuery query, int pageIndex, int pageRow, ref long total) { List <T> list = new List <T>(); try { total = this._db.GetCollection(typeof(T).Name).FindAs <T>(query).Count();//获取总记录数 if (pageIndex == 1) { list = this._db.GetCollection(typeof(T).Name).FindAs <T>(query).SetSortOrder(SortBy.Descending("CreateDate")).SetLimit(pageRow).ToList(); } else { var bd = this._db.GetCollection(typeof(T).Name).Find(query).SetSortOrder("_id:1").SetLimit((pageIndex - 1) * pageRow).Last(); //获取最后一个ID主键 var el = bd.GetElement(0); var value = el.Value; list = this._db.GetCollection(typeof(T).Name).FindAs <T>(query).SetSortOrder("_id:1").SetSkip(pageRow).SetLimit(pageRow).ToList(); } } catch (Exception ex) { } return(list); }
public EmployeeComparer(SortBy sortBy) { SortOn = sortBy; }
/// <summary> /// Searches videos according to the criteria provided by the user. /// </summary> /// <param name="all">Specifies the field:value pairs for search criteria that MUST be present in /// the index in order to return a hit in the result set. If the field's name is not present, it is /// assumed to be name and shortDescription.</param> /// <param name="any">Specifies the field:value pairs for search criteria AT LEAST ONE of which /// must be present to return a hit in the result set. If the field's name is not present, it is /// assumed to be name and shortDescription.</param> /// <param name="none">Specifies the field:value pairs for search criteria that MUST NOT be present /// to return a hit in the result set. If the field's name is not present, it is assumed to be /// name and shortDescription.</param> /// <param name="pageSize">Number of items returned per page. (max 100)</param> /// <param name="pageNumber">The zero-indexed number of the page to return.</param> /// <param name="exact">If true, disables fuzzy search and requires an exact match of search terms. /// A fuzzy search does not require an exact match of the indexed terms, but will return a hit for /// terms that are closely related based on language-specific criteria. The fuzzy search is /// available only if your account is based in the United States.</param> /// <param name="sortBy">Specifies the field by which to sort results.</param> /// <param name="sortOrder">Specifies the direction in which to sort results</param> /// <param name="videoFields">A list of the fields you wish to have populated in the Videos contained /// in the returned object. If you omit this parameter, the method returns the following fields of /// the video: id, name, shortDescription, longDescription, creationDate, publisheddate, lastModifiedDate, /// linkURL, linkText, tags, videoStillURL, thumbnailURL, referenceId, length, economics, playsTotal, /// playsTrailingWeek. If you use a token with URL access, this method also returns FLVURL, renditions, /// FLVFullLength, videoFullLength.</param> /// <param name="customFields">A list of the custom fields you wish to have populated in the videos /// contained in the returned object. If you omit this parameter, no custom fields are returned, unless you /// include the value 'customFields' in the video_fields parameter.</param> /// <returns>A collection of videos matching the specified criteria.</returns> public BrightcoveItemCollection<BrightcoveVideo> SearchVideos(IEnumerable<FieldValuePair> all, IEnumerable<FieldValuePair> any, IEnumerable<FieldValuePair> none, int pageSize, int pageNumber, bool exact, SortBy sortBy, SortOrder sortOrder, IEnumerable<string> videoFields, IEnumerable<string> customFields) { return SearchVideos(all, any, none, pageSize, pageNumber, exact, sortBy, sortOrder, videoFields, customFields, true); }
/// <summary> /// Retrieves the videos uploaded by the specified user id. This method can be used to find videos submitted using /// the consumer-generated media (CGM) module. /// </summary> /// <param name="userId">The id of the user whose videos we'd like to retrieve.</param> /// <param name="pageSize">Number of items returned per page. A page is a subset of all of the items that satisfy the /// request. The maximum page size is 100.</param> /// <param name="pageNumber">The zero-indexed number of the page to return.</param> /// <param name="sortBy">The field by which to sort the results.</param> /// <param name="sortOrder">How to order the results: ascending or descending.</param> /// <param name="videoFields">A list of the fields you wish to have populated in the /// Videos contained in the returned object. If you omit this parameter, the method returns the /// following fields of the video: id, name, shortDescription, longDescription, creationDate, /// publisheddate, lastModifiedDate, linkURL, linkText, tags, videoStillURL, thumbnailURL, /// referenceId, length, economics, playsTotal, playsTrailingWeek. If you use a token with URL /// access, this method also returns FLVURL, renditions, FLVFullLength, videoFullLength.</param> /// <param name="customFields">A list of the custom fields you wish to have populated /// in the videos contained in the returned object. If you omit this parameter, no custom fields are /// returned, unless you include the value 'customFields' in the video_fields parameter.</param> /// <param name="getItemCount">If true, also return how many total results there are.</param> /// <returns>An ItemCollection representing the requested page of Videos uploaded by the specified user, /// in the order specified.</returns> public BrightcoveItemCollection<BrightcoveVideo> FindVideosByUserId(string userId, int pageSize, int pageNumber, SortBy sortBy, SortOrder sortOrder, IEnumerable<string> videoFields, IEnumerable<string> customFields, bool getItemCount) { NameValueCollection parms = BuildBasicReadParams("find_videos_by_user_id"); parms.Add("user_id", userId); parms.Add("page_size", pageSize.ToString()); parms.Add("page_number", pageNumber.ToString()); parms.Add("sort_by", sortBy.ToBrightcoveName()); parms.Add("sort_order", sortOrder.ToBrightcoveName()); parms.Add("get_item_count", getItemCount.ToString().ToLower()); if (videoFields != null) { parms.AddRange("video_fields", videoFields); } if (customFields != null) { parms.AddRange("custom_fields", customFields); } return RunQuery<BrightcoveItemCollection<BrightcoveVideo>>(parms); }
public static void deleteContactInfo(string Id) { MongoCollection <ContactInfo> objCollection = db.GetCollection <ContactInfo>("c_ContactInfo"); var result = objCollection.FindAndRemove(Query.EQ("_id", ObjectId.Parse(Id)), SortBy.Ascending("_id")); }
/// <summary> /// Sorts the given missions with the given method /// </summary> /// <param name="missions">Missions.</param> /// <param name="sortBy">Sort by.</param> public static void Sort(List<Mission> missions, SortBy sortBy) { if (sortBy == SortBy.NAME) { missions.Sort (Mission.SortByName); } else if (sortBy == SortBy.REWARD) { missions.Sort (Mission.SortByReward); } else if (sortBy == SortBy.PACKAGE_ORDER) { missions.Sort (Mission.SortByPackageOrder); } }
internal void OrganizeSelection(SortBy sortBy, ProgressBy progressBy, string filterMod, bool initializing = false) { int displayMusicID = tMusicPlayer.AllMusic[DisplayBox].music; if (sortBy == SortBy.ID) { musicData = musicData.OrderBy(x => x.music).ToList(); } if (sortBy == SortBy.Name) { musicData = musicData.OrderBy(x => x.name).ToList(); } DisplayBox = tMusicPlayer.AllMusic.FindIndex(x => x.music == displayMusicID); SelectionList.Clear(); if (!viewMode) { // Current view mode is GRID ItemSlotRow newRow = new ItemSlotRow(0, 400, 50); int col = 0; int row = 0; for (int i = 0; i < musicData.Count; i++) { // Filter checks do not happen when initializing // Include all music boxes if FilterMod is left empty // Otherwise find music boxes with the same mod name as the selected filter mod // If Availability isn't 'None' check if the box is obtained or not if (!initializing) { MusicPlayerPlayer modplayer = Main.LocalPlayer.GetModPlayer <MusicPlayerPlayer>(); bool CheckFilterMod = filterMod != "" && (musicData[i].mod != filterMod); bool CheckObtained = progressBy == ProgressBy.Obtained && modplayer.MusicBoxList.All(x => x.Type != musicData[i].musicbox); bool CheckUnobtained = progressBy == ProgressBy.Unobtained && modplayer.MusicBoxList.Any(x => x.Type == musicData[i].musicbox); if (CheckFilterMod || CheckObtained || CheckUnobtained) { continue; } } SelectionSlots[i] = new MusicBoxSlot(musicData[i].musicbox, 0.85f); SelectionSlots[i].Left.Pixels = 20f + (SelectionSlots[i].Width.Pixels + 10f) * col; SelectionSlots[i].Top.Pixels = (newRow.Height.Pixels / 2f) - (SelectionSlots[i].Height.Pixels / 2f); SelectionSlots[i].Id = $"SelectionSlotGrid_{i}"; newRow.Append(SelectionSlots[i]); col++; if (col == 5) { row++; col = 0; SelectionList.Add(newRow); newRow = new ItemSlotRow(row, 400, 50); } } if (col != 0) { // Add the last row if we did not complete it SelectionList.Add(newRow); } } else { // Current view mode is LIST ItemSlotRow newRow; for (int i = 0; i < musicData.Count; i++) { // Include all music boxes if FilterMod is left empty // Otherwise find music boxes with the same mod name as the selected filter mod // If Availability isn't 'None' check if the box is obtained or not if (!initializing) { MusicPlayerPlayer modplayer = Main.LocalPlayer.GetModPlayer <MusicPlayerPlayer>(); bool CheckFilterMod = filterMod != "" && (musicData[i].mod != filterMod); bool CheckObtained = progressBy == ProgressBy.Obtained && modplayer.MusicBoxList.All(x => x.Type != musicData[i].musicbox); bool CheckUnobtained = progressBy == ProgressBy.Unobtained && modplayer.MusicBoxList.Any(x => x.Type == musicData[i].musicbox); if (CheckFilterMod || CheckObtained || CheckUnobtained) { continue; } } newRow = new ItemSlotRow(i, panelTextures[2].Bounds.Width, panelTextures[2].Bounds.Height); // Item Slot SelectionSlots[i] = new MusicBoxSlot(musicData[i].musicbox, 0.85f); SelectionSlots[i].Left.Pixels = 20f; SelectionSlots[i].Top.Pixels = (newRow.Height.Pixels / 2f) - (SelectionSlots[i].Height.Pixels / 2f); SelectionSlots[i].Id = $"SelectionSlotList_{i}"; newRow.Append(SelectionSlots[i]); // Play button HoverButton playSong = new HoverButton(buttonTextures, new Rectangle(24, 0, 22, 22)) { Id = $"altplay_{musicData[i].music}", }; playSong.Width.Pixels = 22f; playSong.Height.Pixels = 22f; playSong.Left.Pixels = SelectionSlots[i].Left.Pixels + SelectionSlots[i].Width.Pixels + 8f; playSong.Top.Pixels = (newRow.Height.Pixels / 2f) - (playSong.Height.Pixels / 2f); playSong.OnClick += (a, b) => ListViewPlaySong(playSong.Id); newRow.Append(playSong); // Song name and mod UIText songName = new UIText(musicData[i].name, 0.85f); songName.Left.Pixels = playSong.Left.Pixels + playSong.Width.Pixels + 8f; songName.Top.Pixels = (newRow.Height.Pixels / 2f) - 15f; newRow.Append(songName); UIText songMod = new UIText(musicData[i].mod, 0.85f); songMod.Left.Pixels = playSong.Left.Pixels + playSong.Width.Pixels + 8f; songMod.Top.Pixels = (newRow.Height.Pixels / 2f) + 4f; newRow.Append(songMod); SelectionList.Add(newRow); } } SelectionList.SetScrollbar(selectionScrollBar); }
/// <summary> /// Selects the next sorting mechanism /// </summary> private void nextSort() { currentSort = currentSort.Next (); if (currentSort == SortBy.PACKAGE_ORDER && !currentPackage.ownOrder) { currentSort = currentSort.Next (); } }
public SortByEnum Get() { return(SortBy.From(GetRecord().Name)); }
ADPagedReader <TResult> IConfigurationSession.FindPaged <TResult>(ADObjectId rootId, QueryScope scope, QueryFilter filter, SortBy sortBy, int pageSize) { return(base.InvokeWithAPILogging <ADPagedReader <TResult> >(() => this.GetSession().FindPaged <TResult>(rootId, scope, filter, sortBy, pageSize), "FindPaged")); }
public static void deleteEntertainment(string Id) { MongoCollection <Entertainment> objCollection = db.GetCollection <Entertainment>("c_Entertainment"); var result = objCollection.FindAndRemove(Query.EQ("_id", ObjectId.Parse(Id)), SortBy.Ascending("_id")); }
public async Task <DataResult <Task <DomainProjectForAdmin> > > GetAsyncSequenceAsync(DataQueryOptions filter) { var query = new List <IMongoQuery>(filter.Filters.Count); // filtering List <DataFilterRule> filters = filter.Filters.Where(f => f.Value != null).ToList(); foreach (DataFilterRule dataFilterRule in filters) { DataFilterRule f = dataFilterRule; if (string.Compare(f.Name, NameOfHelper.PropertyName <DomainProjectForAdmin>(x => x.Name), StringComparison.OrdinalIgnoreCase) == 0 && f.Type == DataFilterTypes.Equal) { // by name query.Add(Query.Text(f.Value.ToString().ToLowerInvariant())); } else if (string.Compare(f.Name, NameOfHelper.PropertyName <DomainProjectForAdmin>(x => x.ProductType), StringComparison.OrdinalIgnoreCase) == 0 && f.Type == DataFilterTypes.Equal) { // by product type var productId = Int32.Parse(f.Value.ToString()); query.Add(Query <ProjectEntity> .EQ(p => p.ProductId, productId)); } else if (string.Compare(f.Name, NameOfHelper.PropertyName <DomainProjectForAdmin>(x => x.UserId), StringComparison.OrdinalIgnoreCase) == 0 && f.Type == DataFilterTypes.Equal) { // by user id query.Add(Query <ProjectEntity> .EQ(p => p.UserId, f.Value.ToString())); } else if (string.Compare(f.Name, NameOfHelper.PropertyName <DomainProjectForAdmin>(x => x.UserName), StringComparison.OrdinalIgnoreCase) == 0 && f.Type == DataFilterTypes.Equal) { // by user name List <UserEntity> profiles = await _userRepository.FindByNameAsync(f.Value.ToString()); if (profiles.Count == 0) { // no users found return(new DataResult <Task <DomainProjectForAdmin> >(new Task <DomainProjectForAdmin>[] { })); } List <string> allIds = profiles.Select(prof => prof.Id).ToList(); query.Add(Query <ProjectEntity> .Where(p => allIds.Contains(p.UserId))); } else if (string.Compare(f.Name, NameOfHelper.PropertyName <DomainProjectForAdmin>(x => x.Created), StringComparison.OrdinalIgnoreCase) == 0) { // by created date var date = (DateTime)f.Value; switch (f.Type) { case DataFilterTypes.Equal: query.Add(Query <ProjectEntity> .EQ(p => p.Created, date)); break; case DataFilterTypes.LessThan: query.Add(Query <ProjectEntity> .LT(p => p.Created, date)); break; case DataFilterTypes.LessThanOrEqual: query.Add(Query <ProjectEntity> .LTE(p => p.Created, date)); break; case DataFilterTypes.GreaterThan: query.Add(Query <ProjectEntity> .GT(p => p.Created, date)); break; case DataFilterTypes.GreaterThanOrEqual: query.Add(Query <ProjectEntity> .GTE(p => p.Created, date)); break; } } else { throw new NotSupportedException(string.Format("Filter {0} by property {1} is not supported", f.Type, f.Name)); } } if (!filters.Any() && !string.IsNullOrEmpty(filter.OrderBy)) { // MongoDb 2.6 HACK!!! // adding fake query to hint proper index if (string.Compare(filter.OrderBy, NameOfHelper.PropertyName <DomainProjectForAdmin>(x => x.Name), StringComparison.OrdinalIgnoreCase) == 0) { // order by name query.Add(Query <ProjectEntity> .Exists(p => p.Name)); } else if (string.Compare(filter.OrderBy, NameOfHelper.PropertyName <DomainProjectForAdmin>(x => x.Created), StringComparison.OrdinalIgnoreCase) == 0) { // order by created query.Add(Query <ProjectEntity> .Exists(p => p.Created)); } else if (string.Compare(filter.OrderBy, NameOfHelper.PropertyName <DomainProjectForAdmin>(x => x.ProductType), StringComparison.OrdinalIgnoreCase) == 0) { // order by product type query.Add(Query <ProjectEntity> .Exists(p => p.ProductId)); } } MongoCursor <ProjectEntity> cursor = _projectRepository.Collection.Find(query.Count > 0 ? Query.And(query) : Query.Null); IMongoSortBy sortOrder = null; // sorting if (string.Compare(filter.OrderBy, NameOfHelper.PropertyName <DomainProjectForAdmin>(x => x.Name), StringComparison.OrdinalIgnoreCase) == 0) { // order by name sortOrder = filter.OrderByDirection == OrderByDirections.Asc ? SortBy <ProjectEntity> .Ascending(p => p.Name) : SortBy <ProjectEntity> .Descending(p => p.Name); } else if (string.Compare(filter.OrderBy, NameOfHelper.PropertyName <DomainProjectForAdmin>(x => x.Created), StringComparison.OrdinalIgnoreCase) == 0) { // order by created sortOrder = filter.OrderByDirection == OrderByDirections.Asc ? SortBy <ProjectEntity> .Ascending(p => p.Created) : SortBy <ProjectEntity> .Descending(p => p.Created); } else if (string.Compare(filter.OrderBy, NameOfHelper.PropertyName <DomainProjectForAdmin>(x => x.ProductType), StringComparison.OrdinalIgnoreCase) == 0) { // order by product type sortOrder = filter.OrderByDirection == OrderByDirections.Asc ? SortBy <ProjectEntity> .Ascending(p => p.ProductId) : SortBy <ProjectEntity> .Descending(p => p.ProductId); } if (sortOrder != null) { cursor.SetSortOrder(sortOrder); } // paging if (filter.Skip.HasValue) { cursor.SetSkip(filter.Skip.Value); } if (filter.Take.HasValue) { cursor.SetLimit(filter.Take.Value); } // Count of results long?count = null; if (filter.Count) { count = cursor.Count(); } // post-processing return(new DataResult <Task <DomainProjectForAdmin> >(cursor.Select(GetProjectDataAsync), count)); }
private void Sort_Click(object sender, EventArgs e) { if (ComboBox1.SelectedItem != null) { string txt = ComboBox1.SelectedItem.ToString(); if (RadioButton1.Checked) { switch (txt) { case "Car name": var query = SortBy.Ascending("Car_name"); List <Form1.CarTable> list = collection.FindAllAs <Form1.CarTable>().SetSortOrder(query).ToList(); metroGrid2.DataSource = list; break; case "Company": var query1 = SortBy.Ascending("Car_company"); List <Form1.CarTable> list1 = collection.FindAllAs <Form1.CarTable>().SetSortOrder(query1).ToList(); metroGrid2.DataSource = list1; break; case "Model No.": var query2 = SortBy.Ascending("Model"); List <Form1.CarTable> list2 = collection.FindAllAs <Form1.CarTable>().SetSortOrder(query2).ToList(); metroGrid2.DataSource = list2; break; case "Price": var query3 = SortBy.Ascending("Price"); List <Form1.CarTable> list3 = collection.FindAllAs <Form1.CarTable>().OrderBy(c => double.Parse(c.Price)).ToList(); metroGrid2.DataSource = list3; break; case "Colour": var query4 = SortBy.Ascending("Colour"); List <Form1.CarTable> list4 = collection.FindAllAs <Form1.CarTable>().SetSortOrder(query4).ToList(); metroGrid2.DataSource = list4; break; case "Mileage": var query5 = SortBy.Ascending("Mileage"); List <Form1.CarTable> list5 = collection.FindAllAs <Form1.CarTable>().OrderBy(c => double.Parse(c.Mileage)).ToList(); metroGrid2.DataSource = list5; break; case "Class": var query6 = SortBy.Ascending("Car_class"); List <Form1.CarTable> list6 = collection.FindAllAs <Form1.CarTable>().SetSortOrder(query6).ToList(); metroGrid2.DataSource = list6; break; case "Fuel": var query7 = SortBy.Ascending("Fuel_type"); List <Form1.CarTable> list7 = collection.FindAllAs <Form1.CarTable>().SetSortOrder(query7).ToList(); metroGrid2.DataSource = list7; break; } } else if (RadioButton2.Checked) { switch (txt) { case "Car name": var query = SortBy.Descending("Car_name"); List <Form1.CarTable> list = collection.FindAllAs <Form1.CarTable>().SetSortOrder(query).ToList(); metroGrid2.DataSource = list; break; case "Company": var query1 = SortBy.Descending("Car_company"); List <Form1.CarTable> list1 = collection.FindAllAs <Form1.CarTable>().SetSortOrder(query1).ToList(); metroGrid2.DataSource = list1; break; case "Model No.": var query2 = SortBy.Descending("Model"); List <Form1.CarTable> list2 = collection.FindAllAs <Form1.CarTable>().SetSortOrder(query2).ToList(); metroGrid2.DataSource = list2; break; case "Price": var query3 = SortBy.Descending("Price"); List <Form1.CarTable> list3 = collection.FindAllAs <Form1.CarTable>().OrderBy(c => double.Parse(c.Price)).Reverse().ToList(); metroGrid2.DataSource = list3; break; case "Colour": var query4 = SortBy.Descending("Colour"); List <Form1.CarTable> list4 = collection.FindAllAs <Form1.CarTable>().SetSortOrder(query4).ToList(); metroGrid2.DataSource = list4; break; case "Mileage": var query5 = SortBy.Descending("Mileage"); List <Form1.CarTable> list5 = collection.FindAllAs <Form1.CarTable>().OrderBy(c => double.Parse(c.Mileage)).Reverse().ToList(); metroGrid2.DataSource = list5; break; case "Class": var query6 = SortBy.Descending("Car_class"); List <Form1.CarTable> list6 = collection.FindAllAs <Form1.CarTable>().SetSortOrder(query6).ToList(); metroGrid2.DataSource = list6; break; case "Fuel": var query7 = SortBy.Descending("Fuel_type"); List <Form1.CarTable> list7 = collection.FindAllAs <Form1.CarTable>().SetSortOrder(query7).ToList(); metroGrid2.DataSource = list7; break; } } else { MessageBox.Show("Fields cannot be blank"); } metroGrid2.Columns[0].Visible = false; metroGrid2.Columns[9].Visible = false; } else { MessageBox.Show("Fields cannot be blank"); } Clear(); }
public Pagination <IEnumerable <Item>, SortBy> CartItemss(int page, int pageSize, SortBy sortby) { return(new Pagination <IEnumerable <Item>, SortBy>() { PageSize = pageSize, CurrentPage = page, TotalCount = cartservice.TotalItems(), Data = cartservice.CartItems(page - 1, pageSize, sortby), Sorter = sortby }); }
public UnitComparer(SortBy sortBy) { this.sortBy = sortBy; }
public Pagination <IEnumerable <Item>, SortBy> PagedItems(int page, int pageSize, SortBy sortby) { return(new Pagination <IEnumerable <Item>, SortBy>() { PageSize = pageSize, CurrentPage = page, TotalCount = itemsrepository.ItemssCount(), Data = itemsrepository.FilteredItems(page - 1, pageSize, sortby), Sorter = sortby }); }
public ICollection <Organization> GetByCriteria(string criteria, PagingOptions paging, OrganizationSortBy sortBy, bool?paid = null, bool?suspended = null) { var options = new MongoOptions().WithPaging(paging); if (!String.IsNullOrWhiteSpace(criteria)) { options.Query = options.Query.And(Query.Matches(FieldNames.Name, new BsonRegularExpression(String.Format("/{0}/i", criteria)))); } if (paid.HasValue) { if (paid.Value) { options.Query = options.Query.And(Query.NE(FieldNames.PlanId, new BsonString(BillingManager.FreePlan.Id))); } else { options.Query = options.Query.And(Query.EQ(FieldNames.PlanId, new BsonString(BillingManager.FreePlan.Id))); } } if (suspended.HasValue) { if (suspended.Value) { options.Query = options.Query.And( Query.Or( Query.And( Query.NE(FieldNames.BillingStatus, new BsonInt32((int)BillingStatus.Active)), Query.NE(FieldNames.BillingStatus, new BsonInt32((int)BillingStatus.Trialing)), Query.NE(FieldNames.BillingStatus, new BsonInt32((int)BillingStatus.Canceled)) ), Query.EQ(FieldNames.IsSuspended, new BsonBoolean(true)))); } else { options.Query = options.Query.And( Query.Or( Query.EQ(FieldNames.BillingStatus, new BsonInt32((int)BillingStatus.Active)), Query.EQ(FieldNames.BillingStatus, new BsonInt32((int)BillingStatus.Trialing)), Query.EQ(FieldNames.BillingStatus, new BsonInt32((int)BillingStatus.Canceled)) ), Query.EQ(FieldNames.IsSuspended, new BsonBoolean(false))); } } switch (sortBy) { case OrganizationSortBy.Newest: options.SortBy = SortBy.Descending(FieldNames.Id); break; case OrganizationSortBy.Subscribed: options.SortBy = SortBy.Descending(FieldNames.SubscribeDate); break; case OrganizationSortBy.MostActive: options.SortBy = SortBy.Descending(FieldNames.TotalEventCount); break; default: options.SortBy = SortBy.Ascending(FieldNames.Name); break; } return(Find <Organization>(options)); }
/// <summary> /// Searches videos according to the criteria provided by the user. /// </summary> /// <param name="all">Specifies the field:value pairs for search criteria that MUST be present in /// the index in order to return a hit in the result set. If the field's name is not present, it is /// assumed to be name and shortDescription.</param> /// <param name="any">Specifies the field:value pairs for search criteria AT LEAST ONE of which /// must be present to return a hit in the result set. If the field's name is not present, it is /// assumed to be name and shortDescription.</param> /// <param name="none">Specifies the field:value pairs for search criteria that MUST NOT be present /// to return a hit in the result set. If the field's name is not present, it is assumed to be /// name and shortDescription.</param> /// <param name="pageSize">Number of items returned per page. (max 100)</param> /// <param name="pageNumber">The zero-indexed number of the page to return.</param> /// <param name="exact">If true, disables fuzzy search and requires an exact match of search terms. /// A fuzzy search does not require an exact match of the indexed terms, but will return a hit for /// terms that are closely related based on language-specific criteria. The fuzzy search is /// available only if your account is based in the United States.</param> /// <param name="sortBy">Specifies the field by which to sort results.</param> /// <param name="sortOrder">Specifies the direction in which to sort results</param> /// <param name="videoFields">A list of the fields you wish to have populated in the Videos contained /// in the returned object. If you omit this parameter, the method returns the following fields of /// the video: id, name, shortDescription, longDescription, creationDate, publisheddate, lastModifiedDate, /// linkURL, linkText, tags, videoStillURL, thumbnailURL, referenceId, length, economics, playsTotal, /// playsTrailingWeek. If you use a token with URL access, this method also returns FLVURL, renditions, /// FLVFullLength, videoFullLength.</param> /// <param name="customFields">A list of the custom fields you wish to have populated in the videos /// contained in the returned object. If you omit this parameter, no custom fields are returned, unless you /// include the value 'customFields' in the video_fields parameter.</param> /// <param name="getItemCount">If true, also return how many total results there are.</param> /// <returns>A collection of videos matching the specified criteria.</returns> public BrightcoveItemCollection<BrightcoveVideo> SearchVideos(IEnumerable<FieldValuePair> all, IEnumerable<FieldValuePair> any, IEnumerable<FieldValuePair> none, int pageSize, int pageNumber, bool exact, SortBy sortBy, SortOrder sortOrder, IEnumerable<string> videoFields, IEnumerable<string> customFields, bool getItemCount) { NameValueCollection parms = BuildBasicReadParams("search_videos"); parms.Add("get_item_count", getItemCount.ToString().ToLower()); parms.Add("exact", exact.ToString().ToLower()); parms.Add("page_size", pageSize.ToString()); parms.Add("page_number", pageNumber.ToString()); parms.Add("sort_by", sortBy.ToBrightcoveName()); parms.Add("sort_order", sortOrder.ToBrightcoveName()); if (videoFields != null) { parms.AddRange("video_fields", videoFields); } if (customFields != null) { parms.AddRange("custom_fields", customFields); } if (all != null) { parms.AddRange("all", all.Select(o => o.ToBrightcoveString())); } if (any != null) { parms.AddRange("any", any.Select(o => o.ToBrightcoveString())); } if (none != null) { parms.AddRange("none", none.Select(o => o.ToBrightcoveString())); } return RunQuery<BrightcoveItemCollection<BrightcoveVideo>>(parms); }
public IQueryable <Complaint> SearchComplaints( SortBy sort = SortBy.IdDesc, SearchComplaintStatus?complaintStatus = null, SearchDeleteStatus?deleteStatus = null, DateTime?DateReceivedFrom = null, DateTime?DateReceivedTo = null, string ReceivedById = null, DateTime?DateComplaintClosedFrom = null, DateTime?DateComplaintClosedTo = null, string CallerName = null, string CallerRepresents = null, string ComplaintNature = null, string ComplaintLocation = null, string ComplaintDirections = null, string ComplaintCity = null, int?ComplaintCountyId = null, Guid?ConcernId = null, string SourceFacilityId = null, string SourceFacilityName = null, string SourceContactName = null, string SourceStreet = null, string SourceCity = null, int?SourceStateId = null, string SourcePostalCode = null, Guid?Office = null, string Owner = null ) { var complaints = _context.Complaints.AsNoTracking(); // Filters if (complaintStatus.HasValue) { switch (complaintStatus.Value) { case SearchComplaintStatus.Closed: complaints = complaints.Where(e => e.Status == ComplaintStatus.Closed); break; case SearchComplaintStatus.New: complaints = complaints.Where(e => e.Status == ComplaintStatus.New); break; case SearchComplaintStatus.ReviewPending: complaints = complaints.Where(e => e.Status == ComplaintStatus.ReviewPending); break; case SearchComplaintStatus.UnderInvestigation: complaints = complaints.Where(e => e.Status == ComplaintStatus.UnderInvestigation); break; case SearchComplaintStatus.Open: complaints = complaints.Where(e => e.Status != ComplaintStatus.Closed); break; } } if (deleteStatus.HasValue) { if (deleteStatus.Value == SearchDeleteStatus.Deleted) { complaints = complaints.Where(e => e.Deleted); } // Do not filter if deleteStatus.Value == SearchDeleteStatus.All } else { complaints = complaints .Where(e => !e.Deleted); } if (DateReceivedFrom.HasValue) { complaints = complaints.Where(e => DateReceivedFrom.Value <= e.DateReceived); } if (DateReceivedTo.HasValue) { complaints = complaints.Where(e => e.DateReceived.Date <= DateReceivedTo.Value); } if (!string.IsNullOrEmpty(ReceivedById)) { complaints = complaints.Where(e => e.ReceivedById == ReceivedById); } if (DateComplaintClosedFrom.HasValue) { complaints = complaints.Where(e => e.DateComplaintClosed.HasValue && DateComplaintClosedFrom.Value <= e.DateComplaintClosed.Value); } if (DateComplaintClosedTo.HasValue) { complaints = complaints.Where(e => e.DateComplaintClosed.HasValue && e.DateComplaintClosed.Value.Date <= DateComplaintClosedTo.Value); } if (!string.IsNullOrEmpty(CallerName)) { complaints = complaints.Where(e => e.CallerName.ToLower().Contains(CallerName.ToLower())); } if (!string.IsNullOrEmpty(CallerRepresents)) { complaints = complaints.Where(e => e.CallerRepresents.ToLower().Contains(CallerRepresents.ToLower())); } if (!string.IsNullOrEmpty(ComplaintNature)) { complaints = complaints.Where(e => e.ComplaintNature.ToLower().Contains(ComplaintNature.ToLower())); } if (!string.IsNullOrEmpty(ComplaintLocation)) { complaints = complaints.Where(e => e.ComplaintLocation.ToLower().Contains(ComplaintLocation.ToLower())); } if (!string.IsNullOrEmpty(ComplaintDirections)) { complaints = complaints.Where(e => e.ComplaintDirections.ToLower().Contains(ComplaintDirections.ToLower())); } if (!string.IsNullOrEmpty(ComplaintCity)) { complaints = complaints.Where(e => e.ComplaintCity.ToLower().Contains(ComplaintCity.ToLower())); } if (ComplaintCountyId.HasValue) { complaints = complaints.Where(e => e.ComplaintCountyId.HasValue && e.ComplaintCountyId.Value == ComplaintCountyId.Value); } if (ConcernId.HasValue) { complaints = complaints .Where(e => (e.PrimaryConcernId.HasValue && e.PrimaryConcernId.Value == ConcernId.Value) || (e.SecondaryConcernId.HasValue && e.SecondaryConcernId.Value == ConcernId.Value)); } if (!string.IsNullOrEmpty(SourceFacilityId)) { complaints = complaints.Where(e => e.SourceFacilityId.ToLower().Contains(SourceFacilityId.ToLower())); } if (!string.IsNullOrEmpty(SourceFacilityName)) { complaints = complaints.Where(e => e.SourceFacilityName.ToLower().Contains(SourceFacilityName.ToLower())); } if (!string.IsNullOrEmpty(SourceContactName)) { complaints = complaints.Where(e => e.SourceContactName.ToLower().Contains(SourceContactName.ToLower())); } if (!string.IsNullOrEmpty(SourceStreet)) { complaints = complaints .Where(e => e.SourceStreet.ToLower().Contains(SourceStreet.ToLower()) || e.SourceStreet2.ToLower().Contains(SourceStreet.ToLower())); } if (!string.IsNullOrEmpty(SourceCity)) { complaints = complaints.Where(e => e.SourceCity.ToLower().Contains(SourceCity.ToLower())); } if (SourceStateId.HasValue) { complaints = complaints.Where(e => e.SourceStateId.HasValue && e.SourceStateId.Value == SourceStateId.Value); } if (!string.IsNullOrEmpty(SourcePostalCode)) { complaints = complaints.Where(e => e.SourcePostalCode.ToLower().Contains(SourcePostalCode.ToLower())); } if (Office.HasValue) { complaints = complaints.Where(e => e.CurrentOfficeId == Office.Value); } if (!string.IsNullOrEmpty(Owner)) { complaints = complaints.Where(e => e.CurrentOwnerId == Owner); } // Sort complaints = sort switch { SortBy.IdAsc => complaints.OrderBy(e => e.Id), SortBy.ReceivedDateAsc => complaints.OrderBy(e => e.DateReceived).ThenBy(e => e.Id), SortBy.ReceivedDateDesc => complaints.OrderByDescending(e => e.DateReceived).ThenBy(e => e.Id), SortBy.StatusAsc => complaints.OrderBy(e => (int)e.Status).ThenBy(e => e.Id), SortBy.StatusDesc => complaints.OrderByDescending(e => (int)e.Status).ThenBy(e => e.Id), _ => complaints.OrderByDescending(e => e.Id), }; return(complaints .Include(e => e.CurrentOffice) .Include(e => e.CurrentOwner) .Include(e => e.ReceivedBy) .Include(e => e.SourceState)); }
/// <summary> /// Searches videos according to the criteria provided by the user. /// </summary> /// <param name="all">Specifies the field:value pairs for search criteria that MUST be present in /// the index in order to return a hit in the result set. If the field's name is not present, it is /// assumed to be name and shortDescription.</param> /// <param name="any">Specifies the field:value pairs for search criteria AT LEAST ONE of which /// must be present to return a hit in the result set. If the field's name is not present, it is /// assumed to be name and shortDescription.</param> /// <param name="none">Specifies the field:value pairs for search criteria that MUST NOT be present /// to return a hit in the result set. If the field's name is not present, it is assumed to be /// name and shortDescription.</param> /// <param name="pageSize">Number of items returned per page. (max 100)</param> /// <param name="pageNumber">The zero-indexed number of the page to return.</param> /// <param name="exact">If true, disables fuzzy search and requires an exact match of search terms. /// A fuzzy search does not require an exact match of the indexed terms, but will return a hit for /// terms that are closely related based on language-specific criteria. The fuzzy search is /// available only if your account is based in the United States.</param> /// <param name="sortBy">Specifies the field by which to sort results.</param> /// <param name="sortOrder">Specifies the direction in which to sort results</param> public BrightcoveItemCollection<BrightcoveVideo> SearchVideos(IEnumerable<FieldValuePair> all, IEnumerable<FieldValuePair> any, IEnumerable<FieldValuePair> none, int pageSize, int pageNumber, bool exact, SortBy sortBy, SortOrder sortOrder) { return SearchVideos(all, any, none, pageSize, pageNumber, exact, sortBy, sortOrder, null, null); }
/// <summary> /// 获取筛选条件下的所有文章 /// </summary> /// <param name="cateAlias"></param> /// <param name="pageIndex"></param> /// <param name="pageSize"></param> /// <param name="sortBy"></param> /// <param name="filtType"></param> /// <param name="keyword"></param> /// <returns></returns> public async Task<PostResult> GetPosts(string cateAlias, int pageIndex, int pageSize, SortBy sortBy = SortBy.Latest, FiltType filtType = FiltType.Content, string keyword = "") { var result = new PostResult(); var query = await _posts.Collection.Find(x => x.IsActive).ToListAsync(); if (!string.IsNullOrWhiteSpace(cateAlias)) { query = query.Where(x => x.CategoryAlias.ToUpper() == cateAlias.ToUpper()).ToList(); } if (!string.IsNullOrWhiteSpace(keyword)) { if (filtType == FiltType.Title) { query = query.Where(x => x.Title.Contains(keyword)).ToList(); } else if (filtType == FiltType.Label) { query = query.Where(x => x.Labels.Contains(keyword)).ToList(); } else if (filtType == FiltType.Datetime) { DateTime dt; DateTime.TryParse(keyword, out dt); query = query.Where(x => x.CreateTime.Date == dt.Date).ToList(); } else { query = query.Where(x => x.Content != null ? (x.Title.Contains(keyword) || x.Summary.Contains(keyword) || x.Content.Contains(keyword)) : (x.Title.Contains(keyword) || x.Summary.Contains(keyword))).ToList(); } } result.PostCount = query.Count; if (sortBy == SortBy.Hotest) { query = query.OrderByDescending(x => x.ViewCount).ThenByDescending(x => x.CreateTime).ToList(); } else { query = query.OrderByDescending(x => x.CreateTime).ToList(); } result.PostList = query.Skip((pageIndex - 1) * pageSize).Take(pageSize).ToList(); return result; }
/// <summary> /// Retrieves the videos uploaded by the specified user id. This method can be used to find videos submitted using /// the consumer-generated media (CGM) module. /// </summary> /// <param name="userId">The id of the user whose videos we'd like to retrieve.</param> /// <param name="pageSize">Number of items returned per page. A page is a subset of all of the items that satisfy the /// request. The maximum page size is 100.</param> /// <param name="pageNumber">The zero-indexed number of the page to return.</param> /// <param name="sortBy">The field by which to sort the results.</param> /// <param name="sortOrder">How to order the results: ascending or descending.</param> /// <param name="videoFields">A list of the fields you wish to have populated in the /// Videos contained in the returned object. If you omit this parameter, the method returns the /// following fields of the video: id, name, shortDescription, longDescription, creationDate, /// publisheddate, lastModifiedDate, linkURL, linkText, tags, videoStillURL, thumbnailURL, /// referenceId, length, economics, playsTotal, playsTrailingWeek. If you use a token with URL /// access, this method also returns FLVURL, renditions, FLVFullLength, videoFullLength.</param> /// <returns>An ItemCollection representing the requested page of Videos uploaded by the specified user, /// in the order specified.</returns> public BrightcoveItemCollection<BrightcoveVideo> FindVideosByUserId(string userId, int pageSize, int pageNumber, SortBy sortBy, SortOrder sortOrder, IEnumerable<string> videoFields) { return FindVideosByUserId(userId, pageSize, pageNumber, sortBy, sortOrder, videoFields, null); }
internal static SortBy ShowSortMenu(SortBy currentSortBy) { var newSortBy = new SortBy(); GUIDialogMenu dlg = (GUIDialogMenu)GUIWindowManager.GetWindow((int)GUIWindow.Window.WINDOW_DIALOG_MENU); if (dlg == null) return null; dlg.Reset(); dlg.SetHeading(495); // Sort options // Add generic sortby fields GUIListItem pItem = new GUIListItem(Translation.Title); dlg.Add(pItem); pItem.ItemId = (int)SortingFields.Title; pItem = new GUIListItem(Translation.ReleaseDate); dlg.Add(pItem); pItem.ItemId = (int)SortingFields.ReleaseDate; pItem = new GUIListItem(Translation.Score); dlg.Add(pItem); pItem.ItemId = (int)SortingFields.Score; pItem = new GUIListItem(Translation.Votes); dlg.Add(pItem); pItem.ItemId = (int)SortingFields.Votes; pItem = new GUIListItem(Translation.Runtime); dlg.Add(pItem); pItem.ItemId = (int)SortingFields.Runtime; // Trending if (GUIWindowManager.ActiveWindow == (int)TraktGUIWindows.TrendingMovies || GUIWindowManager.ActiveWindow == (int)TraktGUIWindows.TrendingShows) { pItem = new GUIListItem(Translation.Watchers); dlg.Add(pItem); pItem.ItemId = (int)SortingFields.PeopleWatching; } // Watchlist if (GUIWindowManager.ActiveWindow == (int)TraktGUIWindows.WatchedListMovies || GUIWindowManager.ActiveWindow == (int)TraktGUIWindows.WatchedListShows) { pItem = new GUIListItem(Translation.Inserted); dlg.Add(pItem); pItem.ItemId = (int)SortingFields.WatchListInserted; } // set the focus to currently used sort method dlg.SelectedLabel = (int)currentSortBy.Field; // show dialog and wait for result dlg.DoModal(GUIWindowManager.ActiveWindow); if (dlg.SelectedId == -1) return null; switch (dlg.SelectedId) { case (int)SortingFields.Title: newSortBy.Field = SortingFields.Title; break; case (int)SortingFields.ReleaseDate: newSortBy.Field = SortingFields.ReleaseDate; newSortBy.Direction = SortingDirections.Descending; break; case (int)SortingFields.Score: newSortBy.Field = SortingFields.Score; newSortBy.Direction = SortingDirections.Descending; break; case (int)SortingFields.Votes: newSortBy.Field = SortingFields.Votes; newSortBy.Direction = SortingDirections.Descending; break; case (int)SortingFields.Runtime: newSortBy.Field = SortingFields.Runtime; break; case (int)SortingFields.PeopleWatching: newSortBy.Field = SortingFields.PeopleWatching; newSortBy.Direction = SortingDirections.Descending; break; case (int)SortingFields.WatchListInserted: newSortBy.Field = SortingFields.WatchListInserted; break; default: newSortBy.Field = SortingFields.Title; break; } return newSortBy; }
public override void ReadSectionSettings() { base.ReadSectionSettings(); try { this._allowComments = Convert.ToBoolean(base.Section.Settings["ALLOW_COMMENTS"]); this._allowAnonymousComments = Convert.ToBoolean(base.Section.Settings["ALLOW_ANONYMOUS_COMMENTS"]); this._allowSyndication = Convert.ToBoolean(base.Section.Settings["ALLOW_SYNDICATION"]); this._showArchive = Convert.ToBoolean(base.Section.Settings["SHOW_ARCHIVE"]); this._showAuthor = Convert.ToBoolean(base.Section.Settings["SHOW_AUTHOR"]); this._showCategory = Convert.ToBoolean(base.Section.Settings["SHOW_CATEGORY"]); this._showDateTime = Convert.ToBoolean(base.Section.Settings["SHOW_DATETIME"]); this._numberOfArticlesInList = Convert.ToInt32(base.Section.Settings["NUMBER_OF_ARTICLES_IN_LIST"]); this._displayType = (DisplayType)Enum.Parse(typeof(DisplayType), base.Section.Settings["DISPLAY_TYPE"].ToString()); this._sortBy = (SortBy)Enum.Parse(typeof(SortBy), base.Section.Settings["SORT_BY"].ToString()); this._sortDirection = (SortDirection)Enum.Parse(typeof(SortDirection), base.Section.Settings["SORT_DIRECTION"].ToString()); } catch { // Only if the module settings are not in the database yet for some reason. this._sortBy = SortBy.DateOnline; this._sortDirection = SortDirection.DESC; } }
/// <summary> /// Controls the order of children added to items decorated with this attribute. /// </summary> public static Builder <IDefinitionRefiner> SortChildren <TModel>(this IContentRegistration <TModel> registration, SortBy sortingOrder, string expression = null) { return(registration.RegisterRefiner <IDefinitionRefiner>(new AppendAttributeRefiner(new SortChildrenAttribute(sortingOrder) { SortExpression = expression }))); }
public static Builder<IDefinitionRefiner> SortChildren(this IContentRegistration registration, SortBy sortingOrder, string expression = null) { return registration.RegisterRefiner<IDefinitionRefiner>(new AppendAttributeRefiner(new SortChildrenAttribute(sortingOrder) { SortExpression = expression })); }
// <summary> /// Deletes the role with the specified id /// </summary> /// <param name="roleId">Id of the role to delete</param> /// <returns>Result of the operation, true if was ok</returns> public bool Delete(ObjectId id) { Parcel parcel = Parcels.FindOneById(id); FindAndModifyResult parcelResult = Parcels.FindAndRemove(Query.EQ("_id", id), SortBy.Ascending("_id")); return(parcelResult.Ok); }
/// <summary> /// Get correct sort string /// </summary> private string GetSortString(Song song, SortBy sortBy, int level) { if (sortBy == SortBy.Artist) { switch (level) { case 0: return song.Artist; case 1: return song.Name; case 2: return song.Year; } } else if (sortBy == SortBy.Name) { switch (level) { case 0: return song.Name; case 1: return song.Artist; case 2: return song.TempId; } } else if (sortBy == SortBy.Date) { switch (level) { case 0: return song.DateCreated; case 1: return song.Artist; case 2: return song.Name; } } else if (sortBy == SortBy.PlayDate) { switch (level) { case 0: if (song.LastPlayDateTime.HasValue) return song.LastPlayDateTime.Value.ToString("yyyy-MM-dd HH:mm:ss.fff"); return string.Empty; case 1: return song.Artist; case 2: return song.Name; } } else if (sortBy == SortBy.Genre) { switch (level) { case 0: return song.Genre; case 1: return song.Artist; case 2: return song.Name; } } else if (sortBy == SortBy.Year) { switch (level) { case 0: return song.Year; case 1: return song.Artist; case 2: return song.Name; } } else if (sortBy == SortBy.Rating) { switch (level) { case 0: return song.Rating.ToString("00"); case 1: return song.Name; case 2: return song.Artist; } } else if (sortBy == SortBy.Album) { switch (level) { case 0: return song.Album; case 1: return song.Name; case 2: return song.Artist; } } return string.Empty; }
public async Task <IActionResult> Get( int page = 1, int size = 10, string keywords = "", SortBy sort = SortBy.LastReply, OrderBy order = OrderBy.Desc) { // Get search settings var searchSettings = await _searchSettingsStore.GetAsync(); // Set default sort column if auto is specified if (sort == SortBy.LastReply) { // Get search settings if (searchSettings != null) { sort = searchSettings.SearchType == SearchTypes.Tsql ? SortBy.LastReply : SortBy.Rank; } else { sort = SortBy.LastReply; } } // Get results var entities = await _searchService .ConfigureDb(o => { if (searchSettings != null) { o.SearchType = searchSettings.SearchType; } }) .ConfigureQuery(async q => { // Hide hidden? if (!await _authorizationService.AuthorizeAsync(HttpContext.User, Permissions.SearchHidden)) { q.HidePrivate.True(); } // Hide spam? if (!await _authorizationService.AuthorizeAsync(HttpContext.User, Permissions.SearchSpam)) { q.HideSpam.True(); } // Hide deleted? if (!await _authorizationService.AuthorizeAsync(HttpContext.User, Permissions.SearchDeleted)) { q.HideDeleted.True(); } // Hide private? if (!await _authorizationService.AuthorizeAsync(HttpContext.User, Permissions.SearchPrivate)) { q.HidePrivate.True(); } }) .GetResultsAsync(new EntityIndexOptions() { Search = keywords, Sort = sort, Order = order }, new PagerOptions() { Page = page, Size = size }); IPagedResults <SearchApiResult> results = null; if (entities != null) { results = new PagedResults <SearchApiResult> { Total = entities.Total }; foreach (var entity in entities.Data) { var url = _contextFacade.GetRouteUrl(new RouteValueDictionary() { ["area"] = entity.ModuleId, ["controller"] = "Home", ["action"] = "Display", ["opts.id"] = entity.Id, ["opts.alias"] = entity.Alias }); if (string.IsNullOrEmpty(entity.CreatedBy.Avatar.Url)) { entity.CreatedBy.Avatar.Url = _contextFacade.GetRouteUrl(entity.CreatedBy.Avatar.DefaultRoute); } if (string.IsNullOrEmpty(entity.ModifiedBy.Avatar.Url)) { entity.ModifiedBy.Avatar.Url = _contextFacade.GetRouteUrl(entity.ModifiedBy.Avatar.DefaultRoute); } results.Data.Add(new SearchApiResult() { Id = entity.Id, CreatedBy = new UserApiResult() { Id = entity.CreatedBy.Id, DisplayName = entity.CreatedBy.DisplayName, UserName = entity.CreatedBy.UserName, Avatar = entity.CreatedBy.Avatar, Url = _contextFacade.GetRouteUrl(new RouteValueDictionary() { ["area"] = "Plato.Users", ["controller"] = "Home", ["action"] = "Display", ["opts.id"] = entity.CreatedBy.Id, ["opts.alias"] = entity.CreatedBy.Alias }) }, ModifiedBy = new UserApiResult() { Id = entity.ModifiedBy.Id, DisplayName = entity.ModifiedBy.DisplayName, UserName = entity.ModifiedBy.UserName, Avatar = entity.ModifiedBy.Avatar, Url = _contextFacade.GetRouteUrl(new RouteValueDictionary() { ["area"] = "Plato.Users", ["controller"] = "Home", ["action"] = "Display", ["opts.id"] = entity.ModifiedBy.Id, ["opts.alias"] = entity.ModifiedBy.Alias }) }, LastReplyBy = new UserApiResult() { Id = entity.LastReplyBy.Id, DisplayName = entity.LastReplyBy.DisplayName, UserName = entity.LastReplyBy.UserName, Avatar = entity.LastReplyBy.Avatar, Url = _contextFacade.GetRouteUrl(new RouteValueDictionary() { ["area"] = "Plato.Users", ["controller"] = "Home", ["action"] = "Display", ["opts.id"] = entity.LastReplyBy.Id, ["opts.alias"] = entity.LastReplyBy.Alias }) }, Title = entity.Title, Excerpt = entity.Abstract, Url = url, CreatedDate = new FriendlyDate() { Text = entity.CreatedDate.ToPrettyDate(), Value = entity.CreatedDate }, ModifiedDate = new FriendlyDate() { Text = entity.ModifiedDate.ToPrettyDate(), Value = entity.ModifiedDate }, LastReplyDate = new FriendlyDate() { Text = entity.LastReplyDate.ToPrettyDate(), Value = entity.LastReplyDate }, Relevance = entity.Relevance }); } } IPagedApiResults <SearchApiResult> output = null; if (results != null) { output = new PagedApiResults <SearchApiResult>() { Page = page, Size = size, Total = results.Total, TotalPages = results.Total.ToSafeCeilingDivision(size), Data = results.Data }; } return(output != null ? base.Result(output) : base.NoResults()); }
public SortChildrenAttribute(SortBy orderBy) { this.OrderBy = orderBy; }
private void load_subject() { MongoClient client = new MongoClient("mongodb://localhost"); MongoServer server = client.GetServer(); MongoDatabase db = server.GetDatabase("NBA"); //in this subjects are orderd in ascending order as they are added in subject add form MongoCursor <Subjects> put = db.GetCollection <Subjects>("Subjects").Find(Query.And(Query.EQ("academic_year", academic_year), Query.EQ("clas", clas), Query.EQ("semester", sem))).SetSortOrder(SortBy.Ascending("srno")); //it will count how many subjects are added long count = put.Count(); if (count == 0) { this.Hide(); MessageBox.Show("No Subjects Added!"); return; } int x = 0; foreach (Subjects i in put) { //subject name and their corresponding marks will be searched in collection sub[x++] = i.Subject_Name; sub[x++] = i.marks; } show_sub(Convert.ToInt32(count)); }
internal static string GetSortByString(SortBy currentSortBy) { string strLine = string.Empty; switch (currentSortBy.Field) { case SortingFields.Title: strLine = Translation.Title; break; case SortingFields.ReleaseDate: strLine = Translation.ReleaseDate; break; case SortingFields.Score: strLine = Translation.Score; break; case SortingFields.Votes: strLine = Translation.Votes; break; case SortingFields.Runtime: strLine = Translation.Runtime; break; case SortingFields.PeopleWatching: strLine = Translation.Watchers; break; case SortingFields.WatchListInserted: strLine = Translation.Inserted; break; default: strLine = Translation.Title; break; } return string.Format(Translation.SortBy, strLine); }
public JobHistory GetMostRecent(string jobName) { return(FindOne <JobHistory>(new OneOptions().WithQuery(Query.EQ(FieldNames.Name, jobName)).WithSort(SortBy.Descending(FieldNames.StartTime)))); }
public PagedResult <Organization> List(string criteria = null, bool?isPaidPlan = null, bool?isSuspended = null, OrganizationSortBy sortBy = OrganizationSortBy.Newest, int page = 1, int pageSize = 10) { int skip = (page - 1) * pageSize; if (skip < 0) { skip = 0; } if (pageSize < 1) { pageSize = 10; } var queries = new List <IMongoQuery>(); if (!String.IsNullOrWhiteSpace(criteria)) { queries.Add(Query.Matches(OrganizationRepository.FieldNames.Name, new BsonRegularExpression(String.Format("/{0}/i", criteria)))); } if (isPaidPlan.HasValue) { if (isPaidPlan.Value) { queries.Add(Query.NE(OrganizationRepository.FieldNames.PlanId, new BsonString(BillingManager.FreePlan.Id))); } else { queries.Add(Query.EQ(OrganizationRepository.FieldNames.PlanId, new BsonString(BillingManager.FreePlan.Id))); } } if (isSuspended.HasValue) { if (isSuspended.Value) { queries.Add( Query.Or( Query.And( Query.NE(OrganizationRepository.FieldNames.BillingStatus, new BsonInt32((int)BillingStatus.Active)), Query.NE(OrganizationRepository.FieldNames.BillingStatus, new BsonInt32((int)BillingStatus.Trialing))), Query.EQ(OrganizationRepository.FieldNames.IsSuspended, new BsonBoolean(true)))); } else { queries.Add(Query.And( Query.Or( Query.EQ(OrganizationRepository.FieldNames.BillingStatus, new BsonInt32((int)BillingStatus.Active)), Query.EQ(OrganizationRepository.FieldNames.BillingStatus, new BsonInt32((int)BillingStatus.Trialing))), Query.EQ(OrganizationRepository.FieldNames.IsSuspended, new BsonBoolean(false)))); } } SortByBuilder sort; if (sortBy == OrganizationSortBy.Newest) { sort = SortBy.Descending(OrganizationRepository.FieldNames.Id); } else if (sortBy == OrganizationSortBy.MostActive) { sort = SortBy.Descending(OrganizationRepository.FieldNames.TotalErrorCount); } else { sort = SortBy.Ascending(OrganizationRepository.FieldNames.Name); } MongoCursor <Organization> query = queries.Count > 0 ? ((OrganizationRepository)_repository).Collection.Find(Query.And(queries)) : ((OrganizationRepository)_repository).Collection.FindAll(); List <Organization> results = query.SetSortOrder(sort).SetSkip(skip).SetLimit(pageSize).ToList(); return(new PagedResult <Organization>(results) { Page = page, PageSize = pageSize, TotalCount = query.Count() }); }
/// <summary> /// Standard search /// </summary> /// <param name="keySearch">String search</param> /// <returns></returns> public List<SearchDocumentResult> StandardSearch(string keySearch, SortBy sortBy) { var result = new List<SearchDocumentResult>(); string strResponse = string.Empty; // String search query string strQuery = BuildSearchQuery(keySearch); // String search option string strOption = BuildSearchOption(SearchOptionConst.Or, true); // Call Amazon Cloud Search API Service AmazonCloudSearcher ObjCloudSearch = new AmazonCloudSearcher(); strResponse = ObjCloudSearch.SearchRequest(ApiEndpoint, ApiVersion, strQuery, strOption, "_all_fields,_score", SearchOptionConst.SortByScoreDesc, DataFormat.Json); result = GetSearchDocumentList(strResponse); return result; }
public List <ServiceEntity> GetModelList(ServiceTypeEnum?type, string orderBy, string desc, int page, int pageSize, string id, string keyword, string isApproved, string host, out int count) { count = 0; try { var queryList = new List <IMongoQuery>(); if (type.HasValue) { queryList.Add(Query <ServiceEntity> .EQ(t => t.ServiceType, type.Value)); } if (!string.IsNullOrWhiteSpace(id)) { var arr = id.Split(new[] { '_' }, StringSplitOptions.RemoveEmptyEntries); if (arr[0] == "1") { queryList.Add(Query <ServiceEntity> .EQ(t => t.ServiceName, arr[1])); } else if (arr[0] == "2") { var q = Query <ServiceEntity> .EQ(t => t.SecondaryName, arr[1]); queryList.Add(arr.Length > 2 ? Query.And(q, Query <ServiceEntity> .EQ(t => t.ServiceName, arr[2])) : q); } } if (!string.IsNullOrWhiteSpace(keyword)) { queryList.Add(Query.Or(Query <ServiceEntity> .Matches(t => t.ServiceName, new BsonRegularExpression(new Regex(keyword, RegexOptions.IgnoreCase))), Query <ServiceEntity> .Matches(t => t.SecondaryName, new BsonRegularExpression(new Regex(keyword, RegexOptions.IgnoreCase))), Query <ServiceEntity> .Matches(t => t.Host, new BsonRegularExpression(new Regex(keyword, RegexOptions.IgnoreCase))), Query <ServiceEntity> .Matches(t => t.RegContent, new BsonRegularExpression(new Regex(keyword, RegexOptions.IgnoreCase))), Query <ServiceEntity> .Matches(t => t.Version, new BsonRegularExpression(new Regex(keyword, RegexOptions.IgnoreCase))), Query <ServiceEntity> .Matches(t => t.Remark, new BsonRegularExpression(new Regex(keyword, RegexOptions.IgnoreCase))))); } if (!string.IsNullOrWhiteSpace(isApproved)) { int approved; if (int.TryParse(isApproved, out approved)) { if (approved > 0) { queryList.Add(Query <ServiceEntity> .EQ(t => t.IsApproved, approved == 1)); } } } if (!string.IsNullOrWhiteSpace(host)) { queryList.Add(Query <ServiceEntity> .EQ(t => t.Host, host)); } IMongoSortBy sortBy = SortBy.Ascending(orderBy); if (desc.Equals("desc", StringComparison.InvariantCultureIgnoreCase)) { sortBy = SortBy.Descending(orderBy); } var query = queryList.Any() ? Query.And(queryList) : null; count = (int)DBContext.Mongo.Count(DBContext.DbName, Col, query); var res = DBContext.Mongo.GetPageList <ServiceEntity>(DBContext.DbName, Col, query, page, pageSize, sortBy, null); return(res); } catch (Exception ex) { LogManager.Error(ex); } return(new List <ServiceEntity>()); }