public async Task <PageResult <SiQuanViewModel> > GetAllBySiQuanId(GetPublicSiQuanPagingRequest request)
{
var query = from p in _context.SiQuans select p;
if (request.IDSQ.HasValue && request.IDSQ.Value > 0)
{
query = query.Where(p => p.IDSQ == request.IDSQ);
}
int totalRow = await query.CountAsync();
var data = await query.Skip((request.pageIndex - 1) *request.pageSize)
.Take(request.pageSize)
.Select(x => new SiQuanViewModel()
{
IDSQ = x.IDSQ,
UserId = x.UserId,
HoTen = x.HoTen,
NgaySinh = x.NgaySinh,
GioiTinh = x.GioiTinh,
QueQuan = x.QueQuan,
SDT = x.SDT
}).ToListAsync();
var pageResult = new PageResult <SiQuanViewModel>()
{
TotalRecord = totalRow,
PageIndex = request.pageIndex,
PageSize = request.pageSize,
Items = data
};
return(pageResult);
}
public async Task <IActionResult> Get([FromQuery] GetPublicSiQuanPagingRequest request)
{
var siquan = await _publicSiQuanServices.GetAllBySiQuanId(request);
return(Ok(siquan));
}
