ASP.NET

public HttpResponseMessage Get([FromUri] Query query)
        {
            var data = db.database.AsQueryable();

            int pageSize = 10;

            if (query.price_type != null)
            {
                data = data.Where(c => c.Cover == query.price_type);
            }
            
            int total = data.Count();
            // If any other filters are specified, return records which match any of them:
            var filteredData = new List<IQueryable<database_BWICs>>();

            if (!string.IsNullOrEmpty(query.isin))
            {
                var ids = query.isin.Split(',');
                foreach (string i in ids)
                {
                    filteredData.Add(data.Where(c => c.ISINs != null && c.ISINs.Contains(i)));
                }
            }

            if (!string.IsNullOrEmpty(query.cusip))
            {
                var ids = query.cusip.Split(',');
                foreach (string i in ids)
                {
                    filteredData.Add(data.Where(c => c.CUSIP != null && c.CUSIP.Contains(i)));
                }
            }


            // If no filters passed, return all data.
            // Otherwise, combine the individual filters using the Union method
            // to return all records which match at least one filter.
            
            if (filteredData.Count != 0)
            {
                data = filteredData.Aggregate(Queryable.Union).OrderByDescending(c => c.UploadDate).Take(pageSize);
            }

           
            if (!data.Any())
            {
                var message = string.Format("No data was found");
                return Request.CreateErrorResponse(HttpStatusCode.NotFound, message);
            }

            if (query.price_type != null)
            {
                data = data.OrderByDescending(c => c.Cover == query.price_type).Take(pageSize);
            }
            

            //return Request.CreateResponse(HttpStatusCode.OK, data);
            return Request.CreateResponse(HttpStatusCode.OK, new { total, data });
        }
    }

if (query.price_type != null)
            {
                data = data.Where(c => c.Cover == query.price_type);
            }

@(Html.Telerik().Grid()<myTransactions>
    .Name("Transactions")
        .ClientEvents(events => events.OnLoad("TransactionsGrid_onLoad"))
        .ClientEvents(events => events.OnDataBound("TransactionsGrid_onDataBound"))
    .DataBinding(dataBinding => dataBinding
        .Ajax()
        .OperationMode(GridOperationMode.Client)
        .Select("TransactionsAjax", controller))

@(Html.Kendo().Grid<myTransactions>()
    .Name("Transactions")
    .AutoBind(true)
    .Events(events => events.DataBound("TransactionsGrid_onDataBound"))
        .DataSource(dataSource => dataSource
        .Ajax()
        .ServerOperation(false)
        .Read(read => read.Action("TransactionsAjax", controller))
        .PageSize(15))