Christopher-Quattrocchi/Sillystringz

C# project with mysql featuring many to many relationships

SillyStringz Factory Management System

Table of Contents

• About
• Features
• Technologies Used
• Installation
• Setting Up SQL
• Known Bugs
• License
• Contact

About

This MVC web application is designed to manage the operations of the SillyStringz factory, focusing on handling engineers and their associated machines. It allows the factory management to add engineers, view detailed profiles, and associate each engineer with multiple machines. Machines and engineers can be deleted.

Features

• Engineers: Create and manage engineer profiles.
• Machines: Add and detail machines within the factory.
• Association: Link multiple machines to individual engineers to reflect responsibilities and expertise.

Technologies Used

• Language: C#
• Framework: .NET 5.0 or .NET 6.0
• IDE: Visual Studio 2019 or 2022
• Database Management: Entity Framework Core, Microsoft.EntityFrameworkCore.SqlServer
• Version Control: Git

Installation

Follow these steps to get a local copy up and running:

1. Clone the Repository

   git clone https://github.com/christopher-quattrocchi/SillyStringz.git
   

2. Navigate to the Project Directory cd SillyStringz.Solutions cd SillyStringz

3. Restore Dependencies dotnet restore

4. Build the Project dotnet build

5. Run the Project dotnet run

Access the application through a web browser at the indicated URL, typically http://localhost:5000.

Setting up the SQL Database

This project uses a SQL database to store and manage data. Follow the instructions below to set up the database environment:

Prerequisites

• If needed, install SQL Workbench: official website.

1. Open SQL Workbench and connect to your MySQL server.

2. Import the Database Schema:

   • In the top menu, navigate to Server > Data Import.
   • Choose "Import from Self-Contained File" and select the chris_quattrocchi2.sql file located in your project directory.
   • Under "Default Target Schema", either select an existing schema or create a new one to import the tables into.
   • Click Start Import at the bottom right to execute the script and create the tables in your database.

3. Configure Connection String:

   • In your application's appsettings.json file, update the connection string to match your database name and credentials:

   {
     "ConnectionStrings": {
       "DefaultConnection": "Server=localhost;Database=yourDatabaseName;Uid=yourUsername;Pwd=yourPassword;"
     }
   }
   

Apply Migrations:

dotnet ef database update

Known Bugs

Unknown

License

This project is licensed under the MIT License.

Contact

chrisquattrocchi@gmail.com