Notes

We are already selecting sorted files from FTP.

Create a cache in ImportCacheManager.cs to store the all batch imformation related to ImportStatus, file name and date of file.

To this, Create a below dictionary :

struct ValuePair
{
public string fileDate;
public string importStatus;
}

Dictionary<string, ValuePair> _dictionary = new Dictionary<string, ValuePair>();

OR


Dictionary<fileName, Dictionary<fileDate, ImportStatus>> dictionary = new Dictionary<string, Dictionary<string, string>>();

Initialize the cache when ImportServices start and also Initialize/Update this cache when batch import execution completed, to this read dashboard XML from
(DebugDashBoardDataImport20160603Import_-1_PB.NTF.Transaction.Scotiabatch~gvActivityBlotter_20160424.csv.xml) path

Also handle for NoData file

Get Information to initialize catch :

Get following data from dashboard XML file

1. Get the value of batch filename from <FileName> tag
2. Get the value of file date from <ExecutionDateRef> tag
3. Get the value of ImportStatus from <ImportStatus> tag.


When batch comes to import data in Paxus DB, check the ImportStatus of previous date batch file in cache, that import status is Failed/Success/Partial Success.
If the import status is Success then procced the next file otherwise don't import that file or break the import funtionlity for next datefiles. It will handle on
bgwImportData_DoWork in PositionAndTransactionHandler.cs

If AutoProcessThirdPartyBatch preference vaue is 1 then data is imported if all trades are fullfill the all requirement.Otherwise trade will not import in Paxus DB
and middleware, so for this Import Status either Failed or Success.

If user import next date's batch manually, get the status of last date's batch from cache and check it is failed or success then show a warning message that
"previous date's batch status is failure/partial success, do you want to continue?" If yes then import the data in Paxus DB and middleware otherwise cancle the operation.
If there is previous date batch not folund then also check for previous of previous date batch in cache.


If user selects multiple rows from dashboard of same batch having status failure and import all files at once then get the detail from tupleList and get previous
date batch import status in cache files and check it is failed or success then show a warning message that "previous date's batch status is failure/partial success, do you want to continue?"
If yes then import the data in Paxus DB and middleware otherwise cancle the operation. If there is previous date batch not folund then also check for previous of previous date batch in cache.

To configurable:

Create a preference "SequencialBachProcessing" in T_PranaKeyValuePreferences table. If it is 1 then this functionality should be work otherwise not.