ellajtanttu/Food.Solution

Pierre's Treat Tracker

By Ella Tanttu

An mvc application that allows the user to track treat and flavor relationships using authentication with identity

Technologies Used

• HTML
• C#
• .Net5
• ASP.Net Core MVC
• ASP.Net Identity
• Razor View Engine
• CSS
• Markdown
• Bootstrap
• HtmlHelper
• SQL
• MySQL
• EntityFrameworkCore

Description

Application that allows baker entrepreneur Pierre owner to keep track of treats and flavors in his bakery. Practice with many to many relationships and authentication with identity. Add, delete, edit, and otherwise control both treats and flavors, and which are connected to which.

Setup/Installation Requirements

Package Installations:

1. Download .NET 5 here
2. You can find the Treat.Solution github repository here
3. Click the green code button, and copy the https link
4. In your preferred git terminal navigate to the directory you would like to store the project
5. Enter: "git clone" followed by the copied https link
6. Now that the repository is cloned to your computer, right click on the folder and click open with vs code
7. Once in the project, navigate to the Food directory within the terminal
8. Add the following packages in terminal:
   • dotnet add package Microsoft.EntityFrameworkCore -v 5.0.0
   • dotnet add package Pomelo.EntityFrameworkCore.MySql -v 5.0.0-alpha.2
   • dotnet add package Microsoft.EntityFrameworkCore.Proxies -v 5.0.0
   • dotnet add package Microsoft.AspNetCore.Identity.EntityFrameworkCore -v 5.0.0
   • dotnet tool install --global dotnet-ef --version 3.0.0

Database Setup & Running the Application:

1. In terminal, navigate to the Food directory
2. Type dotnet restore to install dependencies
3. Type dotnet build to build project
4. In order to initalize a database you will need to create an appsettings.json file that looks like this*

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

*NOTE: change {YOUR X} with corresponding information

5. Once you have the appsettings.json file— to create a database, type: dotnet ef migrations add initial
6. To update the database in MySQL type: dotnet ef database update
7. Initialize localhost:3306 in MySQL Workbench (download here)
8. At this point you will now be able to view the project by typing dotnet run in the terminal

Known Bugs

No known issues

License

MIT Copyright (c) 2021 Ella Tanttu https://opensource.org/licenses/MIT

Contact Information

Ella Tanttu ellajtanttu@gmail.com