BestBuy Product Management System

Built on ASP.NET Core MVC and leveraging C#, MySQL, and Dapper ORM, this application provides Best Buy staff with a streamlined CRUD interface, enhancing product management efficiency and productivity.

This project demonstrates proficiency in:

• Web development with ASP.NET Core MVC
• C# programming
• SQL database management
• Object-Relational Mapping (ORM) with Dapper
• Building user-friendly web applications

Features:

• Comprehensive CRUD Functionality: Users can seamlessly add, view, edit, and delete products from the database.
• Dapper ORM Integration: Ensures smooth interaction between the application and the database for optimal performance and data integrity.
• Secure Product Deletion: Alert prompts confirm user intentions before deleting products, preventing accidental data loss.

Benefits:

• Enhanced User Experience: Streamlines product management for Best Buy staff.
• Operational Efficiency: Improves workflow and data manipulation.
• Increased Productivity: Empowers staff to effectively manage the product database.

Technologies:

• ASP.NET Core MVC (Backend Framework)
• C# (Programming Language)
• MySQL (Database)
• Dapper ORM (Object Relational Mapper)
• HTML (User Interface)

How to Use:

1. Clone this repository.
2. Download and run this mock database setup file in MySQL: BestBuy MockDB.
3. Create an appsettings.json file in the project with this format:

  {
  "ConnectionStrings": {
  "bestbuy": "Server=probablyLocalhost;Database=bestbuy;uid=probablyRoot;Pwd=yourPasswordHere;Port=3306;"
  },
  "Logging": {
  "LogLevel": {
      "Default": "Warning"
  }
  },
  "AllowedHosts": "*"
}

4. Configure the connection string in appsettings.json to point to your MySQL instance of the database.
5. Build and run the application.

Stay Connected:

• Email: mackmc9924@gmail.com
• GitHub: Mack McCall
• LinkedIn: Mack McCall