I want to create a reusable way to use the excellent jQuery datatables plugin with .Net MVC for all my views that contain tables. Now, I already worked out how server side processing with this plugin works and how I need to write my controller logic to provide the appropriate response.
The problem starts with rendering html though. Say for example that I need to render a picture next every person's name in a 'people table'. However, when I type in the search box, it should still correctly search by the names of those people.
Now, with the Razor view engine this is easy as pie, you could write something like this:
@foreach (var person in people)
{
<tr>
<td>
<span>@person.Name</span>
<img src="@person.ImgUrl" title="@person.Name"/>
</td>
</tr>
}
The problem is that this needs to be rendered to JSON on the server side. You would have a Controller that handles the jQuery datatables AJAX requests and returns a valid JSON object containing everything the datatable needs. However, you can't access snippets from your view in your controller. The only option I see here is to create partial views for every column that needs to render some specific HTML. (For common use cases, like action buttons, I could write HTML helpers)
And there's the problem. I'm hesitant to create partial views for every table for every HTML column.
The issue here is that the controller needs to somehow access the display logic to create JSON, while the display logic is typically written in the view. My options are limited to using partial views and rendering those to a string in the controller, or storing my display logic (which are lambda expressions) in some sort of server session or cache and fetching it from the controller. The big downside to this last approach is that sessions or cache seem too volatile to depend on.
So, to reiterate:
- I want to show a table of entities using the jQuery datatable plugin with AJAX server side processing.
- I want to write my display logic in my view, using the Razor view engine
- I want to handle the jQuery datatable AJAX requests in my controller
- I want to somehow ** access the display logic per column** written in my view from within my controller to construct the JSON response. This is because some columns can have custom HTML, load partials, etc.
I'm really quite stuck on this, if there are similar questions on Stackoverflow about this please point me to them because I haven't found them.
Thank you in advance for your help.
