private bool MFWERPSIPTransactionInsertion(int UploadProcessId) { bool blResult = false; processlogVo = new UploadProcessLogVo(); uploadsCommonBo = new UploadCommonBo(); CamsUploadsBo camsUploadsBo = new CamsUploadsBo(); bool camsSIPCommonStagingChk = false; bool camsSIPCommonStagingToWERP = false; bool updateProcessLog = false; string packagePath; string fileType = "CA"; processlogVo = uploadsCommonBo.GetProcessLogInfo(UploadProcessId); if (processlogVo.FileTypeId == 20) { fileType = "CA"; } else if (processlogVo.FileTypeId == 26) { fileType = "WPT"; } else if (processlogVo.FileTypeId == 27) { fileType = "KA"; } packagePath = Server.MapPath("\\UploadPackages\\CAMSSystematicUploadPackageNew\\CAMSSystematicUploadPackageNew\\UploadSIPCommonStagingCheck.dtsx"); camsSIPCommonStagingChk = camsUploadsBo.CamsSIPCommonStagingChk(UploadProcessId, packagePath, configPath, fileType); processlogVo.NoOfTransactionInserted = uploadsCommonBo.GetUploadSystematicInsertCount(UploadProcessId, fileType); updateProcessLog = uploadsCommonBo.UpdateUploadProcessLog(processlogVo); if (camsSIPCommonStagingChk) { packagePath = Server.MapPath("\\UploadPackages\\CAMSSystematicUploadPackageNew\\CAMSSystematicUploadPackageNew\\UploadSIPCommonStagingToWERP.dtsx"); camsSIPCommonStagingToWERP = camsUploadsBo.CamsSIPCommonStagingToWERP(UploadProcessId, packagePath, configPath); if (camsSIPCommonStagingToWERP) { processlogVo.IsInsertionToWERPComplete = 1; processlogVo.EndTime = DateTime.Now; processlogVo.NoOfRejectedRecords = uploadsCommonBo.GetUploadSystematicRejectCount(UploadProcessId, fileType); blResult = uploadsCommonBo.UpdateUploadProcessLog(processlogVo); } } return(blResult); }
public bool MFTrailTransactionInsertion(int UploadProcessId) { bool blResult = false; uploadProcessLogVo = new UploadProcessLogVo(); uploadsCommonBo = new UploadCommonBo(); CamsUploadsBo camsUploadsBo = new CamsUploadsBo(); bool TempletonTrailCommonStagingChk = false; bool TempletonTrailCommonStagingToSetUp = false; bool updateProcessLog = false; string packagePath; uploadProcessLogVo = uploadsCommonBo.GetProcessLogInfo(UploadProcessId); packagePath = Server.MapPath("\\UploadPackages\\TrailCommisionUploadPackage\\TrailCommissionUpload\\TrailCommissionUpload\\callOnReprocess.dtsx"); TempletonTrailCommonStagingChk = uploadsCommonBo.TrailCommissionCommonStagingCheck(adviserId, UploadProcessId, packagePath, configPath); uploadProcessLogVo.NoOfTransactionInserted = uploadsCommonBo.GetUploadSystematicInsertCount(UploadProcessId, "TN"); updateProcessLog = uploadsCommonBo.UpdateUploadProcessLog(uploadProcessLogVo); if (TempletonTrailCommonStagingChk) { packagePath = Server.MapPath("\\UploadPackages\\TrailCommisionUploadPackage\\TrailCommissionUpload\\TrailCommissionUpload\\commonStagingToTrailSetUp.dtsx"); //TempletonTrailCommonStagingToSetUp = camsUploadsBo.CamsSIPCommonStagingToWERP(UploadProcessId, packagePath, configPath); TempletonTrailCommonStagingToSetUp = camsUploadsBo.TempletonTrailCommissionCommonStagingChk(UploadProcessId, packagePath, configPath, "TN", adviserId); if (TempletonTrailCommonStagingToSetUp) { uploadProcessLogVo.IsInsertionToWERPComplete = 1; uploadProcessLogVo.EndTime = DateTime.Now; uploadProcessLogVo.NoOfRejectedRecords = uploadsCommonBo.GetUploadSystematicRejectCount(UploadProcessId, "TN"); blResult = uploadsCommonBo.UpdateUploadProcessLog(uploadProcessLogVo); } } return(blResult); }