Esempio n. 1
0
        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));
        }