-limegreen)

## v5.10 (1.7.0) - October 18th, 2024
Angular CLI version 9.1.15.
## Steps
1. **IMPORTANT!!!!**:
- **BACKUP DB Elicon_Voyage**. In case of error happened during upgrade, we can restore DB to previous state.
- **Archive/Zip the whole directory `C:\inetpub\wwwroot` as a BACKUP**. In case of error happened during upgrade, we can restore web files to previous state.
- Make sure all users saved their work and log out from Elicon FeMS.
3. Updating files in `ExcelTemplate` to
- `C:\EliconUpload\1\ExcelTemplate`
4. Copy the folder `IMPA Images` to
- `C:\`
5. Execute all scripts in folder `Scripts`
- Please execute scripts in **SEQUENCE**
7. **Elicon_Sync.exe, init and create triggers for new tables.**
- Run C:\Elicon\Elicon_Tool.exe
- `Quickly`, click the word Init after exe is opened. You should see the **Success** information box.
5. Execute below scripts, make sure you get **`6668`** records returned

USE [Elicon_Voyage]
GO
SELECT COUNT(1)
FROM INFORMATION_SCHEMA.COLUMNS
WHERE COLUMN_NAME NOT IN ('SYNC_CODE','FlowGroupId')
AND TABLE_NAME NOT IN ('sysdiagrams','EliconDataDesign','EliconDataGroupDesign','EliconDataSet','__EFMigrationsHistory','__WorkFlowEFMigrationHistory')
AND TABLE_NAME NOT LIKE '%WorkFlow%'

5. Execute below scripts, make sure you get **`1167`** records returned

USE [Elicon_Voyage]
GO
SELECT COUNT(1) FROM ExcelFormMapping WHERE template NOT LIKE 'ntu%'

6. Execute below scripts:
- Make sure you get **`414`** records returned

    USE [Elicon_Sync]
    GO
    SELECT COUNT(1) FROM Definition

- For sites which are using Sync, for example TVL, Cetus, Tairong, Jinhui, make sure you get **`0`** records returned

    USE [Elicon_Voyage]
    GO
    SELECT COUNT(1) FROM sys.triggers WHERE is_disabled = 1

- For sites which are **NOT** using Sync, for example CLSICO, make sure you get **`0`** records returned

    USE [Elicon_Voyage]
    GO
    SELECT COUNT(1) FROM sys.triggers WHERE is_disabled = 0

7. Execute below scripts:
- For sites which are using Sync, for example TVL, Cetus, Tairong, Jinhui, make sure you get **`0`** records returned

    USE [Elicon_Voyage]
    GO
    SELECT COUNT(1) FROM sys.tables
    WHERE object_id NOT IN (SELECT parent_id FROM sys.triggers WHERE  is_disabled = 0)
    AND name NOT IN ('UserRefreshTokens','sysdiagrams','EliconDataDesign','EliconDataGroupDesign','EliconDataSet','TableDefinition','SystemConfig','Sheet1','IMPA_IMPORT','IMPA8_IMPORT','LoginLog','SystemKeyGenerator')

- If you do not get **`0`** records returned, do the following
- Run C:\Elicon\Elicon_Tool.exe
- `Quickly`, click the word Init after exe is opened. You should see the **Success** information box.

8. Execute below sripts for IMPA checking, by right you should get **`53507`**, **`51708`**, **`51708`**

    USE [Elicon_Voyage]
    GO
    SELECT count(1) FROM IMPA8_IMPORT
    SELECT count(1) FROM IMPA8_IMPORT WHERE INFORMATION NOT IN ('DELETE','NEW. SKIP BECAUSE IT IS DUPLICATE')
    SELECT count(1) FROM StockType WHERE IMPA = 1 AND StatusIndicator = 1 AND DeleteFlag = 0

9. Updating webpage files in directory`C:\inetpub\wwwroot`:
- C:\inetpub\wwwroot\FeMS-Frontend
- Delete all files, **EXCEPT** the file web.config.
- C:\inetpub\wwwroot\Qms
- Delete all files in this directory.
- Copy web folders from Release package to `C:\inetpub\wwwroot`, and REPLACE!!
- 
- if encountered error, for example: when updating the folder `pms`:
- This means someone is using FeMS.
- In IIS, select the site `pms` and Stop,
- Do file replacement (paste) again.
- Start IIS service.
9. Open Browser and test Elicon FeMS.