Skip to content

Nav-cmd/GreenLife-Organics

BranchesTags

Repository files navigation

🌿 GreenLife Organic Store Management System

A full-featured desktop retail management platform for the modern organic marketplace


Platform Language Framework Database Architecture Pattern Status


C# .NET Framework Windows Forms SQL Server Visual Studio ADO.NET MailKit iTextSharp


Designed & Developed by Naveen Nagendran

GitHub Email

📋 Table of Contents

🌱 Overview

The GreenLife Organic Store Management System is a robust, desktop-based retail management application designed to address the operational challenges faced by small and medium-scale organic retailers. It replaces inefficient manual processes with a structured, automated digital platform — covering everything from product cataloguing and inventory tracking to customer management, order processing, payment handling, and automated reporting.

Built using C# and the .NET Framework 4.8 with Windows Forms as the UI layer and Microsoft SQL Server as the backend relational database (accessed via ADO.NET), the system follows a rigorous three-tier layered architecture and applies Object-Oriented Programming (OOP) principles throughout — making it maintainable, scalable, and extensible.

🎯 The Problem

Organic retail businesses managing a wide variety of perishable and eco-friendly products face compounding operational challenges:

  • Manual stock tracking leads to overstocking or out-of-stock situations for time-sensitive organic goods
  • Dispersed customer records make it difficult to understand purchasing patterns or maintain relationships
  • No unified order management results in fulfilment delays and poor visibility into order statuses
  • Fragmented promotional management means discounts are applied inconsistently or missed entirely
  • No reporting tools limit the ability to make data-driven business decisions

✅ The Solution

GreenLife provides a single, integrated desktop application serving two distinct user roles:

Role Responsibilities
🛠️ Administrator Manage products, inventory, customers, orders, discounts, reviews, notifications, suppliers, and generate reports
🛒 Customer Browse and search products, manage a cart and wishlist, check out securely, track orders, and rate products

🌍 Real-World Scenario

A store manager (Admin) logs into GreenLife each morning, checks the dashboard for low-stock alerts and overnight orders, updates product inventory after a supplier delivery, and applies a new weekend discount promotion. Meanwhile, a registered customer browsing from their desktop discovers a featured product, adds it to their wishlist, applies a discount code at checkout, completes payment, and receives a confirmation notification — all within the same unified application.

🏗️ System Architecture

The system follows a clean Three-Tier Layered Architecture, separating responsibilities into three well-defined layers:

┌─────────────────────────────────────────────────────────────────┐
│                     PRESENTATION LAYER                          │
│  ┌─────────────────────────┐   ┌─────────────────────────────┐  │
│  │     Admin Interface     │   │    Customer Interface        │  │
│  │  Dashboard · Products   │   │  Home · Products · Cart      │  │
│  │  Orders · Reports       │   │  Payment · Orders · Profile  │  │
│  │  Discounts · Suppliers  │   │  Wishlist · Reviews          │  │
│  └─────────────────────────┘   └─────────────────────────────┘  │
└─────────────────────────────────────────────────────────────────┘
                               │
                               ▼
┌─────────────────────────────────────────────────────────────────┐
│                   APPLICATION LOGIC LAYER                       │
│  ┌──────────────┐ ┌───────────────┐ ┌──────────────────────┐   │
│  │ Auth Service │ │Product Catalog│ │  Cart / Order Service│   │
│  └──────────────┘ └───────────────┘ └──────────────────────┘   │
│  ┌──────────────┐ ┌───────────────┐ ┌──────────────────────┐   │
│  │ Notification │ │   Payment     │ │  Shared Business     │   │
│  │   Service    │ │   Gateway     │ │     Logic API        │   │
│  └──────────────┘ └───────────────┘ └──────────────────────┘   │
└─────────────────────────────────────────────────────────────────┘
                │                          │
                ▼                          ▼
┌──────────────────────────┐   ┌──────────────────────────────┐
│       DATA LAYER         │   │    EXTERNAL COMMUNICATION    │
│  Microsoft SQL Server    │   │                              │
│  ─────────────────────   │   │   Mail Server                │
│  Users · Products        │   │   (MailKit / SMTP)           │
│  Orders · Inventory      │   │                              │
│  Payments · Reviews      │   └──────────────────────────────┘
│  Notifications           │
└──────────────────────────┘
Layer Responsibility
Presentation Windows Forms UI for Admin and Customer roles
Application Logic C# OOP classes handling business rules, validations, and service orchestration
Data SQL Server relational database accessed via ADO.NET with enforced relational integrity
External MailKit-powered SMTP mail server for automated email notifications

