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