01 December 2017

Predicate

var varshipmentDetails = (from ship in condb.GetSGrid(userId, searchText, pageNumber, pageSize, sortColumn, sortOrder)
where statusId == 0 ? ship.StatusId != 1 : ship.StatusId == statusId
select ship).AsQueryable();

IQueryable<GetSGrid_Result> filteredShipments = varshipmentDetails;
var predicate = PredicateBuilder.True<GetSGrid_Result>();
string predic = string.Empty;
if (filterParams != null && filterParams.Count > 0)
{
foreach (var item in filterParams)
{
predicate = predicate.And(Consys.Utility.ExtensionUtility.GenerateFieldExpression<GetSGrid_Result>(item.ColumnName, item.TypeOfComparison, item.SearchCriteria));
}

////filteredShipments = varshipmentDetails.AsQueryable().Where(predicate);
}

shipmentDetails = filteredShipments.ToList()

No comments: