ASP.NET MVC - One Page - Read only - SignalR Update in Datatable js

MVC one page - web application

1. By default load all the data in grid order by ActionTakenOn (latest first)

2. The data will be huge in actual scenario (Half million), so use server side pagination with default 100 records in one page

3. Use only Data table js - [login to view URL] for the grid

4. There is no insert and update of the table required. Just search and show the data in web page

5. This is a read only grid. All the inserts and updates happending in table should reflect in web page without refreshing - Must use signalR.

6. User should be able to search by internal id and click search to get all the respective rows of the internal id

7. All javascript codes should be in a single .js file, SignalR scripts should be in content/plugins folder

9. Show the last date time stamp of grid updated via SignalR

10. Show the reference value of [ActionState], [ActionType], [ActionFor] columns from lookup table and True/False for [ActionStatus]

11. Coding standard and naming conventions with proper comments

See, attached files for page layout and sql db script for sql table and data

ASP.NET C# Programování JavaScript Microsoft SQL Server MVC

Identifikační číslo projektu: #18484722

O projektu