This is a migrated thread and some comments may be shown as answers.

EnableCustomBinding and GroupBy

17 Answers 202 Views

Grid

This is a migrated thread and some comments may be shown as answers.

This question is locked. New answers and comments are not allowed.

Jason Walker asked on 23 Mar 2010, 09:25 PM

Forgive me if this is a known issue, but it appears that you cannot use EnableCustomBinding with Grouping in the current version.

I've identified the problem being in GridActionAttribute.OnActionExecuting (this is reflected code, not the actual source code):

                    public void OnActionExecuting(ActionExecutingContext filterContext)         
            {         
                if (filterContext.ActionParameters.ContainsKey(this.ActionParameterName))         
                {         
                    GridCommand command2 = new GridCommand();         
                    command2.Page = filterContext.Controller.ValueOf<int>(GridUrlParameters.CurrentPage);         
                    command2.PageSize = filterContext.Controller.ValueOf<int>(GridUrlParameters.PageSize);         
                    GridCommand command = command2;         
                    string from = filterContext.Controller.ValueOf<string>(GridUrlParameters.OrderBy);         
                    command.SortDescriptors.AddRange<SortDescriptor>(GridDescriptorSerializer.Deserialize<SortDescriptor>(from));         
                    string input = filterContext.Controller.ValueOf<string>(GridUrlParameters.Filter);         
                    command.FilterDescriptors.AddRange<IFilterDescriptor>(FilterDescriptorFactory.Create(input));         
                    filterContext.ActionParameters[this.ActionParameterName] = command;         
                }         
            }         
                     
        
        
        
        

Notice that it deserializes all the required parts of GridCommand except for GroupBy. I've fixed this in my own code, but figured you guys may want to fix this in the next release.

17 Answers, 1 is accepted

answered on 14 Apr 2010, 02:10 PM

In a few days, I will post some extensions that me and my friend Juan implemented on the Telerik grid to help the implementation on CustomBinding. We are testing the extensions now, and we can use filtering, sorting and grouping with a few lines of code.

An example:

                    [GridAction(EnableCustomBinding = true)]         
            public ActionResult Index(GridCommand command)         
            {         
                return View(command.List<TUser>(30));         
            }         

Where the List is an extension method that have GridCommand and PageSize as parameters.

I expect to release the code in google code today or tomorrow.

It will be awesome to have the feedback of you guys.

Regards,

Lincoln

answered on 14 Apr 2010, 11:50 PM

You don't need GridState to call ToGridModel

                    public static GridModel Apply<T>(this GridCommand command, IQueryable<T> data)         
                    {         
                        var sortDescriptors = command.SortDescriptors ?? new List<SortDescriptor>();         
                        var groupDescriptors = command.GroupDescriptors ?? new List<GroupDescriptor>();         
                        var filterDescriptors = command.FilterDescriptors ?? new List<IFilterDescriptor>();         
                     
                        foreach (var sortDescriptor in sortDescriptors)         
                            sortDescriptor.Member = GetSortMember(sortDescriptor.Member);         
                                 
                        foreach (var groupDescriptor in groupDescriptors)         
                            groupDescriptor.Member = GetSortMember(groupDescriptor.Member);         
                                 
                        return data.ToGridModel(command.Page, command.PageSize, sortDescriptors, filterDescriptors, groupDescriptors);         
                    }         

This is my extension method on GridCommand. Nevermind what GetSortMember does, that's my bit of custom stuff, which is why I had to EnableCustomBinding to begin with.

answered on 17 Apr 2010, 04:09 AM

Hi, as Lincoln said before, we were working on a set of extensions to enable using Telerik with partially implemented LINQ providers (e.g.: NHibernate's one). We have finished a first working version. It can create a meta expression, that works on an IQueryable<T> and returns another one.

The code itself is made to create expressions able to be serialized (and sent over the wire) and to work with NHibernate Linq provider, but the whole idea can be incorporated to any use you want. The implementation is very similar to ExpressionVisitor class, provided by Microsoft.

Sadly, we had an issue with the GroupBy using CustomBinding. To workaround, we modified the grid source code a little bit. The whole source code (including the modified Telerik's one), as well as the nightly built binaries and an example can be downloaded at:

http://code.google.com/p/simple-telerik-extensions

answered on 30 Jun 2010, 04:33 PM

I followed his advice and added

                    .Groupable(settings =>         
                        {         
                     
                            settings.Groups(groups =>         
                            {         
                                groups.Add(o => o.ShipName);         
                            });         
                            settings.Enabled(true);         
                        })         

to the CustomBinding.aspx page and when you select paging everything gets thrown off. In this case grouping is not being applied. I have a serious issue with grouping not working and the view being thrown off when an ajax call is made. Please advise a resolution .