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); }