Helper for use the PrimeNG table load lazy filter in backend use LINQ to Entity
If you use PrimeNG.TableFilter version 1.x.x you will need to migrate your implementation code. Please delete total record variable and change to get total record from variable out in extension. You can looking for implementation guide line in unit test.
Completely handle PrimeNG table load lazy in ASP.NET use PrimeNG.TableFilter (kusumotolab.com)
PM> Install-Package PrimeNG.TableFilter
[HttpPost("[action]")]
public BaseTableResponseEntity<ClassRoomGridModel> GetClassRoom([FromBody] TableFilterModel tableFilterPayload)
=> _classRoomService.GetClassRoom(tableFilterPayload);
public BaseTableResponseEntity<ClassRoomGridModel> GetClassRoom(TableFilterModel filterPayload)
{
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, out var totalRecord);
return MvcHelper.ResponseTableData(totalRecord, result);
}
MIT License
Copyright (c) 2021 Weerayut Hongsa