protected void btnReprocess_Click(object sender, EventArgs e) { bool blResult = false; uploadsCommonBo = new UploadCommonBo(); xmlPath = Server.MapPath(ConfigurationManager.AppSettings["xmllookuppath"]).ToString(); int countCustCreated = 0; int countFolioCreated = 0; int countRejectedRecords = 0; processlogVo = uploadsCommonBo.GetProcessLogInfo(ProcessId); if (processlogVo.FileTypeId == 7) { source = "WP"; } else if (processlogVo.FileTypeId == 4) { source = "KA"; } else if (processlogVo.FileTypeId == 2) { source = "CA"; } else if (processlogVo.FileTypeId == 16) { source = "TN"; } else if (processlogVo.FileTypeId == 18) { source = "DT"; } // 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()); } StandardProfileUploadBo standardProfileUploadBo = new StandardProfileUploadBo(); //Checks in Profile Staging string packagePath = Server.MapPath("\\UploadPackages\\StandardProfileUploadPackageNew\\StandardProfileUploadPackageNew\\UploadsCommonProfileChecksInProfileStaging.dtsx"); bool karvyProCommonChecksResult = standardProfileUploadBo.StdCommonProfileChecks(ProcessId, adviserVo.advisorId, packagePath, configPath); if (karvyProCommonChecksResult) { // Insert Customer Details into WERP Tables bool stdProCreateCustomerResult = standardProfileUploadBo.StdInsertCustomerDetails(adviserVo.advisorId, ProcessId, rmVo.RMId, processlogVo.BranchId, xmlPath, out countCustCreated); if (stdProCreateCustomerResult) { //Create new Bank Accounts packagePath = Server.MapPath("\\UploadPackages\\StandardProfileUploadPackageNew\\StandardProfileUploadPackageNew\\UploadCreateNewBankAccount.dtsx"); bool stdProCreateBankAccountResult = standardProfileUploadBo.StdCreationOfNewBankAccounts(ProcessId, packagePath, configPath); if (stdProCreateBankAccountResult) { processlogVo.IsInsertionToWERPComplete = 1; processlogVo.EndTime = DateTime.Now; processlogVo.NoOfRejectedRecords = uploadsCommonBo.GetUploadProfileRejectCount(ProcessId, source); processlogVo.NoOfCustomerInserted = processlogVo.NoOfCustomerInserted + countCustCreated; processlogVo.NoOfCustomerDuplicates = processlogVo.NoOfTotalRecords - processlogVo.NoOfCustomerInserted - processlogVo.NoOfRejectedRecords; processlogVo.NoOfInputRejects = uploadsCommonBo.GetUploadProfileInputRejectCount(ProcessId, source); blResult = uploadsCommonBo.UpdateUploadProcessLog(processlogVo); if (blResult) { bool stdProCommonDeleteResult = standardProfileUploadBo.StdDeleteCommonStaging(ProcessId); } } } } if (blResult) { // Success Message //trErrorMessage.Visible = true; //lblError.Text = "Reprocess Done Successfully!"; msgReprocessComplete.Visible = true; } else { // Failure Message msgReprocessincomplete.Visible = true; } BindWerpProfileGrid(ProcessId); }
protected void btnReprocess_Click(object sender, EventArgs e) { bool blResult = false; uploadsCommonBo = new UploadCommonBo(); xmlPath = Server.MapPath(ConfigurationManager.AppSettings["xmllookuppath"]).ToString(); string error = ""; int countCustCreated = 0; int countFolioCreated = 0; int countRejectedRecords = 0; int processIdReprocessAll = 0; string strErrorDesc = "Please a select a processId"; DropDownList ddl = (DropDownList)gvWERPProfileReject.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); if (Request.QueryString["filetypeid"] != null) { filetypeId = Int32.Parse(Request.QueryString["filetypeid"].ToString()); } if (Request.QueryString["processId"] != null) { ProcessId = Int32.Parse(Request.QueryString["processId"].ToString()); processlogVo = uploadsCommonBo.GetProcessLogInfo(ProcessId); if (processlogVo.FileTypeId == 7) { source = "WP"; } else if (processlogVo.FileTypeId == 4) { source = "KA"; } else if (processlogVo.FileTypeId == 2) { source = "CA"; } else if (processlogVo.FileTypeId == 16) { source = "TN"; } else if (processlogVo.FileTypeId == 18) { source = "DT"; } else if (processlogVo.FileTypeId == 21) { source = "SU"; } if (processlogVo.FileTypeId == 7 || processlogVo.FileTypeId == 4 || processlogVo.FileTypeId == 2 || processlogVo.FileTypeId == 16 || processlogVo.FileTypeId == 18 || processlogVo.FileTypeId == 21) { StandardProfileUploadBo standardProfileUploadBo = new StandardProfileUploadBo(); //Checks in Profile Staging string packagePath = Server.MapPath("\\UploadPackages\\StandardProfileUploadPackageNew\\StandardProfileUploadPackageNew\\UploadsCommonProfileChecksInProfileStaging.dtsx"); bool karvyProCommonChecksResult = standardProfileUploadBo.StdCommonProfileChecks(ProcessId, processlogVo.AdviserId, packagePath, configPath); if (karvyProCommonChecksResult) { // Insert Customer Details into WERP Tables bool stdProCreateCustomerResult = standardProfileUploadBo.StdInsertCustomerDetails(processlogVo.AdviserId, ProcessId, processlogVo.RmId, processlogVo.BranchId, xmlPath, out countCustCreated); if (stdProCreateCustomerResult) { //Create new Bank Accounts packagePath = Server.MapPath("\\UploadPackages\\StandardProfileUploadPackageNew\\StandardProfileUploadPackageNew\\UploadCreateNewBankAccount.dtsx"); bool stdProCreateBankAccountResult = standardProfileUploadBo.StdCreationOfNewBankAccounts(ProcessId, packagePath, configPath, adviserVo.advisorId); if (stdProCreateBankAccountResult) { processlogVo.IsInsertionToWERPComplete = 1; processlogVo.EndTime = DateTime.Now; processlogVo.NoOfRejectedRecords = uploadsCommonBo.GetUploadProfileRejectCount(ProcessId, source); processlogVo.NoOfCustomerInserted = processlogVo.NoOfCustomerInserted + countCustCreated; processlogVo.NoOfCustomerDuplicates = processlogVo.NoOfTotalRecords - processlogVo.NoOfCustomerInserted - processlogVo.NoOfRejectedRecords; processlogVo.NoOfInputRejects = uploadsCommonBo.GetUploadProfileInputRejectCount(ProcessId, source); blResult = uploadsCommonBo.UpdateUploadProcessLog(processlogVo); if (blResult) { bool stdProCommonDeleteResult = standardProfileUploadBo.StdDeleteCommonStaging(ProcessId); } } } } } } else { DataSet ds = uploadsCommonBo.GetWERPUploadDetailsForProcessId(ProcessId); //DataSet ds = uploadsCommonBo.GetWERPUploadProcessId(); foreach (DataRow dr in ds.Tables[0].Rows) { rmId = int.Parse(dr["AR_RMId"].ToString()); adviserId = int.Parse(dr["A_AdviserId"].ToString()); processIdReprocessAll = ProcessId; processlogVo = uploadsCommonBo.GetProcessLogInfo(processIdReprocessAll); if (processlogVo.FileTypeId == 7) { source = "WP"; } else if (processlogVo.FileTypeId == 4) { source = "KA"; } else if (processlogVo.FileTypeId == 2) { source = "CA"; } else if (processlogVo.FileTypeId == 16) { source = "TN"; } else if (processlogVo.FileTypeId == 18) { source = "DT"; } else if (processlogVo.FileTypeId == 21) { source = "SU"; } if (processlogVo.FileTypeId == 7 || processlogVo.FileTypeId == 4 || processlogVo.FileTypeId == 2 || processlogVo.FileTypeId == 16 || processlogVo.FileTypeId == 18 || processlogVo.FileTypeId == 21) { StandardProfileUploadBo standardProfileUploadBo = new StandardProfileUploadBo(); //Checks in Profile Staging string packagePath = Server.MapPath("\\UploadPackages\\StandardProfileUploadPackageNew\\StandardProfileUploadPackageNew\\UploadsCommonProfileChecksInProfileStaging.dtsx"); bool karvyProCommonChecksResult = standardProfileUploadBo.StdCommonProfileChecks(processIdReprocessAll, adviserId, packagePath, configPath); if (karvyProCommonChecksResult) { // Insert Customer Details into WERP Tables bool stdProCreateCustomerResult = standardProfileUploadBo.StdInsertCustomerDetails(adviserId, processIdReprocessAll, rmId, processlogVo.BranchId, xmlPath, out countCustCreated); if (stdProCreateCustomerResult) { //Create new Bank Accounts packagePath = Server.MapPath("\\UploadPackages\\StandardProfileUploadPackageNew\\StandardProfileUploadPackageNew\\UploadCreateNewBankAccount.dtsx"); bool stdProCreateBankAccountResult = standardProfileUploadBo.StdCreationOfNewBankAccounts(processIdReprocessAll, packagePath, configPath, adviserVo.advisorId); if (stdProCreateBankAccountResult) { processlogVo.IsInsertionToWERPComplete = 1; processlogVo.EndTime = DateTime.Now; processlogVo.NoOfRejectedRecords = uploadsCommonBo.GetUploadProfileRejectCount(processIdReprocessAll, source); processlogVo.NoOfCustomerInserted = processlogVo.NoOfCustomerInserted + countCustCreated; processlogVo.NoOfCustomerDuplicates = processlogVo.NoOfTotalRecords - processlogVo.NoOfCustomerInserted - processlogVo.NoOfRejectedRecords; processlogVo.NoOfInputRejects = uploadsCommonBo.GetUploadProfileInputRejectCount(processIdReprocessAll, source); blResult = uploadsCommonBo.UpdateUploadProcessLog(processlogVo); if (blResult) { bool stdProCommonDeleteResult = standardProfileUploadBo.StdDeleteCommonStaging(processIdReprocessAll); } } } } } } } if (blResult == false) { error = error + "Error when reprocessing for the processid:" + processIdReprocessAll + ";"; } if (blResult) { // Success Message //trErrorMessage.Visible = true; //lblError.Text = "Reprocess Done Successfully!"; msgReprocessComplete.Visible = true; } else { // Failure Message msgReprocessincomplete.Visible = true; } BindWerpProfileGrid(ProcessId); } }
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 CommonStdTransChecks = false; bool CommonTransChecks = false; if (fileTypeId == 1) { bool camsDatatranslationCheckResult = uploadsCommonBo.UploadsCAMSDataTranslationForReprocess(ProcessId); if (camsDatatranslationCheckResult) { CommonTransChecks = uploadsCommonBo.TransCommonChecks(adviserId, ProcessId, packagePath, configPath, "CA", "CAMS"); } } else if (fileTypeId == 25) { bool camsDatatranslationCheckResult = uploadsCommonBo.UploadsCAMSDataTranslationForReprocess(ProcessId); if (camsDatatranslationCheckResult) { CommonTransChecks = uploadsCommonBo.TransCommonChecks(adviserId, ProcessId, packagePath, configPath, "SU", "Sundaram"); } } //***reprocess for folioandTrnx else if (fileTypeId == 6) { standardProfileUploadBo = new StandardProfileUploadBo(); string stdPackagePath = Server.MapPath("\\UploadPackages\\StandardFolioUploadPackageNew\\StandardFolioUploadPackageNew\\UploadsStandardMFTrxnStagingChk.dtsx"); CommonStdTransChecks = standardProfileUploadBo.StdCommonProfileChecks(ProcessId, adviserId, stdPackagePath, configPath); } else if (fileTypeId == 3) { bool karvyDataTranslationCheck = uploadsCommonBo.UploadsKarvyDataTranslationForReprocess(ProcessId); if (karvyDataTranslationCheck) { CommonTransChecks = uploadsCommonBo.TransCommonChecks(adviserId, ProcessId, packagePath, configPath, "KA", "Karvy"); } } else if (fileTypeId == 15) { bool TempletonDataTranslationCheck = uploadsCommonBo.UploadsTempletonDataTranslationForReprocess(ProcessId); if (TempletonDataTranslationCheck) { CommonTransChecks = uploadsCommonBo.TransCommonChecks(adviserId, ProcessId, packagePath, configPath, "TN", "Templeton"); } } else if (fileTypeId == 17) { bool DeutscheDataTranslationCheck = uploadsCommonBo.UploadsDeutscheDataTranslationForReprocess(ProcessId); if (DeutscheDataTranslationCheck) { CommonTransChecks = uploadsCommonBo.TransCommonChecks(adviserId, 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); } else if (filetypeId == 25) { processlogVo.NoOfRejectedRecords = uploadsCommonBo.GetTransUploadRejectCount(ProcessId, "SU"); } blResult = uploadsCommonBo.UpdateUploadProcessLog(processlogVo); } } else if (CommonStdTransChecks) { processlogVo.IsInsertionToWERPComplete = 1; processlogVo.NoOfTransactionInserted = uploadsCommonBo.GetTransUploadCount(ProcessId, "WP"); processlogVo.EndTime = DateTime.Now; processlogVo.NoOfRejectedRecords = uploadsCommonBo.GetTransUploadRejectCount(ProcessId, Contants.UploadExternalTypeStandard); blResult = uploadsCommonBo.UpdateUploadProcessLog(processlogVo); } return(blResult); }