Pierre's Sweet and Savory Treats

C# ASP.NET Core MVC, Entity Core and Identity practice for Epicodus, 08.14.2020

By Brittany Lindgren

Description

Authenticated users can keep track of their favorite treats from Pierre's bakery, view, add, edit and delete their treats list while unauthenticated users can view all of the delicious treats Pierre's Bakery has to offer.

Specifications

Behavior	Input	Output	Met? (Y/N)
x	x	x	x

User Stories

• A user should be able to navigate to a splash page that lists all treats and flavors. Users should be able to click on an individual treat or flavor to see all the treats/flavors that belong to it.
• A user should be able to log in and log out. Only logged in users should have create, update and delete functionality. All users should be able to have read functionality.

Stretch Goals

Behavior	Input	Output	Met? (Y/N)

• Have separate roles for admins and logged-in users. Only admins should be able to add, update and delete.
• Add an order form that only logged-in users can access. A logged-in user should be able to create, read, update and delete their own order.

Setup/Installation Requirements

1. Follow this link to the project repository on GitHub.
2. Click on the "Clone or download" button to copy the project link.
3. If you are comfortable with the command line, you can copy the project link and clone it through your command line with the command git clone. Otherwise, I recommend choosing "Download ZIP".
4. Once the ZIP file has finished downloading, you can right click on the file to view the zip folder in your downloads.
5. Right click on the project ZIP folder that you have just downloaded and choose the option "Copy To...", then choose the location where you would like to save this folder.
6. Navigate to the final location where you have chosen to save the project folder.
7. To view the code itself, right click, choose open with... and open using a text editor such as VS Code or Atom, etc.
8. Once you are inside of your text editor, open the terminal. If you are in VS Code for example, this can be done by clicking on Terminal at the top of the editor and then selecting New Terminal. **You can navigate to different directories in the project by typing cd DirectoryName to go down into specific directories or cd .. to go back up one directory.
9. Navigate to the Bakery directory by typing cd Bakery in your terminal and hitting enter. Then type the command dotnet restore,dotnet build, then dotnet run into your terminal and hit enter. You should see files appear inside of your bin folder. The bin folder should appear greyed out.
10. Click on the link provided after you see now listening on: ... appear in your terminal.

Additional Setup/Installation Notes:

• You will need to configure the MySQL Workbench database in order to run this project. See directions below.
• Do not alter the bin/ or obj/ directories or any of the files in them.

Configure the MySQL Workbench Database:

• Install MySQL and MySQL Workbench first. During installation of MySQL you will be asked to create a password. This is important! Take note of your password. Once you have installed MySQL and MySQL Workbenck, start MySQL by entering mysql -uroot -p+_yourpassword_ in the terminal. Example: password is tomato, enter mysql -uroot ptomato. If this doesn't work in your terminal, try using your computer's command line interface application. If you are successful, you will see a message in the terminal, ending with the line mysql>. Once you have succesfully completed these steps, follow the instructions below.
• Open MySQL Workbench and double click on the grey box under the line MySQL Connections (this box should say mamp and have some text and numbers ending in :3306). This will launch the MySQL Workbench. You may be prompted to enter the same password that you used in the previous step (ex: tomato).

Import Database to MySQL Workbench

To set up the database for this project, you can follow the steps below to import it into MySQL Workbench.

• Open the Navigator, click on the Administration tab
• Select Data Import/Restore
• Select the option to Import from Self-Contained File
• To the right, click on the ... box to select the database file from this project (the file in the root directory ending in .sql)
• Below the items from the last step, you'll see Default Schema to be Imported To, select New...
• Enter the name of the database, in this case database_name
• Select the Import Progress tab and click on the Start Import button.
• Return to the Navigator window. Anywhere in that area, right click and select refresh
• Your database should appear in the navigator window.

Create a New Schema Query:

• You should see an icon in the upper left that looks like a little piece of paper with the letters SQL and a + sign. Hover over the icon and confirm that this is the 'create a new SQL tab for executing queries' icon. Once confirmed, double click the icon.
• Copy paste the code below into the Query tab.
• Then click 'execute' (this may appear as a lightening bolt icon).

NOTE database is listed in appsettings.json as brittany_lindgren_uniqueidentifier to avoid overwriting author's other databases. If you experience any issues, check to make sure that all references to database in project match name of MySQL Workbench Schema.

SQL SCHEMA QUERY

CREATE DATABASE IF NOT EXISTS brittany_lindgren_bakery; USE brittany_lindgren_bakery;
DROP TABLE IF EXISTS `__efmigrationshistory`;

DROP TABLE IF EXISTS `__efmigrationshistory`;
CREATE TABLE `__efmigrationshistory` (
  `MigrationId` varchar(95) NOT NULL,
  `ProductVersion` varchar(32) NOT NULL,
  PRIMARY KEY (`MigrationId`)
)

