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) { }