This program will allow a user to track stylists working in a hair salon as well as their clients. The user can add stylists and their specialty to prevent clients from being added to multiple stylists.
Behavior | Example Input | Example Output |
---|---|---|
Will allow user to add a stylist or add a client to a stylist | User clicks to add a stylist | user taken to stylist input form |
User can add stylist to list of stylists | user inputs stylist name and specialty | stylist added to stylist list |
User can add client to a chosen stylist | user selects a stylist and adds client by name | client added to chosen stylist list |
User can view list of stylists with their specialties and list of clients | user selects stylist | stylist name and specialty are displayed with list of clients |
- Click here to download a .NET Core SDK from Microsoft Corp.
- Open the file (this will launch an installer which will walk you through installation steps. Use the default settings the installer suggests.)
- Click here to download the 64-bit .NET Core SDK from Microsoft Corp.
- Open the .exe file and follow the steps provided by the installer for your OS.
Enter the command dotnet tool install -g dotnet-script
in Terminal (macOS) or PowerShell (Windows).
Download the MySQL Community Server DMG File here. Follow along with the installer until you reach the configuration page. Once you've reached Configuration, set the following options (or user default if not specified):
- use legacy password encryption
- set password (and change the password field in appsettings.json file of this repository to match your password)
- click finish
- open Terminal and enter the command
echo 'export PATH="/usr/local/mysql/bin:$PATH"' >> ~/.bash_profile
if using Git Bash. - Verify MySQL installation by opening Terminal and entering the command
mysql -uroot -p{your password here, omitted brackets}
. If you gain access to the MySQL command line, installation is complete. An error (e.g., -bash: mysql: command not found) indicates something went wrong.
Download MySQL Workbench DMG file here. Install MySQL Workbench to Applications folder. Open MySQL Workbench and select Local instance 3306 server, then enter the password you set. If it connects, you're all set.
Download the MySQL Web Installer here and follow along with the installer. Click "Yes" if prompted to update, and accept license terms.
- Choose Custom setup type
- When prompted to Select Products and Features, choose the following: MySQL Server (Will be under MySQL Servers) and MySQL Workbench (Will be under Applications)
- Select Next, then Execute. Wait for download and installation (can take a few minutes)
- Advance through Configuration as follows:
- High Availability set to Standalone.
- Defaults are OK under Type and Networking.
- Authentication Method set to Use Legacy Authentication Method.
- Set password to epicodus. You can use your own if you want but epicodus will be assumed in the lessons.
- Unselect Configure MySQL Server as a Windows Service.
- Complete installation process
Add the MySQL environment variable to the System PATH. Instructions for Windows 10:
- Open the Control Panel and visit System > Advanced System Settings > Environment Variables...
- Select PATH..., click Edit..., then Add.
- Add the exact location of your MySQL installation and click OK. (This location is likely C:\Program Files\MySQL\MySQL Server 8.0\bin, but may differ depending on your specific installation.)
- Verify installation by opening Windows PowerShell and entering the command
mysql -uroot -p{your password here, omitted brackets}
. It's working correctly if you gain access to the MySQL command line. Exit MySQL by entering the commandexit
. - Open MySQL Workbench and select Local instance 3306 server (may be named differently). Enter the password you set, and if it connects, you're all set.
Enter the following commands in Terminal (macOS) or PowerShell (Windows):
cd desktop
git clone https://github.com/Pieharder/Eau-Claire-Salon.Solutions
cd Eau-Claire-Salon.Solutions
Confirm that you have navigated to the HairSalon.Solution directory (e.g., by entering the command pwd
in Terminal).
Recreate the geoff_goetz
database using the following MySQL commands (in Terminal on macOS or PowerShell on Windows):
-
CREATE DATABASE geoff_goetz;
-
USE geoff_goetz;
-
CREATE TABLE
stylists
(StylistId
int NOT NULL AUTO_INCREMENT,StylistName
varchar(255) DEFAULT NULL,StylistSpecialty
varchar(255) DEFAULT NULL, PRIMARY KEY (StylistId
)); -
CREATE TABLE
clients
(ClientId
int NOT NULL AUTO_INCREMENT,ClientName
varchar(255) DEFAULT NULL,StylistId
int DEFAULT '0', PRIMARY KEY (ClientId
));
Run this application by entering the following command in Terminal (macOS) or PowerShell (Windows):
cd HairSalon
dotnet restore
dotnet build
dotnet run
ordotnet watch run
To view/edit the source code of this application, open the contents of the HairSalon.Solution directory in a text editor or IDE of your choice (e.g., to open all contents of the directory in Visual Studio Code on macOS, enter the command code .
in Terminal).
- Git
- HTML
- CSS
- C#
- .NET Core 2.2
- ASP.NET Core MVC (version 2.2)
- Razor
- dotnet script
- MySQL 8.0 CE
- MySQL Workbench 8.0 CE
- Entity Framework Core 2.2
- Michelle Mornin README Template
This webpage is licensed under the MIT license.
Copyright (c) 2020 Geoff Goetz