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 MFWERPTransactionWERPInsertion(int ProcessId, out int countTransactionsInserted, out int countRejectedRecords, int fileTypeId) { bool blResult = false; processlogVo = new UploadProcessLogVo(); uploadsCommonBo = new UploadCommonBo(); werpUploadBo = new WerpUploadsBo(); countTransactionsInserted = 0; countRejectedRecords = 0; processlogVo = uploadsCommonBo.GetProcessLogInfo(ProcessId); //CAMS and KARVY Reprocess string packagePath = Server.MapPath("\\UploadPackages\\MFTransactionCommonUploadPackage\\MFTransactionCommonUploadPackage\\MFTransactionCommonUploadPackage\\ChecksCommonUploadPackage.dtsx"); bool CommonTransChecks = false; if (fileTypeId == 1) { bool camsDatatranslationCheckResult = uploadsCommonBo.UploadsCAMSDataTranslationForReprocess(ProcessId); if (camsDatatranslationCheckResult) { CommonTransChecks = uploadsCommonBo.TransCommonChecks(adviserVo.advisorId, ProcessId, packagePath, configPath, "CA", "CAMS"); } } else if (fileTypeId == 3) { bool karvyDataTranslationCheck = uploadsCommonBo.UploadsKarvyDataTranslationForReprocess(ProcessId); if (karvyDataTranslationCheck) { CommonTransChecks = uploadsCommonBo.TransCommonChecks(adviserVo.advisorId, ProcessId, packagePath, configPath, "KA", "Karvy"); } } else if (fileTypeId == 15) { bool TempletonDataTranslationCheck = uploadsCommonBo.UploadsTempletonDataTranslationForReprocess(ProcessId); if (TempletonDataTranslationCheck) { CommonTransChecks = uploadsCommonBo.TransCommonChecks(adviserVo.advisorId, ProcessId, packagePath, configPath, "TN", "Templeton"); } } else if (fileTypeId == 17) { bool DeutscheDataTranslationCheck = uploadsCommonBo.UploadsDeutscheDataTranslationForReprocess(ProcessId); if (DeutscheDataTranslationCheck) { CommonTransChecks = uploadsCommonBo.TransCommonChecks(adviserVo.advisorId, ProcessId, packagePath, configPath, "DT", "Deutsche"); } } if (CommonTransChecks) { packagePath = Server.MapPath("\\UploadPackages\\MFTransactionCommonUploadPackage\\MFTransactionCommonUploadPackage\\MFTransactionCommonUploadPackage\\InsertTransactionIntoWERP.dtsx"); bool insertTransWERP = uploadsCommonBo.InsertTransToWERP(ProcessId, packagePath, configPath); if (insertTransWERP) { processlogVo.IsInsertionToWERPComplete = 1; processlogVo.NoOfTransactionInserted = uploadsCommonBo.GetTransUploadCount(ProcessId, "WPMF"); processlogVo.EndTime = DateTime.Now; if (fileTypeId == 1) { processlogVo.NoOfRejectedRecords = uploadsCommonBo.GetTransUploadRejectCount(ProcessId, Contants.UploadExternalTypeCAMS); } else if (fileTypeId == 3) { processlogVo.NoOfRejectedRecords = uploadsCommonBo.GetTransUploadRejectCount(ProcessId, Contants.UploadExternalTypeKarvy); } else if (fileTypeId == 15) { processlogVo.NoOfRejectedRecords = uploadsCommonBo.GetTransUploadRejectCount(ProcessId, Contants.UploadExternalTypeTemp); } else if (fileTypeId == 17) { processlogVo.NoOfRejectedRecords = uploadsCommonBo.GetTransUploadRejectCount(ProcessId, Contants.UploadExternalTypeDeutsche); } blResult = uploadsCommonBo.UpdateUploadProcessLog(processlogVo); } } return(blResult); }
protected void btnProbableInsert_Click(object sender, EventArgs e) { bool result = true; bool blResult = true; string gvStagingIds = ""; uploadsCommonBo = new UploadCommonBo(); processlogVo = uploadsCommonBo.GetProcessLogInfo(ProcessId); int fileTypeId = processlogVo.FileTypeId; rejectedRecordsBo = new RejectedRecordsBo(); foreach (GridDataItem gvRow in gvWERPTrans.MasterTableView.Items) //foreach (GridViewRow gvRow in gvWERPTrans.Rows) { CheckBox ChkBxItem = (CheckBox)gvRow.FindControl("chkId"); if (ChkBxItem.Checked) { gvStagingIds += gvWERPTrans.MasterTableView.DataKeyValues[gvRow.RowIndex]["CMFTSId"].ToString() + ","; } } result = rejectedRecordsBo.InsertProbableDuplicatesRejectedTransaction(gvStagingIds); if (result) { // Success Message processlogVo.IsInsertionToWERPComplete = 1; processlogVo.NoOfTransactionInserted = uploadsCommonBo.GetTransUploadCount(ProcessId, "WPMF"); processlogVo.EndTime = DateTime.Now; if (fileTypeId == 1) { processlogVo.NoOfRejectedRecords = uploadsCommonBo.GetTransUploadRejectCount(ProcessId, Contants.UploadExternalTypeCAMS); } else if (fileTypeId == 3) { processlogVo.NoOfRejectedRecords = uploadsCommonBo.GetTransUploadRejectCount(ProcessId, Contants.UploadExternalTypeKarvy); } else if (fileTypeId == 15) { processlogVo.NoOfRejectedRecords = uploadsCommonBo.GetTransUploadRejectCount(ProcessId, Contants.UploadExternalTypeTemp); } else if (fileTypeId == 17) { processlogVo.NoOfRejectedRecords = uploadsCommonBo.GetTransUploadRejectCount(ProcessId, Contants.UploadExternalTypeDeutsche); } else if (filetypeId == 25) { processlogVo.NoOfRejectedRecords = uploadsCommonBo.GetTransUploadRejectCount(ProcessId, "SU"); } blResult = uploadsCommonBo.UpdateUploadProcessLog(processlogVo); ScriptManager.RegisterClientScriptBlock(this.Page, this.GetType(), "pageloadscript", "alert('Records Inserted Successfully');", true); } else { // Failure Message ScriptManager.RegisterClientScriptBlock(this.Page, this.GetType(), "pageloadscript", "alert('Please Select Probable Duplicate Records');", true); } BindEquityTransactionGrid(ProcessId); }