public override WhereClause AddGlobalWhereClause()
        {
            CompoundFilter filter = new CompoundFilter(CompoundFilter.CompoundingOperators.And_Operator, null);
            WhereClause    wc     = new WhereClause();
            String         formula;

            if (BaseFormulaEvaluator.ShouldApplyGlobalWhereClause("1"))
            {
                formula = EvaluateFormula("1");
                filter.AddFilter(new BaseClasses.Data.ColumnValueFilter(PhotoClubContactLinksTable.RecordDeleted, formula, BaseClasses.Data.BaseFilter.ComparisonOperator.Not_Equals, false));
                wc.AddFilter(filter, CompoundFilter.CompoundingOperators.And_Operator);
            }

            return(wc);
        }
Example #2
0
        public override WhereClause AddGlobalWhereClause()
        {
            CompoundFilter filter = new CompoundFilter(CompoundFilter.CompoundingOperators.And_Operator, null);
            WhereClause    wc     = new WhereClause();
            String         formula;

            if (BaseFormulaEvaluator.ShouldApplyGlobalWhereClause("Session(\"ActiveEventId\")"))
            {
                formula = EvaluateFormula("Session(\"ActiveEventId\")");
                filter.AddFilter(new BaseClasses.Data.ColumnValueFilter(FieldTripsTable.EventId, formula, BaseClasses.Data.BaseFilter.ComparisonOperator.EqualsTo, false));
                wc.AddFilter(filter, CompoundFilter.CompoundingOperators.And_Operator);
            }

            return(wc);
        }
Example #3
0
        public override WhereClause AddGlobalWhereClause()
        {
            CompoundFilter filter = new CompoundFilter(CompoundFilter.CompoundingOperators.And_Operator, null);
            WhereClause    wc     = new WhereClause();
            String         formula;

            if (BaseFormulaEvaluator.ShouldApplyGlobalWhereClause("\"registration\""))
            {
                formula = EvaluateFormula("\"registration\"");
                filter.AddFilter(new BaseClasses.Data.ColumnValueFilter(UsersTable.UserName0, formula, BaseClasses.Data.BaseFilter.ComparisonOperator.Not_Equals, false));
                wc.AddFilter(filter, CompoundFilter.CompoundingOperators.And_Operator);
            }

            return(wc);
        }