static void Main(string[] args)
{
var optionsBuilder = new DbContextOptionsBuilder <AdventureWorksContext>();
optionsBuilder.UseSqlServer(Settings.Adventure);
AdventureWorksContext context = new AdventureWorksContext(optionsBuilder.Options);
new IntroAnimation().Play();
History history = new History(context);
history.Presenter();
LanguageSupport language = new LanguageSupport(context);
language.Presenter();
QueryOperators queryOperators = new QueryOperators();
queryOperators.Presenter();
DeferredExecution deferred = new DeferredExecution(context);
deferred.Presenter();
Performance perf = new Performance(context);
perf.PerformancePresenter();
Console.ReadLine();
}
/// <summary>
/// Converts a QueryOperator to a string
/// </summary>
public static string ToQuery(this QueryOperators qe)
{
switch (qe)
{
case QueryOperators.Equals:
return("=");
case QueryOperators.NotEqualTo:
return("<>");
case QueryOperators.GreaterThan:
return(">");
case QueryOperators.GreaterThanOrEqualTo:
return(">=");
case QueryOperators.LessThan:
return("<");
case QueryOperators.LessThanOrEqualTo:
return("<=");
case QueryOperators.Like:
return("LIKE");
case QueryOperators.NotLike:
return("NOT LIKE");
case QueryOperators.IsNot:
return("IS NOT");
case QueryOperators.Is:
return("IS");
case QueryOperators.In:
return("IN");
case QueryOperators.NotIn:
return("NOT IN");
default:
return(string.Empty);
}
}
public static String GetQueryOperatorSymbol(this QueryOperators value)
{
String queryOperatorSymbol = String.Empty;
switch (value)
{
case QueryOperators.Equals:
queryOperatorSymbol = "=";
break;
case QueryOperators.NotEquals:
queryOperatorSymbol = "!=";
break;
case QueryOperators.GreaterThan:
queryOperatorSymbol = ">";
break;
case QueryOperators.LessThan:
queryOperatorSymbol = "<";
break;
case QueryOperators.GreaterThanOrEqual:
queryOperatorSymbol = ">=";
break;
case QueryOperators.LessThanOrEqual:
queryOperatorSymbol = "<=";
break;
case QueryOperators.Contains:
queryOperatorSymbol = "LIKE";
break;
}
return(queryOperatorSymbol);
}
public static Query ToQuery(this DataSourceRequest request)
{
Query query = new Query();
#region Paging
query.UsePaging = true;
query.PageSize = request.PageSize;
query.CurrentPage = request.Page - 1;
#endregion
#region Sort
query.SortPropertyName = request.Sorts[0].Member;
query.SortDescending = request.Sorts[0].SortDirection == System.ComponentModel.ListSortDirection.Descending;
#endregion
#region Filters
if (request.Filters.Count > 0)
{
QueryFilterGroup qfg = new QueryFilterGroup()
{
IsAndFilter = true
};
foreach (IFilterDescriptor iFilterDescriptor in request.Filters)
{
if (iFilterDescriptor is FilterDescriptor)
{
FilterDescriptor filterDescriptor = iFilterDescriptor as FilterDescriptor;
QueryOperators queryOperator = QueryOperators.None;
switch (filterDescriptor.Operator)
{
case FilterOperator.IsLessThan:
queryOperator = QueryOperators.LessThan;
break;
case FilterOperator.IsLessThanOrEqualTo:
queryOperator = QueryOperators.LessThanOrEqual;
break;
case FilterOperator.IsEqualTo:
queryOperator = QueryOperators.Equals;
break;
case FilterOperator.IsNotEqualTo:
queryOperator = QueryOperators.NotEquals;
break;
case FilterOperator.IsGreaterThanOrEqualTo:
queryOperator = QueryOperators.GreaterThanOrEqual;
break;
case FilterOperator.IsGreaterThan:
queryOperator = QueryOperators.GreaterThan;
break;
case FilterOperator.StartsWith:
break;
case FilterOperator.EndsWith:
break;
case FilterOperator.Contains:
break;
case FilterOperator.IsContainedIn:
break;
case FilterOperator.DoesNotContain:
break;
case FilterOperator.IsNull:
break;
case FilterOperator.IsNotNull:
break;
case FilterOperator.IsEmpty:
break;
case FilterOperator.IsNotEmpty:
break;
case FilterOperator.IsNullOrEmpty:
break;
case FilterOperator.IsNotNullOrEmpty:
break;
default:
break;
}
String parameter = filterDescriptor.Value.ToString();
if (filterDescriptor.Value is String)
{
parameter = String.Format("\'{0}\'", filterDescriptor.Value);
}
//filterDescriptor.v
if (queryOperator != QueryOperators.None)
{
qfg.QuerySingleFilters.Add(new QuerySingleFilter()
{
IsAndFilter = true,
PropertyName = filterDescriptor.Member,
QueryOperator = queryOperator,
Parameter = parameter
});
}
}
}
query.QueryFilterGroups.Add(qfg);
}
#endregion
return(query);
}
/// <summary>
/// Constrcutor with the most common parameters
/// </summary>
public WhereCondition(Expression <Func <T, object> > column, QueryOperators queryOperator, object value)
{
Column = column;
Value = value;
Operator = queryOperator;
}
/// <summary>
/// Returns an object collection of the type T where
/// the object's value(s) matches the supplied value(s)
/// </summary>
protected static List <TY> LoadReferencing <TY>(Expression <Func <TY, object> > column, QueryOperators queryOperator, object value) where TY : Dwarf <TY>, new()
{
return(LoadReferencing(new WhereCondition <TY> {
Column = column, Operator = queryOperator, Value = value
}));
}
