Skip to content

README.md

Latest commit

 

History

History
74 lines (58 loc) · 3.71 KB

README.md

File metadata and controls

74 lines (58 loc) · 3.71 KB

Together Culture - CRM Software

📌 Project Overview

This project is a Customer Relationship Management (CRM) software developed for Together Culture, a Community Interest Company focused on fostering an equitable and ecological creative economy. The goal of this project is to transition the company from a manual data management system to a digital CRM solution that streamlines member engagement, event management, and activity tracking.

🛠️ Features Implemented

  • 🔐 User Authentication - Members can log in to a password-protected portal.
  • 📊 Dashboard & Insights - Members can track their benefits, past event participation, and get event recommendations.
  • 📅 Event Management - Members can browse, book, and track events.
  • 🔍 Advanced Search & Filtering - Admins can search members, events, and participation history.
  • 🎭 Membership Tiers - Support for Community Members, Key Access Members, and Creative Workspace Members.
  • 📌 Digital Content Modules - Members can enroll in digital learning modules and track their engagement.
  • 📄 Admin Controls - Admins can add new members, track interests, and monitor engagement trends.

💻 Technologies Used

  • Programming Language: C# (.NET Framework)
  • Database: MySQL
  • Development Tools: Microsoft Visual Studio, GitHub
  • Design Tools: Lucidchart, Visual Paradigm, MermaidChart
  • Version Control: Git & GitHub

🗂️ System Architecture & Design

1️⃣ Wireframes

Wireframe

2️⃣ Entity-Relationship Diagram (ERD)

ERD

3️⃣ UML Diagrams

  • Use Case Diagram - Defines system functionalities for Members and Admins.
  • Class Diagram - Shows system entities, attributes, and relationships.
  • Sequence Diagram - Illustrates user interactions with the system.

🚀 Installation Guide

1️⃣ Clone the Repository:

[https://github.com/QuantumAlchemist03/CommunityEngageDB-Design.git]

2️⃣ Set Up the Database:

  • Import the MySQL database schema (database.sql).
  • Configure the database connection string in the appsettings.json file.

3️⃣ Run the Application:

  • Open the project in Visual Studio.
  • Click Start (▶️) to launch the application.

🛠️ Testing & Debugging

  • Unit Testing: Conducted automated tests to ensure system reliability.
  • Functional Testing: Verified user authentication, event booking, and admin features.
  • Performance Testing: Optimized database queries and page load times.

🛠️ Maintenance & Future Enhancements

✅ Bug Fixes & Patches - Regular updates to fix issues and optimize performance. ✅ Feature Upgrades - Potential enhancements include event recommendations using AI and a chatbot for member interactions. ✅ Security Audits - Periodic security checks to protect user data.

👨‍💻 Contributors

  • Alif Sathar - Event Page, Digital Content Module, UI/UX Design, Software Testing
  • Jakes Jacob Mathew - Backend Development, Database Optimization
  • Muhammed Aseem - Admin Dashboard, Authentication System
  • Niroshan Kekulawala - Member Management, User Role Implementation

📧 Contact

For questions or contributions, reach out via:

🚀 If you find this project helpful, don't forget to ⭐ star the repository!

License

This project is not open-source and is protected under a custom all-rights-reserved license.
Unauthorized use, copying, or distribution is strictly prohibited. See LICENSE.txt for details.