UretimKontrol is an ASP.NET Core MVC-based Production Control and Reporting Application designed for seamless integration with physical PLC (Programmable Logic Controller) systems on a manufacturing line. Its primary goal is the digital management of production orders and the analysis of performance data (line, product, shift) stored in a SQL database.
It digitizes the entire production lifecycle, from order creation to final reporting. The system synchronizes web-based production orders with real-time confirmation data from the PLC, eliminating manual intervention and providing reliable, automated reporting.
This project demonstrates Enterprise Application Development (MES/ERP) expertise using the modern Microsoft stack.
| Component | Technology | Detail |
|---|---|---|
| Backend / Framework |  C# - ASP.NET Core MVC | Follows a robust MVC pattern for control and web display. |
| Database & ORM |  - Entity Framework Core | Manages core ERP tables (MARA, MKAL, UretimEmri) via a DbContext (ChikettoContext). |
| Frontend / Views | Razor Views (GenelOzet, AyrintiliHat, etc.) | Provides interactive data viewing and reporting UI. |
| Performance | async/await & PagedResult | Optimized for fast reporting and data handling via asynchronous queries and LINQ filtering. |
- PLC Integration: Synchronized operation with physical PLCs, utilizing confirmation data (HMI-derived records) for accurate tracking.
- ERP Synchronization (SAP): Manages data integrity by tracking and cleaning cancelled pallet records via SAP OData Service integration.
- Data Modelling: Built with strong relational models for key entities (UretimEmri, Mara, Mkal, Hat, Kullanici).
- Order Creation: Management of new production orders based on products and versions from the MARA table.
- Automated Metrics: Calculates metrics such as liters, cartons, pallets, and total weight automatically.
- Advanced Reporting: Generates detailed and general production reports in Excel format (ClosedXML), filterable by line, product, shift, and date.
- User Management: Session-based user authentication and role-based authorization (Admin, Operator).
This system is ideal for line-based manufacturing facilities, particularly within the food and beverage sectors. Its architecture is highly extensible, facilitating future integration with major MES or ERP systems.
This project is a high-value commercial application currently in use by a client. For reasons of commercial secrecy and proprietary code protection, the source code is kept in a private repository.
https://www.linkedin.com/in/misolmaz/ – I welcome confidential discussions with technical leads regarding the system architecture, performance optimization, and integration challenges.