public async Task <JsonResult> GetAppraisedItemList(int page, int pageSize) { var listItemType = await _appraisalService.GetItemTypeList(); var listItemCategory = await _appraisalService.GetItemCategoryList(); var listAppraisedItem = await _appraisalService.GetList(page, pageSize); var result = from a in listAppraisedItem select new { a.AppraiseId, a.AppraiseDate, a.AppraiseNo, a.ItemTypeId, a.ItemCategoryId, a.ItemName, a.Brand, a.Karat, a.Weight, a.AppraisedValue, a.Remarks, a.CustomerFirstName, a.CustomerLastName, a.IsPawned, a.CreatedBy, a.CreatedAt }; return(Json(new { data = result.OrderByDescending(d => d.AppraiseDate).ThenBy(s => s.IsPawned), noMoreData = result.Count() < pageSize, recordCount = result.Count() }, JsonRequestBehavior.AllowGet)); }
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)); }
public async Task <JsonResult> GetAppraisedItem() { var listAppraisedItem = await _appraisalService.GetList(); var result = from a in listAppraisedItem where a.IsPawned.Equals(false) select new { a.AppraiseId, a.ItemName }; return(Json(result.OrderBy(o => o.ItemName), JsonRequestBehavior.AllowGet)); }