WPF client-server application for ensuring operational interaction with databases

Keywords: client-server application, data analysis, production planning, Microsoft Visual Studio, C#, WPF, XAML, .Net Framework, Microsoft SQL Server

Abstract

The article describes the implementation of an interactive WPF client-server application for ensuring the planning of production processes (machines as production units on the line) in industry. The task of operational interaction with databases is solved. The server part is responsible for storing, processing, and providing data, while the client part is responsible for displaying and interacting with the user. The client-server application is designed to store and present detailed information about production order plan records in the production planning system, aggregating a large amount of data related to each specific task. The data is presented in the form of a formatted table with headings of plan categories and execution statuses. The interactivity of selecting individual row elements and updating visual data in real time is implemented. A UML class diagram of the client-server application structure is presented, namely a set of classes and their attributes, fields, properties, methods, and events. Class objects can notify other application components, including user interface elements, about changes to their property values, which is key to WPF's data binding mechanisms. Providing quick access to up-to-date data allows you to make informed decisions and perform work tasks efficiently

References

1. Guzman E., Andres B., Poler R. Models and algorithms for production planning, scheduling and sequencing problems: A holistic framework and a systematic review. Journal of Industrial Information Integration. Vol. 27, 2022, pp. 100287.
2. Ninan Theradapuzha Mathew, Björn Johansson. Production Planning and Scheduling Challenges in the Engineer-to-Orde-r Manufacturing Segment. A Literature Study. International Journal of Innovation, Management and Technology. Vol. 14. No. 3, 2023, pp. 80-87. doi: 10.18178/ijimt.2023.14.3.942
3. Nina Zdolbitska, Oleksandr Ostapchuk, Svitlana Lavrenchuk, Taras Terletskyi, Oleh Kaidyk, Oksana Zhyharevych. Business Information System for Forecasting Raw Material Stocks for the Production of Flexible Packaging. 14th International Conference on Dependable Systems, Services and Technologies (DESSERT). 2024.
4. Simulation Modeling and Analysis for Performance Measurement in the Production Line. URL: https://www.researchgate.net/publication/326622320_Simulation_Modeling_and_Analysis_for_Performance_Measurement_in_the_Production_Line (дата звернення: 10.05.2025).
5. Jiang N. Y., Yan H. S. Integrated optimization of production planning and scheduling in uncertain re-entrance environment for fixed-position assembly workshops. Journal of Intelligent & Fuzzy Systems. Vol. 42(3), 2022, pp. 1705-1722.

Abstract views: 28
PDF Downloads: 18
Published
2025-06-16
How to Cite
Zdolbitska , N., Zdolbitskyi А., & Heiko , B. (2025). WPF client-server application for ensuring operational interaction with databases. COMPUTER-INTEGRATED TECHNOLOGIES: EDUCATION, SCIENCE, PRODUCTION, (59), 120-125. https://doi.org/10.36910/6775-2524-0560-2025-59-16
Section
Computer science and computer engineering