public async Task <PageResult <EmployeeDtos> > GetDataPaging(PageRequestBase request)
{
var query = from em in _context.Employees
select new { em };
int totalRow = await query.CountAsync();
var data = await query.Skip((request.index - 1) *request.sizePage)
.Take(request.sizePage)
.Select(x => new EmployeeDtos()
{
FullName = x.em.FullName,
Email = x.em.Email,
DateOfBirth = x.em.DateOfBirth,
Gender = x.em.Gender,
Username = x.em.Username,
//Password=x.em.
Addresses = x.em.Addresses,
AvatarUrl = x.em.AvatarUrl,
ProfileUrl = x.em.ProfileUrl,
//Position=x.em.Po
// Status=x.em.
StartDate = x.em.StartDate,
EndDate = x.em.EndDate,
}).ToListAsync();
var pageResult = new PageResult <EmployeeDtos>
{
record = data,
totalRecord = totalRow
};
return(pageResult);
}
/// <summary>
/// Lấy danh sách thuộc tính theo số trang và kích thước trang
/// </summary>
/// <param name="pageRequestBase">số trang và kích thước trang</param>
/// <returns>danh sách thuộc tính</returns>
/// create: 7/2/2021
public async Task <IEnumerable <T> > GetData(PageRequestBase pageRequestBase)
{
int indexStart = (pageRequestBase.PageIndex - 1) * pageRequestBase.PageSize;
string className = typeof(T).Name;
var queryString = $"SELECT * FROM {className} LIMIT {indexStart.ToString()}, {pageRequestBase.PageSize.ToString()}";
return(await dbConnection.QueryAsync <T>(queryString));
}
/// <summary>
/// Lấy danh sách đối tượng theo trang và số bản ghi
/// </summary>
/// <param name="pageRequestBase">trang và bản ghi</param>
/// <returns>ServiceResult</returns>
/// create 6/2/2021
public async Task <ServiceResult> GetData(PageRequestBase pageRequestBase)
{
var listEntiry = await _baseData.GetData(pageRequestBase);
var ListPage = new PageResult <T>()
{
Items = listEntiry,
TotalRecord = listEntiry.Count()
};
return(new ServiceResult()
{
Data = ListPage,
Error = null,
MISAeShopCode = MISAeShopServiceCode.Success
});
}
public FindOrdersToPageCore(PageRequestBase request, IOrderRepository orderRepository)
: base(request)
{
_orderRepository = orderRepository;
SetValidator(new PageRequestBaseValidator());
}
public PageResultObject <Order> FindOrdersToPage(PageRequestBase request)
{
var core = new FindOrdersToPageCore(request, _orderRepository);
return(core.DoExecute());
}
public async Task <IActionResult> GetEmployeePaging([FromQuery] PageRequestBase request)
{
}
