public SearchResult <KategoriJabatanDTO> GetDataByFilter(KategoriJabatanSearchFilter filter)
        {
            if (string.IsNullOrEmpty(filter.SortName))
            {
                filter.SortName = "KategoriJabatan_PK";
            }
            KategoriJabatanQuery kategoriJabatanQuery = new KategoriJabatanQuery(this.Db);

            var filteredRecords =
                kategoriJabatanQuery.GetQuery()
                .Where(kategoriJabatan =>
                       kategoriJabatan.Title.Contains(filter.Keyword));

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

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

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

            return(searchResult);
        }
        public KategoriJabatanListModel Get(KategoriJabatanSearchFilter searchFilter)
        {
            KategoriJabatanListFormData       formData     = new KategoriJabatanListFormData();
            SearchResult <KategoriJabatanDTO> searchResult = kategoriJabatanSearch.GetDataByFilter(searchFilter);

            return(new KategoriJabatanListModel()
            {
                FormData = formData,
                SearchResult = searchResult
            });
        }
        public IHttpActionResult Search([FromUri] KategoriJabatanSearchFilter filter)
        {
            ThrowIfUserHasNoRole(readRole);
            if (filter == null)
            {
                throw new KairosException("Missing search filter parameter");
            }

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