private void QueryFilter(QueryFilterContext context) {
if (!context.Filters.ContainsKey("content"))
return;
var contentId = context.Filters["content"].ToInt32();
context.Query = context.Query.Where(x => x.EventFilterKey == "content" && x.EventFilterData == contentId.ToString());
}
private void QueryFilter(QueryFilterContext context) {
var contentType = context.Filters.Get("contenttype");
if(String.IsNullOrWhiteSpace(contentType))
return;
context.Query = context.Query.Where(x => x.EventFilterKey == "contenttype" && x.EventFilterData == contentType);
}
public override void Filter(QueryFilterContext context) {
var userName = context.Filters.Get("username");
var category = context.Filters.Get("category");
var from = GetDateFromFilter(context.Filters, "From", "from").StartOfDay();
var to = GetDateFromFilter(context.Filters, "To", "to").EndOfDay();
var query = context.Query;
if (!String.IsNullOrWhiteSpace(userName)) {
query = query.Where(x => x.UserName == userName);
}
if (!String.IsNullOrWhiteSpace(category)) {
query = query.Where(x => x.Category == category);
}
if (from != null) {
query = query.Where(x => x.CreatedUtc >= from);
}
if (to != null) {
query = query.Where(x => x.CreatedUtc <= to);
}
context.Query = query;
}
public virtual void Filter(QueryFilterContext context) {}
