Skip to content

Latest commit

 

History

History
121 lines (85 loc) · 3.68 KB

README.md

File metadata and controls

121 lines (85 loc) · 3.68 KB

Eau Claire's Hair Salon

An MVC Web Application

By Helen Lehrer

Description

An MVC application for a hair salon that manages salon employees (stylists) and their clients. The user is able to add a list of stylists working at the salon and assign clients to that stylist. The stylists have specific specialties, so each client can only see (belong to) a single stylist (A one-to-many relationship). This application includes:

  • A splash page with options to see all Stylists, all Clients, or search for a specific Stylist or Client
  • A Stylists page that contains a link to a page with a form to create a new Stylist
  • Clickable Stylist names that go to new page displaying the selected Stylist details and a dynamic list of their assigned Clients
  • A Clients page that contains a link to a page with a form to create a new Client
  • Clickable Client names that go to new page displaying the selected Client details
  • All submissions have Edit, Delete, and Search functionality

Features:

  • A splash page
  • One-to-many database relationship
  • Multiple controllers
  • Use of MySQL for database management
  • GET and POST requests
  • MVC routes follow RESTful conventions
  • Search functionalities

Technologies Used

  • .NET 5.0.401
  • C#
  • Git Bash
  • MySQL & MySQL Workbench 8.0.30
  • Entity Framework Core 5.0.0
  • LINQ queries

Setup/Installation Requirements

Enter this command into your terminal to clone the project:

$ git clone https://github.com/helen-lehrer/HairSalon.Solution

Navigate from the root directory of the repo into the production folder HairSalon:

$ cd HairSalon

Restore dependencies and tools:

$ dotnet restore

Compile the code:

$ dotnet build

Database Import/Configuration:

  • Download, install, and configure MySQL & MySQL Workbench

  • In MySQL Workbench, In the Navigator>Administration window, select "Data Import/Restore"

  • In Import Options, select "Import from Self-Contained File"

  • In the field next to this, navigate to or type "[directory repo was cloned into]/HairSalon.Solution/helen_lehrer.sql".

  • In 'Default Schema to be Imported To', create a new Default Target Schema name called helen_lehrer.

  • Navigate to the tab called Import Progress and click Start Import at the bottom right corner of the window.

After you are finished with the above steps, reopen the Navigator > Schemas tab. Right click and select Refresh All. The database helen_lehrer will appear. Next, you will create an appsettings.json file.

Navigate from the root directory of the repo into the production folder HairSalon:

$ cd HairSalon

Create a file called appsettings.json:

$ touch appsettings.json

Add the following code to the appsettings.json file:

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

  • Make sure to insert your MySQL username and password into the appsettings.json connection string

  • Note that the database will change based on the database you are connecting to and that uid and pwd may vary depending on your MySql configurations.

To run the application:

Navigate from the root directory of the repo into the folder HairSalon:

$ cd HairSalon

Run the application:

$ dotnet run

Known Bugs

  • The search functionality is case sensitive

License

License

© Copyright 2022 Helen Lehrer