This application, utilizing an MVC framework, lets the user, in this case a hair salon, keep track of employees and their clients. Employees can be added dynamically in a form, and clients can be listed under each employee account. The app implements this with C#, .NET Core, and SQL.

This project uses SQL, Entity Framework, RESTful routing, the Razor View Engine, and MVC conventions. It was created for the Epicodus week 11 friday independent project, on week 4 of C# and .NET course: Database Basics.

The source code is hosted on GitHub.

Download or clone the repository to run this program locally!

This program requires .NET Core SDK to run. Here is a free tutorial for installing .NET on Mac or Windows 10.

This program also makes use of SQL databases. We recommend using MySQL Workbench to build your databases. Here is a free tutorial for installing MySQL WorkBench and MySQL Community Server on Mac or Windows 10.

• Download or clone this repo.
  • To Download ZIP:
    • Select "Download" on the GitHub Repository site
    • Once downloaded, open the ZIP and extract files. The new folder will be created as 'VendorList.Solution'.
  • To Clone:
    • Clone from command line into your Desktop: $ git clone https://github.com/KristaRutz/C-Sharp-Database-Basics-Independent-Project.git
    • The new directory will be created as 'Desktop/C-Sharp-Database-Basics-Independent-Project'.
• Build your local databases.
  • To construct in the command line:
    • run your MySQL server from the command line.
    • use the commands listed in the 'DataBaseSetUpInstructions.txt' file in the root directory of this project.
  • To construct import from my file:
    • Open MySQL Workbench. In the Navigator > Administration window, select Data Import/Restore.
    • In Import Options select Import from Self-Contained File.
    • Navigate to the sql file at 'DumpStructure.sql' in the root directory of this project.
    • Under Default Schema to be Imported To, select the New button.
    • Enter the desired name of your database. The program is currently set to look for a database called 'krista_rutz'. If you use a different name, you will need to change the connection string in appsettings.json to reflect this.
    • Click Ok.
    • Click Start Import.
    • Reopen the Navigator > Schemas tab. Right click and select Refresh All to see the database appear.
• Once you have stored the files locally and built databases, execute the following commands.
  • Navigate to the application directory: $ cd VendorList.Solution/VendorList
  • dotnet build
  • dotnet run
• Upon success, the program will begin running on a local server.

• C#
• .NET Core 2.2
• MySQL Server and MySQL Workbench
• Entity Framework
• HTML with Razor
• CSS: Custom and Bootstrap

• Database table and column names follow both the specific requirements for this project and general .NET naming conventions.
• Instructions for re-creating your database are thorough and clear.
• There is a one-to-many relationship set up correctly in the database.
• CREATE functionality is included for one class and CREATE and VIEW functionality are included for the other class.
• Entity is used for communication with the database
• The project demonstrates understanding of this week's concepts.
• The project is in a polished, portfolio-quality state.
• Project uses two or more controllers.
• GET and POST requests/responses are used successfully.
• MVC routes follow RESTful conventions.
• Logic is easy to understand.
• Build files are included in .gitignore file and are not be tracked by Git
• Code and Git documentation follows best practices (descriptive variables names, proper indentation and spacing, separation between front and back-end logic, detailed commit messages in the correct tense, and a well-formatted README).

No known bugs

Please contact me if you run into any issues or have questions, ideas or concerns. I can be contacted at [email protected]. Feel free to fork and create pull requests for updates - contributions to the code are encouraged!

Copyright (c) 2020 Krista Rutz

This software is licensed under the MIT license.