Files Having Changes:

1)\trunk\WORKTERRAweb\App\BusinessLogic\ImportExportDTS\ExecuteImportDTS.vb
2)\trunk\WORKTERRAweb\App\BusinessLogic\ImportExportDTS\ImportEmployeeEnrollment.vb
3)\trunk\WORKTERRAweb\Web\Web Projects\WORKTERRA\Areas\Customization\Controllers\EDI\ImportExportBaseController.cs
4)\trunk\WORKTERRAweb\Web\Web Projects\WORKTERRA\Areas\Customization\Models\EDI\ImportExportRecordDetails.cs
5)\trunk\WORKTERRAweb\Web\Web Projects\WORKTERRA\Areas\Customization\Models\EDI\ManualImportExportModel.cs

Changes:

1) Removed calls to functions which accesses 'ImportExportRecordSummary' table to insert and fetch the data
2) Created separate variables to store total no of records and total no of valid records. Added these values to 'CompanyWiseAsyncRoutineInfoHash'
3) Displayed record counts on UI using hash 'CompanyWiseAsyncRoutineInfoHash'.

Concern: Import Record summary should have unique identification

Impacted Areas:
1) Manual Import (Sync/Async)
2) Re-Import

Scenarios to check:
1) Bad record count, total record count, valid record count should be correct
2) Bad file should be able to download

Hi Snehal Katkar,

Verified on LB
Company - QA ASML for hspl

Verified below scenario
1)Bad Record count - PAss
2)Total imported record count - Pass
3)Bad file download - Pass
4)When bad file is generated, re-imported data - Pass
5)Valid record count for all scenario - PAss
6)Verified all above scenario for syn and Async manual import
7)Verified all scenario for company and global level import
8)Verified Import type -> Employee import, spouse import, child import , Election data import and waive import

All above mentioned scenarios are working fine
Hence marking item state as Ready for stage.

Thanks,
Jayshree

cc : Rakesh Roy Prasad Pise

Hi Snehal Katkar,

Verified Demographics and dependent import on stage,
Company - Je dunn for hspl, city of durham for hspl,
Symphony for hspl, city of bellevue for hspl

But Import is getting fail , could not verify as its blocked due to : WT-11623

Error Log : ErrorID : 0
ErrorSource : ControllerAppTier.SaveAndGetData->WORKTERRAControllerAppTier.SaveAndGetData->ExecuteImportDTS.ImportData_Isolated->WTIsolatedRoutines.Main->ExecuteImportDTS.ImportData->ImportValidation.ImportData->ImportValidation.GetUniqueUserNameHashTable
ErrorMessage: Item has already been added. Key in dictionary: 'abc05011990test' Key being added: 'abc05011990test'
StackTrace: at WORKTERRA.Shared.WORKTERRAControllerAppTier.SaveAndGetData(WORKTERRAControllerWebTierEntity objWORKTERRAControllerWebTierEntity)
at WORKTERRA.ControllerAppTier.SaveAndGetData(Int32 intProjectsId, String strInput)
TargetSite: System.String SaveAndGetData(WORKTERRA.Shared.WORKTERRAControllerWebTierEntity)

Hence Marking this jira as Stage QA on Hold,
We will verify once WT-11623 will deploy on stage.

Thanks,
Jayshree

cc : Rakesh Roy Prasad Pise Jaideep Vinchurkar

Hi Jayshree Nagpure,

As discussed, I have reverted this patch from stage. Please check and let me know in case of any issues.

cc: Rakesh Roy, Jaideep Vinchurkar

Hi Snehal Katkar,

Import working fine on stage
Hence marking item state as Ready for Stage.

Thanks,
Jayshree

cc : Rakesh Roy Prasad Pise