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);
        }
Ejemplo n.º 2
0
        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);
        }