HairSalon.Solution: A C# repository from jaredh123


jaredh123

HairSalon.Solution

Epicodus independent project: HairSalon.Solution parts 1 and 2, created March 1st, 2019

By Jared Hanson

Description

A hair salon database that allows the additions and deletions of stylists, clients, and specialties using C# and MySql.

Known Bugs

No known bugs.

Specifications

Have the database properly saved and the website running. The user is then allowed to click the available buttons and hyperlinks to access and fill in information on the stylists, clients, specialties, and the relationships between these aspects. All pages have a link back to the main home page.

Behavior	Input	Output
User clicks "View/add stylists and add clients" link.	Click	Page redirect to stylist page to add or clear stylists.
User can then also access and edit stylist info, create clients, or add specialties.	Click/type	stylist info and/or clients, and/or specialties were accessed, created, or edited.
User clicks "View clients" link.	Click	Page redirect to client page to show or clear clients.
User clicks client name if present.	Click	Page redirect to client info page to show info, add stylist, edit client info, or delete client.
User clicks "View specialties" link.	Click	Page redirect to specialties page to show specialties, add specialties, or clear all specialties.
User clicks specialty if present.	Click	Page redirects to page to show stylists that have this specialty, to add stylists to specialty, and to delete specialty.

Setup and Use

Software Requirements: Download .NET Core 1.1.4 SDK and .NET Core Runtime 1.1.2 and install them. Download Mono and install it. Download MAMP and install it.

Clone this repository repo: "$ git clone https://github.com/jaredh123/HairSalon.Solution "
To edit the project, open the project in your preferred text editor.
Open MAMP (make sure Apache port is 8888 & MySql port is 8889) and start both the Apache serve and the MySql server.
!Database must be created first to use webpage!
In the Command Prompt or Terminal use the command "mysql -uroot -proot"
Use the following SQL commands in MySql to create database:
"CREATE DATABASE hair_salon;"
"USE hair_salon;"
"CREATE TABLE stylists (id serial PRIMARY KEY, name VARCHAR(255));"
"CREATE TABLE clients (id serial PRIMARY KEY, name VARCHAR(255)), stylist_id INT;"
CREATE TABLE specialities (id serial PRIMARY KEY, name VARCHAR(255));
CREATE TABLE specialities_stylists (id serial PRIMARY KEY, speciality_id INT, stylist_id INT;
"CREATE DATABASE hair_salon_test;"
"USE hair_salon_test;"
"CREATE TABLE stylists (id serial PRIMARY KEY, name VARCHAR(255));"
"CREATE TABLE clients (id serial PRIMARY KEY, name VARCHAR(255)), stylist_id INT;"
CREATE TABLE specialities (id serial PRIMARY KEY, name VARCHAR(255));
CREATE TABLE specialities_stylists (id serial PRIMARY KEY, speciality_id INT, stylist_id INT;
To run the program, in terminal first navigate to the location of the the HairSalon and HairSalon.Tests directories at the top levels and execute: "$ dotnet restore" in both directories.
Open MAMP.
Go to "http://localhost:8888/phpMyAdmin/server_import.php"
Choose the files named jared_hanson.sql and jared_hanson_test.sql and import them.
Then navigate to the HairSalon directory and execute commands: "$ dotnet build" and "$ dotnet run".
Then go to "http://localhost:5000" to view webpage.

Prerequisites

Must have a working browser, IDE, and terminal.
Must have basic computer use proficiency

Built With

Atom (IDE)
C#
.NET
Git
MAMP
MySql
MyPHPAdmin

Contributors

Author	GitHub	Email
Jared Hanson	jaredh123	jared.hanson12345@gmail.com

Support and contact details

If you have any feedback or concerns, please contact me at jared.hanson12345@gmail.com.

jaredh123/HairSalon.Solution