public async Task <JqDataTableResponse <BankAccountListItemDto> > GetPagedResultAsync(JqDataTableRequest model) { return(await _bankAccountRepository.GetPagedResultAsync(model)); }
public async Task <IActionResult> GetPagedResult(JqDataTableRequest model) { var pagedResult = await _leadManager.GetPagedResultAsync(model); return(Ok(pagedResult)); }
public async Task <JqDataTableResponse <LeadStatusDetailDto> > GetPagedResultAsync(JqDataTableRequest model) { return(await _repository.GetPagedResultAsync(model)); }
public async Task <IActionResult> PagedResult(JqDataTableRequest model) { return(Ok(await _manager.GetPagedResultAsync(model))); }
public async Task <JqDataTableResponse <UserRoleDetailDto> > GetPagedResultAsync(JqDataTableRequest model) { if (model.Length == 0) { model.Length = Constants.DefaultPageSize; } var filterKey = model.Search.Value; var linqStmt = (from s in _dataContext.UsersRoles where s.Status != Constants.RecordStatus.Deleted && (filterKey == null || EF.Functions.Like(s.RoleName, "%" + filterKey + "%")) select new UserRoleDetailDto { Id = s.Id, RoleName = s.RoleName }) .AsNoTracking(); var sortExpresstion = model.GetSortExpression(); var pagedResult = new JqDataTableResponse <UserRoleDetailDto> { RecordsTotal = await _dataContext.UsersRoles.CountAsync(x => x.Status != Constants.RecordStatus.Deleted), RecordsFiltered = await linqStmt.CountAsync(), Data = await linqStmt.OrderBy(sortExpresstion).Skip(model.Start).Take(model.Length).ToListAsync() }; return(pagedResult); }
//get only online agent public async Task <JqDataTableResponse <UserDetailDto> > GetOnlyOnlineAgentPagedResultAsync(JqDataTableRequest model) { if (model.Length == 0) { model.Length = Constants.DefaultPageSize; } var filterKey = model.Search.Value; var linqStmt = (from s in _dataContext.LoginModule where s.user.Role.RoleName == "Agent" select new UserDetailDto { Id = s.Id, FirstName = s.user.FirstName, LastName = s.user.LastName, UserName = s.user.UserName, Password = s.user.Password, Mobile = s.user.Mobile, Email = s.user.Email, RoleId = s.user.RoleId, RoleName = s.user.Role.RoleName, CallStatus = s.status ?? false }) .AsNoTracking(); var sortExpresstion = model.GetSortExpression(); var pagedResult = new JqDataTableResponse <UserDetailDto> { RecordsTotal = await _dataContext.User.CountAsync(x => x.Status != Constants.RecordStatus.Deleted), RecordsFiltered = await linqStmt.CountAsync(), Data = await linqStmt.OrderBy(sortExpresstion).Skip(model.Start).Take(model.Length).ToListAsync() }; return(pagedResult); }
public async Task <JqDataTableResponse <UserDetailDto> > GetOnlyOnlineAgentPagedResultAsync(JqDataTableRequest model) { return(await _repository.GetOnlyOnlineAgentPagedResultAsync(model)); }