Showing posts with label stored procedure. Show all posts
Showing posts with label stored procedure. Show all posts

Tuesday, June 26, 2012

Fresh and Easy Shop for Shools Admin Tool

This is one of my biggest .NET project and I am happy with the end result. This project has 12 database tables and 50 stored procedures. This application is completely Ajax and web services driven. I also used EJS Javascript template engine.

Main functionality including:
  1. Administrator activity log
  2. Find possible duplicate school records. This is done using Full-text search against school name and address
  3. Search schools
  4. Result pagination
  5. Update 1 or more schools at a time
  6. Add new school attributes
  7. Create and update admin users
  8. Multiple user level with different permissions
  9. Export school data to Excel