Skynet – Unified Operations Platform for Travel & Ticketing Service Businesses

Skynet (aka, Target CRM) is a mature, enterprise‑grade ERP system built for travel agencies, tour operators, and ticketing service‑based businesses. Developed by Extreme Solutions, Skynet seamlessly integrates CRM, multi‑service billing, comprehensive accounting, and operational workflows into a single web application. Whether you handle flight ticketing, hotel reservations, visa assistance, or even diagnostic lab services, Skynet automates the entire lifecycle – from booking to final ledger entry.

The platform is built on ASP.NET Web Forms (.NET Framework 4.8) with a SQL Server backend, delivering a reliable, high‑performance solution that has been refined through real‑world use.

Key Features at a Glance

Travel Service Management – Ticketing, hotel, visa, transport, and Hajj/Umrah pilgrim management.
Unified Billing Engine – One interface to invoice all service types with automatic accounting entries.
Full Accounting Suite – Ledgers, vouchers, profit & loss, balance sheets, and cash/bank management.
Accounts Receivable / Payable – Collections, payments, due tracking, and receipt printing.
Lab / Test Workflow – Test categories, patient entries, report delivery, and billing (optional module).
Customer & Supplier Management – Complete CRM with lead tracking and contact history.
Role‑Based Security – Granular permissions, login history, IP blocking, and user administration.
Document Management – Centralised uploads for contracts, employee records, purchase orders, and attachments.
Robust Reporting – Export to Excel, PDF; pre‑built financial and operational reports.
Multi‑Project / Tenant Support – Run multiple branches or business units from one installation.

Detailed Features

Travel Services & Billing

Flight Ticketing – Capture PNR, airline, class, fare breakdown (gross, tax, AIT, commission), and automatically calculate net payable.
Hotel Reservation – Manage check‑in/out, room types, guest details, and package rates.
Visa Assistance – Track passport info, visa type, application status, and required documents.
Transport Services – Schedule and bill for ground transportation.
Pilgrim Management – Specialised fields for Hajj/Umrah groups, including package tracking and documentation.

All service entries flow into a unified billing interface (Billing.aspx) that adapts to the service type. On saving, the system:

Generates a unique invoice number.
Inserts service‑specific records.
Automatically creates double‑entry accounting vouchers via the Accounting.VoucherEntry engine.
Updates customer/supplier balances and profitability metrics.

Accounting & Finance

Automated Vouchers – Every sale, collection, payment, or expense posts to the Transactions ledger with proper debit/credit heads.
Ledger Management – Real‑time balances for any account head (bank, cash, customer, supplier).
Accounts Receivable – Collect payments against multiple invoices; partial payments and due updates are handled seamlessly.
Accounts Payable – Pay vendors/agents and automatically adjust outstanding amounts.
Financial Reports – Profit & Loss, Balance Sheet, Day Book, Ledger, and custom date‑range reports.
Cash & Bank Transfers – Move funds between accounts and record adjustments with full audit trail.

Lab / Test Module (Optional)

Define test categories and test names with prices.
Create patient test orders (TestMaster, TestDetails) with auto‑calculated totals, discounts, VAT, and balances.
Print acknowledgment invoices and track report delivery.
Record collections and update test statuses.

Administration & Security

User Management – Create/delete users, assign permission levels (CanInsert, CanEdit, CanDelete), and map users to projects.
Login History – Track IP, login time, and session duration.
IP Blocker – Restrict access from specific countries or IP ranges (enhanced security).
Password Reset – Secure token‑based flow with email notifications.
Project / Tenant Context – All data is scoped by project; ideal for multi‑branch operations.

Reporting & Export

Pre‑built Reports – Ticketing report, sales history, payment history, due list, profit/loss, and more.
Excel Export – Uses ClosedXML for high‑fidelity spreadsheet generation.
Print‑Ready Formats – Invoices, receipts, and statements rendered as clean HTML for printing or PDF conversion (via integrated libraries like iTextSharp and NReco.PdfGenerator).

Document Management

Central Repository – Upload important company documents, employee records, purchase order attachments, and message attachments.
Metadata Storage – Files are physically stored on disk with references in database tables (ImportentDocuments, PO_Images, Photos).
Image Resizing – Automatic compression for uploaded images where needed.

Internal Communication

Messaging System – Send/receive internal messages with attachments and read/unread tracking.
Task Management – Create, assign, and track tasks directly from the dashboard.

Benefits

For Business Owners

Unified Operations – One system for travel, finance, and administration eliminates silos and manual reconciliation.
Real‑Time Financial Visibility – Profit & Loss and balance sheets are always up‑to‑date.
Scalable Multi‑Project Support – Easily manage multiple branches or brands without separate installations.
Audit Trail – Every action (login, transaction, status change) is logged for compliance and review.
White‑Label Ready – Customise branding, logos, and report headers per project.

For Managers & Accountants

Automated Accounting – No need to double‑entry; billing events instantly update ledgers.
Efficient Collections/Payments – Stage multiple invoices, post payments, and print receipts in one go.
Comprehensive Reporting – Generate Excel reports for analysis or share with stakeholders.
Expense & Purchase Tracking – Link expenses to projects and monitor cash flow.

For Operational Staff

Fast Data Entry – Service‑specific forms with dropdowns, auto‑calculated fields, and minimal clicks.
Print & Email Integration – Instantly print or email invoices and receipts.
Document Attachment – Easily upload and retrieve files related to customers, bookings, or employees.
Task & Message Alerts – Stay informed about pending tasks and internal communications.

