private bool MFWERPTransactionWERPInsertion(int ProcessId, out int countTransactionsInserted, out int countRejectedRecords) { bool blResult = false; processlogVo = new UploadProcessLogVo(); uploadsCommonBo = new UploadCommonBo(); werpUploadBo = new WerpUploadsBo(); countTransactionsInserted = 0; countRejectedRecords = 0; processlogVo = uploadsCommonBo.GetProcessLogInfo(ProcessId); // WERP Insertion // WERP Equity Transation Insertion WerpEQUploadsBo werpEQUploadsBo = new WerpEQUploadsBo(); string packagePath = Server.MapPath("\\UploadPackages\\EQTransactionUploadPackage\\EQTransactionUploadPackage\\EQTransactionUploadPackage\\UploadChecksOnEQTranStaging.dtsx"); bool WERPEQSecondStagingCheckResult = werpEQUploadsBo.WERPEQProcessDataInSecondStagingTrans(ProcessId, packagePath, configPath, adviserVo.advisorId); if (WERPEQSecondStagingCheckResult) { packagePath = Server.MapPath("\\UploadPackages\\EQTransactionUploadPackage\\EQTransactionUploadPackage\\EQTransactionUploadPackage\\UploadEQTranStagingToWerp.dtsx"); bool WERPEQTranWerpResult = werpEQUploadsBo.WERPEQInsertTransDetails(ProcessId, packagePath, configPath); // EQ Trans XML File Type Id = 8); if (WERPEQTranWerpResult) { processlogVo.IsInsertionToWERPComplete = 1; processlogVo.NoOfTransactionInserted = uploadsCommonBo.GetTransUploadCount(ProcessId, "WPEQ"); processlogVo.NoOfRejectedRecords = uploadsCommonBo.GetTransUploadRejectCount(ProcessId, "WPEQ"); processlogVo.EndTime = DateTime.Now; blResult = uploadsCommonBo.UpdateUploadProcessLog(processlogVo); } } return(blResult); }
private bool TradeAccountStagingInsertion(int ProcessId, out int countTransactionsInserted, out int countRejectedRecords) { bool blResult = false; processlogVo = new UploadProcessLogVo(); uploadsCommonBo = new UploadCommonBo(); werpUploadBo = new WerpUploadsBo(); countTransactionsInserted = 0; countRejectedRecords = 0; processlogVo = uploadsCommonBo.GetProcessLogInfo(ProcessId); WerpEQUploadsBo werpEQUploadsBo = new WerpEQUploadsBo(); // WERP Insertion string packagePath = Server.MapPath("\\UploadPackages\\EQTradeAccountUploadPackage\\EQTradeAccountUploadPackage\\EQTradeAccountUploadPackage\\UploadChecksOnEQTradeStaging.dtsx"); bool WERPEQSecondStagingCheckResult = werpEQUploadsBo.WERPEQProcessDataInSecondStagingTradeAccount(ProcessId, packagePath, configPath, adviserVo.advisorId); if (WERPEQSecondStagingCheckResult) { packagePath = Server.MapPath("\\UploadPackages\\EQTradeAccountUploadPackage\\EQTradeAccountUploadPackage\\EQTradeAccountUploadPackage\\UploadEQTradeStagingToWerp.dtsx"); bool WERPEQTradeWerpResult = werpEQUploadsBo.WERPEQInsertTradeAccountDetails(ProcessId, packagePath, configPath); if (WERPEQTradeWerpResult) { processlogVo.IsInsertionToWERPComplete = 1; processlogVo.NoOfAccountsInserted = uploadsCommonBo.GetAccountsUploadCount(ProcessId, "WPEQ"); processlogVo.NoOfRejectedRecords = uploadsCommonBo.GetAccountsUploadRejectCount(ProcessId, "WPEQ"); processlogVo.EndTime = DateTime.Now; bool updateProcessLog = uploadsCommonBo.UpdateUploadProcessLog(processlogVo); if (updateProcessLog) { blResult = true; } } } return(blResult); }