ahmedtalaat327 / accioinventory

Simple and well managed data entry system for any store! 🏪

AccioInventory

Welcome to Accio open source inventory system written to simplify all store needs.

About The Project: 💼

• This idea is not new but, Many want to implement web based systems in desktop application actually in windows env. for more speed and reliability
  here we use C sharp as a main lang with some dlls and tweaks.

Database Version: 💉

• Here we use Oracle Database through Oracle with (ManagedDataAccess.dll) this library can be used as a connection object and execute all sql commands as string.

Screens: 📷

• Login..
  
• Users page..
  
• About..
  

Video: 📹

Go to youtube 👉

Console [still in beta] 🖲️

Go to this url 👉

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.



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 there is a file called 'params.info' its for intit the current connection.

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,
]

To Do: ⛏️🤦

• 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;"
• Integrade QR code.
• Chart cards usercontrol.

accioinventory's Issues

Login feed back freezes

This issue related to this code

  myTimer_showReaction.Tick += new EventHandler((ob, ev) =>
                                {


                                    if (this.label6.Text.Contains("Fail"))
                                    {
                                        // Restarts the timer and increments the counter.

                                        Invoke(new Action(() =>
                                        {
                                            this.label6.Text = "...";
                                            this.label6.ForeColor = Color.Black;
                                        }));
                                        myTimer_showReaction.Stop();
                                    }

                                });

yes it's happens for some reason could be the main task which this timer is inside of it.

PK (ID) not incrementing while adding new row

This issue happens when you want to add new row in DB but oracle not supporting auto incrementing in 10g version

` var replyOfOracle = Scripts.InsertMyDataRow(myOpenedTunnel, "users",

                new string[]
                {
                "3","'"+userName+"'","'"+fullName+"'","'" + pass + "'",telNo.ToString(),"DATE '"+inputDate.Year.ToString()+"-"+inputDate.Month.ToString()+"-"+inputDate.Day.ToString()+"'","''","'" + selectedAuth + "'" ,selectedDept.ToString()
                }
                
                );`

in Scripts.cs