marnionrails/FactoryTracker.Solution

Dr. Sillystringz's Factory

By Marni Sucher

An application to keep track of engineers and machines at Dr. Sillystringz's factory.

Technologies Used

• C#
• .NET 5.0
• dotnet
• MySql/Workbench

Description

An application to keep track of machine repairs at Dr. Sillystringz's factory. The application is capable of the following:

• Add engineers and machines to the system.
• Add and remove machines to specific engineers that they are licensed to the repair.
• Add or remove engineers from a specific machine that are licenced to repair it.

Setup/Installation Requirements

• Make sure you have MySql Workbench installed on your computer.
• Make sure to have dotnet-ef installed too.
  This project uses dotnet-ef --version 3.0.0 which I have globally installed but you can install it however you want.
• Download repo to your computer using either clone or the download link: https://github.com/marnionrails/FactoryTracker.Solution
• Open the project in VScode or your terminal/IDE of choice.
• Create a appsettings.json file in the root directory of the project folder. And add the following code replacing anything in square brackets with the information it represents specific to the project database:

{
  "ConnectionStrings": {
    "DefaultConnection": "Server=localhost;Port=3306;database=[DATABASE-NAME-HERE];uid=[USER-ID-HERE];pwd=[YOUR-PASSWORD-HERE];"
  }
}

Example of complete appsettings.json:

{
  "ConnectionStrings": {
    "DefaultConnection": "Server=localhost;Port=3306;database=to_do_list;uid=root;pwd=MySuperStrongPassword;"
  }
}

• Make sure to run your mysql server and open MySql workbench.
• Open MySql Workbench and login to your server.
• Click on the Administration tab in the Navigator on the left side of the screen. (this tab will likely be on the bottom of the window)
• In the management section of this administration tab click on the button called Data Import/Export.
• Once the data import window opens click on Import from Self-Contained file radio button, navigate into the project folder and select marni_sucher.sql using the file path next to that radio button.
• Now click on the New... button in the section marked "Default Schema to be Imported To" directly underneath the import options section.
• Click on the "Import Progress" tab at the top of the Data import window.
• At the bottom of this tab click the button that reads Start Import.
• Confirm the database has been imported and you can check it by clicking the "Schemas" tab on the navigator at the left side of the program. Right click in the white space and select "Refresh All"
• Now using your IDE navigate into FactoryTracker.Solution/Factory folder and use the command dotnet run to launch the program.
• The site should be available at the server address you used in the appsettings.json folder.

Known Bugs

• No known bugs

Contact Me

Please email me if you run into any issues or have any ideas. suchermarni@gmail.com

License

MIT

Copyright (c) 2022_Marni Sucher