marnionrails/doctors-office

Epicodus many to many database practice project

Doctors Office

By Cesar Lopez, Karl Starkweather, & Patrick Dolan

An application for office administrators to track patients in a doctors office.

Technologies Used

• C#
• .NET 5.0
• dotnet
• MySql/Workbench

Description

An application for office administrators to track patients in a doctors office. The application is capable of the following:

• Add a doctor to the system including name and specialty.
• Add a patient to a doctor including name and birthdate.
• Add more than one doctor to a patient.

Setup/Installation Requirements

• Make sure you have MySql Workbench installed on your computer.
• Make sure to have dotnet-ef installed too.
  This project uses dotnet-ef --version 3.0.0 which I have globally installed but you can install it however you want.
• Download repo to your computer using either clone or the download link.
• Open the project in VScode or your terminal/IDE of choice.
• Create a appsettings.json file in the root directory of the project folder. And add the following code replacing anything in square brackets with the information it represents specific to the project database:

{
  "ConnectionStrings": {
    "DefaultConnection": "Server=localhost;Port=3306;database=[DATABASE-NAME-HERE];uid=[USER-ID-HERE];pwd=[YOUR-PASSWORD-HERE];"
  }
}

Example of complete appsettings.json:

{
  "ConnectionStrings": {
    "DefaultConnection": "Server=localhost;Port=3306;database=to_do_list;uid=root;pwd=MySuperStrongPassword;"
  }
}

• Make sure to run your mysql server and open MySql workbench.
• Open MySql Workbench and login to your server.
• Click on the Administration tab in the Navigator on the left side of the screen. (this tab will likely be on the bottom of the window)
• In the management section of this administration tab click on the button called Data Import/Export.
• Once the data import window opens click on Import from Self-Contained file radio button, navigate into the project folder and select patrick_dolan.sql using the file path next to that radio button.
• Now click on the New... button in the section marked "Default Schema to be Imported To" directly underneath the import options section.
• Click on the "Import Progress" tab at the top of the Data import window.
• At the bottom of this tab click the button that reads Start Import.
• Confirm the database has been imported and you can check it by clicking the "Schemas" tab on the navigator at the left side of the program. Right click in the white space and select "Refresh All"
• Now using your IDE navigate into the HairSalon/HairSalon/ folder and use the command dotnet run to launch the program.
• The site should be available at the server address you used in the appsettings.json folder.

Test Setup/Installation

• Open the repo on your editor of choice/terminal
• Navigate to DoctorsOffice.Tests directory in your terminal
• Run the following command to setup testing:
  dotnet restore
• Run tests by going to the test project in the terminal (DoctorsOffice.Solution/DoctorsOffice.Tests) and running the following command:
  dotnet test

Known Bugs

• No known bugs

Contact Me

Let me know if you run into any issues or have questions, ideas or concerns:
dolanp1992@gmail.com

License

MIT

Copyright (c) 2022 Cesar Lopez, Karl Starkweather, & Patrick Dolan