Electronics Shop Sample Project

A project is a sample for an Electronics online shop for selling multiple electronic products

Table of Contents

1. About The Project
   • Built With
2. Getting Started
   • Database
   • System Flow
3. Contact

About The Project

The project is simulating the experience of online shopping, an Electronics online shop with multiple products from different categories. You Can:

1. Fill your cart with products
2. Place an order to your address, even if you are not registered
3. You will have discounts on buying even number of products

(back to top)

Built With

• DotNet Core 6
• SQL Server Express LocalDB

(back to top)

Getting Started

You may check the word document (Requirements.docx) for more information

Database

We have the Category table that contains 3 main categories (TVs, Laptops and Sound Systems). The products are categorized by a one-to-many relationship between Category and Product tables.

The Product table has the information and price for each product, also the discount that will be applied (if the customer bought doubles of the same product).

And finally we have the Order header and lines tables, that refelcts the order placed by the customer with summing the quantities and total price for the order.

System Flow

1. Adminstrators can manage categories and products only

2. Registered and un-registered Customers can start shopping, adding products to the cart and then place the order for shipping

3. Discounts applied when adding the products to the cart.

4. Discount Formula >> Amount to be cut from the total = (Item Qty X Item Unit Price X Discount %)

(back to top)

Contact

Mohamed El Ghandour - m.el_ghandour@hotmail.com

Project Link: (https://github.com/MGhandour92/EShop-Task-LDev)

(back to top)