Example #1
0
        public static T[] GridCommonSettingswithCustomFilter <T>(this IQueryable <T> query, GridSettings grid, out int count)
        {
            if (grid.IsSearch)
            {
                //And
                if (grid.Where.groupOp == "AND")
                {
                    foreach (var rule in grid.Where.rules)
                    {
                        if (rule.field != "Pending" && rule.field != "Confirmed")
                        {
                            query = query.Where(
                                rule.field, rule.data,
                                (WhereOperation)StringEnum.Parse(typeof(WhereOperation), rule.op));
                        }
                    }
                }
                else
                {
                    //Or
                    var temp = query;
                    foreach (var rule in grid.Where.rules)
                    {
                        if (rule.field != "Pending" && rule.field != "Confirmed")
                        {
                            var t = query.Where(
                                rule.field, rule.data,
                                (WhereOperation)StringEnum.Parse(typeof(WhereOperation), rule.op));
                            temp = temp.Concat(t);
                        }
                    }
                    //remove repeating records
                    query = temp.Distinct();
                }
            }

            //sorting
            query = query.OrderBy(grid.SortColumn,
                                  grid.SortOrder);

            //count the total number of count
            count = query.Count();

            // return data with paging
            return(query.Skip((grid.PageIndex - 1) * grid.PageSize).Take(grid.PageSize).ToArray());
        }
Example #2
0
        public static T[] GridCommonSettings <T>(this IQueryable <T> query, GridSettings grid, out int count)
        {
            if (grid.IsSearch)
            {
                //And
                if (grid.Where.groupOp == "AND")
                {
                    foreach (var rule in grid.Where.rules)
                    {
                        //Hack to resolve datetime issue for equal , add one more where condition with lessthan of next date
                        ParameterExpression parameter    = Expression.Parameter(query.ElementType, "p");
                        MemberExpression    memberAccess = null;
                        foreach (var property in rule.field.Split('.'))
                        {
                            memberAccess = MemberExpression.Property
                                               (memberAccess ?? (parameter as Expression), property);
                        }

                        if ((memberAccess.Type == typeof(DateTime) || memberAccess.Type == typeof(DateTime?)) && (WhereOperation)StringEnum.Parse(typeof(WhereOperation), rule.op) == WhereOperation.Equal)
                        {
                            query = query.Where(
                                rule.field, rule.data,
                                (WhereOperation)StringEnum.Parse(typeof(WhereOperation), "ge"));

                            query = query.Where(
                                rule.field, DateTime.Parse(rule.data).AddDays(1).Date,
                                (WhereOperation)StringEnum.Parse(typeof(WhereOperation), "lt"));
                        }
                        else
                        {
                            query = query.Where(
                                rule.field, rule.data,
                                (WhereOperation)StringEnum.Parse(typeof(WhereOperation), rule.op));
                        }
                    }
                }
                else
                {
                    //Or
                    var temp = query;
                    foreach (var rule in grid.Where.rules)
                    {
                        //Hack to resolve datetime issue for equal , add one more where condition with lessthan of next date
                        ParameterExpression parameter    = Expression.Parameter(query.ElementType, "p");
                        MemberExpression    memberAccess = null;
                        foreach (var property in rule.field.Split('.'))
                        {
                            memberAccess = MemberExpression.Property
                                               (memberAccess ?? (parameter as Expression), property);
                        }

                        if ((memberAccess.Type == typeof(DateTime) || memberAccess.Type == typeof(DateTime?)) && (WhereOperation)StringEnum.Parse(typeof(WhereOperation), rule.op) == WhereOperation.Equal)
                        {
                            var t = query.Where(
                                rule.field, rule.data,
                                (WhereOperation)StringEnum.Parse(typeof(WhereOperation), "ge"));
                            temp = temp.Concat(t);

                            t = query.Where(
                                rule.field, DateTime.Parse(rule.data).AddDays(1).Date,
                                (WhereOperation)StringEnum.Parse(typeof(WhereOperation), "lt"));
                            temp = temp.Concat(t);
                        }
                        else
                        {
                            var t = query.Where(
                                rule.field, rule.data,
                                (WhereOperation)StringEnum.Parse(typeof(WhereOperation), rule.op));
                            temp = temp.Concat(t);
                        }
                    }

                    //remove repeating records
                    query = temp.Distinct();
                }
            }

            //sorting

            query = query.OrderBy(grid.SortColumn,
                                  grid.SortOrder);

            //count the total number of count
            count = query.Count();

            // return data with paging
            return(query.Skip((grid.PageIndex - 1) * grid.PageSize).Take(grid.PageSize).ToArray());
        }