🌟 CRUD Inventory Database Website 🌟

Overview

This CRUD Inventory Database Website was developed using ASP.NET MVC, C#, HTML, CSS, and SQL within the Visual Studio environment, leveraging the ASP.NET Core MVC Framework. The project empowers users to seamlessly perform Create, Read, Update, and Delete (CRUD) operations on items stored in a MySQL database. The application is designed to enhance inventory management and streamline data interactions.

Key Features

• ASP.NET Core MVC Framework: The project is built on the robust ASP.NET Core MVC framework, ensuring scalability, maintainability, and high-performance web development.

• MySQL Database Integration: The application seamlessly integrates with a MySQL database, enabling efficient storage and retrieval of product data.

• JSON Integration: JSON is employed to connect to a mock Best Buy database, facilitating dynamic and flexible data retrieval.

• C# Development: C# is utilized to create a "Product" model, representing the structure of the Product table in the MySQL database. Additionally, C# is employed to establish an IProductRepository interface and implement a ProductRepository class conforming to the interface.

• Dapper ORM and Parameterized SQL Queries: Dapper ORM is integrated into the project, enhancing data access efficiency. Parameterized SQL queries are employed to ensure secure and optimized CRUD operations on products-related tables in the database.

How to Run the Project

1. Environment Setup:

   • Ensure you have Visual Studio installed.
   • Configure your MySQL database connection details in the application settings.

2. Clone the Repository:

   git clone [repository_url]
   

3. Open in Visual Studio:

   • Open the solution file in Visual Studio.

4. Build and Run:

   • Build the solution and run the application.

5. Access the Website:

   • Navigate to the specified URL to access the CRUD Inventory Database Website.