Spring

Our new project is built to serve MVVM pattern and Oracle sql commands with new .dll easy static funcs.

About The Project: 💼

• It took 2 years to combine binding properties and commands [MVVM] with a/an speed and reliability UI experience
  we use dotNet concepts ex. weavers and memory management system with some dlls and tweaks.

Database Version: 💉

• In this project we use Oracle Database through Oracle with (ManagedDataAccess.dll) and a C# pure dll (AccioOracleKit.dll) both can work together to achieve repeatitve queries as string same as SQL* and manage connection object.

Screens shots: 📷

• Login
  
  

• User page
  
  

• PDF extract demo
  
  

• Charts demo
  
  

* Design on Site

What you need to know:.🫡
#1 this SW using database managed dll for oracle version 10g.
#2 you should know how to build all tables to act inside scripts.
#3 working in adding .cs file to handle main SQL commands and quiries.

- [View Architecture] 🎲

Icons pack used in right options butttons with their indices..

- [Layers] 🪢

Very Impertant!
#1 first thing first you must build your database.
#2 I will put down the structure script you may need to change it.
🫳Link to ERD

#3 we use 'params.info' for initialize the server parameters and some other data about the current corporation.

params.info :

 
**this file is to initialize the current database connection to make app connect to its server**
**don't try to move lines down or up this will miss the whole file just change data values**
[
#server_ip::127.0.0.1,
#port::1521,
#company_name::Haam Corporation,
#version::1.1.0,
#console::False,
]

Server Side 😎🚀

• We're working on a small tool will allow any IT help desk
  to make easy .dmp file every time and control any session on server too.
• Note: you need to install VC++ Redist 2012 ~ 2022.

To Do List: ⛏️

• Add params file in the project.
• Convert Scripts.cs to .dll library. (Now migrating to .dll as library to use!) from "using AccioInventory.DBConnection;" to "using AccioOracleKit;"
• Integrating QR code.
• Chart cards usercontrol.
• Make a parallel procesudre process for exporting db DUMP.

---