public JsonResult SearchCommodities(string searchText, string commodityTypeIDList, bool?isOnlyAlphaNumericString) { var result = commodityRepository.SearchCommodities(searchText, commodityTypeIDList, isOnlyAlphaNumericString).Select(s => new { s.CommodityID, s.Code, s.Name, s.CommodityTypeID, CommodityCategoryLimitedKilometreWarranty = s.CommodityCategory.LimitedKilometreWarranty, CommodityCategoryLimitedMonthWarranty = s.CommodityCategory.LimitedMonthWarranty, s.GrossPrice, s.CommodityCategory.VATPercent }); return(Json(result, JsonRequestBehavior.AllowGet)); }