Hi,
I'd developing an ASP.NET MVC application using Infragistics Grid. I'd like to let users save the filtering, sorting, and column hiding options they set on the grid, using a Save button on the UI. So, the setting are not to be saved automatically, but only when the button is pressed. This will extract the setting from the grid, and post them to the server, to store in DB. This part works nicely:
var gridSortingSettings = $("#CompaniesGrid").igGridSorting("option", "columnSettings"); var gridColumnSettings = $("#CompaniesGrid").igGrid("option", "columns"); var gridFilteringSettings = $("#CompaniesGrid").igGridFiltering("option", "columnSettings");
var url = '@Url.Action("SaveGridSettings")'; $.ajax({ type: "POST", url: url, data: JSON.stringify({ sortingSettings: gridSortingSettings, columnSettings: gridColumnSettings, filteringSettings: gridFilteringSettings }), contentType: "application/json; charset=utf-8", dataType: "json", });
What i'd like to do now, is to be able to restore these setting from the database, when loading the grid. I can retrieve these setting as JSON, however, I found no example of setting these options using the MVC View of the grid, as the grid is initialized this way. I have no idea how to set a JSON here. Do you have any suggestion, maybe better ideas for restoring these settings?
I tried setting it manually, this way, using a Restore button (would't be working this way, just for testing):var gridSortingSettings = <get JSON from server...> $('#CompaniesGrid').igGridSorting("option", "columnSettings", gridSortingSettings);Then, reading it again: var gridSortingSettingsReadBack = $("#CompaniesGrid").igGridSorting("option", "columnSettings");I found that however the JSON i read back changes as expected, the grid shows no difference. Maybe I need some way to refresh? Anyway, the perfect solutuon would be to make this load automatically from the MVC View when the grid is initializing grid, like setting @Html.Infragistics().Features().Sorting().Whatever()... in the View.
regards,
Peter
Hello Peter,
Thank you for contacting Infragistics!
Since you are using the MVC wrappers of the Ignite UI controls you can execute C# code inside the wrappers. So instead of trying to apply the settings after the grid is setup and then refresh you can apply them when initializing the grid. For example:
features.Updating().EditMode(GridEditMode.Cell).ColumnSettings(settings => { if (editor == true) { settings.ColumnSetting().ColumnKey("ProductID").EditorType(ColumnEditorType.Combo).ComboEditorOptions(options => { options.DataSourceUrl(Url.Action("GetComboData", "Home")).ShowDropDownButton(true).TextKey("ProductID").ValueKey("ProductID"); }); } });
So you can loop/parse you saved settings and apply them in initialization.
Please let me know if you have any further questions concerning this matter.
Mike,
Thanks for the quick help. So, that means that I have to parse the JSONs I saved from the grid, and set those options one by one using C# code? I have very complex grids, I hoped for a more straightforward solution, where I don't have to care about the actual contents of the JSONs, just save and restore them as strings, and igGrid taking care of the rest. Are you sure that no such solution exists? Maybe not using the MVC wrappers, but using pure JS or jQuery?
It's kind of hard to believe that I can't import something that I just exported without parsing it myself.
If I eventually have to implement this parsing, is there any resource about the structure of those JSONs? I'm afraid just clicking through the grid and checking the results wouldn't reveal all options that might be in them.
Thank you for the update. The Updating and sorting behaviors don’t have set methods for the column settings. The Filtering does:
http://www.igniteui.com/help/api/2015.2/ui.iggridfiltering#options:columnSettings
If you use JavaScript/jQuery to initialize the grid instead of the MVC wrappers you can put the settings you got before directly into the column settings property of the different grid features.
Thanks for answering the first part of my question. However, I'm still waiting for the second answer:
"If I eventually have to implement this parsing, is there any resource about the structure of those JSONs? I'm afraid just clicking through the grid and checking the results wouldn't reveal all options that might be in them."
Could you pleas answer this as well?
They would be an array of column settings and you can see the documentation for what properties they have:
http://www.igniteui.com/help/api/2015.2/ui.iggridsorting#options:columnSettings