public async Task <JsonResult> GetPawnedItems()
{
var listPawnedItem = await _pawningService.GetNormalList();
var listAppraisedItem = await _appraisalService.GetList();
var listCustomer = await _customerService.GetCustomerList();
var result =
from a in listPawnedItem
join c in listCustomer on a.CustomerId equals c.autonum
select new
{
a.PawnedItemId,
a.PawnedItemNo,
a.PawnedDate,
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.Status,
a.IsReleased,
a.CreatedBy,
a.CreatedAt,
c.first_name,
c.last_name
};
return(Json(new { data = result.OrderByDescending(d => d.PawnedDate).ThenBy(s => s.IsReleased) }, JsonRequestBehavior.AllowGet));
}