✨ Key Features

🔐 Authentication & Access Control

  • Secure login with encrypted (hashed + salted) credentials
  • Role-Based Access Control (RBAC) — Admin vs Customer
  • Password reset via automated email (MailKit / SMTP)
  • Session management and controlled access to protected routes

👨‍💼 Admin Panel

Module Capabilities
📊 Dashboard Real-time KPIs — total sales, active orders, products in stock, low-stock alerts
📦 Product Management Full CRUD — add, update, delete products; manage categories, supplier links, pricing, stock, and discounts
👥 Customer Management View, search, and update all registered customer accounts
🚚 Order Management Monitor all orders; update status through Pending → Shipped → Delivered lifecycle
🏷️ Discount Management Create time-bound percentage or fixed-value discounts; automatic price recalculation
⭐ Reviews Management Moderate and view all customer product reviews and star ratings
🔔 Notifications Send and manage system-wide notifications; read/unread tracking
📈 Reports Date-range-filtered Sales, Stock, and Customer Order History reports — Export to CSV and Export to PDF via iTextSharp
🏭 Supplier Management Add, update, and manage supplier records; link suppliers to product inventory

🛒 Customer Panel

Module Capabilities
🏠 Home Page Personalized dashboard with featured products, active promotions, and cart/order/wishlist summary widgets
🔍 Product Browsing Search by name; filter by category and price range; full product detail views
🛒 Shopping Cart Add/remove products, adjust quantities, live discount and delivery fee calculation, order summary
💳 Payment & Checkout Multi-method payment (Cash, Card, Bank Transfer); delivery address entry; stock auto-decrement on confirmation
📦 Order Tracking Full order history with status progression (Pending → Shipped → Delivered) and delivery details
❤️ Wishlist Save products for future purchase; move items directly to cart
👤 Profile Management View and update personal information and delivery addresses
⭐ Product Reviews Leave star ratings and written reviews post-purchase

🛠️ Technology Stack

Core Language & Framework

Component Technology Details
Primary Language C# OOP-first, strongly typed, .NET ecosystem
Application Framework .NET Framework 4.8 Windows desktop runtime environment
UI Framework Windows Forms (WinForms) Graphical forms, data grids, panels, navigation
Database Connectivity ADO.NET Parameterized queries, connection management

Database

Component Technology
RDBMS Microsoft SQL Server Express
Admin Tool SQL Server Management Studio (SSMS)
Schema Design Tool dbdiagram.io

External Libraries

Library Purpose Source
MailKit Automated SMTP email — registration, OTP, order confirmations jstedfast/MailKit
iTextSharp PDF report and invoice generation iText Group

Development & Modelling Tools

Tool Purpose
Visual Studio Primary IDE — IntelliSense, WinForms designer, integrated debugger, build system
draw.io UML diagram modelling (Use Case, Sequence, Class Diagrams)
dbdiagram.io Entity-Relationship and database schema visualization

🗄️ Database Design

The database is implemented in Microsoft SQL Server using a fully relational schema with primary key and foreign key constraints enforced throughout. The schema is organized into six logical domains:

User & Access Control

Roles ──────────────────► Users ──────────── UserAddresses
(Admin, Customer)         (Auth, Profile)     (Delivery Addresses)

Product & Inventory

Categories ──► Products ◄── ProductSuppliers ──► Suppliers
                  │
                  └──► ProductDiscounts ──► Discounts

Order & Transaction Lifecycle

Orders ──► OrderItems
  │
  ├──► OrderStatus ──► OrderStatusHistory
  │
  └──► Payments ──► PaymentMethods / PaymentStatus

Customer Engagement

Users ──► Carts ──► CartItems
      ──► Wishlist ──► WishlistItems
      ──► ProductReviews
      ──► Notifications ──► NotificationTypes

Full Schema Summary

Domain Tables
Users & Auth Roles, Users, UserAddresses
Product Catalog Categories, Products, Suppliers, ProductSuppliers
Promotions Discounts, ProductDiscounts
Orders Orders, OrderItems, OrderStatus, OrderStatusHistory
Payments Payments, PaymentMethods, PaymentStatus
Customer Activity Carts, CartItems, Wishlist, WishlistItems, ProductReviews
Communication Notifications, NotificationTypes

All tables enforce primary key and foreign key constraints, ensuring referential integrity and consistent relationships across all system operations.

📦 Module Breakdown

Module 1 — User Management

Handles all aspects of account lifecycle: registration, login authentication, role assignment, profile editing, and secure session control. The Users table maintains hashed/salted passwords and role references. Admins and Customers each have role-restricted views of the system.