DROP TABLE IF EXISTS `applicationusertreat`;
CREATE TABLE `applicationusertreat` (
  `ApplicationUserTreatId` int NOT NULL AUTO_INCREMENT,
  `TreatId` int NOT NULL,
  `ApplicationUserId` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`ApplicationUserTreatId`),
  KEY `IX_ApplicationUserTreat_ApplicationUserId` (`ApplicationUserId`),
  KEY `IX_ApplicationUserTreat_TreatId` (`TreatId`),
  CONSTRAINT `FK_ApplicationUserTreat_AspNetUsers_ApplicationUserId` FOREIGN KEY (`ApplicationUserId`) REFERENCES `aspnetusers` (`Id`) ON DELETE RESTRICT,
  CONSTRAINT `FK_ApplicationUserTreat_Treats_TreatId` FOREIGN KEY (`TreatId`) REFERENCES `treats` (`TreatId`) ON DELETE CASCADE
)

DROP TABLE IF EXISTS `aspnetroleclaims`;
CREATE TABLE `aspnetroleclaims` (
  `Id` int NOT NULL AUTO_INCREMENT,
  `RoleId` varchar(255) NOT NULL,
  `ClaimType` longtext,
  `ClaimValue` longtext,
  PRIMARY KEY (`Id`),
  KEY `IX_AspNetRoleClaims_RoleId` (`RoleId`),
  CONSTRAINT `FK_AspNetRoleClaims_AspNetRoles_RoleId` FOREIGN KEY (`RoleId`) REFERENCES `aspnetroles` (`Id`) ON DELETE CASCADE
)

DROP TABLE IF EXISTS `aspnetroles`;
CREATE TABLE `aspnetroles` (
  `Id` varchar(255) NOT NULL,
  `Name` varchar(256) DEFAULT NULL,
  `NormalizedName` varchar(256) DEFAULT NULL,
  `ConcurrencyStamp` longtext,
  PRIMARY KEY (`Id`),
  UNIQUE KEY `RoleNameIndex` (`NormalizedName`)
)

DROP TABLE IF EXISTS `aspnetuserclaims`;
CREATE TABLE `aspnetuserclaims` (
  `Id` int NOT NULL AUTO_INCREMENT,
  `UserId` varchar(255) NOT NULL,
  `ClaimType` longtext,
  `ClaimValue` longtext,
  PRIMARY KEY (`Id`),
  KEY `IX_AspNetUserClaims_UserId` (`UserId`),
  CONSTRAINT `FK_AspNetUserClaims_AspNetUsers_UserId` FOREIGN KEY (`UserId`) REFERENCES `aspnetusers` (`Id`) ON DELETE CASCADE
)

DROP TABLE IF EXISTS `aspnetuserlogins`;
CREATE TABLE `aspnetuserlogins` (
  `LoginProvider` varchar(255) NOT NULL,
  `ProviderKey` varchar(255) NOT NULL,
  `ProviderDisplayName` longtext,
  `UserId` varchar(255) NOT NULL,
  PRIMARY KEY (`LoginProvider`,`ProviderKey`),
  KEY `IX_AspNetUserLogins_UserId` (`UserId`),
  CONSTRAINT `FK_AspNetUserLogins_AspNetUsers_UserId` FOREIGN KEY (`UserId`) REFERENCES `aspnetusers` (`Id`) ON DELETE CASCADE
)

DROP TABLE IF EXISTS `aspnetuserroles`;
CREATE TABLE `aspnetuserroles` (
  `UserId` varchar(255) NOT NULL,
  `RoleId` varchar(255) NOT NULL,
  PRIMARY KEY (`UserId`,`RoleId`),
  KEY `IX_AspNetUserRoles_RoleId` (`RoleId`),
  CONSTRAINT `FK_AspNetUserRoles_AspNetRoles_RoleId` FOREIGN KEY (`RoleId`) REFERENCES `aspnetroles` (`Id`) ON DELETE CASCADE,
  CONSTRAINT `FK_AspNetUserRoles_AspNetUsers_UserId` FOREIGN KEY (`UserId`) REFERENCES `aspnetusers` (`Id`) ON DELETE CASCADE
)

