internal static string getOperator(QueryComparisonOperators op)
{
switch (op)
{
case QueryComparisonOperators.EqualTo: goto default;
case QueryComparisonOperators.GreaterOrEqual: return(">=");
case QueryComparisonOperators.GreaterThan: return(">");
case QueryComparisonOperators.IsLike: return("IS LIKE");
case QueryComparisonOperators.IsNotLike: return("IS NOT LIKE");
case QueryComparisonOperators.IsNotNull: return("IS NOT NULL");
case QueryComparisonOperators.IsNull: return("IS NULL");
case QueryComparisonOperators.LessOrEqual: return("<=");
case QueryComparisonOperators.LessThan: return("<");
case QueryComparisonOperators.NotEqualTo: return("!=");
default:
return("=");
}
}
protected override IQueryBuilder <EventModel> CreateQueryBuilder(EventModel Source, QueryComparisonOperators Operator, bool IdOnly)
{
var queryBuilder = new QueryBuilder <EventModel>();
if (Source.IsChanged(x => x.ID))
{
queryBuilder.Where(x => x.ID, Source.ID, Operator);
}
if (!IdOnly && Source.IsChanged(x => x.Code))
{
queryBuilder.Where(x => x.Code, Source.Code, Operator);
}
if (!IdOnly && Source.IsChanged(x => x.Content))
{
queryBuilder.Where(x => x.Content, Source.Content, Operator);
}
if (!IdOnly && Source.IsChanged(x => x.Type))
{
queryBuilder.Where(x => x.Type, Source.Type, Operator);
}
return(queryBuilder);
}
protected override IQueryBuilder <RoleModel> CreateQueryBuilder(RoleModel Source, QueryComparisonOperators Operator, bool IdOnly)
{
var queryBuilder = new QueryBuilder <RoleModel>();
if (Source.IsChanged(x => x.ID))
{
queryBuilder.Where(x => x.ID, Source.ID, Operator);
}
if (!IdOnly && Source.IsChanged(x => x.Name))
{
queryBuilder.Where(x => x.Name, Source.Name, Operator);
}
if (!IdOnly && Source.IsChanged(x => x.Description))
{
queryBuilder.Where(x => x.Description, Source.Description, Operator);
}
if (!IdOnly && Source.IsChanged(x => x.Mode))
{
queryBuilder.Where(x => x.Mode, Source.Mode, Operator);
}
return(queryBuilder);
}
public DatabaseCondition(string Table1, string Column1, QueryLogicalOperators LogicalOperator, QueryComparisonOperators ComparisonOperator, Int32 Depth)
{
this.Table1 = Table1;
this.Column1 = Column1;
this.LogicalOperator = LogicalOperator;
this.ComparisonOperator = ComparisonOperator;
this.Depth = Depth;
this.CanPerformAction = false;
this.Action = QueryColumnActions.None;
this.Table2 = null;
this.Column2 = null;
this.Value = null;
this.Wildcard = "*";
this.CompareColumns = false;
}
protected override IQueryBuilder <UserModel> CreateQueryBuilder(UserModel Source, QueryComparisonOperators Operator, bool IdOnly)
{
var queryBuilder = new QueryBuilder <UserModel>();
if (Source.IsChanged(x => x.ID))
{
queryBuilder.Where(x => x.ID, Source.ID, Operator);
}
if (!IdOnly && Source.IsChanged(x => x.Login))
{
queryBuilder.Where(x => x.Login, Source.Login, Operator);
}
if (!IdOnly && Source.IsChanged(x => x.Email))
{
queryBuilder.Where(x => x.Email, Source.Email, Operator);
}
if (!IdOnly && Source.IsChanged(x => x.Name))
{
queryBuilder.Where(x => x.Name, Source.Name, Operator);
}
if (!IdOnly && Source.IsChanged(x => x.CreatedMethod))
{
queryBuilder.Where(x => x.CreatedMethod, Source.CreatedMethod, Operator);
}
if (!IdOnly && Source.IsChanged(x => x.Pin))
{
queryBuilder.Where(x => x.Pin, Source.Pin, Operator);
}
if (!IdOnly && Source.IsChanged(x => x.Manager))
{
queryBuilder.Where(x => x.Manager, Source.Manager, Operator);
}
if (!IdOnly && Source.IsChanged(x => x.Role))
{
queryBuilder.Where(x => x.Role, Source.Role, Operator);
}
return(queryBuilder);
}
protected abstract IQueryBuilder <M> CreateQueryBuilder(M Source, QueryComparisonOperators Operator, Boolean IdOnly);
protected override IQueryBuilder <ActionModel> CreateQueryBuilder(ActionModel Source, QueryComparisonOperators Operator, bool IdOnly)
{
var queryBuilder = new QueryBuilder <ActionModel>();
if (Source.IsChanged(x => x.ID))
{
queryBuilder.Where(x => x.ID, Source.ID, Operator);
}
return(queryBuilder);
}
