Claires Stylist/Client Tracker

A Brief Description.

Un outil pour Madame Claire pour voir les clients de chacun de ses stylistes.

An MVC 'one-to-many' example project that allows Claire to track her stylists and their clients.

By Giancarlo Vigneri

---

Technologies Used

• VS Code
• Html
• CSS
• C#
• .NET 5 SDK
• ASP.NET
• Bootstrap

---

Description

The program will allow someone named Claire who owns a salon to see a list of their stylists and their specialities as well as a list of clients associated with said stylist. Claires can also add/delete new/old stylists. Clients also have similar functionality as well as being associated with a particular stylist.

---

Installation Requirements/Setup

Requirements:

• MySQL Community Server
• MySQL Workbench
• .NET 5 SDK
• A text editor like VS Code
• A command line interface like Terminal or GitBash to run and interact with the console app.

Further Setup:

To setup the MySQL database:

• Carefully follow these steps from LearnHowToProgram.com to install both MySQL Server 8.0.19 and MySQL Workbench.
• Ensure the MySQL server is running by opening Terminal or Windows Powershell and entering the command mysql -uroot -pepicodus
• If you set up MySQL Server with a different username and/or password, the command will be mysql -u[YourUsername] -p[YourPassword] (omit the square brackets'[ ]')

Importing giancarlo_vigneri.sql (the included database .sql file):

(note: these instructions are only applicable after one has cloned the git repository: "https://github.com/Bobloblawlobslawbomb/HairSalon.Solution" -- see 'Running the Program' instructions below)

1. Open MySQL Workbench.
2. In the Navigator > Administration window, select Data Import/Restore.
3. In Import Options select Import from Self-Contained File.
4. Navigate to giancarlo_vigneri.sql.
5. Under Default Schema to be Imported To, select the New button.
6. Enter the name of the database.
   • In this case: hair_salon.
7. Click Ok.
8. Click Start Import.
9. Reopen the Navigator > Schemas tab. Right click and select Refresh All. Our new test database will appear.

Running the Program:

1. Clone the repository: "https://github.com/Bobloblawlobslawbomb/HairSalon.Solution"
2. Navigate to the 'HairSalon.Solution/' directory on your computer
3. Open with your favorite text editor (Visual Studio Code, is a pretty sweet one)
4. To run the web app:

• Navigate to HairSalon.Solution/HairSalon in your command line
• Run the command touch appsettings.json - open the newly created "appsettings.json" file - add the following code to the .json file:

{
    "ConnectionStrings": {
    "DefaultConnection": "Server=localhost;Port=3306;database=>> hair_salon;uid=[YOUR USERNAME];pwd=[YOUR PASSWORD];"
    }
 }

*NOTE: make sure that [YOUR USERNAME] and [YOUR PASSWORD] match the database username and password of your local MySQL server (omit the square brackets. Also note: port 3306 is the default)

• Run the command dotnet restore to restore the dependencies that are listed in HairSalon.csproj
• Run the command dotnet build to build the project and its dependencies into a set of binaries.
• Finally, run the command dotnet run to run the project!
• Note: dotnet run also restores and builds the project, so you can use this single command to start the console app.

Known Bugs

• Background image does not display via css styling

Background Image

Photo by: Guilherme Petri Via: Unsplash

---

License [GPL] (https://choosealicense.com/licenses/gpl-3.0/)

if you do run into any issues or have questions, ideas, or concerns; I would greatly encourage you to send feedback or make a contribution to the code

---

Contact Information

Contact Giancarlo Vigneri at: bobloblaw.vigneri@gmail.com

(What do you call a good hair stylist? A shear delight.)