Welcome to the Tech Support Tracker (TST)

The core of this project is an ASP.NET 4.0 website that utilizes ADO.NET to manage/persist trouble ticket data, and to track any people and status changes to these tickets.

Requirements

Secure / Admin / ManageEmployees.aspx:

  • Master/Detail multi-view of employees
  • Page only available to users in role of "admin"
  • Master View should be set to display only active employees, but be filterable to inactive employees
  • CRUD (Create/Retrieve/Update/Delete) functionality: Soft delete on Master View and Insert/Edit on Detail View
  • Upon inserting or editing the employee (or clicking the button to see employees), they are taken to the Master View to see the updated list of employees

Secure / Admin / ManageDepartments.aspx:

  • Master/Detail multi-view of departments
  • Page only available to users in role of "admin"
  • Master View should be set to display all departments
  • CRUD (Create/Retrieve/Update/Delete) functionality: Soft delete (with Return Confirm) on Master View and Insert/Edit on Detail View
  • On inserting or editing a department, user is taken to the Master View to see the updated list of departments

Requests.aspx:

  • Master/Detail multi-view of requests
  • Master View should be set to display only "open" (Pending, Assigned, In Process, On Hold) tickets
  • Anonymous users can only view tickets in read-only mode
  • If logged in (i.e. authenticated), the user can insert a new request (but may not edit)
  • Authenticated users can also filter between "open" (Pending, Assigned, In Process, On Hold) and "resolved" (Resolved, Deactivated) tickets
  • If logged in as an Administrator, the user should be able to access edit functionality in Detail View and toggle status between "resolved" and "open" from Master View
  • CRUD (Create/Retrieve/Update/Delete) functionality: Soft delete (with Return Confirm) on Master View and Insert/Edit on Detail View
  • Upon completing the new request (or clicking button to see Open requests), the user is taken to the Master View with all "open" requests

Miscellaneous Requirements

  • jQuery Datepicker controls are used for any date entry
  • All foreign key ID selections for Insert/Update are displayed as DropDownLists
  • Notes fields should be converted to Multiline
  • All required fields should have validation controls

Extra Functionality Added

  • On creation of a new request, the request date is dynamically set to current date and time. If a request is deactivated, the closed date is updated to the current date and time. If reactivating a resolved request, the closed date is set to null.
  • Employees and Requests have an optional image field to allow for an upload of an image file associated with the request (or picture of the employee) which is displayed on the Details View.
  • Requests have been given a priority field. Initial display of requests are in priority order, highest to lowest, and the select button for each row is color-coded to help indicate the priority. Also included a priority color legend in the footer which illustrates what priority each color represents.
  • Footer reference section - Values of priority levels, departments, and request statuses listed in page footer for quick reference
  • Functional contact page.

Future Functionality

  • Role of "tech" - Allows for request editing and closing, separated from admin role.
  • Further responsive updates for the grid views