For Developers / Buyers of the Source Code

Full‑Stack Legacy Solution – Complete C# Web Forms codebase with direct SQL access – easy to customise and extend.
Breadth of Functionality – CRM + billing + accounting + lab – a ready‑made foundation for vertical ERPs.
Extensible Helpers – Shared classes (RunQuery, Accounting, Stock) speed up development.
Third‑Party Integrations – Excel export, PDF generation, SMS gateway, and SMTP email already wired.

Technical Specifications

Component	Technology
Backend Language	C# (ASP.NET Web Forms)
.NET Framework	4.8
Database	Microsoft SQL Server (via `System.Data.SqlClient`)
Authentication	ASP.NET Membership Provider + Forms Authentication
Frontend Libraries	jQuery, AjaxControlToolkit, DataTables, jqPlot, select2, Plupload
Reporting & Documents	ClosedXML (Excel), iTextSharp (PDF), NReco.PdfGenerator, Ionic.Zip
Architecture	Monolithic N‑Tier: Presentation (`.aspx`), Business Logic (`App_Code`), Data Access (`RunQuery.cs`), Database
Deployment	IIS 7+; requires .NET 4.0 AppPool (Integrated Mode)

Architecture Overview

Skynet follows a classic layered architecture:

text

User Action (Web Form)
    → Code‑behind Event Handler
        → Business Logic (App_Code classes)
            → Data Access (RunQuery.SQLQuery)
                → SQL Server Tables
            → Optional Accounting.VoucherEntry
                → Transactions & Voucher tables
        → Output (GridView, Print HTML, Excel, Email)

Presentation Layer: .aspx pages and master pages with server controls.
Business Logic Layer: Helper classes in App_Code (e.g., Accounting.cs, Stock.cs) that encapsulate core rules.
Data Access Layer: RunQuery.cs provides methods for executing SQL commands, populating dropdowns, and binding GridViews.
Database Layer: SQL Server stores all transactional and master data in a well‑normalised schema.

The system’s billing‑to‑cash lifecycle is fully automated:

text

Invoice Creation (service tables)
    → Transactions (ledger entries)
        → Collection/Payment Staging (TempInv)
            → Collection/Payment Posting
                → Status & Due Update in Invoices
                    → Real‑time Ledger & Report Visibility

Use Cases & Industries

Travel Agencies & Tour Operators – Manage flight ticketing, hotel bookings, visa processing, and package tours.
Hajj & Umrah Service Providers – Specialised pilgrim management with group tracking.
Diagnostic Labs / Healthcare – Use the lab module to handle test orders, reporting, and billing.
Multi‑branch Service Businesses – Run several offices under one system with project‑level data isolation.
ERP Resellers / Developers – Acquire the source code to build customised solutions for service industries.

Why Choose Skynet?

Proven in Production – Developed and refined over years of real‑world use in travel and service businesses.
Hybrid Domain Expertise – Uniquely combines travel service workflows with a full‑fledged accounting engine.
Minimal External Dependencies – Self‑contained; no reliance on expensive third‑party APIs for core functionality.
Immediate ROI – Reduce manual data entry, eliminate reconciliation errors, and gain instant financial insights.
Customisable & Extensible – Full source code available – modify, rebrand, and sell your own version.

Get Started Today

Skynet is available for immediate deployment or as a source‑code purchase. Whether you’re a travel agency looking to streamline operations or a developer seeking a robust foundation for your next ERP product, Skynet delivers.

Contact us for a live demo, pricing, or to request the complete source code package.

Pricing for Skynet

Tier 1: Source Code Purchase (One-Time)

Price: $1,497 USD

Includes:

Complete ASP.NET Web Forms source code (.NET Framework 4.8)
Full SQL Server database schema and stored procedures
Commercial license with white-label rights
Distribution rights (you can sell to your own clients)
6 months of email support and bug fixes
12 months of access to security updates
Basic documentation (as extracted from code analysis)

Rationale:

Positioned above the $499 Enterprise CRM
Below the $2,000 psychological threshold while maintaining premium positioning
Travel industry specialization commands higher value than generic ERP
White-label rights add significant value for agencies and resellers
Multi-project/tenant architecture justifies higher price than single-tenant solutions

Tier 2: Source Code + Development/Customization Package

Recommended Price: $7,497 – $14,997 USD

Package Includes:

Everything in Tier 1
40-80 hours of development/customization (based on selected tier)
Modernization services (choose from menu):

Customization Option	Description	Typical Hours
Security Hardening	Parameterize SQL queries, remove SQL utility pages, fix injection vulnerabilities	15-25 hours
UI Modernization	Update legacy UI with responsive design, modern CSS framework	20-40 hours
New Module Development	Build additional service types or custom reports	30-60 hours
Third-Party Integration	Connect to payment gateways, SMS providers, accounting APIs	20-50 hours
Data Migration	Import legacy data from Excel/other systems	15-40 hours
Cloud Deployment	Configure for Azure/AWS hosting with proper security	10-20 hours
Multi-Tenant SaaS Conversion	Convert to multi-tenant architecture (requires extended engagement)	80-150+ hours

Priority support for 12 months
Code review and architecture consultation (2 hours)
Deployment assistance to your production server

Tier Options:

Starter Customization ($7,497): 40 hours + security hardening + 1 integration
Professional Customization ($11,997): 60 hours + all of above + UI modernization + 2 integrations
Enterprise Customization ($14,997): 80 hours + priority queue + all options + dedicated developer