Epicodus C# Independent Project - Week 3 - June 9, 2017

By Joshua Fairchild

This application demonstrates my ability to create a project that will interact with a database using object oriented C# and SQL. The user is able to create new stylists, adding them to a list of employees, and to create new clients by assigning them to a stylist in a one-to-many relationship.

The user is able to interact with the information they enter in several ways. All stylists can be viewed from the index page, and clicking on a stylist's name will display their name, phone number, and all clients. Stylists as well as clients may have their existing information updated by the user, or they can be deleted altogether. The user is able to delete information in several ways: deleting an individual stylist, deleting all stylists, deleting all clients of a given stylist, or deleting a single client. The application also contains a search function, allowing the user to lookup stylists by name.

• Install Mono or another C# compiler.

• Install the Nancy web framework.

• Install the ASP.NET CORE framework for access to the Kestrel server

• Clone this repository

  git clone https://github.com/joshuafairchild1/hair_salon_csharp

• In PowerShell, run the following commands:

  SQLCMD -S "(localdb)\mssqllocaldb"

  CREATE DATABASE hair_salon;

  GO;

  USE hair_salon;

  GO;

  CREATE TABLE stylists (id INT IDENTITY(1,1), name VARCHAR(255), telephone VARCHAR(255));

  GO;

  CREATE TABLE clients (id INT IDENTITY(1,1), name VARCHAR(255), telephone VARCHAR(255), stylist_id INT);

  GO;

• Navigate to the root directory and run dnx kestrel to start the server

• Navigate to localhost:5004 in your web browser to view the application

• None known

• Nancy web framework
• Razor C# syntax
• C#
• HTML
• CSS (Bootstrap)
• Kestrel web server
• xUnit
• SQL
• Microsoft SQL Server Management Studio

This software is licensed under the MIT license

Copyright (c) 2017 Joshua Fairchild