Module 2 — Product & Inventory Management

Enables administrators to manage the full product catalog with add, update, and delete operations. Products are linked to categories, suppliers, and optional discount records. The system monitors stock levels in real time and generates automated low-stock alerts when quantities fall below defined thresholds.

Module 3 — Order Processing

Manages the complete order lifecycle from cart checkout through to delivery confirmation. Covers stock validation at checkout, order record creation, status progression (Pending → Shipped → Delivered), and automatic inventory deduction on confirmed purchase.

Module 4 — Cart & Wishlist

Temporary product selection (Cart) and product bookmarking (Wishlist) are handled as separate but related modules. Customers can adjust quantities, remove items, and move wishlist products directly to the cart. Cart totals auto-update with applied discounts and delivery fees.

Module 5 — Payment Management

Processes financial transactions with support for multiple payment methods (Cash, Card, Bank Transfer). Records payment amount, method, and status against each order. Card payment captures holder name, card number, CVV, and expiry date. All payment records are stored with full traceability.

Module 6 — Notification & Communication

Generates and dispatches automated system alerts via the integrated MailKit email service — covering registration confirmation, order status updates, low-stock warnings, and promotional announcements. Notifications are tracked with read/unread states in the database.

Module 7 — Review & Feedback

Post-purchase, customers may submit star ratings and written reviews for products they have ordered. Administrators can monitor all submitted reviews through the dedicated Reviews Management panel and moderate content as required.

Module 8 — Reporting & Analytics

Administrators can generate and export a range of business intelligence reports filtered by date range, including:

  • Sales Reports — order-level revenue and product performance
  • Stock / Inventory Reports — current stock levels, low-stock items, reorder status
  • Customer Order History — full per-customer transaction records

Reports are exportable as CSV for further analysis and PDF via iTextSharp for printing and distribution.

🧩 OOP Design Principles

The system is architected around four core Object-Oriented Programming principles applied consistently throughout every module.

Inheritance

User  (base class — credentials, contact info, account status)
 ├── Admin    → manageProducts(), viewOrders(), generateReports(), sendNotification()
 └── Customer → addToCart(), placeOrder(), writeReview(), addToWishlist()

Common attributes and behaviours are defined once in User and inherited by both Admin and Customer — eliminating duplication and enforcing a consistent user model.

Encapsulation

All business logic and data access operations are encapsulated within dedicated class files, fully separated from Windows Forms UI code:

  • Admin_ProductsClass — encapsulates all product business logic
  • CustomerCartClass — manages all cart state and operations
  • PaymentProcessClass — handles transaction workflows with database-level atomicity (SQL transactions across multiple tables)

Abstraction

Each class exposes clean, well-named public methods to the UI layer, hiding internal implementation details entirely. UI forms interact only through defined method interfaces — the form does not know how a query is constructed, only that LoadProducts() returns the data it needs.

Single Responsibility

Each class is designed around one operational concern. CRUD patterns are consistently applied across all data-driven modules, and PascalCase naming conventions are enforced throughout for classes, methods, and properties.

🔒 Security Implementation

Security Feature Implementation
Password Storage Hashed and salted encryption — plaintext passwords are never stored or transmitted
Role-Based Access RBAC enforced at the application layer — admin routes are inaccessible to the customer role
Input Validation All user inputs validated before database interaction to prevent malformed data errors
SQL Injection Prevention Parameterized queries used throughout all ADO.NET data access operations
Session Management Session state managed per user login; logout fully invalidates the active session
Secure DB Connection Controlled connection strings; connection scope minimized per operation

📐 UML Diagrams

The system was modelled using draw.io for UML diagrams and dbdiagram.io for the database schema before implementation.

Use Case Diagram

Covers both actor roles — Customer and Admin — with the following use cases:

Customer: Login · Register · Browse Products · Search Products · Add to Cart · Checkout · Make Payment · Apply Discount · Track Order · View Order History · Write Review · Manage Wishlist

Admin: View/Update Customer Details · Manage Products · Manage Categories · Manage Suppliers · Manage Discounts · View/Update Orders · Monitor Low Stock · Receive Notifications · Generate Reports

Sequence Diagram

Captures the full interaction flow across all system components: Customer, Admin, Web Application, Authentication Service, Product Catalog, Cart Service, Order Service, Payment Gateway, Database, and Notification Service — from login through to checkout confirmation.

Class Diagram

Defines the full OOP class structure with attributes, methods, and relationships — including association, dependency, composition, and inheritance links between: User, Admin, Customer, Product, Category, Order, OrderItem, Cart, CartItem, Wishlist, WishlistItem, Payment, Supplier, Discount, Review, and Notification.

