Project Details
- Title: Help Desk Ticketing
- Tools: Visual Studio, SQLITE3
- Team: Myself; Nicholas Olsen
- Purpose: Conceptual CRUD VB.NET Project
Features
- Authentication: Simple local User Authentication storing data hashed.
- Data Persistence: Create and edit Tickets stored in a local SQLITE3 file.
- Responsive Design: Using WinForms responsive anchors and code to resize and center appropriately.
Architecture
Architected with in a simple WinForm
WinForm
This app is built as a WinForm application written using VB.NET
Database (SQLITE3)
Relational database used to store and query user and ticket data
- Users: Stores hashed credentials for users and display names.
- Tickets: Stores ticket data.
- Comments: Stores all ticket comments which is linked back to their ticket by id.
Challenges
Throughout development as simple features grew into more complex ones several problems occurred such as:
- Responsive: Implementing a responisive and resizable layout was a challenge and I had to lean on Anchors and Code to accomplish appropriate design.
