TelecomManager

🗄️ Archived — retired project. This repo is preserved for historical reference. No active development.

A Windows .NET desktop application used by a former employer's telecommunications department to track work orders, generate stats reports, and manage telecom service requests. Built and maintained from 2007 through 2018.

Stack

• Language: C# (.NET Framework 4.x, Windows Forms)
• Reporting: Crystal Reports (CrystalDecisions.* references)
• Backends: SQL Server (multiple databases — call-record, ECAS, switchboard, telecom)
• Email: Microsoft Outlook COM interop for sending work-order status emails

Layout

telecom-manager/
├── versions/                                ← source code snapshots (22+ dates)
│   ├── 2016-03-04 TelecomManager/
│   ├── 2016-03-08 TelecomManager/
│   ├── ...
│   ├── 2018-08-02-125 TelecomManager/      ← last version
│   └── 2018-08-03 TelecomManager/
└── README.md

Each dated folder is a self-contained snapshot of the Visual Studio solution at that point in time — Globals.cs (connection strings), the work-order forms, the stats reporting forms, and the About dialog. The naming convention YYYY-MM-DD[-build] indicates the snapshot date and (for later ones) the build number.

Notable features

• Work-order CRUD with status workflow
• Crystal Reports-driven PDF report generation
• Outlook-based email notifications to a routing-list of recipients (sanitized to placeholders in this repo)
• ECAS / Endeavor database queries for call-record reconciliation
• Multi-year version history showing the project's evolution

Sanitization note

This codebase has been sanitized before publication:

• Real employee email addresses (To/CC defaults in frmStats.cs) replaced with recipient1@example.com, recipient2@example.com, recipient3@example.com, developer@example.com
• Internal SQL Server hostnames replaced with <sql-server> placeholder
• Former-employer attribution (AssemblyCompany, AssemblyCopyright, About dialog) replaced with generic "Former Employer"
• Internal logo image files (.bmp/.gif) and their .resx / .csproj / Designer.cs references removed
• Internal work-order tracking URLs replaced with telecom.example.com placeholder
• Compiled .exe and .dll binaries removed (source-only repo)

The code cannot be built as-is without the original Crystal Reports licenses, SQL Server schemas, and proprietary employer assets — it's published for portfolio / historical purposes only.

Status

Retired. Last touched 2018. The system it ran on is decommissioned.