📁 Diagram images are available in the docs/diagrams/ folder of this repository.

💻 System Requirements

Hardware Requirements

Component Admin Customer
Processor Intel Core i3 (13th Gen) or higher Intel Core i3 or equivalent
RAM Minimum 8 GB Minimum 8 GB
Storage 512 GB SSD 256 GB SSD
UPS 650VA – 1200VA —
Printer Ink Tank Printer (for reports/invoices) —
Network Broadband Internet Internet connectivity

Software Requirements

Software Admin Customer
Operating System Windows 11 Pro Windows 10 / Windows 11
.NET Framework 4.8 4.8
SQL Server SQL Server Express —
SSMS SQL Server Management Studio —
GreenLife Application ✅ Required ✅ Required

⚙️ Installation & Setup

Step 1 — Install Prerequisites

# Install the following on the host machine:
1. Windows 10 or Windows 11
2. .NET Framework 4.8
   → https://dotnet.microsoft.com/en-us/download/dotnet-framework/net48
3. Microsoft SQL Server Express
   → https://www.microsoft.com/en-us/sql-server/sql-server-downloads
4. SQL Server Management Studio (SSMS)
   → https://learn.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms
5. Visual Studio (for building from source)
   → https://visualstudio.microsoft.com/

Step 2 — Configure the Database

-- 1. Open SQL Server Management Studio (SSMS)
-- 2. Connect to your local SQL Server instance
-- 3. Create the database
CREATE DATABASE GreenLifeOrganicStoreDB;

-- 4. Open Database/GreenLifeOrganicStoreDB.sql and execute it
--    This generates all tables, constraints, and relationships

-- 5. Insert seed data before first use
INSERT INTO Roles (RoleName) VALUES ('Administrator'), ('Customer');

INSERT INTO Categories (CategoryName)
VALUES ('Fruits'), ('Vegetables'), ('Dairy Products'), ('Greens'), ('Sweet');

INSERT INTO Users (Name, Username, Email, Phone, PasswordHash, IsAdmin)
VALUES ('Store Admin', 'admin', 'admin@greenlife.com', '0000000000', '<hashed_password>', 1);

Step 3 — Configure the Application

<!-- Update the connection string in App.config -->
<connectionStrings>
  <add name="GreenLifeDB"
       connectionString="Server=YOUR_SERVER_NAME;
                         Database=GreenLifeOrganicStoreDB;
                         Integrated Security=True;"
       providerName="System.Data.SqlClient" />
</connectionStrings>

⚠️ Replace YOUR_SERVER_NAME with your actual SQL Server instance name — e.g., .\SQLEXPRESS or localhost\SQLEXPRESS.

Step 4 — Build and Run

# 1. Open GreenLife.sln in Visual Studio
# 2. Restore NuGet packages (MailKit, iTextSharp)
#    → Tools → NuGet Package Manager → Restore Packages
# 3. Build the solution
#    → Ctrl + Shift + B
# 4. Run the application
#    → F5 (debug) or Ctrl + F5 (without debug)
# 5. The Login screen will appear — log in with the admin account to begin

🧪 Testing

The system was validated through a comprehensive structured test plan covering all core functional areas — including both positive (valid input) and negative (invalid/edge case) scenarios.

Test Case Feature Area Test Scenario Result
TC-01 Registration Valid user registration with all required fields ✅ Passed
TC-02 Email Email notification delivery via MailKit ✅ Passed
TC-03 Authentication Valid login credentials — correct dashboard routing ✅ Passed
TC-04 Password Recovery Forgot password — OTP email flow and reset ✅ Passed
TC-05 Supplier Supplier add and update operations ✅ Passed
TC-06 Product Product creation with all required fields ✅ Passed
TC-07 Input Validation Negative price value rejection ✅ Passed
TC-08 Discounts Discount creation and product association ✅ Passed
TC-09 Discount Calculation Correct discounted price applied at checkout ✅ Passed
TC-10 Search Product search by keyword — accurate filtering ✅ Passed
TC-11 Cart Add to cart and quantity update ✅ Passed
TC-12 Cart Quantity Quantity increment and decrement validation ✅ Passed
TC-13 Wishlist Add and remove product from wishlist ✅ Passed
TC-14 Wishlist Guard Duplicate wishlist entry prevention ✅ Passed
TC-15 Payment End-to-end payment processing and order confirmation ✅ Passed
TC-16 Review Product review and star rating submission ✅ Passed

