Hair Salon

Week 3 C# ASP.NET Core MVC Independent Project at Epicodus, 12.7.2018

Created By

• Tanvi Garg

Description

• The owner(user) should be able to add a list of the stylists, and for each stylist, add clients who see that stylist. The stylists work independently, so each client only belongs to a single stylist.

Specs

• Salon employee should be able to see a list of all the stylists.
• Salon employee should be able to select a stylist, see their details, and see a list of all clients that belong to that stylist.
• Salon employee should be able add new stylists to the system when they are hired.
• Salon employee should be able to add new clients to a specific stylist.
• Salon employee should not be able to add a client if no stylists have been added.

Specs For Optional Functionality

• Salon employee should be able to delete individual stylists.
• Salon employee should be able to delete individual clients.

Database Setup using SQL commands

• Production Database: tanvi_garg.sql

• Test Database: tanvi_garg_test.sql

• Tables in Database: stylists (columns: id, name) and clients (id, name, phone, stylist_id(foreign key))

• Relationship: One To Many

• From Terminal Command Line, Enter MySQL using localhost -uroot -proot and run following commands to setup the Database and its tables

• CREATE DATABASE tanvi_garg;

• USE tanvi_garg;

• SELECT DATABASE();

• CREATE TABLE stylists (id serial PRIMARY KEY, name VARCHAR (255));

• CREATE TABLE clients (id serial PRIMARY KEY, name VARCHAR (255), phone VARCHAR (255), stylist_id INT);

• SHOW TABLES;

• 

Setup on Mac OSX

1. Download and install .Net Core 1.1.4
2. Download and install Mono
3. Download and install MAMP 4.5
4. Go to GitHub profile and clone the repo from TanviCodeLife. Use git clone <project url> command to pull it to a local repository in your Home directory.
5. Open MAMP and start the Apache and MySql servers
6. Navigate to MAMP > Tools > phpMyAdmin and import the tanvi_garg.sql file to create the database
7. Navigate to MAMP > Tools > phpMyAdmin and import the tanvi_garg_test.sql file to create the test database
8. Run dotnet restore from Main Project Folder (HairSalon) and Test Directory (HairSalon.Tests) to install packages
9. Run dotnet build from Main Project Folder and make sure no build errors appear. Run dotnet restore after build is complete.
10. Run dotnet restore to compile tests and then dotnet test from the Test Directory to run the testing suite. All tests should pass.
11. Run dotnet run from Main Project Folder to start the server
12. Wait till you see this message display in you bash terminal - "Now listening on: http://localhost:xxxx"
13. Copy the local host link http://localhost:xxx and paste it into your web browser address bar.
14. Browse through the project.

Technologies Used

• .Net Core 1.1.4
• MAMP 4.5 (phpMyAdmin)
• MySQL
• Bootstrap 3.3.7
• JavaScript
• jQuery 3.3.1

License

This software is licensed under the MIT license.

Copyright (c) 2018 Tanvi Garg