SEBS API 🍽️

A robust ASP.NET Core 9.0 REST API backend for SEBS (Special Event Booking System) - a comprehensive event booking and catering management platform designed for food cart and catering businesses.

📋 Overview

SEBS API powers an event booking system that allows customers to request catering services for various events (weddings, birthdays, corporate events, etc.) while providing administrators with tools to manage bookings, services, and gallery content.

Key Features

• 📅 Event Booking System - Complete booking workflow from request to completion
• 👥 Role-Based Access Control - Admin and customer-specific endpoints with JWT authentication
• 🖼️ Gallery Management - AWS S3-integrated image storage for service showcases and event highlights
• 📧 Transactional Emails - Automated notifications via Brevo (SendinBlue) for booking confirmations, approvals, and rejections
• 🔔 Real-time Notifications - In-database notification system for admin alerts
• 📊 Analytics Integration - Visit logging and analytics tracking

🏗️ Architecture

┌─────────────────────────────────────────────────────────────┐
│                        Client Apps                          │
│              (React Dashboard / Customer Website)           │
└──────────────────────────┬──────────────────────────────────┘
                           │ HTTPS
                           ▼
┌─────────────────────────────────────────────────────────────┐
│                      SEBS API (.NET 9)                      │
├─────────────────────────────────────────────────────────────┤
│  Controllers    │  Services      │  Data Access            │
│  ├─ Auth        │  ├─ JWT Auth   │  ├─ EF Core             │
│  ├─ Booking     │  ├─ Email      │  ├─ PostgreSQL          │
│  ├─ Gallery     │  ├─ S3 Storage │  └─ Migrations          │
│  ├─ Services    │  └─ Analytics  │                         │
│  └─ Public      │                │                         │
└─────────────────┴────────────────┴─────────────────────────┘
                           │                    │
              ┌────────────┴────────┐           │
              ▼                     ▼           ▼
        ┌──────────┐         ┌──────────┐  ┌──────────┐
        │  AWS S3  │         │  Brevo   │  │PostgreSQL│
        │ (Images) │         │ (Email)  │  │   (DB)   │
        └──────────┘         └──────────┘  └──────────┘

🚀 Getting Started

Prerequisites

• .NET 9.0 SDK
• PostgreSQL (v14+)
• AWS Account (for S3 image storage)
• Brevo Account (for transactional emails)

Installation

1. Clone the repository

   git clone https://github.com/Jomar77/SEBS-API.git
   cd SEBS-API/SEBS-API

2. Configure environment variables

   Create a .env file in the SEBS-API directory:

   # Database
   ConnectionStrings__SEBSDbContext=Host=localhost;Database=sebs;Username=your_user;Password=your_password
   
   # JWT Authentication
   JWT_KEY=your-super-secret-jwt-key-minimum-32-characters
   JWT_ISSUER=https://your-api-domain.com
   JWT_AUDIENCES=https://your-frontend-domain.com
   
   # AWS S3
   AWS_ACCESS_KEY_ID=your-aws-access-key
   AWS_SECRET_ACCESS_KEY=your-aws-secret-key
   
   # Brevo Email
   BREVO_API_KEY=your-brevo-api-key

3. Update appsettings.json for AWS bucket configuration:

   {
     "AWS": {
       "BucketName": "your-bucket-name",
       "Region": "us-east-1"
     }
   }

4. Apply database migrations

   dotnet ef database update

5. Run the application

   dotnet run

   The API will be available at http://localhost:5139 (or configured port).

Docker Deployment

# Build the image
docker build -t sebs-api .

# Run the container
docker run -d -p 8080:8080 \
  -e ConnectionStrings__SEBSDbContext="your-connection-string" \
  -e JWT_KEY="your-jwt-key" \
  -e AWS_ACCESS_KEY_ID="your-aws-key" \
  -e AWS_SECRET_ACCESS_KEY="your-aws-secret" \
  sebs-api

📡 API Endpoints

Authentication

Method	Endpoint	Description
POST	/api/auth/login	Admin login with JWT token response

Customer Booking

