What is VueTicket?

The VueTicket is a Ticketing Application for small companies in customer support.

Technologies Used

• ASP.NET Core 7.0

• Entity Framework Core 7.0.8

Give a Star ⭐️

If you find the project helpful in Quick Learning, give it a star.

How to Purchase Database

Purchase

⭐️ New Features⭐️

Features

---

• Multilingual application
• Login
• Create User
• Create Ticket
• Dashboard with Status Counts
• View All Tickets
• Ticket History
• Knowledgebase
• Delete & Restore Ticket
• Replying to Ticket
• Reports
• Escalation
• Notification
• Masters
• View All Roles
• Managing Menu Category, Menu, and SubMenu
• Adding and Managing Users (Users, Agent, Agentadmin, Hod, Admin)
• Setting up SMTP
• General settings
• Adding Holiday and Managing it
• Configuring Business Hours
• Assign Category and Business Hours to AgentAdmin & HOD
• Configuring SLA policies
• Setting Default Ticket Count for Agents and Auto Closing Ticket Hours
• Managing Cache
• Auto process of ticket Allocation, Notification, Overdue, Escalation, and Closing

About Platform Used

• Entire Application using Microsoft Visual Studio 2019 with SQL Server 2019.

• Framework used is .Net 7.0 and the language is C# and Dapper, Entity Framework Core as ORM and Repository Pattern.

Link to download VisualStudio

https://www.visualstudio.com/vs/older-downloads/

Link to download Microsoft SQL Server 2019

https://www.microsoft.com/en-us/sql-server/sql-server-downloads

NuGet Packages which are used in Project

• AutoMapper.Extensions.Microsoft.DependencyInjection
• DNTCaptcha.Core
• EPPlus Version
• Microsoft.AspNetCore.Mvc.NewtonsoftJson Version
• Microsoft.AspNetCore.Mvc.Razor.RuntimeCompilation Version
• Microsoft.EntityFrameworkCore Version
• Microsoft.EntityFrameworkCore.SqlServer Version
• Microsoft.VisualStudio.Web.CodeGeneration.Design Version
• NLog.Web.AspNetCore Version
• Dapper Version
• Microsoft.AspNetCore.Mvc.ViewFeatures Version
• Microsoft.Data.SqlClient Version
• Microsoft.EntityFrameworkCore Version
• Microsoft.EntityFrameworkCore.Relational Version
• System.Data.SqlClient Version
• System.Linq.Dynamic.Core Version
• X.PagedList.Mvc.Core

Design Template

• AdminLTE

Documentation

• Project Description Document

• SuperAdmin Document

• Agent Document

• AgentAdmin Document

• HOD Document

• User Document

How To Run this Project.

1. First of all Clone repository to your local machine.
2. Create an SQL database with the name VueTicketDatabase
3. Run the SQL Database script which you have received on request.
4. Configure Connection String in appsettings.json ("DatabaseConnection")
5. Run the Application
6. Configure SQL jobs for assigning Tickets which are shared with the database.

About the Author

Saineshwar Bageri

• Blogs
• Facebook Page
• Facebook
• Twitter
• Linkedin

License

Released under the MIT LICENSE

Database.

For the Database Please send the request. sendticket365[at]gmail[dot]com