Dr. Sillystringz's Factory - Machine Repairs

Web app that keeps track of repair engineers and machines that need to be maintained.

By Vanessa Su

Description

MVC pattern web app that is used to keep track of engineers and machines in a factory. Engineers have machines that they are qualified to repair, which is displayed on their details page. Machines will also display what engineers are qualified to repair them on their details page. This association is stored in a MySQL database, with a many-to-many relationship between the Engineer and Machine tables. Associations can be added or removed from the machine pages or the engineer pages.

User Story

See a splash page listing all engineers and machines
Click on an engineer or machine to see its details
For engineers, see a list of machines they are certified to repair
For machines, see a lit of engineers certified to repair them
Add new machines/engineers without needing to associate them with a machine/engineer
Add and remove machines/engineers from specific machines/engineers

Technologies Used

C#
ASP.NET Core
Razor
Entity Framework Core
MySQL
VS Code

Setup/Installation Requirements

Prerequisites

MySQL
.NET
A text editor like VS Code

Installation

Clone the repository: git clone https://github.com/vnessa-su/Factory.Solution.git
Navigate to the /Factory.Solution directory
Open with your preferred text editor to view the code base

Database Setup

Navigate to the /Factory directory
Create appsettings.json file: touch appsettings.json
Open appsettings.json in a text editor and add in:

{
  "ConnectionStrings": {
      "DefaultConnection": "Server=localhost;Port=<port number>;Database=vanessa_su;Uid=root;Pwd=<password>;"
  }
}

Replace <port number> with the port number the server is running on, default is usually 3306
Replace <password> with your MySQL password

Save the file and go back to the terminal
Run dotnet ef database update

Run the Program

Navigate to the /Factory directory
Run dotnet restore
Run dotnet build
Start the program with dotnet run
Open http://localhost:5000/ in your preferred browser

Known Bugs

No known bugs

Contact Information

For any questions or comments, please reach out through GitHub.

License

MIT License

vnessa-su/Factory.Solution