Method	Endpoint	Description
POST	/api/booking/request	Submit a new booking request
GET	/api/booking/lookup	Look up booking by reference

Admin Booking Management

Method	Endpoint	Description
GET	/api/admin/booking	Get all bookings (with filters)
GET	/api/admin/booking/requests	Get pending booking requests
GET	/api/admin/booking/{id}	Get booking details
PATCH	/api/admin/booking/{id}/status	Update booking status

Services

Method	Endpoint	Description
GET	/api/service	Get all services
POST	/api/service	Create new service
PUT	/api/service/{id}	Update service
DELETE	/api/service/{id}	Delete service

Gallery & Highlights

Method	Endpoint	Description
GET	/api/highlights	Get all highlights
POST	/api/highlights/upload	Bulk upload highlight images
DELETE	/api/highlights/{id}	Delete highlight
GET	/api/event-gallery	Get event galleries

Public Endpoints

Method	Endpoint	Description
GET	/api/public/services	Get services for website display
GET	/api/public/highlights	Get highlighted images
GET	/api/public/images/{s3Key}	Serve images from S3

📊 Data Models

Core Entities

User ─────────┬──────── Role
              │
              ▼
          Booking ──────── Event ──────── EventService ──────── Service
              │               │
              │               └──── EventGallery ──── EventImage ──── GalleryImage
              │                                                            │
              └─── Notification                                      Highlight

Event Types

• Wedding
• Birthday
• Corporate
• Baby Shower
• Engagement
• Anniversary
• Debut
• Other

Booking Statuses

• Pending - Awaiting admin approval
• Confirmed - Approved and scheduled
• Declined - Request rejected
• Cancelled - Cancelled by customer/admin
• Completed - Event finished successfully
• No Show - Customer unreachable

🔐 Security

• JWT Authentication - Stateless token-based auth with configurable expiration
• BCrypt Password Hashing - Secure password storage
• Role-Based Authorization - Policy-based access control (Admin, Manager)
• CORS Configuration - Configurable cross-origin policies
• Environment Variables - Sensitive data kept out of source code

🛠️ Tech Stack

Category	Technology
Framework	ASP.NET Core 9.0
Database	PostgreSQL with EF Core
Authentication	JWT Bearer Tokens
File Storage	AWS S3
Email Service	Brevo (SendinBlue)
Image Processing	SixLabors.ImageSharp
Documentation	Swagger/OpenAPI
Containerization	Docker

📁 Project Structure

SEBS-API/
├── Controllers/
│   ├── Base/              # Base controllers for inheritance
│   ├── Booking/           # Customer and admin booking endpoints
│   └── Gallery/           # Image and gallery management
├── Data/
│   ├── SEBSDbContext.cs   # EF Core database context
│   └── DbInitializer.cs   # Database seeding
├── DTOs/                  # Data transfer objects
├── Enum/                  # Enumerations (BookingStatus, EventType)
├── Models/                # Entity models
├── Services/
│   ├── Auth/              # JWT authentication
│   ├── email/             # Brevo email service
│   ├── ImageProcessing/   # S3 integration
│   └── Analytics/         # Analytics services
├── Utils/                 # Utility classes
└── Migrations/            # EF Core migrations

🧪 Development

Running Locally

# Restore packages
dotnet restore

# Run in development mode
dotnet run --environment Development

API Documentation

When running locally, access Swagger UI at:

http://localhost:5139/swagger

Database Migrations

# Add a new migration
dotnet ef migrations add MigrationName

# Update database
dotnet ef database update

# Revert migration
dotnet ef database update PreviousMigrationName

🤝 Contributing

1. Fork the repository
2. Create a feature branch (git checkout -b feature/amazing-feature)
3. Commit your changes (git commit -m 'Add amazing feature')
4. Push to the branch (git push origin feature/amazing-feature)
5. Open a Pull Request

📄 License

This project is licensed under the MIT License - see the LICENSE file for details.

📞 Contact

Jomar - @Jomar77

Project Link: https://github.com/Jomar77/SEBS-API

---

Made with ❤️ for the food service industry