jve386 / hotelsol_app

.NET & Python synergy for room reservation management, leveraging ADO.NET, ASP.NET, BCL, C#, Python scripting for Odoo API integration, and Entity Framework Core. Connects with Odoo for CRUD operations. UML, Use Case, and Sequence Diagrams for a comprehensive overview.

RocketTeam-HotelSOL_APP

🛠 Technical Overview

This project synergizes technologies from both the .NET and Python ecosystems to deliver a room reservation management application. The .NET components facilitate distributed data programming, with access to SQL Server databases and native XML databases. The core objective is to integrate with Odoo, utilizing Python for CRUD operations and system interaction.

🚀 Technologies Used

• .NET Ecosystem Components: Employed for robust application development, including ADO.NET, ASP.NET, BCL, and C# Windows Forms.

• ADO.NET: Used to access and manage databases within .NET applications, ensuring efficient data handling.

• ASP.NET: Leveraged for the creation of web applications within the .NET environment.

• Base Class Library (BCL): Utilized for fundamental functionalities shared across all .NET applications, simplifying development.

• C# Windows Forms: Chosen for creating desktop applications tailored for the Windows platform.

• Python: Utilized for its versatility and ease of integration with Odoo.

• Odoo API: Leveraged for seamless connectivity and interaction with the Odoo platform.

• MVC Pattern: Implemented using the Model-View-Controller architectural pattern for effective code organization and separation of concerns.

🧐 Conclusions and Justification for Choices

• System.Xml Library: Selected for its robust support in working with XML data in .NET, offering user-friendly functionality for basic read and write operations.

• Entity Framework Core: Opted for its XML data manipulation, providing an effective means to model and manipulate data through data models and queries, especially advantageous for complex read and write operations.

• XmlReader and XmlTextWriter: Adopted for efficient handling of large XML files and precise control over data read and write operations. These classes facilitate sequential data processing without loading the entire document into memory.

🧩 Object-Relational Mapping (ORM) Used

• Entity Framework Core

This collaborative effort intertwines technologies from both ecosystems to deliver a comprehensive room reservation management solution. The project integrates with Odoo, utilizing Python for CRUD operations and system interaction.

📊 UML DIAGRAM

📈 USE CASE

🔄 SEQUENCE DIAGRAM