Skip to content

RubyBe/Salon

Repository files navigation

Salon Management Program with C#, Nancy, Razor, and SQL Databases

Project Specifications

By Sid Benavente

Description/Specs

A program which allows management of salon Stylists and their associated Clients.

Data Model

The data model consists of two classes, Stylist and Client. There is a 1:Many relationship between the Stylist and Clients.

The Stylist class contains the following fields:

  • id
  • name
  • specialty
  • id

The Client class contains the following fields:

  • id
  • name
  • treatment
  • stylist_id (foreign key)

Program Routing

Method Route Action Model/Comments
GET / Returns index.cshtml, Model Model is a list of all Stylist instances
POST / Returns index.cshtml, Model Model is a list of all Stylist instances, after saving a new stylist
GET /stylists/{id} Returns stylist.cshtml, Model Model is a dictionary containing the selected Stylist instance, and all associated Client instances
GET /stylist/edit/{id} Returns stylist_edit.cshtml, Model Model is a found Stylist instance to be updated
PATCH /stylist/edit/{id} Returns success.cshtml Updates Stylist information, routes to simple confirmation page with link to home page
POST /stylist/new Returns success.cshtml Creates and saves a new stylist, routes to simple confirmation page with link to home page
GET /stylist/delete/{id} Returns stylist_delete.cshtml, Model Model is a found Stylist instance to be deleted, along with all associated clients
DELETE /stylist/delete/{id} Returns success.cshtml Deletes a single Stylist instance, routes to simple confirmation page with link to home page

Use this program

Clone this repository. Prepare your machine to run the Kestrel server by following the instructions here. To start the local server, type in "DNX Kestrel" at a command prompt in the root directory of your project. Navigate in your browser to "LocalHost:5004" to view the homepage.

The root folder of this project contains two database scripting files (salon_test_script.sql for testing, salon_script.sql for production). To import these databases, do the following:

  • Open SSMS
  • Select File > Open > File and select the appropriate .sql file.
  • Click !Execute.
  • The databases should appear in your database listing.

Known Bugs / Unimplemented Features

  • The database names (salon, salon_test) should be hair_salon and hair_salon_test).
  • The ability to update/delete a client is not yet implemented.

Support and contact details

Please contact the authors if you have any questions or comments.

Technologies Used

This web application was created using C#, Nancy, Razor, SQL, CSS, and Bootstrap.

License

Copyright (c) 2016 Sid Benavente

This software is licensed under the MIT license.

About

No description, website, or topics provided.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published