[CLOSED] GridFilters Plugin and MVC

[Stefanaccio]

Hello,

in an MVC application I'm using a GridPanel with the GridFilters Plugin. The GridPanel is linked to the following Store:

        <ext:Store ID="dsCustomers" runat="server" RemoteSort="true" >
            <Proxy>
                <ext:HttpProxy Url="/Customer/GetCustomerList/" />
            </Proxy>
            <UpdateProxy>
                <ext:HttpWriteProxy Url="/Customer/SaveCustomerList/" />
            </UpdateProxy>
            <Reader>
                <ext:JsonReader IDProperty="CustomerId" Root="data" TotalProperty="total">
                    <Fields>
                        <ext:RecordField Name="CustomerId" Type="Int" />
                        <ext:RecordField Name="CustomerName" SortDir="ASC" />
                        <ext:RecordField Name="EMailAddress" />
                    </Fields>
                </ext:JsonReader>
            </Reader>
            <BaseParams>
                <ext:Parameter Name="limit" Value="50" Mode="Raw" />
                <ext:Parameter Name="start" Value="0" Mode="Raw" />
                <ext:Parameter Name="dir" Value="ASC" />
                <ext:Parameter Name="sort" Value="CustomerName" />
            </BaseParams>
            <SortInfo Field="CustomerName" Direction="ASC" />
        </ext:Store>

The Proxy invokes the following method in the CustomerController class:

public AjaxStoreResult GetCustomerList(int limit, int start, string dir, string sort)
{
    var query = (from c in this._CustomerRepository
                                 select new
                                 {
                                     c.CustomerId,
                                     c.CustomerName,
                                     c.EMailAddress
                                 }).OrderBy(string.Concat(sort, " ", dir));


    int total = query.Count();
    var paginatedQuery = query.Skip(start).Take(limit).ToList();
    return new AjaxStoreResult(paginatedQuery, total);
}

How can I pass filters set in the grid to the GetCustomerList method to parse them and send appropriate query to the database?

Thanks,
Stefano

[Vladimir]

Hi,

Please update from SVN first


You have to use Remote mode for GridFilters (by default)
If you use remote mode then current filters set will be submitted as 'gridfilters'


Action method:

public AjaxStoreResult GetCustomerList(int limit, int start, string dir, string sort, string gridfilters)
        {
            if (!string.IsNullOrEmpty(gridfilters))
            {
                FilterConditions filters = new FilterConditions(gridfilters);
            }
            return new AjaxStoreResult(data, total);
        }

The example how to work with FilterConditions class
https://examples1.ext.net/#/GridPane...ilters_Remote/

[Stefanaccio]

Hi,

I tried your changes but there is something that I can not understand. When invoked the GetCustomerList method gridfilters string parameter has the value "[object Object]".

Is there anything else I have to do?

Bye,
Stefano

[Vladimir]

Hi,

Did you update from SVN?

[Stefanaccio]

Yes, this morning.

Bye,
Stefano

[Vladimir]

Hi,

I think you still use old assemblies (may be caching issue)
"[object Object]" is old behaviour, now gridfilters return json string
Check assembly time creation
If you sure that you use latest assemblies then please send me your test project with assemblies (support@object.net)

[Stefanaccio]

It's correct that after the SVN update I have to recompile the Ext.Net.install solution?

Bye,
Stefano

[Vladimir]

Hi,

You have to recompile Ext.Net or Ext.Net.install solution (just install solution doesn't have Ext.Net.Examples, sandbox and another none required solutions).


After recompile you have to add references on new assemblies in your application

[Stefanaccio]

It's all OK.

Thanks,
Stefano

[dynamikus]

Action method:

public AjaxStoreResult GetCustomerList(int limit, int start, string dir, string sort, string gridfilters)
        {
            if (!string.IsNullOrEmpty(gridfilters))
            {
                FilterConditions filters = new FilterConditions(gridfilters);
            }
            return new AjaxStoreResult(data, total);
        }

For the moment I cannot buy premium service (sorry) so if it possible could you post a sample of code that manages this gridfilters based on linq to sql model (below)

public AjaxStoreResult GetCustomerList(int limit, int start, string dir, string sort)
{
    var query = (from c in this._CustomerRepository
                                 select new
                                 {
                                     c.CustomerId,
                                     c.CustomerName,
                                     c.EMailAddress
                                 }).OrderBy(string.Concat(sort, " ", dir));
 
 
    int total = query.Count();
    var paginatedQuery = query.Skip(start).Take(limit).ToList();
    return new AjaxStoreResult(paginatedQuery, total);
}

In any case thank you anyway.