public DataTablesParser(HttpRequestBase httpRequest, IQueryable <T> queriable)
{
_queriable = queriable;
_httpRequest = httpRequest;
_type = typeof(T);
//This associates class properties with relevant datatable configuration options
//Single pass for key then hash lookups for corresponding properties
_propertyMap = (from key in _httpRequest.Params.AllKeys.Where(k => Regex.IsMatch(k, Constants.COLUMN_PROPERTY_PATTERN))
join prop in _type.GetProperties() on _httpRequest[key] equals prop.Name
let index = Regex.Match(key, Constants.COLUMN_PROPERTY_PATTERN).Groups[1].Value
let searchableKey = Constants.GetKey(Constants.SEARCHABLE_PROPERTY_FORMAT, index)
let searchable = _httpRequest[searchableKey] == null ? true : _httpRequest[searchableKey].Trim() == "true"
let orderableKey = Constants.GetKey(Constants.ORDERABLE_PROPERTY_FORMAT, index)
let orderable = _httpRequest[orderableKey] == null ? true : _httpRequest[orderableKey].Trim() == "true"
// Set regex and individual search when implemented
select new
{
index = int.Parse(index),
map = new PropertyMapping
{
Property = prop,
Searchable = searchable,
Orderable = orderable
}
}).Distinct().ToDictionary(k => k.index, v => v.map);
}
static TestHelper()
{
Params.Add(Constants.DRAW, "1");
Params.Add(Constants.DISPLAY_START, "0");
Params.Add(Constants.DISPLAY_LENGTH, "10");
Params.Add(Constants.GetKey(Constants.DATA_PROPERTY_FORMAT, "0"), "PhotoTitle");
Params.Add(Constants.GetKey(Constants.SEARCHABLE_PROPERTY_FORMAT, "0"), "true");
Params.Add(Constants.GetKey(Constants.SEARCH_VALUE_PROPERTY_FORMAT, "0"), "");
Params.Add(Constants.GetKey(Constants.SEARCH_REGEX_PROPERTY_FORMAT, "0"), "false");
Params.Add(Constants.GetKey(Constants.DATA_PROPERTY_FORMAT, "1"), "AlbumTitle");
Params.Add(Constants.GetKey(Constants.SEARCHABLE_PROPERTY_FORMAT, "1"), "true");
Params.Add(Constants.GetKey(Constants.SEARCH_VALUE_PROPERTY_FORMAT, "1"), "");
Params.Add(Constants.GetKey(Constants.SEARCH_REGEX_PROPERTY_FORMAT, "1"), "false");
Params.Add(Constants.GetKey(Constants.DATA_PROPERTY_FORMAT, "2"), "ThumbnailUrl");
Params.Add(Constants.GetKey(Constants.SEARCHABLE_PROPERTY_FORMAT, "2"), "true");
Params.Add(Constants.GetKey(Constants.SEARCH_VALUE_PROPERTY_FORMAT, "2"), "");
Params.Add(Constants.GetKey(Constants.SEARCH_REGEX_PROPERTY_FORMAT, "2"), "false");
Params.Add(Constants.SEARCH_KEY, "");
Params.Add(Constants.SEARCH_REGEX_KEY, "false");
Params.Add(Constants.GetKey(Constants.ORDER_COLUMN_FORMAT, "0"), "0");
Params.Add(Constants.GetKey(Constants.ORDER_DIRECTION_FORMAT, "0"), "0");
}
public Parser(IEnumerable <KeyValuePair <string, StringValues> > configParams, IQueryable <T> query)
{
_originalQuery = query;
_query = query;
_config = configParams.ToDictionary(k => k.Key, v => v.Value.First().Trim());
_type = typeof(T);
//This associates class properties with corresponding datatable configuration options
_propertyMap = (from param in _config
join prop in _type.GetProperties() on param.Value equals prop.Name
where Regex.IsMatch(param.Key, Constants.COLUMN_PROPERTY_PATTERN)
let index = Regex.Match(param.Key, Constants.COLUMN_PROPERTY_PATTERN).Groups[1].Value
let searchableKey = Constants.GetKey(Constants.SEARCHABLE_PROPERTY_FORMAT, index)
let searchable = _config.ContainsKey(searchableKey) && _config[searchableKey] == "true"
let orderableKey = Constants.GetKey(Constants.ORDERABLE_PROPERTY_FORMAT, index)
let orderable = _config.ContainsKey(orderableKey) && _config[orderableKey] == "true"
let filterKey = Constants.GetKey(Constants.SEARCH_VALUE_PROPERTY_FORMAT, index)
let filter = _config.ContainsKey(filterKey)?_config[filterKey]:string.Empty
// Set regex when implemented
select new
{
index = int.Parse(index),
map = new PropertyMap
{
Property = prop,
Searchable = searchable,
Orderable = orderable,
Filter = filter
}
}).Distinct().ToDictionary(k => k.index, v => v.map);
if (_propertyMap.Count == 0)
{
throw new Exception("No properties were found in request. Please map datatable field names to properties in T");
}
if (_config.ContainsKey(Constants.DISPLAY_START))
{
int.TryParse(_config[Constants.DISPLAY_START], out _skip);
}
if (_config.ContainsKey(Constants.DISPLAY_LENGTH))
{
int.TryParse(_config[Constants.DISPLAY_LENGTH], out _take);
}
else
{
_take = 10;
}
_sortDisabled = _config.ContainsKey(Constants.ORDERING_ENABLED) && _config[Constants.ORDERING_ENABLED] == "false";
_isEnumerableQuery = _query is System.Linq.EnumerableQuery;
}
private void ApplySort()
{
var sorted = false;
var paramExpr = Expression.Parameter(_type, "val");
// Enumerate the keys sort keys in the order we received them
foreach (var param in _config.Where(k => Regex.IsMatch(k.Key, Constants.ORDER_PATTERN)))
{
// column number to sort (same as the array)
int sortcolumn = int.Parse(param.Value);
// ignore disabled columns
if (!_propertyMap.ContainsKey(sortcolumn) || !_propertyMap[sortcolumn].Orderable)
{
continue;
}
var index = Regex.Match(param.Key, Constants.ORDER_PATTERN).Groups[1].Value;
var orderDirectionKey = Constants.GetKey(Constants.ORDER_DIRECTION_FORMAT, index);
// get the direction of the sort
string sortdir = _config[orderDirectionKey];
var sortProperty = _propertyMap[sortcolumn].Property;
var expression1 = Expression.Property(paramExpr, sortProperty);
var propType = sortProperty.PropertyType;
var delegateType = Expression.GetFuncType(_type, propType);
var propertyExpr = Expression.Lambda(delegateType, expression1, paramExpr);
// apply the sort (default is ascending if not specified)
string methodName;
if (string.IsNullOrEmpty(sortdir) || sortdir.Equals(Constants.ASCENDING_SORT, StringComparison.OrdinalIgnoreCase))
{
methodName = sorted ? "ThenBy" : "OrderBy";
}
else
{
methodName = sorted ? "ThenByDescending" : "OrderByDescending";
}
_query = typeof(Queryable).GetMethods().Single(
method => method.Name == methodName &&
method.IsGenericMethodDefinition &&
method.GetGenericArguments().Length == 2 &&
method.GetParameters().Length == 2)
.MakeGenericMethod(_type, propType)
.Invoke(null, new object[] { _query, propertyExpr }) as IOrderedQueryable <T>;
sorted = true;
}
//Linq to entities needs a sort to implement skip
//Not sure if we care about the queriables that come in sorted? IOrderedQueryable does not seem to be a reliable test
if (!sorted)
{
var firstProp = Expression.Property(paramExpr, _propertyMap.First().Value.Property);
var propType = _propertyMap.First().Value.Property.PropertyType;
var delegateType = Expression.GetFuncType(_type, propType);
var propertyExpr = Expression.Lambda(delegateType, firstProp, paramExpr);
_query = typeof(Queryable).GetMethods().Single(
method => method.Name == "OrderBy" &&
method.IsGenericMethodDefinition &&
method.GetGenericArguments().Length == 2 &&
method.GetParameters().Length == 2)
.MakeGenericMethod(_type, propType)
.Invoke(null, new object[] { _query, propertyExpr }) as IOrderedQueryable <T>;
}
}