C# Test Automation Framework for End-to-End Invoice Validation and Data Consistency Checks.

CSharpValidationFramework

⚙️ C# Invoice Validation Framework

This repository contains a C#-based automation framework designed to validate end-to-end invoice processing flows across multiple database systems.

🔹 Tech Stack

• Language: C# (.NET 7.3)
• Database: SQL Server (InvoiceHeader, InvoiceDetail, MQMessage)
• Tools: Dapper, CSV Export, Azure DevOps
• Structure: Modular repository classes and console-based workflow

🔹 Key Features

• Tracks invoices from MQMessage → InvoiceHeaderStaging → InvoiceHeader
• Exports query results automatically into CSV for data comparison
• Provides humorous, timestamped console logs for better readability (QA style!)
• Supports multi-phase validation (summary generation, adjustments, re-summarization)
• Integrates seamlessly with Azure DevOps pipeline runs

🔹 How to Run

1. Clone this repo
2. Open in Visual Studio
3. Set the startup project to EndToEndValidationScript.cs
4. Build and run to validate invoices end-to-end

---

📫 Author: Luis Labrada
LinkedIn: linkedin.com/in/luis-labrada
Email: labradaluism@gmail.com