Inventory Management and Reports
Inventory Management and Reports
This is a program developed in C# using Windows Forms, designed to connect to a database and offer key functionalities such as report generation, item stock queries, and visualization of brands and categories.
Features
- Stock Management: Real-time queries of item availability.
- Advanced Classification: View items organized by brands and categories.
- Report Generation: Create customizable and exportable reports.
- Intuitive Interface: Built on Windows Forms, with controls like DataGridView for a user-friendly experience.
Technologies Used
- Language: C#
- Framework: .NET Framework
- Database: SQL Server
- Additional Libraries:
- ADO.NET for database interaction.
- [Optional] Crystal Reports or Report Viewer for report generation.
Database Structure
The program uses a well-structured database with the following main tables:
- Items: Contains basic product information.
- Stock: Records available quantities.
- Brands: Stores the different brands associated with items.
- Categories: Classifies items by type or category.
Installation
1. Clone the Repository:
git clone https://github.com/ORYEPA/Almacen_Forms.git
cd inventory-management
2. Set Up the Database:
3. Build the Project:
Open the .sln file in Visual Studio and build the solution.
4. Run the Application:
Start the program from Visual Studio or execute the .exe file located in the bin folder.
Usage
- Stock Queries: Filter items by brand or category and check current availability.
- Report Generation: Access the reports section, select desired filters, and generate a report in PDF or Excel format.