Debugging Tools Used During Development

  • Breakpoint Debugging — Step-through execution for logic tracing in Visual Studio
  • Error Visualization Panel — Real-time error markers in the editor for syntax and type errors
  • IntelliSense — Type-safe code completion reducing runtime errors at authoring time
  • Try-Catch Blocks — Structured exception handling at all database and external call boundaries

📁 Project Structure

GreenLife/
│
├── Forms/
│   ├── Auth/
│   │   ├── Login.cs
│   │   ├── Register.cs
│   │   └── ForgotPassword.cs
│   │
│   ├── Admin/
│   │   ├── AdminDashboard.cs
│   │   ├── Admin_Products_Management.cs
│   │   ├── CustomerManagement.cs
│   │   ├── OrderManagement.cs
│   │   ├── DiscountsManagement.cs
│   │   ├── ReviewsManagement.cs
│   │   ├── Notifications.cs
│   │   ├── Reports.cs
│   │   └── SupplierManagement.cs
│   │
│   └── Customer/
│       ├── CustomerDashboard.cs
│       ├── CustomerProducts.cs
│       ├── CustomerCart.cs
│       ├── Payment.cs
│       ├── CustomerOrders.cs
│       ├── Wishlist.cs
│       └── CustomerProfile.cs
│
├── Classes/
│   ├── Admin_Dashboard_Class.cs
│   ├── Admin_ProductsClass.cs
│   ├── CustomerManagementClass.cs
│   ├── OrderManagementClass.cs
│   ├── DiscountClass.cs
│   ├── ReviewsClass.cs
│   ├── NotificationsClass.cs
│   ├── ReportsClass.cs
│   ├── SupplierClass.cs
│   ├── CustomerDashboardClass.cs
│   ├── CustomerProductsClass.cs
│   ├── CustomerCartClass.cs
│   ├── PaymentProcessClass.cs
│   ├── WishlistManager.cs
│   ├── CustomerOrderClass.cs
│   └── CustomerProfileClass.cs
│
├── Database/
│   └── GreenLifeOrganicStoreDB.sql
│
├── docs/
│   └── diagrams/
│       ├── architecture-diagram.png
│       ├── database-erd.png
│       ├── use-case-diagram.png
│       ├── sequence-diagram.png
│       └── class-diagram.png
│
├── App.config
└── GreenLife.sln

🔮 Future Enhancements

The system is architected to support the following planned extensions:

  • ☁️ Cloud Deployment — Migration to Azure SQL / Azure App Service for remote multi-user access
  • 📱 Mobile Application — Companion Android/iOS app for customers
  • 💳 Online Payment Gateway — Integration with Stripe, PayPal, or regional gateways
  • 📊 Advanced Analytics — Real-time trend charts for sales performance and stock forecasting
  • 🔔 Push Notifications — Real-time in-app and push notification service
  • 🌐 Web Portal — Responsive browser-based interface as an alternative to the desktop client

👨‍💻 Developer

Naveen Nagendran
Role Software Engineer
Specialisation C# · .NET · SQL Server · Desktop & Full-Stack Development
GitHub github.com/Nav-cmd
Email nn5012089@gmail.com

GreenLife is my first independently designed and delivered full-stack desktop application. I conceived, architected, and implemented the entire system end-to-end — from requirements analysis and relational database design through to every UI screen, business logic class, security mechanism, test case, and technical document.

The project gave me deep, hands-on experience with real-world software engineering practices: three-tier architecture design, OOP class hierarchies, ADO.NET database integration, structured testing, and professional documentation — the full software development lifecycle from blank canvas to completed product.

💡 This project demonstrates my ability to architect and deliver a complete, production-quality software system — covering layered architecture design, OOP implementation, relational database design, security practices, and comprehensive testing.

GitHub Email

📚 References

📄 License

MIT License — feel free to explore, fork, and build on this project.

🌿 GreenLife Organic Store Management System Designed & Developed by Naveen Nagendran · 2026

C# SQL Server .NET

"A comprehensive software solution that effectively addresses the operational needs of a modern organic store."

About

🌿 A full-featured desktop retail management system for organic stores — built with C#, .NET Framework 4.8, Windows Forms & SQL Server. Features dual Admin/Customer roles, product & inventory management, order processing, payment handling, automated email notifications, PDF report generation, and a complete OOP three-tier architecture.

green-life-organics.vercel.app

Topics

crud sql-server csharp dotnet oop winforms desktop-application inventory-management ado-net three-tier-architecture mailkit retail-management

Resources

Readme
Activity

Stars

0 stars

Watchers

0 watching

Forks

0 forks
Report repository

Releases

No releases published

Packages

 
 
 

Contributors

Languages