A complete web-based inventory & order management and vessel tracking system for ship chandlers, built using ASP.NET Core MVC, SQL Server, and deployed on Azure.
🚀 Real-world logistics + maritime use case. CRUD-capable with smart dashboards, live vessel tracking (via IMO), and inventory system built around industry-standard IMPA codes.
- Project Name:
ShipChandlerHub - Domain: Ship Chandling, Logistics, Maritime Tracking
- Type: Full-Stack MVC Web App
| Layer | Tech Used |
|---|---|
| Frontend | ASP.NET Core MVC, Razor Pages, Bootstrap |
| Backend | C#, ASP.NET Controllers, Entity Framework Core |
| Database | SQL Server |
| Cloud | Azure App Service, Azure SQL Database |
Core Modules:
- 📊 Dashboard Overview
- 🛰️ Vessel Tracker (bulk IMO-based ETA & destination fetch)
- 📦 Inventory Management (IMPA-coded stock system)
- 📑 Order Management (Vessel-based item orders)
Displays key metrics:
- Total Vessels
- Total Orders
- Total Stock Items
Quick navigation to major modules.
| Input | Output |
|---|---|
| IMO numbers | Table showing: IMO, Destination, ETA |
Features:
- Bulk input of IMO numbers
- Export results
- Backed by API or Mock JSON
| Field | Description |
|---|---|
| Vessel IMO | Target vessel |
| Order List | Items associated with vessel |
| Status | Order progress (Pending, Shipped, etc.) |
| Created Date | Timestamp of order |
Features:
- Create/Edit/Delete Orders
- Add Inventory Items to Order (multi-select)
- Filter by vessel, status, date
| Field | Description |
|---|---|
| IMPA Code | Maritime standard inventory code |
| Item Name | Descriptive name |
| Quantity | Current stock |
| Category | (Food / Tools / Safety / etc.) |
Features:
- Add/Edit/Delete Items (Admin Only)
- Filter by IMPA, Category
- Add to Orders via junction table
- 🧩 Entity Framework Core for all DB interaction
- 📤 ViewModels to communicate between Views & Controllers
- 🎨 Bootstrap + Razor Pages for responsive UI
- 🔐 ASP.NET Identity for authentication & role-based access
- 🔄 LINQ Queries for filtering/search
- 🌐 HttpClient to consume API (or mock)
- ☁️ Azure App Service for deployment
- Admin/User logs in & views dashboard
- Tracks vessels by entering IMO numbers
- Adds/Updates inventory
- Creates orders for vessels with multiple items
- Filters/exports data as needed
| Skill | Description |
|---|---|
| ASP.NET MVC | Full-stack architecture |
| C# Programming | Backend logic + object-oriented design |
| EF Core ORM | Relational data access, LINQ, DB Seeding |
| SQL | Schema design, joins, migrations |
| Azure Deployment | Hosting App + Database on Azure |
| REST API | External data integration using HttpClient |
| Domain Knowledge | Logistics + Ship Chandling System Architecture |
📦 ShipChandlerHub
┣ 🔗 Connected Services
┣ 📦 Dependencies
┣ ⚙️ Properties
┣ 🌐 wwwroot
┣ 📁 Areas
┣ 📁 Controllers
┃ ┣ 📄 DashboardController.cs
┃ ┣ 📄 HomeController.cs
┃ ┣ 📄 InventoryItemsController.cs
┃ ┣ 📄 OrdersController.cs
┃ ┣ 📄 TestController.cs
┃ ┗ 📄 VesselTrackerController.cs
┣ 📁 Data
┃ ┣ 📁 Seed
┃ ┃ ┗ 📄 DbInitializer.cs
┃ ┗ 📄 ApplicationDbContext.cs
┣ 📁 Migrations
┣ 📁 MockData
┃ ┗ 📜 mock_vessels.json
┣ 📁 Models
┃ ┣ 📄 Company.cs
┃ ┣ 📄 ErrorViewModel.cs
┃ ┣ 📄 InventoryItem.cs
┃ ┣ 📄 Order.cs
┃ ┣ 📄 OrderItem.cs
┃ ┗ 📄 Vessel.cs
┣ 📁 Views
┃ ┣ 📁 Dashboard
┃ ┃ ┗ 📄 Index.cshtml
┃ ┣ 📁 Home
┃ ┣ 📁 InventoryItems
┃ ┃ ┣ 📄 Create.cshtml
┃ ┃ ┣ 📄 Delete.cshtml
┃ ┃ ┣ 📄 Details.cshtml
┃ ┃ ┣ 📄 Edit.cshtml
┃ ┃ ┗ 📄 Index.cshtml
┃ ┣ 📁 Orders
┃ ┃ ┣ 📄 Create.cshtml
┃ ┃ ┣ 📄 Delete.cshtml
┃ ┃ ┣ 📄 Details.cshtml
┃ ┃ ┣ 📄 Edit.cshtml
┃ ┃ ┣ 📄 Index.cshtml
┃ ┃ ┗ 📄 UpdateStatus.cshtml
┃ ┣ 📁 Shared
┃ ┗ 📁 VesselTracker
┃ ┃ ┣ 📄 Index.cshtml
┃ ┃ ┗ 📄 _ViewImports.cshtml
┃ ┃ ┗ 📄 _ViewStart.cshtml
┣ 📄 .gitignore
┣ 📄 appsettings.json
┣ 📄 Program.cs
┗ 📄 ScaffoldingReadMe.txt
This app is deployed to Microsoft Azure using Visual Studio:
- 🌐 Azure App Service – for Web Hosting
- 🗄️ Azure SQL Database – for cloud-hosted database
- 🔗 Vessel Tracker API (or JSON mock used)
- 📘 Microsoft Learn - ASP.NET Core Docs
- 🎨 Bootstrap – for frontend design
- 📚 Entity Framework Core Docs
- 🧠 ChatGPT