public async Task <JsonResult> GetPawnedItems(int page, int pageSize) { var listPawnedItem = await _pawningService.GetList(page, pageSize); var result = from a in listPawnedItem select new { a.PawnedItemId, a.PawnedItemNo, a.PawnedDate, a.AppraiseId, a.CustomerId, a.PawnedItemContractNo, a.LoanableAmount, a.InterestRate, a.InterestAmount, a.InitialPayment, a.ServiceCharge, a.Others, a.IsInterestDeducted, a.NetCashOut, a.TermsId, a.ScheduleOfPayment, a.NoOfPayments, a.DueDateStart, a.DueDateEnd, a.IsReleased, a.ReviewedBy, a.ApprovedBy, a.CreatedBy, a.CreatedAt }; return(Json(new { data = result.OrderByDescending(d => d.PawnedDate).ThenBy(s => s.IsReleased), noMoreData = result.Count() < pageSize, recordCount = result.Count() }, JsonRequestBehavior.AllowGet)); }