Vendor Entry Automation is a sophisticated solution developed for automating the Berger Vendor Approval Process. It utilizes CSOM for SharePoint List integration and MS SQL for data management, implementing a 4-tier architecture for robust performance. The project leverages SQL Server with Dapper for database operations and integrates SharePoint client libraries for real-time data synchronization between SharePoint lists and SQL Server databases. SMTP servers are used for seamless email communication.
The main functionality of Vendor Entry Automation revolves around facilitating Berger's vendor approval process. Users can select materials, initiate approval requests, and navigate through multiple approval layers. The system includes change request functionality and maintains comprehensive logs for transparent tracking and auditing.