Setup & Installation

Download the Project:
- Obtain the project files by downloading them from https://auratheme.gumroad.com/l/solvi-ticket-helpdesk-asp-net-mvc.
Extract Files:
- Unzip the downloaded file to your desired location.
Open the Project:
- Open the solution file (Solvi.sln) with Visual Studio 2022.

Setup and Run the Project

Step 1: Configure the Database Connection and OpenAI API key

Open the appsettings.json file.
Locate the DefaultConnection key under the ConnectionStrings section.

Replace the placeholder value with your actual database connection string. For example:

"ConnectionStrings": {
    "DefaultConnection": "Server=YourServerName;Database=YourDatabaseName;User Id=YourUsername;Password=YourPassword;"
}

How to get the connection string? You may watch this video: https://youtu.be/WjLV5ccuzaU?si=3adrNcKEMdlj0-oP&t=172. Start from 2.52 to 3.48.
Follow this video to create your OpenAI API key. Once you have copied your API key, go to appsettings.json and paste the API key to replace PasteYourOpenAIAPIKeyHere for OpenAiApiKey

Step 2: Apply Database Migrations

Open the Package Manager Console in Visual Studio:
- Go to Tools > NuGet Package Manager > Package Manager Console.
Run the following command to apply the existing migration and create the database:
```
Update-Database
```
Once the command completes, the database will be created with the necessary tables and structure.

Step 3: Run the Application

Press Ctrl+F5 or click Debug > Start without debugging in Visual Studio
Done! The application is running now.

Register the First Account

Click on the Register icon located in the top-right corner of the page.
Fill out the registration form to create the first account.
- Note: The first registered account is automatically assigned the Admin role. It is assumed that the first user is the system administrator.
Log in using the newly created admin account.
Navigate to General Settings from the sidebar menu.
Configure the system by providing the following information:
- SMTP Information for email notifications. Video: How to get SMTP information?
- Time Zone to match your organization’s location.
- Portal Name for branding purposes.
- Logo to personalize the portal.
Save the settings to complete the initial system setup.
Navigate to Chatbot Default, change the default questions.
Navigate to Chatbot Setting, change the chatbot avatar.

Common issue: Warning icons on Dependencies > Packages

Here are some steps you can take to troubleshoot this issue:

Restore NuGet Packages:
- Open solution with Visual Studio 2022. Right-click on the solution and click "Restore NuGet Packages".
Clear the NuGet Cache:
- Sometimes, clearing the cache helps resolve dependency issues. Go to Tools > NuGet Package Manager > Package Manager Settings > Clear All NuGet Storage.
Check .NET SDK and Runtime Version:
- Ensure that you have the correct .NET SDK and runtime versions installed that the project requires. Make sure you have the .NET 8 SDK installed, you can search “download .net8.0” from google
Reinstall Dependencies:
- Sometimes, deleting and reinstalling dependencies can help. Delete the obj and bin folders in the project directory and try to rebuild the project.

Lastly, right-click on the solution and click "Clean Solution". Then, click "Rebuild Solution".

Try these steps and see if they resolve the issue. Let me know if the problem persists after attempting these solutions. I’d be happy to assist further. Thank you!