Wednesday, November 11, 2009

getting done things

public static string GetFilterExpression(int filterId)
{
var db = new UserQuery();
var filter = db.Filters.Single(f => f.Id == filterId);
var filterExpressions = filter.FilterExpressions;
var expressions = new List();
foreach(FilterExpression expr in filterExpressions)
{
expressions.Add(string.Format(expr.Operator.Operation, expr.ColumnName, expr.Value));
}
string logicalOperator = (filter.MatchAll) ? " AND " : " OR ";
return String.Join(logicalOperator, expressions.ToArray());
}

No comments: