public Page<WorkitemServicesDetail> Get(WorkItemServicesDetailSearchCriteria criteria)
{
var sql = Sql.Builder
.OrderBy(criteria.OrderBy + " " + criteria.OrderByDirection)
.Where("workOrderNumber=@0",criteria.WorkOrderNumber);
return _repository.PagedQuery<WorkitemServicesDetail>(criteria.PageNumber, criteria.ItemsPerPage, sql.SQL, sql.Arguments);
}
public JsonResult List(WorkItemServicesDetailSearchCriteria criteria)
{
var page = _workItemServicesQueries.Get(criteria);
return Json(new
{
total = page.TotalPages,
page = page.CurrentPage,
records = page.TotalItems,
rows = page.Items.Select(Mapper.Map<WorkitemServicesViewModel>)
});
}