A C# application that is connected to a SQL database with tables for Stylists and Clients. Users can add to the Client lists for each individual Stylist. Any time a Client is added, it must be associated with a Stylist. Stylist table includes details such as name, address, phone number and Client list.
- Clone this repository: $ git clone https://github.com/kwolfenb/HairSalon.Solution.git
- To edit the project, open the project in your preferred text editor.
- To create related database, open MySql from terminal. Enter the following commands:
- CREATE DATABASE hair_salon;
- USE hair_salon;
- CREATE TABLE stylists (id serial PRIMARY KEY, name VARCHAR(255), phone VARCHAR(20), picture VARCHAR(255));
- CREATE TABLE clients (id serial PRIMARY KEY, name VARCHAR(255), stylist_id INT, phone VARCHAR(20), notes TEXT);
- CREATE TABLE specialties (id serial PRIMARY KEY, description VARCHAR(255));
- CREATE TABLE stylists_specialties (id serial PRIMARY KEY, stylist_id INT, specialty_id INT);
- To run the program, first navigate to the location of the HairSalon file then run dotnet restore, dotnet build, and dotnet run.
- When program is running open a web browser and go to localhost:5000 to view program.
- To run the tests navigate to the Yelp.Tests folder and use these commands: $ dotnet restore and dotnet test.
Kenny Wolfenberger - kennywolfenberger@gmail.com
Spec |
---|
Program can take new user input for new Stylist |
Program can take new user input for new Clients |
New clients will be linked to stylist table in a one-to-many relationship |
Users can delete individual clients |
Users can make updates to existing Stylists |
Users can make updates to existing Clients |
Users can see list of all clients |
Users can see list of all stylists |
Users can see list of all specialties |
Users can see list of clients by specific stylists |
Users can view detailed information for specific stylists |
Users can view detailed information for specific clients |
Users can view stylists by specialties |
Users can delete ALL clients |
Users can delete ALL stylists |
- C#
- .NET
- MSTests
- MVC
- Razor
- Mono
- SQL
- PhpMyAdmin
This software is licensed under the MIT license.
Copyright (c) 2018 Kenny Wolfenberger