/SillystringzFactory.Solution

Epicodus Independent Project, Week 11: Many to Many Relationships

Primary LanguageC#

Dr. Sillystringz & the Great Broken Factory

Let's not have any Staplerfahrer Klaus incidents this month, boys.

Technologies Used

  • C#
  • NuGet
  • .NET 5
  • ASP.NET Core
  • Entity Framework

Description

Well, you've never seen a factory like this before! Let me tell ya. This place is more fun than Mr. Wonka's famous chocolate factory!

Trouble is, everything's breaking all the time. So, this little web app—made with C# & Entity Framework—was designed to coordinate all the fixin' what needs doin' around here.

Just sign your engineers up, track which machines they're licensed to tinker around with, and kick your feet up on that big manager's desk of yours. Slurp some coffee, call your mama; we've got you covered.

Instructions

Technology Requirements

Setup/Installation

  • Clone this repository to an empty folder or to your desktop, or download and open the Zip on your local machine. Instructions for cloning can be found here.

  • Open the Factory folder in your preferred text editor. We'll come back to this shortly.

  • Set up your SQL database:

    • Create a new appsettings.json file in your Factory/Factory folder
    • Copy the following code into that file, replacing YOUR_PASSWORD with your MySql password:
    {
      "ConnectionStrings": {
          "DefaultConnection": "Server=localhost;Port=3306;database=melissa_schatzmiller;uid=root;pwd=YOUR_PASSWORD;"
      }
    }
  • Set up your SQL database, continued:

    • Open a new terminal and run mysql -uroot -p<YOUR_PASSWORD>
    • Open MySQL Workbench
    • Go to Navigator > Administration and select Data Import/Restore
    • In Import Options, select Import from Self-Contained File
    • Navigate to melissa_schatzmiller.sql
    • Under Default Schema to be Imported To, select New and enter melissa_schatzmiller as the name of the database. Click Ok!
    • Navigate to the Import Progress tab and click Start Import at the bottom right of the window
    • After finishing the steps above, reopen Navigator > Schemas. Right click and select Refresh All. The melissa_schatzmiller database should appear.
    • If you'd like to make use of the included database Migrations, simply run dotnet ef database update in your Factory/Factory folder
  • Return to Factory in your text editor

  • Restore and build the project:

    • Navigate to the Factory/Factory folder in the command line or terminal
      -- Run dotnet restore to restore the project dependencies
      -- Run dotnet build to build and compile the project
  • Use the Web App:

    • Navigate to the Factory/Factory folder in the terminal
    • Run dotnet run
    • If you would like to be able to continue viewing the site while making changes to its content, instead run dotnet watch run
    • Access http://localhost:5000/ in your browser to view & interact with the web app

Known Bugs

  • No known bugs at this time

License

GPL Copyright (c) 2021, Melissa Schatz-Miller

Contact Information

Melissa Schatz-Miller melissa.scmi@gmail.com
Please feel free to reach out to me with suggested changes/improvements, or if you have any questions.