A program for a University registrar to keep track of students and courses.

In Terminal:

• Navigate to where you want this application to be saved, i.e.: cd desktop
• Clone the file from GitHub with HTTPS git clone https://github.com/benjamin-thompdx/WordCounter.Solution.git
• Open file in your preferred text editor
• On Mac: open -a {your text editor} WordCounter.Solution
• On Windows: WordCounter.Solution

Download Manually:

• Navigate to https://github.com/benjamin-thompdx/WordCounter.Solution.
• Click the green "Clone or Download" button.
• Click "Download ZIP".
• Click downloaded file to unzip.
• Open folder called "WordCounter.Solution".

Installing MySQL | MacOS:

• Download the MySQL Community Server DMG File from MySQL Community Server
• You can exit the mysql program by entering exit.
• Download the MySQL Workbench DMG File from MySQL Workbench. (Use the No thanks, just start my download link.)
• Install MySQL Workbench to Applications folder.
• Open MySQL Workbench and select the Local instance 3306 server. You will need to enter the password you set. (We used epicodus.) If it connects, you're all set.

Installing MySQL | Windows 10:

• Download the MySQL Web Installer from MySQL Downloads (Use the No thanks, just start my download link.)
• You can exit the mysql program by entering exit
• Add the MySQL environment variable to the System PATH. We must include MySQL in the System Environment Path Variable. This is its own multi-step process. Instructions here are for Windows 10:
  1. Open the Control Panel and visit System > Advanced System Settings > Environment Variables...
  2. Then select PATH..., click Edit..., then Add.
  3. Add the exact location of your MySQL installation, and click OK. (This location is likely C:\Program Files\MySQL\MySQL Server 8.0\bin, but may differ depending on your specific installation.)
• Open MySQL Workbench and select the Local instance 3306 server (it may have a different name). You will need to enter the password you set (We used epicodus). If it connects, you're all set.

MySQL Workbench Database Setup:

CREATE DATABASE to_do_list;

USE to_do_list;

CREATE TABLE categories (CategoryId PRIMARY KEY, Name VARCHAR(255));

CREATE TABLE items (ItemId PRIMARY KEY, Description VARCHAR(255), CategoryId INT));

Note For Editors:

• Download the .NET Core SDK Software Development Kit
• Open the .Net Core SDK file and install
• To confirm installation was successful, run the $ dotnet --version command in your terminal
• Install dotnet script, run the $ dotnet tool install -g dotnet-script command in your terminal
• Restart your terminal to complete installation, and run the $ dotnet run command to run application within your terminal - Note: To exit, simply press Ctrl + C
• Open project's productions directory within your terminal $ cd ToDoList.Solution/ToDoList
• Run the command > dotnet restore
• Run the command > dotnet build
• If build is successful, run the command > dotnet run, if build failed, make necessary updates and repeat > dotnet restore followed by > dotnet build

No known bugs at this time.

Have a bug or an issue with this application? Open a new issue here on GitHub.

• Git 2.23.0
• C# language
• .NET Core 2.2.106
• dotnet script 0.50.1
• VS Code 1.43.1
• Model-View-Controller(MVC) framework
• Create, Read, Update, Delete (CRUD) functionality
• MySQL 8.0.15
• MySQL Workbench 8.0.15
• Entity Framework Core 2.2.4
• Language-Integrated Query (LINQ)
• ASP.NET Razor

This webpage is licensed under the MIT license.

Copyright (c) 2020 Benjamin Thom, K. Wicz, Jonathan Carlos