Project Implementation Guide
Step 1: Create Database, Tables, and Stored Procedures
-----------------------------------------------------
1. Database Setup:
Create a database `ShopManagement`.
Create the following tables:
- Product
- Model
- Users
- Cart
SQL Example:
CREATE TABLE Product (
Pid INT PRIMARY KEY IDENTITY(1,1),
Pname NVARCHAR(100),
Specification NVARCHAR(500),
Uprice DECIMAL(10, 2),
SOH INT
);
CREATE TABLE Model (
Mid INT PRIMARY KEY IDENTITY(1,1),
Mname NVARCHAR(100),
Pid INT FOREIGN KEY REFERENCES Product(Pid),
Specification NVARCHAR(500),
Uprice DECIMAL(10, 2),
SOH INT
);
CREATE TABLE Users (
UserId INT PRIMARY KEY IDENTITY(1,1),
Username NVARCHAR(50),
Password NVARCHAR(50),
Utype NVARCHAR(10)
);
CREATE TABLE Cart (
CartId INT PRIMARY KEY IDENTITY(1,1),
Mid INT FOREIGN KEY REFERENCES Model(Mid),
Pid INT FOREIGN KEY REFERENCES Product(Pid),
BillNo INT,
BillDate DATETIME,
Qty INT,
TotalAmount DECIMAL(10, 2)
);
2. Stored Procedures:
Add/Edit/Delete/View procedures for each table.
Example Stored Procedure:
CREATE PROCEDURE SP_AddProduct
@Pname NVARCHAR(100),
@Specification NVARCHAR(500),
@Uprice DECIMAL(10, 2),
@SOH INT
AS
BEGIN
INSERT INTO Product (Pname, Specification, Uprice, SOH)
VALUES (@Pname, @Specification, @Uprice, @SOH)
END
Step 2: Create Login Page
-------------------------
Create a login form with fields:
1. Username
2. Password
3. Redirect based on user type (Admin/User).
Step 3: Admin MDI Form
----------------------
1. Set IsMdiContainer = True and WindowState = Maximized.
2. Add MenuStrip with options:
- Product: Add, Edit, Delete, View.
- Model: Add, Edit, Delete, View.
- Reports.
- Exit.
Step 4: User MDI Form
---------------------
1. Set IsMdiContainer = True.
2. Menu Options:
- View Products
- View Models
Step 5: SDI Forms
-----------------
Create SDI forms for all CRUD operations.
Example Code (Add Product):
private void btnSave_Click(object sender, EventArgs e)
using (SqlConnection con = new SqlConnection("your_connection_string"))
SqlCommand cmd = new SqlCommand("SP_AddProduct", con);
[Link] = [Link];
[Link]("@Pname", [Link]);
[Link]("@Specification", [Link]);
[Link]("@Uprice", [Link]([Link]));
[Link]("@SOH", [Link]([Link]));
[Link]();
[Link]();
[Link]("Product Added Successfully");
}
}
Step 6: Cascading Combo Boxes
-----------------------------
1. Load product in the first combo box.
2. Load models based on the selected product.
Example Code:
private void cmbProduct_SelectedIndexChanged(object sender, EventArgs e)
int productId = (int)[Link];
using (SqlConnection con = new SqlConnection("your_connection_string"))
SqlDataAdapter da = new SqlDataAdapter("SELECT Mid, Mname FROM Model WHERE Pid =
@Pid", con);
[Link]("@Pid", productId);
DataTable dt = new DataTable();
[Link](dt);
[Link] = dt;
[Link] = "Mname";
[Link] = "Mid";
Step 7: Cart Functionality
--------------------------
1. Calculate Total (Qty * Uprice).
2. Add to Cart Table.
Example Code:
private void btnAddToCart_Click(object sender, EventArgs e)
int qty = [Link]([Link]);
decimal uprice = [Link]([Link]);
decimal totalAmount = qty * uprice;
using (SqlConnection con = new SqlConnection("your_connection_string"))
SqlCommand cmd = new SqlCommand("INSERT INTO Cart (Mid, Pid, BillNo, BillDate, Qty,
TotalAmount) VALUES (@Mid, @Pid, @BillNo, @BillDate, @Qty, @TotalAmount)", con);
[Link]("@Mid", [Link]);
[Link]("@Pid", [Link]);
[Link]("@BillNo", GenerateBillNo());
[Link]("@BillDate", [Link]);
[Link]("@Qty", qty);
[Link]("@TotalAmount", totalAmount);
[Link]();
[Link]();
[Link]("Added to Cart Successfully");
}
Step 8: Reports
---------------
Generate reports for Products, Models, and Cart using DataGridView or Crystal Reports.