About This Website
Download Documentation
The purpose of this portfolio website is to demonstrate a working Ticket Support Tracker for tech support with an integrated employee database, such as would be used on a corporation intranet.
The Star Trek theme was selected for this site to add interest and a unifying theme. The styling, theme, and colors can be easily modified to conform to existing design while retaining the functionality of the site.
This website also incorporates code to convert standard dates to a Star Trek stardate. The current stardate can be seen at the bottom right of every page, and all views that show a date show it in terms of the stardate it was set. Dates are still entered according to the Gregorian calendar for simplicity.
About Me
I have always had a passion for computers and coding and a love of technology (and Star Trek). My experience in programming began in 1983 on an Apple IIe. I was in junior high school. After earning my bachelor’s degree, I spent time operating my own business creating custom database applications for the publishing industry.
For more than 20 years, I worked as the editor and media director for a major nonprofit and was in charge of supervising, organizing, and maintaining five association websites, as well as the social media presence for the organization. I was also responsible for all of the print media efforts of the organization. I worked successfully with a very broad range of people, from accountants to artists and from business owners to potential clients of member businesses. I am very proud that I was able to organize and present huge amounts of data to the targeted end users in such a way that it was understandable and accessible to them.
In recent months, I have gained new skills and updated others through Centriq’s .Net Application Developer program. I look forward to putting my skills and experience to work coding in an environment that offers opportunity to encounter many challenges and discover solutions that meet and exceed the needs and expectations of the end user.
Visit Me
You can visit my portfolio website at:
Project Parameters
Tech Support Tracker Requirements
This project has been designed to utilize the majority of skills learned at Centriq. The core of this project is an ASP.NET MVC 5 website that utilizes Entity Framework to manage/persist trouble ticket data, and to track any people and status changes to these tickets.
The minimum requirements for this project are as follows:
Manage Departments:
- only available to admin users
- Index view should show all departments
- CRUD functionality (Soft Delete)
- Upon inserting or editing the department, they are taken to the index view with all departments
Manage Employees:
- only available to admin users
- index view should be set to only active employees, but be filterable to inactive employees
- CRUD functionality (Soft Delete)
- Upon inserting or editing the employee they are taken to the index view with all open employees
Support Tickets:
- index view should be set to only “open” (pending & In Process) requests
- Anonymous users can only view master-detail read-only mode
- If logged in, can insert new request (but may not edit)
- Authenticated users should be able to filter between either Open (Pending or In Process) and Resolved Requests
- If logged in as an Administrator (Techs should all be in Admin role) should be able to access edit functionality in detail view and toggle status between Resolved and In Process from master view
- Upon completing the new request (or clicking button to see Open requests) they are taken to the master view with all open requests
- CRUD functionality (Soft Delete)
Notes:
- BASIC Requirements should be fulfilled BEFORE any additional functionality is added
- jQuery DatePicker controls should be used for any dates
- All non-PK ID selections for Inserting and Updating should be done with DropDown lists
- Notes fields will need to be converted to Multi line text boxes in the
- All required fields should be validated
- Once you have base functionality your project should be backed up and not touched
All NEW requests should:
- Be in Pending Status automatically. (No user activity/selection)
- Have a null closed date
- Should NOT be able to see the Tech Notes field
- Allow for null tech id in the creation
- The only viewable fields for Authenticated NON ADMIN users should be the RequestingEmployee and Requestor Notes.
- Request history by Tech
- Request history by Employee
Example Status Records (know which constitute open/closed)
- Pending
- Assigned
- InProcess
- OnHold
- Resolved