I need a web page with the jquery date picker and a grid to represent a daily exercise log.?
* uses jquery and can use any jquery plugin
* 5 or 6 columns
* add/edit/delete functionality - all inline (no popups)
* add - adds new row to bottom of grid
* should always start with 5 rows (even if they are blank)
* paging and search not necessary
* grid height should change
* use jeditable for the inline editing (all items in the row should be editable at once
* can tab from one cell to the next
* external to the grid save and cancel buttons
* summary row at the top that will give summation if all values are numbers
* select row will highlight entire row (no checkboxes)
* this should use json web service calls from the front end to the back end
* built in asp.net/C# on the back end (not MVC)
* use linq to one sql server table called exercise
I've looked at a bunch of the grids out there, but nothing meets my immediate requirements.? jqgrid could probably be modified. ?
## Deliverables
Grid is based on current day (picked by the jquery datepicker) and the userid - on pageload date will be defaulted to today's date
in the exercise table 'setdate' is the date the exercise occurred, 'createdate' is the created or modified date for that record
save/add/delete are all buttons external to the grid
there is no edit button, user can edit rows by clicking on a cell in a row
For Add functionality:
User clicks "Add"? ?
* ? new row at the bottom of the grid appears
* ? user can then edit that row by clicking anywhere on the row and doing? inline editing
User highlights one or multiple rows and clicks Delete Button
Rows are removed from the grid, but the delete from the database does not occur until the user clicks 'save'
User clicks "Save" - code inserts, updates, or deletes appropriate rows in the Exercise Table
ID column not be shown in the grid
whenever an action takes longer than 1 second, a? 'processing' animated icon should? appear?
confirmation of save should appear (something nicer than just a javascript alert)