PrimeNG.TableFilter 1.0.4

PrimeNG.TableFilter

Helper for use the PrimeNG table load lazy filter in backend use LINQ to Entity

.Net Platform Support

• .Net Standard 2.0
• .Net Framework 4.0 more then
• Mono Framework

Feature

• Handle all command from PrimeNG table filter frontend
• Filter criteria from PrimeNG table filter in Iterators and Entities
• Convert PrimeNG table filter payload to SQL Query (use LINQ to Entities)

Install via Nuget Package Manager

PM> Install-Package PrimeNG.TableFilter

How to use

1. Handle PrimeNG table filter payload in ASP.Net MVC Controller use "TableFilterModel" in parameter from body

[HttpPost("[action]")]
        public BaseTableResponseEntity<ClassRoomGridModel> GetClassRoom([FromBody] TableFilterModel tableFilterPayload)
            => _classRoomService.GetClassRoom(tableFilterPayload);

2. Implement programming logic for get your data from iterators or entities and use extension method "PrimengTableFilter" in your iterators or entities

public BaseTableResponseEntity<ClassRoomGridModel> GetClassRoom(TableFilterModel filterPayload)
        {
            var totalRecord = 0; // for summary all record before pagination
            var result = _classRoomRepository.Gets()
                .Select(o =>
                    new ClassRoomGridModel
                    {
                        Code = o.Code,
                        Id = o.Id,
                        TotalSeat = o.TotalSeat,
                        BuildingName = o.BuildingName.Description,
                        Name = o.Name,
                        Remark = o.Remark,
                        ActiveFlag = o.ActiveFlag,
                        Type = GenerateClassRoomTypeToText(o.Type)
                    }
                );
            result = result.PrimengTableFilter(filterPayload, ref totalRecord);
            return MvcHelper.ResponseTableData(totalRecord, result);
        }

MIT License

Copyright (c) 2021 Weerayut Hongsa