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