Route Sheet

Business Purpose & Overview

Route Sheet is an ASP.NET Web Forms application for automotive service departments to manage repair-order workflow, technician assignments, advisor queues, and vehicle delivery status. It gives service advisors and dispatchers a web-based route sheet for tracking vehicles through the repair lifecycle from intake to delivery.

Key Features & Capabilities

• Repair-order route sheet entry and tracking (RO number, tag number, vehicle model, repair description)
• Service advisor assignment with color-coded advisor catalog
• Technician assignment (primary and secondary) for each repair order
• Waiting status and delivery-status flags
• Date-range filtering and delivered-vehicle filtering on the main dashboard
• Add/edit/delete route sheet transactions with inline actions
• One-click delivery confirmation workflow
• Administration pages for advisor and technician master data
• SQL Server / SQL Express persistence with ObjectDataSource-bound GridView
• ASP.NET output caching and SQL cache dependency for performance

Technical Architecture

Route Sheet is an ASP.NET Web Forms application for automotive service departments to manage repair-order workflow, technician assignments, advisor queues, and vehicle delivery status. It is implemented as a single-tier application using C#, ASP.NET Web Forms and integrates SQL Server / SQL Express, System.Data.SqlClient, ObjectDataSource, GridView to deliver the functional capabilities described above.