This program uses a local database to keep track of different stylists and each of their clients for a hair salon. Each client is assigned to an individual stylist. The user can create new stylists or clients and see a list of each stylist's clients. Information for stylists and clients can be changed after they are created, and individuals of either type can be deleted from the system.
This program will...
- Save a record of info for an individual stylist.
- Input: Stylist: Grace
- Output: Stylist: {1, Grace}
- Display a list of saved stylists.
- Input: All stylists
- Output: Stylist: {1, Grace}, {2, Harmony}, ...
- Save a record of info for an individual client that is assigned to a stylist.
- Input: Grace's Client: Cathy
- Output: Client: {1, Cathy, 1}
- Display a list of any stylist's clients.
- Input: Harmony's clients
- Output: Client: {1, Cathy, 1}, {2, Cindy, 1}, ...
- Edit saved info for any individual.
- Input: Client Cathy -> Kathy
- Output: Client: {1, Cathy, 1} -> {1, Kathy, 1}
- Delete any individual client.
- Input: Remove Client Kathy
- Output: Client: {1, Kathy, 1} -> {}
- Delete any individual stylist and all of that stylist's clients.
- Input: Remove Stylist Grace
- Output: Stylist: {1, Grace), Client: {1, Kathy, 1} -> {}, {}
-
Clone this GitHub repository.
-
From the command prompt, run '>SqlLocalDb.exe c MSSQLLocalDB -s' to create an instance of LocalDB.
-
Run the command '>sqlcmd -S "(localdb)\MSSQLLocalDB"' and run the following SQL commands to create the local database and tables:
>CREATE DATABASE hair_salon >GO >USE hair_salon >GO >CREATE TABLE stylists( > id INT IDENTITY(1,1), > name VARCHAR(255) >) >GO >CREATE TABLE clients( > id INT IDENTITY(1,1), > name VARCHAR(255), > stylist_id INT >) >GO
-
Navigate to the repository in terminal and run the command >dnu restore
-
In the same location, create a local server by running the command >dnx kestrel
-
Open a web browser and navigate to localhost:5004 to view the app.
None yet.
Add more properties to Stylist and Client. Reassign a client to a different stylist. Two column homepage with lists on one side and details on the other.
If you have questions or comments, contact the author at [email protected]
- C#
- SQL
- Nancy framework
- Razor view engine
- html/css
- Bootstrap
This project is licensed under the MIT license.
Copyright (c) 2016 Brad Copenhaver