Coordina (CCRP)
Community Collaboration & Resource Platform – An enterprise-grade, role-based platform for organizing events, booking resources, tracking donations, and coordinating tasks.
Technologies Used
Problem
In many community organizations, coordinators struggle with fragmented tools (managing files in Excel, chat communication in WhatsApp, calendars in Google Calendar, and resource bookings on paper). This fragmentation leads to:
- Double bookings of shared resources (halls, equipment, vehicles).
- Missed deadlines and lack of clear progress tracking.
- Scattered communication that gets lost in chat logs.
- Lack of transparency in donation drives and event evidence collection.
Solution
Coordina solves this by providing a unified, secure, role-based platform. It implements real-time synchronization via SignalR, a smart AI assistant powered by n8n and Google Gemini, drag-and-drop form builders, and structured analytics dashboards to streamline community coordination.
Results and Impact
- ✓Resource Conflict Elimination: Prevented double-bookings of halls and assets in real-time using custom concurrency filters on the database level.
- ✓Unified Organizational View: Centralized multi-level interactive calendars and Kanban boards, increasing operational visibility.
- ✓Increased Campaign Transparency: Motivated community members with real-time donation progress bars, simulated leaderboards, and verified evidence links.
Challenges
- Concurrency Without ORM: Building robust booking validation logic using raw ADO.NET Npgsql queries rather than relying on Entity Framework required careful coordination of database transactions and connection lifetimes.
- WebSocket JWT Authentication: Since standard WebSockets do not support sending headers during upgrade handshakes, we authenticated SignalR connections by intercepting the JWT token in query strings during the initial handshake upgrade phase.
- Structured AI Extraction: Designing an n8n AI Agent workflow that uses Gemini to accurately extract parameter objects (name, type, description, ISO 8601 dates) and make authorized HTTP calls back to our REST API.
Key Features
User & Role Management (RBAC)
JWT secured flows with short-lived access tokens and long-lived refresh tokens. Global roles (Admin, Organizer, Participant, Viewer) map to granular entity-level memberships (e.g. project creators auto-assigned Admin for their entities).
Multi-Level Synchronized Calendar
Global Dashboard Calendar showing all events/drives, supplemented by project and task-level schedules. Real-time updates push via SignalR when cards are rescheduled, and events export to .ics format.
Resource Booking System
Shared inventory registry preventing overlapping bookings. Status transitions from Pending to Approved/Rejected, pushing real-time change notifications to occupants through SignalR hubs.
Drag-and-Drop Form Builder
Visual interface for organizers to compose event registration or feedback forms. Responses are structured, logged to PostgreSQL, and exportable as CSV/PDF or visual analytical charts.
Real-Time Event & Task Chat
WebSocket-based chat rooms for projects/events alongside Kanban card comment threads, allowing targeted team discussions and micro-collaboration.
Donation Management
Campaign status tracker displaying goals and live progress, complete with donor leaderboards and Padlet receipt integration for validation.
AI-Powered Smart Assistant (n8n & Gemini)
A floating chatbot in the React UI linked to an n8n webhook. Employs Gemini to interpret natural user request prompts, extracts clean fields, and submits authorized creation payloads directly to our REST API.
Technical Implementation & Architecture
Frontend Presentation Layer
Built with React.js using Vite. The application leverages Material-UI components for structured layout consistency, Tailwind CSS for tailorable styling, FullCalendar.js for rendering synchronized schedules, and Chart.js for data insights.
Business Logic & Communication Layer
Powered by an ASP.NET Core 8.0 Web API written in C#. Bidirectional streaming updates are driven by ASP.NET Core SignalR hubs. Operations are secured using customized JWT middleware interceptors.
Data Access & Migrations
Utilizes PostgreSQL database accessed directly through raw ADO.NET and Npgsql (NpgsqlConnection, NpgsqlCommand). To eliminate setup friction, migration queries automatically assert the existence of tables and index objects on service initialization.
CI/CD & Testing Hierarchy
Fully containerized using multi-stage Docker configurations. Orchestrated local deployments run alongside Jenkins pipelines that enforce quality checks: executing unit tests, integration checks (Jest + Axios) against live API controllers, and automated E2E user flows via Selenium WebDriver (Chromedriver).
Project Links
Explore the code repositories or watch the walkthrough of the platform.