Aplicación web utilizando Framework open source para la gestión de inventario en el almacén PIL’S Autorepuestos

Abstract

Inventory management is essential for the efficient operation of any business, as it directly impacts product availability, customer satisfaction, and ultimately financial results. As the company experiences continuous growth, inventory management becomes increasingly complex. The variation in products, suppliers, and locations requires a more advanced approach than conventional methods based on spreadsheets or manual systems. This project aligns with the research line in Information Technologies and Control Systems, aiming to implement a web application for inventory management using an Open Source framework at the "Pil's Autorepuestos" warehouse. The goal is to automate manual inventory management processes, incorporate administrative roles to improve spare parts traceability, and contribute significantly to decision-making. The Extreme Programming (XP) methodology is employed for planning, design, coding, and testing of the product, facilitating efficient supervision of deliverables at each stage of the process, ensuring compliance with the requirements defined by the warehouse manager. The application is structured into three key components: a robust and secure SQL Server database for information management, a backend developed in .NET Core using Entity Framework to provide a scalable and modular architecture, and a frontend implemented with Angular due to its modular structure. Bootstrap, along with the AdminLTE template, was used for design.