public virtual async Task <IEnumerable <Register> > GetByFilters(RegisterFilter filters) { var queryBase = this._rep.GetBySimplefilters(filters); return(await this._rep.ToListAsync(queryBase)); }
public virtual async Task <Register> GetOne(RegisterFilter filters) { return(await this._rep.GetById(filters)); }
internal static void OnApplicationStart() { LoadFavorites(); RegisterFilter("search", false, "Search Results", SongSearchButton.ShowSearchButton, SongSearchButton.HideSearchButton, (result) => { if (SongSearch.searchResult != null) { result.Clear(); for (int i = 0; i < SongSearch.searchResult.Count; i++) { result.Add(SongSearch.searchResult[i]); } return(true); } return(false); }); RegisterFilter("favorites", false, "Favorites", () => {}, () => {}, (result) => { if (favorites != null) { result.Clear(); string id; for (int i = 0; i < favorites.songIDs.Count; i++) { id = favorites.songIDs[i]; if (SongLoadingManager.songIDs.Contains(id)) { result.Add(id); } } return(true); } return(false); }); PlaylistManager.playlistFilter = RegisterFilter("playlists", false, "Playlist", SelectPlaylistButton.ShowPlaylistButton, SelectPlaylistButton.HidePlaylistButton, (result) => { result.Clear(); if (PlaylistManager.selectedPlaylist is null) { if (PlaylistManager.playlistFilter != null) { PlaylistManager.playlistFilter.SongListText = "No Playlist selected"; } } else { if (PlaylistManager.playlistFilter != null) { PlaylistManager.playlistFilter.SongListText = PlaylistManager.selectedPlaylist.name; } foreach (string song in PlaylistManager.selectedPlaylist.songs) { string fileName = song + ".audica"; if (SongLoadingManager.songDictionary.ContainsKey(fileName)) { result.Add(SongLoadingManager.songDictionary[fileName]); } } songSelect.ChangeSort(SongSelect.Sort.Default); } return(true); })(); PlaylistManager.playlistFilter.OnHit += PlaylistManager.OnFilterApplied; }
public static IQueryable <Register> WithBasicFilters(this IQueryable <Register> queryBase, RegisterFilter filters) { var queryFilter = queryBase; if (filters.Ids.IsSent()) { queryFilter = queryFilter.Where(_ => filters.GetIds().Contains(_.RegisterId)); } if (filters.RegisterId.IsSent()) { queryFilter = queryFilter.Where(_ => _.RegisterId == filters.RegisterId); } if (filters.StatusRegisterId.IsSent()) { queryFilter = queryFilter.Where(_ => _.StatusRegisterId == filters.StatusRegisterId); } if (filters.ParticipantId.IsSent()) { queryFilter = queryFilter.Where(_ => _.ParticipantId == filters.ParticipantId); } if (filters.Description.IsSent()) { queryFilter = queryFilter.Where(_ => _.Description.Contains(filters.Description)); } if (filters.EnterDate.IsSent()) { queryFilter = queryFilter.Where(_ => _.EnterDate >= filters.EnterDate.AddHours(-filters.EnterDate.Hour).AddMinutes(-filters.EnterDate.Minute).AddSeconds(-filters.EnterDate.Second) && _.EnterDate <= filters.EnterDate.AddDays(1).AddHours(-filters.EnterDate.Hour).AddMinutes(-filters.EnterDate.Minute).AddSeconds(-filters.EnterDate.Second)); } if (filters.EnterDateStart.IsSent()) { queryFilter = queryFilter.Where(_ => _.EnterDate >= filters.EnterDateStart); } if (filters.EnterDateEnd.IsSent()) { filters.EnterDateEnd = filters.EnterDateEnd.AddDays(1).AddMilliseconds(-1); queryFilter = queryFilter.Where(_ => _.EnterDate <= filters.EnterDateEnd); } if (filters.ExitDate.IsSent()) { queryFilter = queryFilter.Where(_ => _.ExitDate >= filters.ExitDate.AddHours(-filters.ExitDate.Hour).AddMinutes(-filters.ExitDate.Minute).AddSeconds(-filters.ExitDate.Second) && _.ExitDate <= filters.ExitDate.AddDays(1).AddHours(-filters.ExitDate.Hour).AddMinutes(-filters.ExitDate.Minute).AddSeconds(-filters.ExitDate.Second)); } if (filters.ExitDateStart.IsSent()) { queryFilter = queryFilter.Where(_ => _.ExitDate >= filters.ExitDateStart); } if (filters.ExitDateEnd.IsSent()) { filters.ExitDateEnd = filters.ExitDateEnd.AddDays(1).AddMilliseconds(-1); queryFilter = queryFilter.Where(_ => _.ExitDate <= filters.ExitDateEnd); } return(queryFilter); }
public async Task <IActionResult> Get([FromQuery] RegisterFilter filters) { var result = new HttpResult <dynamic>(this._logger); try { if (filters.FilterBehavior == FilterBehavior.GetDataItem) { var searchResult = await this._rep.GetDataItem(filters); return(result.ReturnCustomResponse(searchResult, filters)); } if (!this._user.GetClaims().GetTools().VerifyClaimsCanRead("Register")) { return(new ObjectResult(null) { StatusCode = (int)HttpStatusCode.Forbidden }); } if (filters.FilterBehavior == FilterBehavior.GetDataCustom) { var searchResult = await this._rep.GetDataCustom(filters); return(result.ReturnCustomResponse(searchResult, filters)); } if (filters.FilterBehavior == FilterBehavior.GetDataListCustom) { var searchResult = await this._rep.GetDataListCustom(filters); return(result.ReturnCustomResponse(searchResult, filters)); } if (filters.FilterBehavior == FilterBehavior.GetDataListCustomPaging) { var paginatedResult = await this._rep.GetDataListCustomPaging(filters); return(result.ReturnCustomResponse(paginatedResult.ToSearchResult <dynamic>(), filters)); } if (filters.FilterBehavior == FilterBehavior.Export) { var searchResult = await this._rep.GetDataListCustom(filters); var export = new ExportExcelCustom <dynamic>(filters); var file = export.ExportFile(this.Response, searchResult, "Register", this._env.RootPath); return(File(file, export.ContentTypeExcel(), export.GetFileName())); } throw new InvalidOperationException("invalid FilterBehavior"); } catch (Exception ex) { var responseEx = result.ReturnCustomException(ex, "Seed - Register", filters, new ErrorMapCustom()); return(responseEx); } }
public static IQueryable <Register> WithCustomFilters(this IQueryable <Register> queryBase, RegisterFilter filters) { var queryFilter = queryBase; return(queryFilter); }