This project is a Helpdesk System developed using the ASP.NET web application framework with C# as the programming language. The system was built from scratch.
Development Environment:
- IDE: Visual Studio
- Database: Microsoft SQL Server (connected via Visual Studio)
The system allows users to submit tickets and admins to manage them efficiently.
- Each ticket can be assigned to one admin only.
- Other admins can view ticket details but cannot assign the ticket to themselves once it is assigned.
- The admin who assigned the ticket can edit it, unless they drop it (change status back to pending).
- Users can delete tickets only if no admin has assigned them yet.
- All ticket actions are timestamped (created, assigned, completed).
Admins can:
- Login using Email & Password
- Recover forgotten password via registered email
- Assign pending tickets to themselves
- Add comments to tickets for users to view
- Drop tickets for other admins to handle
- Add new users to the system
- Add new tickets
- View system statistics via the dashboard
- Reset user passwords and send them via email
- Change their own password
Users can:
- Login using Email & Password
- Recover forgotten password via registered email
- Create new tickets
- View all their submitted tickets
- Delete tickets only if the status has not been changed by an admin
- View personal statistics via the dashboard
- Change their own password
- Uses SMTP (smtp.gmail.com, port 587)
- Replace the example email and password in the following files to activate email features:
Forgotpassword.aspx.csAdminUserListDetails.aspx.cs
Admin Dashboard:
- Displays total tickets, completed tickets, in-progress tickets, and pending tickets
- Shows the latest 4 tickets submitted by all users
Ticket Submission Page:
- Allows users or admins to submit new tickets
Ticket List (Admin):
- Displays all tickets in the system
- Admins can assign pending tickets to themselves or view ticket details
- Includes a search box to filter tickets by any detail
Assigned Tickets (Admin):
- Shows tickets assigned to each admin
- Admin can mark tickets as completed or drop them for others to handle
User Management (Admin):
- Add new users
- View all users, edit details, delete users, or reset passwords
Password Management:
- Allows users and admins to change their password if they know the current one
- ASP.NET Web Application Framework
- C# Programming Language
- Microsoft SQL Server
- Visual Studio IDE
- Clone the repository
- Open the solution in Visual Studio
- Configure the database connection in Visual Studio to your local SQL Server
- Update the SMTP email settings in
Forgotpassword.aspx.csandAdminUserListDetails.aspx.cs - Build and run the application