Corp Management is a project of management in Company.

• Platform: Windows (x64)
• SqlServer >= 2014
• MS Visual Studio >= 15 (2017)

• Microsoft Visual Studio Installer Projects in Visual Studio

• The folder "sql/base" content the requests for create the database : "CreateDB.sql"
• The folder "sql/old" content the requests for the full data in database : "TDB_xxxx_xx_xx.sql"
• The folder "sql/update" content the last requests for update the database.

Open the file "App.config" in "CorpManagement" and define the different value for the access to database :

server : access route for the database (example : "22.22.22.222, 1433", ip and port)
database : DB name
uid : login app access
password

domain : not used

You can connect to the database with 3 different ways (see DBConnect.cs in DB folder). With domain name + uid + password; or uid + password; or without uid/password, but with Windows authentication.

Define the directory for save the files for each elements :

DirectoryFilesServicing (example : DirectoryFilesServicing="\\22.22.22.222\FileDB\Servicing")
DirectoryFilesVehicle
DirectoryFilesTires
DirectoryFilesInvoice
DirectoryFilesInsurance
DirectoryFilesArticle
DirectoryFilesEquipment

You need one user in the database with a 'matricule' number to start the application for the first time. By default the number is "11223344", you can change that in 'AllUserViewModel.cs' -> "username" ('ViewModel' folder). Remember to create the tables with the 'CreateDB.sql' (folder: 'sql/base'), execute the 'TDB_.sql' file (folder: sql/old) and finally 'user_example.sql'.

You will have by default a user 'Toto' in your Db to start the application.

In your request for user table, you will need to define idprofilelevel (1 for Admin) for the access level, the status (1:active/0:inactive user), the gradepoint (3 for 0 point) and most importantly the 'matricule' number.

Issues can be reported via the Github issue tracker.

Copyright Wylath © 2021-2022

Wylath