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));
}
