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); }
protected void btnReprocess_Click(object sender, EventArgs e) { bool blResult = false; UploadCommonBo uploadsCommonBo = new UploadCommonBo(); UploadProcessLogVo processlogVo = new UploadProcessLogVo(); UploadProcessLogVo TempprocesslogVo = new UploadProcessLogVo(); StandardProfileUploadBo standardProfileUploadBo = new StandardProfileUploadBo(); StandardFolioUploadBo standardFolioUploadBo = new StandardFolioUploadBo(); CamsUploadsBo camsUploadsBo = new CamsUploadsBo(); int countCustCreated = 0; //int countFolioCreated = 0; //int countRejectedRecords = 0; // processlogVo = uploadsCommonBo.GetProcessLogInfo(ProcessId); // BindGrid if (Request.QueryString["processId"] != null) { ProcessId = Int32.Parse(Request.QueryString["processId"].ToString()); } if (Request.QueryString["filetypeid"] != null) { filetypeId = Int32.Parse(Request.QueryString["filetypeid"].ToString()); } processlogVo = uploadsCommonBo.GetProcessLogInfo(ProcessId); if (uploadsCommonBo.ResetRejectedFlagByProcess(ProcessId, 9)) { //Folio Chks in Std Folio Staging string packagePath = Server.MapPath("\\UploadPackages\\StandardFolioUploadPackageNew\\StandardFolioUploadPackageNew\\UploadsCommonFolioChecksInFolioStaging.dtsx"); bool camsFolioStagingChkResult = standardFolioUploadBo.StdFolioChksInFolioStaging(packagePath, adviserVo.advisorId, ProcessId, configPath); if (camsFolioStagingChkResult) { //Folio Chks in Std Folio Staging packagePath = Server.MapPath("\\UploadPackages\\StandardFolioUploadPackageNew\\StandardFolioUploadPackageNew\\UploadStdFolioFromFolioStagingToWerpTable.dtsx"); bool camsFolioWerpInsertionResult = standardFolioUploadBo.StdCustomerFolioCreation(packagePath, adviserVo.advisorId, ProcessId, configPath); if (camsFolioWerpInsertionResult) { processlogVo.IsInsertionToWERPComplete = 1; processlogVo.EndTime = DateTime.Now; if (processlogVo.FileTypeId == 2) { processlogVo.IsInsertionToWERPComplete = 1; processlogVo.EndTime = DateTime.Now; processlogVo.NoOfRejectedRecords = uploadsCommonBo.GetProfileUploadRejectCount(ProcessId, "CA"); processlogVo.NoOfAccountsInserted = uploadsCommonBo.GetAccountsUploadCount(ProcessId, "WPMF"); processlogVo.NoOfInputRejects = uploadsCommonBo.GetUploadProfileInputRejectCount(ProcessId, "CA"); processlogVo.NoOfAccountDuplicates = processlogVo.NoOfTotalRecords - processlogVo.NoOfAccountsInserted - processlogVo.NoOfRejectedRecords; } else if (processlogVo.FileTypeId == 4) { processlogVo.IsInsertionToWERPComplete = 1; processlogVo.EndTime = DateTime.Now; processlogVo.NoOfRejectedRecords = uploadsCommonBo.GetProfileUploadRejectCount(ProcessId, "KA"); processlogVo.NoOfAccountsInserted = uploadsCommonBo.GetAccountsUploadCount(ProcessId, "WPMF"); processlogVo.NoOfInputRejects = uploadsCommonBo.GetUploadProfileInputRejectCount(ProcessId, "KA"); processlogVo.NoOfAccountDuplicates = processlogVo.NoOfTotalRecords - processlogVo.NoOfAccountsInserted - processlogVo.NoOfRejectedRecords; } else if (processlogVo.FileTypeId == 16) { processlogVo.IsInsertionToWERPComplete = 1; processlogVo.EndTime = DateTime.Now; processlogVo.NoOfRejectedRecords = uploadsCommonBo.GetProfileUploadRejectCount(ProcessId, "TN"); processlogVo.NoOfAccountsInserted = uploadsCommonBo.GetAccountsUploadCount(ProcessId, "WPMF"); processlogVo.NoOfInputRejects = uploadsCommonBo.GetUploadProfileInputRejectCount(ProcessId, "TN"); processlogVo.NoOfAccountDuplicates = processlogVo.NoOfTotalRecords - processlogVo.NoOfAccountsInserted - processlogVo.NoOfRejectedRecords; blResult = uploadsCommonBo.UpdateUploadProcessLog(processlogVo); } else if (processlogVo.FileTypeId == 18) { processlogVo.IsInsertionToWERPComplete = 1; processlogVo.EndTime = DateTime.Now; processlogVo.NoOfRejectedRecords = uploadsCommonBo.GetProfileUploadRejectCount(ProcessId, "DT"); processlogVo.NoOfAccountsInserted = uploadsCommonBo.GetAccountsUploadCount(ProcessId, "WPMF"); processlogVo.NoOfInputRejects = uploadsCommonBo.GetUploadProfileInputRejectCount(ProcessId, "DT"); processlogVo.NoOfAccountDuplicates = processlogVo.NoOfTotalRecords - processlogVo.NoOfAccountsInserted - processlogVo.NoOfRejectedRecords; blResult = uploadsCommonBo.UpdateUploadProcessLog(processlogVo); } blResult = uploadsCommonBo.UpdateUploadProcessLog(processlogVo); if (blResult) { bool stdFolioCommonDeleteResult = standardFolioUploadBo.StdDeleteCommonStaging(ProcessId); } } } } if (blResult) { // Success Message trErrorMessage.Visible = true; lblError.Text = "Reprocess Done Successfully!"; } else { // Failure Message trErrorMessage.Visible = true; lblError.Text = "Reprocess Failure!"; } BindGrid(ProcessId); }
protected void btnReprocess_Click(object sender, EventArgs e) { bool blResult = false; UploadCommonBo uploadsCommonBo = new UploadCommonBo(); UploadProcessLogVo processlogVo = new UploadProcessLogVo(); UploadProcessLogVo TempprocesslogVo = new UploadProcessLogVo(); StandardProfileUploadBo standardProfileUploadBo = new StandardProfileUploadBo(); StandardFolioUploadBo standardFolioUploadBo = new StandardFolioUploadBo(); CamsUploadsBo camsUploadsBo = new CamsUploadsBo(); string strErrorDesc = "Please a select a processId"; DropDownList ddl = (DropDownList)gvCAMSProfileReject.HeaderRow.Cells[0].FindControl("ddlProcessId"); string val = ddl.SelectedValue; if (val == "Select") { Response.Write(@"<script language='javascript'>alert('The following errors have occurred: \n" + strErrorDesc + " .');</script>"); } else { ProcessId = Convert.ToInt32(val); // BindGrid if (Request.QueryString["processId"] != null) { ProcessId = Int32.Parse(Request.QueryString["processId"].ToString()); } if (Request.QueryString["filetypeid"] != null) { filetypeId = Int32.Parse(Request.QueryString["filetypeid"].ToString()); } processlogVo = uploadsCommonBo.GetProcessLogInfo(ProcessId); if (uploadsCommonBo.ResetRejectedFlagByProcess(ProcessId, 9)) { //Folio Chks in Std Folio Staging string packagePath = Server.MapPath("\\UploadPackages\\StandardFolioUploadPackageNew\\StandardFolioUploadPackageNew\\UploadsCommonFolioChecksInFolioStaging.dtsx"); bool camsFolioStagingChkResult = standardFolioUploadBo.StdFolioChksInFolioStaging(packagePath, processlogVo.AdviserId, ProcessId, configPath); if (camsFolioStagingChkResult) { //Folio Chks in Std Folio Staging packagePath = Server.MapPath("\\UploadPackages\\StandardFolioUploadPackageNew\\StandardFolioUploadPackageNew\\UploadStdFolioFromFolioStagingToWerpTable.dtsx"); bool camsFolioWerpInsertionResult = standardFolioUploadBo.StdCustomerFolioCreation(packagePath, processlogVo.AdviserId, ProcessId, configPath); if (camsFolioWerpInsertionResult) { processlogVo.IsInsertionToWERPComplete = 1; processlogVo.EndTime = DateTime.Now; if (processlogVo.FileTypeId == 2) { processlogVo.IsInsertionToWERPComplete = 1; processlogVo.EndTime = DateTime.Now; processlogVo.NoOfRejectedRecords = uploadsCommonBo.GetProfileUploadRejectCount(ProcessId, "CA"); processlogVo.NoOfAccountsInserted = uploadsCommonBo.GetAccountsUploadCount(ProcessId, "WPMF"); processlogVo.NoOfInputRejects = uploadsCommonBo.GetUploadProfileInputRejectCount(ProcessId, "CA"); processlogVo.NoOfAccountDuplicates = processlogVo.NoOfTotalRecords - processlogVo.NoOfAccountsInserted - processlogVo.NoOfRejectedRecords; } else if (processlogVo.FileTypeId == 4) { processlogVo.IsInsertionToWERPComplete = 1; processlogVo.EndTime = DateTime.Now; processlogVo.NoOfRejectedRecords = uploadsCommonBo.GetProfileUploadRejectCount(ProcessId, "KA"); processlogVo.NoOfAccountsInserted = uploadsCommonBo.GetAccountsUploadCount(ProcessId, "WPMF"); processlogVo.NoOfInputRejects = uploadsCommonBo.GetUploadProfileInputRejectCount(ProcessId, "KA"); processlogVo.NoOfAccountDuplicates = processlogVo.NoOfTotalRecords - processlogVo.NoOfAccountsInserted - processlogVo.NoOfRejectedRecords; } else if (processlogVo.FileTypeId == 16) { processlogVo.IsInsertionToWERPComplete = 1; processlogVo.EndTime = DateTime.Now; processlogVo.NoOfRejectedRecords = uploadsCommonBo.GetProfileUploadRejectCount(ProcessId, "TN"); processlogVo.NoOfAccountsInserted = uploadsCommonBo.GetAccountsUploadCount(ProcessId, "WPMF"); processlogVo.NoOfInputRejects = uploadsCommonBo.GetUploadProfileInputRejectCount(ProcessId, "TN"); processlogVo.NoOfAccountDuplicates = processlogVo.NoOfTotalRecords - processlogVo.NoOfAccountsInserted - processlogVo.NoOfRejectedRecords; blResult = uploadsCommonBo.UpdateUploadProcessLog(processlogVo); } else if (processlogVo.FileTypeId == 18) { processlogVo.IsInsertionToWERPComplete = 1; processlogVo.EndTime = DateTime.Now; processlogVo.NoOfRejectedRecords = uploadsCommonBo.GetProfileUploadRejectCount(ProcessId, "DT"); processlogVo.NoOfAccountsInserted = uploadsCommonBo.GetAccountsUploadCount(ProcessId, "WPMF"); processlogVo.NoOfInputRejects = uploadsCommonBo.GetUploadProfileInputRejectCount(ProcessId, "DT"); processlogVo.NoOfAccountDuplicates = processlogVo.NoOfTotalRecords - processlogVo.NoOfAccountsInserted - processlogVo.NoOfRejectedRecords; blResult = uploadsCommonBo.UpdateUploadProcessLog(processlogVo); } blResult = uploadsCommonBo.UpdateUploadProcessLog(processlogVo); if (blResult) { bool stdFolioCommonDeleteResult = standardFolioUploadBo.StdDeleteCommonStaging(ProcessId); } } } } if (blResult) { // Success Message trErrorMessage.Visible = true; lblError.Text = "Reprocess Done Successfully!"; } else { // Failure Message trErrorMessage.Visible = true; lblError.Text = "Reprocess Failure!"; } BindGrid(ProcessId); } }