public async Task <IEnumerable <SystemLookupCategoryIndexView> > Handle(GetSystemLookupCategoriesListQuery request, CancellationToken cancellationToken)
 {
     return(await _database.SystemLookup
            .Where(l => l.Type.ToLower() == "lookup_category")
            .Select(SystemLookupCategoryIndexView.Project)
            .ToListAsync());
 }
        public async Task <ActionResult <IEnumerable <SystemLookupCategoryIndexView> > > GetSystemLookupCategories([FromQuery] GetSystemLookupCategoriesListQuery query)
        {
            var lookupCategories = await _Mediator.Send(new GetSystemLookupCategoriesListQuery());

            return(Ok(lookupCategories));
        }