Feedback Site

Application for a site that hosts feedbacks on any subjects, built using ASP.NET Core and React. Previews can be found at the bottom.

How to run?

The application uses ports 7000 (Client), 7001 (Backend, Https), 7002 (Backend, Http)

API

Follow the guide.

Build the solution using Visual Studio or .NET CLI.

First run adds some example data to the database.

Frontend

Navigate to Frontend.

run npm install.

run npm start.

API Guide

Prerequisite

1. Have .NET 6 and Visual Studio installed.

2. Have a Microsoft SQL Server installed. I used Microsoft SQL Server 2022 Express, which can be downloaded here.

3. Create a database called Feedbank in the SQL server and see that the connection string in appsettings.json is correct for you, in case you have set a custom name and/or login credentials for your SQL server, include them as well.

4. Update the database for this project with Entity Framework. You can run the included Powershell script to do this, note that you need to edit the connection string in the scripts as well to match your SQL server. Or you can run the commands yourself info on it can be found here.

Endpoints:

/Feedback

Returns the feedbacks from the database

You can use the parameters ?limit and ?offset to set the amount and starting point. By default, the limit is 25 and the offset is 0.

/Feedback/{id}

Returns the feedback with the specified ID.

Example of the data you'll receive:

{
  "id": 6,
  "created": "2023-12-20T00:53:21.8292779",
  "name": "Testinen",
  "email": "testi.testinen@testi.com",
  "subject": "testing",
  "score": 5,
  "message": "This is testi"
}

Posting new data:

New data can be added by POST to the /Feedback

Example of the data:

{
  "name": "Testinen",
  "email": "testi.testinen@testi.com",
  "score": 5,
  "message": "This is testi"
}

Deleting data:

by DELETE to the /Feedback/{id} which deletes the feedback with the specified id.

Frontend Guide

Prerequisite

Have Node.js installed.

Features

Website features a homepage where you can see how many feedbacks are currently in the database, from there you can navigate to add your own feedback.

Feedbacks page holds all the feedbacks and you can read through them.

Azure

How would I host this project in Azure?

Database can be pretty painlessly replaced with Azure SQL Database.

The API can be published to Azure API Management and Azure App Service.

The frontend can be deployed to Azure Static Web Apps.

Some adjustments are necessary for deploying the whole project to Azure, like URI's and ports for example.

Previews