/EauClairesSalon.Solution

An application for handling Stylist/Client relations

Primary LanguageC#

Eau Claire's Salon

By Jacob Wilson

An application for keeping track of stylist/client relations.

Technologies Used

  • HTML
  • CSS
  • C#
  • SQL
  • MySQL
  • Markdown
  • Bootstrap
  • Razor
  • HTML Helper
  • EntityFrameworkCore

Description

An application designed using MVC layout for keeping track of stylist/client relations. The user starts on a splash page welcoming them to the program. From there the user is able to click a link that will rout them to a page containing all stylists, if any clients have been added they will also be able to click a link to view all clients and their respective stylist. Once the page viewing all stylists you will be able to click on a specific stylist to view all of their clients or you will be able to click "Add a stylist" to be routed to a create page containing a form. Once the form is filled out you will be redirected back to the page to view all stylists and the newly created stylist will have been saved into the database and is now loaded in with all the other stylists.

Setup/Installation Requirements

  • Requires VSCode and MySql

  • You can find the github repository here

  • Click the code button, and copy the https link

  • In your in git bash or your preferred git terminal navigate to the directory you would like to store the project

  • Enter: "git clone" followed by the https link

  • Now that the repository is cloned to your computer, right click on the folder and click open with vs code

In order to access a usable version of the sql database you will need to do the following:

  • Create a file named appsettings.json in the HairSolon directory
  • The file should contain this block of code except with your own username and password for the server(brackets around private information not included):
{
  "ConnectionStrings": {
      "DefaultConnection": "Server=localhost;Port=3306;database=jacob_wilson;uid={YOUR USER ID HERE};pwd={YOUR PASSWORD HERE};"
  }
}
  • Open MySQL and log into your server

  • In the "Navigator" panel select the "Administration" tab.

  • Select "Data Import/Restore"

  • Select "Import from self-contained file" navigate to to the HairSolon directory you cloned above and select jacob_wilson.sql

  • In "Default Schema to be Imported to" select new and name the schema jacob_wilson

  • NOTE: Make sure you name the file jacob_wilson or else the project won't locate the correct database

  • Click Start Import

  • The schema has now been added! You may need to refresh your databases to see the newly imported database

  • Now in your terminal run "dotnet restore" to download csproj dependencies.

  • Once all of the above is completed you can view the project on your local server by running "dotnet run"

Known Bugs

  • No known bugs

License - MIT

If you run into any problems or find a bug, would like to reach me for a separate reason, feel free to send me an email @jacobleeeugenewilson@gmail.com with details of your issue.

Copyright (c) 12/26/2021 Jacob Wilson(s)