public JsonResult GetCommoditiesAvailables(int?locationID, DateTime?entryDate, string searchText)
{
var result = commodityRepository.GetCommoditiesAvailables(locationID, entryDate, searchText).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));
}