public PagedResult <Room> GetRoomsByTopicPaginated(long TopicId, PagedRequestDescription pagedRequestDescription)
{
var queryResult = _context.Set <Room>().Where(p => p.TopicId == TopicId)
.Page(pagedRequestDescription);
return(queryResult);
}
public JsonResult GetAll(PagedRequestDescription pageDescription)
{
int count = _genericService.GetAllCount();
var cases = _mapper.Map <IEnumerable <CaseDTO>, IEnumerable <CaseViewModel> >(_genericService.GetAllPaged(pageDescription));
return(Json(new { Result = "OK", Records = cases, TotalRecordCount = count }));
}
public JsonResult GetAll(PagedRequestDescription pageDescription)
{
int count = _userService.GetAllCount();
var users = _mapper.Map <IEnumerable <UserDTO>, IEnumerable <UserViewModel> >(_userService.GetAllPaged(pageDescription));
return(Json(new { Result = "OK", Records = users, TotalRecordCount = count }));
}
public static IList <T> GetPagedResult <T>(this IQueryOver <T> query, PagedRequestDescription description)
{
query.Sort(description.JtSortingColumn, description.JtAscending);
var entities = query.Skip(description.JtStartIndex).Take(description.JtPageSize).List <T>();
return(entities);
}
public PagedResult <RoomDTO> GetRoomsPaginated(PagedRequestDescription pagedRequestDescription)
{
var queryResult = _repository.GetRoomsPaginated(pagedRequestDescription);
var pagedResult = new PagedResult <RoomDTO>
{
AllItemsCount = queryResult.AllItemsCount,
result = _mapper.Map <IList <Room>, IList <RoomDTO> >(queryResult.result)
};
return(pagedResult);
}
public PagedResult <RoomDTO> GetRoomsByTopic(long TopicId, PagedRequestDescription pagedRequestDescription)
{
var getRoomsDomain = _repository.GetRoomsByTopicPaginated(TopicId, pagedRequestDescription);
var result = new PagedResult <RoomDTO>
{
AllItemsCount = getRoomsDomain.AllItemsCount,
result = _mapper.Map <IList <Room>, IList <RoomDTO> >(getRoomsDomain.result)
};
return(result);
}
public PagedResult <TopicDTO> GetTopicsPage(PagedRequestDescription pagedRequestDescription)
{
var getTopicsPaginated = _repository.GetTopicsPaged(pagedRequestDescription);
var result = new PagedResult <TopicDTO>
{
AllItemsCount = getTopicsPaginated.AllItemsCount,
result = _mapper.Map <IList <Topic>, IList <TopicDTO> >(getTopicsPaginated.result)
};
return(result);
}
public IActionResult LoadTopics(PagedRequestDescription pagedRequestDescription)
{
var topicsDTO = _topicService.GetTopicsPage(pagedRequestDescription);
var result = new
{
recordsTotal = topicsDTO.AllItemsCount,
recordsFiltered = topicsDTO.AllItemsCount,
data = _mapper.Map <ICollection <TopicDTO>, ICollection <TopicViewModel> >(topicsDTO.result)
};
return(Json(result));
}
public IActionResult GetRoomsByTopic(long TopicId, PagedRequestDescription pagedRequestDescription)
{
var roomsPaginated = _roomService.GetRoomsByTopic(TopicId, pagedRequestDescription);
var result = new
{
recordsTotal = roomsPaginated.AllItemsCount,
recordsFiltered = roomsPaginated.AllItemsCount,
data = roomsPaginated.result
};
return(Json(result));
}
public static PagedResult <T> Page <T>(this IQueryable <T> list, PagedRequestDescription description)
{
if (description.searchKeyword == null)
{
description.searchKeyword = "";
}
var query = list.Where(p => p.GetType().GetProperty(description.columnToSearch).GetValue(p).ToString().StartsWith(description.searchKeyword));
if (description.order.Equals("asc", StringComparison.InvariantCultureIgnoreCase))
{
query = query.OrderBy(p => p.GetType().GetProperty(description.columnToSort).GetValue(p));
}
else
{
query = query.OrderByDescending(p => p.GetType().GetProperty(description.columnToSort).GetValue(p));
}
var pagedResult = query.Page(description.numPage, description.pageSize);
return(pagedResult);
}
public PagedResult <Topic> GetTopicsPaged(PagedRequestDescription pagedRequestDescription)
{
return(_context.Set <Topic>().Page(pagedRequestDescription));
}
public IEnumerable <TDTOModel> GetAllPaged(PagedRequestDescription pageDescription)
{
return(_mapper.Map <IEnumerable <TDomainModel>, IEnumerable <TDTOModel> >(_genericRepository.GetAllPaged(pageDescription)));
}
public IEnumerable <User> GetAllPaged(PagedRequestDescription pagedDescription)
{
return(_session.QueryOver <User>().GetPagedResult(pagedDescription));
}
public IEnumerable <UserDTO> GetAllPaged(PagedRequestDescription pagedDescription)
{
return(_mapper.Map <IEnumerable <User>, IEnumerable <UserDTO> >(_userRepository.GetAllPaged(pagedDescription)));
}
public PagedResult <Room> GetRoomsPaginated(PagedRequestDescription pagedRequestDescription)
{
var queryResult = _context.Set <Room>().Page(pagedRequestDescription);
return(queryResult);
}
