Inventory Management System is a Windows Forms desktop application built using C# (.NET) and backed by Oracle SQL. It allows small businesses and shops to manage their stock, categories, and customer records through an intuitive and stylish graphical user interface.
- Oracle Database XE for free database support
- Bunifu UI Framework for modern UI components
- Microsoft Visual Studio for a smooth development experience
- GitHub for version control and collaboration
FodyWeavers.xml: Used for embedding dependenciesApp.config: Contains Oracle connection string.csproj: Manages dependencies through PackageReference
- Usama Akram BSCS Student, FAST National University, Pakistan GitHub: @usamacodez
- Primary Theme:
#3B82F6(Blue) - Sidebar BG:
#1F2937(Dark Gray) - Button Hover:
#60A5FA(Light Blue) - Status Texts: Green for success, Red for alert
Contributions are welcome! If you'd like to add a module, fix a bug, or improve UI:
- Fork the repo
- Create a feature branch
- Commit and push
- Open a pull request
(Will add video or gif link here soon)
This is a desktop application and does not require deployment to a server. It can be compiled and run directly from Visual Studio or can be installed by created setup.
- Oracle DB setup queries in
/docs/oracle-schema.sql - UI structure described in
Forms/ - App logic located in
InventoryManagementSystem/
Oracle DB connection string is stored in App.config. Example:
<connectionStrings>
<add name="OracleDbContext"
connectionString="Data Source=localhost:1521/XEPDB1;User Id=your_user;Password=your_pass;"
providerName="Oracle.ManagedDataAccess.Client" />
</connectionStrings>Q: Does this run on Linux? A: No, this project is built using Windows Forms, which is Windows-only.
Q: Can I change the database to MySQL or SQL Server? A: Yes, but you’ll need to change the data access code and connection string.
- Login authentication
- Add/edit/delete Categories
- Add/edit/delete Customers
- Manage product inventory
- Display dashboards with stats
- Responsive UI with animations
- Database integration with Oracle
If you have any suggestions or feedback, feel free to reach out at: [email protected] Or open an issue in this repository.
- Languages: C#, SQL
- Tools: Visual Studio, Git, VS Code
- Frameworks: .NET
- DBMS: Oracle
- Clone the repo:
git clone https://github.com/usama-codez/inventory-management-system.git- Open the solution in Visual Studio
- Restore NuGet packages
- Run Oracle DB locally or connect to cloud
- Update
App.configwith DB credentials - Press F5 to run the project
- Working with Oracle DB integration in C#
- Building layered desktop applications
- Using Fody for dependency management
- Creating modern Windows Forms UIs with Bunifu
This project is licensed under the MIT License. See the LICENSE file for details.
- Switched from
packages/toPackageReferencefor cleaner project structure - Embedded DLLs using Costura.Fody to make a single-exe deployable app
- Lazy loading of forms to reduce memory footprint
- Basic Inventory CRUD
- Oracle Integration
- Sales Module
- Expiry Date Notifications
- User Role Management
- MAUI mobile version (future)
Make sure Oracle DB is running locally and that your Oracle listener is configured correctly. Update the config and run with F5 or from terminal: Try Running this application on Visual Studio 2015 to avoid crashes and errors.
dotnet buildFor help or questions:
- Email: [email protected]
- GitHub Issues: Create new issue
- .NET Framework / .NET 6 (Windows Forms)
- Oracle SQL
- Bunifu UI Framework
- Fody & Costura
- Visual Studio 2015
This project is UI-based and does not include automated unit tests. Manual testing was conducted per module.
- Launch app
- Login using credentials
- Navigate sidebar to manage categories/customers/inventory
- Use dashboard to monitor stock levels
- Data is stored and retrieved via Oracle queries