DROP TABLE IF EXISTS `aspnetusers`;
CREATE TABLE `aspnetusers` (
  `Id` varchar(255) NOT NULL,
  `UserName` varchar(256) DEFAULT NULL,
  `NormalizedUserName` varchar(256) DEFAULT NULL,
  `Email` varchar(256) DEFAULT NULL,
  `NormalizedEmail` varchar(256) DEFAULT NULL,
  `EmailConfirmed` bit(1) NOT NULL,
  `PasswordHash` longtext,
  `SecurityStamp` longtext,
  `ConcurrencyStamp` longtext,
  `PhoneNumber` longtext,
  `PhoneNumberConfirmed` bit(1) NOT NULL,
  `TwoFactorEnabled` bit(1) NOT NULL,
  `LockoutEnd` datetime(6) DEFAULT NULL,
  `LockoutEnabled` bit(1) NOT NULL,
  `AccessFailedCount` int NOT NULL,
  `FirstName` longtext,
  `LastName` longtext,
  `UserRole` longtext,
  PRIMARY KEY (`Id`),
  UNIQUE KEY `UserNameIndex` (`NormalizedUserName`),
  KEY `EmailIndex` (`NormalizedEmail`)
)

DROP TABLE IF EXISTS `aspnetusertokens`;
CREATE TABLE `aspnetusertokens` (
  `UserId` varchar(255) NOT NULL,
  `LoginProvider` varchar(255) NOT NULL,
  `Name` varchar(255) NOT NULL,
  `Value` longtext,
  PRIMARY KEY (`UserId`,`LoginProvider`,`Name`),
  CONSTRAINT `FK_AspNetUserTokens_AspNetUsers_UserId` FOREIGN KEY (`UserId`) REFERENCES `aspnetusers` (`Id`) ON DELETE CASCADE
)

DROP TABLE IF EXISTS `flavors`;
CREATE TABLE `flavors` (
  `FlavorId` int NOT NULL AUTO_INCREMENT,
  `Type` longtext,
  PRIMARY KEY (`FlavorId`)
)

DROP TABLE IF EXISTS `flavortreat`;
CREATE TABLE `flavortreat` (
  `FlavorTreatId` int NOT NULL AUTO_INCREMENT,
  `FlavorId` int NOT NULL,
  `TreatId` int NOT NULL,
  PRIMARY KEY (`FlavorTreatId`),
  KEY `IX_FlavorTreat_FlavorId` (`FlavorId`),
  KEY `IX_FlavorTreat_TreatId` (`TreatId`),
  CONSTRAINT `FK_FlavorTreat_Flavors_FlavorId` FOREIGN KEY (`FlavorId`) REFERENCES `flavors` (`FlavorId`) ON DELETE CASCADE,
  CONSTRAINT `FK_FlavorTreat_Treats_TreatId` FOREIGN KEY (`TreatId`) REFERENCES `treats` (`TreatId`) ON DELETE CASCADE
)

DROP TABLE IF EXISTS `treats`;
CREATE TABLE `treats` (
  `TreatId` int NOT NULL AUTO_INCREMENT,
  `Type` longtext,
  `ApplicationUserId` varchar(255) DEFAULT NULL,
  `Description` longtext,
  PRIMARY KEY (`TreatId`),
  KEY `IX_Treats_ApplicationUserId` (`ApplicationUserId`),
  CONSTRAINT `FK_Treats_AspNetUsers_ApplicationUserId` FOREIGN KEY (`ApplicationUserId`) REFERENCES `aspnetusers` (`Id`) ON DELETE RESTRICT
)

Code First with Migrations

You can also populate the Database from the VS Code terminal using Migrations.

• Enter the following into the VS Code terminal dotnet ef migrations add Initial and hit Enter
• Now enter dotnet ef database update and hit Enter

Anytime you make a change to a Model that affects the database, run the dotnet commands

1. dotnet ef migrations add NameExpressingWhatYouAdded
2. dotnet ef database update

Run the Application

• After you have completed setup and installation and configured the database, you can type the command dotnet run into your terminal.
• Once you see the message now listening on: ... appear in your terminal, open your browser and type localhost:5000 as the url. This should direct you to the main page of this project.

Known Bugs

Bug : Message	Situation	Resolved (Y/N)	How was the issue resolved?
Register page, fill in information, hit register, password disappears, but page does not redirect	Attempting to Register or Log In	Yes and No	Issue only occurs if A) attempting to register with information that has been used for a different account or B) if entering the wrong information when attempting to Log In - need error message that indicates to user why register or login has failed
DbUpdateConcurrencyException: Database operation expected to affect 1 row(s) but actually affected 0 row(s). Data may have been modified or deleted since entities were loaded.	When clicking Edit button	Y	Add @Html.HiddenFor(model => model.TreatId) to View/Treats/Edit.cshtml form

Support and contact details

Please feel free to contact the authors through GitHub (LINDGRENBA) with any feedback, questions or concerns.

Technologies Used

• Entity Framework Core
• ASP.NET Core Identity
• ASP.NET Core MVC
• .NET Core 2.2
• Identity Authentication
• MySQL & MySQL Workbench
• C#
• Razor
• Visual Studio Code
• Git Version Control
• GitHub

License

This site is licensed under the MIT license.

Copyright (c) 2020 {Brittany Lindgren}