public JsonResult GetCommoditiesInWarehouses(int?locationID, DateTime?entryDate, string searchText, int?salesInvoiceID, int?stockTransferID, int?stockAdjustID) { var result = commodityRepository.GetCommoditiesInWarehouses(locationID, entryDate, searchText, salesInvoiceID, stockTransferID, stockAdjustID).Select(s => new { s.CommodityID, s.CommodityCode, s.CommodityName, s.CommodityTypeID, s.WarehouseID, s.WarehouseCode, s.QuantityAvailable, s.GrossPrice, s.VATPercent }); return(Json(result, JsonRequestBehavior.AllowGet)); }