What is VueTicket?

The VueTicket is an Ticketing Application for small companies which are into customer support.

Technologies Used

• ASP.NET Core 5.0

• Entity Framework Core 5.0.9

Give a Star ⭐️

If you find project really helpful in Quick Learning do give it a star.

Support If Possible

⭐️ New Features ⭐️

Features

• Multilingual application
• Login
• Create User
• Create Ticket
• Dashboard with Status Counts
• View All Tickets
• Ticket History
• Knowledgebase
• Delete & Restore Ticket
• Replying on Ticket
• Reports
• Escalation
• Notification
• Masters
• View All Roles
• Managing Menu Category,Menu,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,Closing

About Platform Used

• Entire Application using Microsoft visual studio 2019 with SQL Server 2019.

• Framwork used is .Net 5.0 and 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 SQL database with name VueTicketDatabase
3. Run SQL Database script which you have Received on request.
4. Configure Connection String in appsettings.json ("DatabaseConnection")
5. Run Application
6. Configure SQL jobs for assiging Tickets which are shared with database.

About the Author

Saineshwar Bageri

• Blogs
• Facebook Page
• Facebook
• Twitter
• Linkedin

License

Released under the MIT LICENSE

Database.

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