MVC List with Advance Filtering

MVC List with Advance Filtering

Business Case

Client already had the solution on some other platform. He wanted same with MVC. Basically requirement is to create a grid, which has some data for a particular project. User can filter with different conditions and also can group data for one level. Also filtered and grouped data grid can be exported to excel sheet.

Skills

ASP.NET MVC 4
65
Microsoft SQL Server 2014
80
Dynamic LINQ for filtering data
70
Bootstrap3
60
JQuery, JQuery UI, JQuery query-builder
75
NPOI for excel export
70
Technical Objectives
1. Show data in a grid
2. Drag headers and drop to a particular area to group by that column
3. Advanced data filter that can include various conditions including “AND”, “OR” on different columns
4. Export to Excel
5. Achieve all these functionalities simultaneously and without using any paid tool.
PSSPL Solution
1. Replication of functionality of old system and using existing database to work with new system
2. Using MVC Architecture along with JQuery and other JQuery Plugins
Benefits
1. User can see data as he/she wants. Data can be filtered, grouped, summarized etc.
2. Grid can be exported to excel.