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);
            }
        }
Beispiel #2
0
        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);
        }