Our new project is built to serve MVVM pattern and Oracle sql commands with new .dll easy static funcs.
- 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.
- 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.
-
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] 🎲
#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
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,
]
- 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.
- 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. [working on add customization instead of static cards always with multiple realations]
- Make a parallel procesudre process for exporting db DUMP.