Tracking System

A comprehensive Request Management System for Radiation Safety Services that streamlines client request handling through a role-based approval workflow.

📋 Table of Contents

• Overview
• Features
• System Architecture
• Workflow Example
• Installation
• Technical Stack
• Database Schema
• Documentation
• Screenshots

🎯 Overview

The Tracking System is a web-based portal designed to manage service requests for Radiation Safety Services. It provides a structured approval process with role-based access control, allowing clients to submit requests while administrators can review, approve, and track them through completion.

Key Objectives

• Real-time Request Tracking: Monitor request status, approval history, and current assignee
• Streamlined Workflow: Automate the approval process across multiple administrative levels
• Online Registration: Enable self-service account creation with admin approval
• Role-Based Access: Assign appropriate permissions and workflow steps to each user type

✨ Features

• User Management

  • Self-service registration with admin approval
  • Email notifications for account activation
  • Role-based access control (Customer, Director, Technician)

• Request Management

  • Create and submit service requests
  • Multi-level approval workflow
  • Automatic request routing between departments

• Tracking & Audit Trail

  • Complete timestamp logging (registration, approval, completion)
  • View request history and current status
  • Track who viewed or processed each request

• Administrative Controls

  • Director backend for user and request approval
  • Technician backend for request fulfillment
  • Centralized request monitoring

🏗️ System Architecture

Frontend

• User-facing portal for registration and request submission
• Built with ASP.NET Web Forms
• Enhanced UI components using Telerik Controls

Backend

• Separate administrative interfaces for Directors and Technicians
• SQL Server database for data persistence
• C# business logic layer

🔄 Workflow Example

1. Customer Registration
   └─> System records timestamp
   └─> Account pending approval

2. Director Approval (User)
   └─> System records approval timestamp
   └─> Email notification sent to customer
   └─> Customer can now login

3. Customer Creates Request
   └─> System records request timestamp
   └─> Request pending director approval

4. Director Approval (Request)
   └─> System records approval timestamp
   └─> Request forwarded to Technician

5. Technician Processes Request
   └─> Fulfills service/item requirements
   └─> Closes request
   └─> System records completion timestamp

Note: After user approval, all stakeholders can track the request to see its current status, who has reviewed it, and its position in the workflow.

🛠️ Technical Stack

Component	Technology
IDE	Visual Studio 2015
Framework	ASP.NET Web Forms
Language	C#
Database	SQL Server 2012
UI Components	Telerik Controls

💾 Installation

Prerequisites

• SQL Server 2012 or higher
• Visual Studio 2015 or higher
• .NET Framework (compatible version)

Setup Steps

1. Database Setup

   - Install SQL Server
   - Create a new database
   - View the database diagram: https://github.com/touficSl/TrackingSystem/blob/master/DBTrack-Diagram.png
   - Execute the database scripts to create tables and relationships
   

2. Configure Application

   - Open Visual Studio 2015
   - Click File → Open → Web Site...
   - Select the project directory
   - Open web.config
   - Update the connection string with your SQL Server credentials:
     <connectionStrings>
       <add name="ConnectionString" 
            connectionString="Data Source=YOUR_SERVER;Initial Catalog=YOUR_DATABASE;..." />
     </connectionStrings>
   

3. Run Application

   - Press F5 or click the Run button in Visual Studio
   - The application will open in your default browser
   

📊 Database Schema

View the complete database diagram here:
Database Diagram

The database includes tables for:

• User management and authentication
• Request records and statuses
• Approval workflow tracking
• Timestamp audit trails
• Role assignments

📖 Documentation

Detailed Screen Descriptions & UML Diagrams

Complete system documentation including screen flows and UML diagrams:
System Documentation (Google Docs)

Video Tutorials

Watch the complete video tutorial series on YouTube:
Tracking System Tutorial Playlist

📸 Screenshots

(Add screenshots of your application here)

• Login Page
• Customer Dashboard
• Request Submission Form
• Director Admin Panel
• Technician Backend
• Request Tracking View

🤝 Contributing

Contributions are welcome! Please feel free to submit a Pull Request.

📝 License

(Add your license information here)

👤 Author

Toufic SL

• GitHub: @touficSl
• Project Link: https://github.com/touficSl/tracking-system

📧 Contact

For questions or support, please open an issue on GitHub or contact through the repository.

---

Note: This system was specifically designed for Radiation Safety Services but can be adapted for other service-based organizations requiring multi-level approval workflows.