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.

Project Gallery

Check out some photos of the ticket app in action