public SearchResult <CostKategoriDTO> GetDataByFilter(CostKategoriSearchFilter filter)
        {
            if (string.IsNullOrEmpty(filter.SortName))
            {
                filter.SortName = "CostKategori_PK";
            }
            CostKategoriQuery costKategoriQuery = new CostKategoriQuery(this.Db);

            var filteredRecords =
                costKategoriQuery.GetQuery()
                .Where(costKategori =>
                       costKategori.Title.Contains(filter.Keyword));

            var displayedRecords = filteredRecords.
                                   SortBy(filter.SortName, filter.SortDir)
                                   .Skip(filter.Skip)
                                   .Take(filter.PageSize)
                                   .ToList();

            var searchResult = new SearchResult <CostKategoriDTO>(filter);

            searchResult.Filter               = filter;
            searchResult.Count.TotalRecords   = costKategoriQuery.GetTotalRecords();
            searchResult.Count.TotalFiltered  = filteredRecords.Count();
            searchResult.Count.TotalDisplayed = displayedRecords.Count();
            searchResult.Records              = displayedRecords;

            return(searchResult);
        }
        public CostKategoriListModel Get(CostKategoriSearchFilter searchFilter)
        {
            CostKategoriListFormData       formData     = new CostKategoriListFormData();
            SearchResult <CostKategoriDTO> searchResult = costKategoriSearch.GetDataByFilter(searchFilter);

            return(new CostKategoriListModel()
            {
                FormData = formData,
                SearchResult = searchResult
            });
        }
Beispiel #3
0
        public IHttpActionResult Search([FromUri] CostKategoriSearchFilter filter)
        {
            ThrowIfUserHasNoRole(readRole);
            if (filter == null)
            {
                throw new KairosException("Missing search filter parameter");
            }

            using (var costKategoriSearch = new CostKategoriSearch(Db))
            {
                var data = costKategoriSearch.GetDataByFilter(filter);
                return(Ok(new SuccessResponse(data)));
            }
        }