public SubmitDealResponse SubmitDealFunc(SubmitDealRequest submitDealRequest)
        {
            List <User> result             = new List <User>();
            string      API_User_ID        = null;
            string      API_User_FirstName = null;
            string      API_User_LastName  = null;
            string      API_User_UserName  = null;
            string      API_User_Password  = null;

            _rs = _GetAPIUsersList.ExecuteReader();

            if (_rs.HasRows)
            {
                while (_rs.Read())
                {
                    API_User_ID        = _rs["API_User_ID"].ToString();
                    API_User_FirstName = _rs["API_User_FirstName"].ToString();
                    API_User_LastName  = _rs["API_User_LastName"].ToString();
                    API_User_UserName  = _rs["API_User_UserName"].ToString();
                    API_User_Password  = _rs["API_User_Password"].ToString();
                    User user = new User(API_User_ID, API_User_FirstName, API_User_LastName, API_User_UserName, API_User_Password);
                    result.Add(user);
                }
                _rs.Close();
                return(null);
            }
            _rs.Close();
            return(null);
        }
        public IActionResult SubmitDeal([FromBody] SubmitDealRequest submitDealRequest)
        {
            try
            {
                _logger.LogInformation($"SubmitDeal Call with submitDealRequest.RequestID {submitDealRequest.RequestID}");

                if (string.IsNullOrEmpty(submitDealRequest.RequestID))
                {
                    throw new Exception(message: "RequestID is missing.");
                }
                else if (submitDealRequest.AccountDetails == null)
                {
                    throw new Exception(message: "AccountDetails Object is missing.");
                }
                else if (submitDealRequest.Borrowers == null)
                {
                    throw new Exception(message: "Borrowers Object is missing.");
                }
                else if (submitDealRequest.LoanDetails == null)
                {
                    throw new Exception(message: "LoanDetails Object is missing.");
                }
                else if (submitDealRequest.SecurityPropertyDetails == null)
                {
                    throw new Exception(message: "SecurityPropertyDetails Object is missing.");
                }
                else if (submitDealRequest.PreauthorizedPaymentAccount == null)
                {
                    throw new Exception(message: "PreauthorizedPaymentAccount Object is missing.");
                }

                SubmitDealResponse SubmitDealResponse = _SubmitDealService.SubmitDeal(submitDealRequest);

                return(Ok(SubmitDealResponse));
            }
            catch (Exception ex)
            {
                _logger.LogError(ex, message: "Exception Occurred.");
                return(Result(HttpStatusCode.InternalServerError, ex.Message));
            }
        }
Exemple #3
0
        public SubmitDealResponse SubmitDeal(SubmitDealRequest request)
        {
            // Declarations
            string Product_XSU_ID  = Enums.GetEnumDescription(request.AccountDetails.Status);
            string Brand_CMR_ID    = Enums.GetEnumDescription(request.AccountDetails.Brand);
            string Investor_CMR_ID = Enums.GetEnumDescription(request.AccountDetails.Investor);
            string Broker_CMR_ID   = Enums.GetEnumDescription(request.AccountDetails.Broker);
            string MI_CMR_ID       = Enums.GetEnumDescription(request.MortgageInsuranceDetails.MortgageInsurer);

            // Deal Master Details
            string RMR_ID = _rubiDataConnect.PQ_ServicingAPI_Product_MasterReferenceFunc(request.AccountDetails.Product, Product_XSU_ID);

            // Deal Associations
            string Brand_LMR_ID           = _rubiDataConnect.PQ_ServicingAPI_Link_MasterReferenceFunc(Brand_CMR_ID, RMR_ID, Enums.GetEnumDescription(Enums.Association.Brand));
            string Investor_LMR_ID        = _rubiDataConnect.PQ_ServicingAPI_Link_MasterReferenceFunc(Investor_CMR_ID, RMR_ID, Enums.GetEnumDescription(Enums.Association.Investor));
            string MortgageInsurer_LMR_ID = _rubiDataConnect.PQ_ServicingAPI_Link_MasterReferenceFunc(MI_CMR_ID, RMR_ID, Enums.GetEnumDescription(Enums.Association.MortgageInsurer));

            if (!(request.AccountDetails.Brand == Enums.Brand.Nesto))
            {
                string Agent_LMR_ID           = _rubiDataConnect.PQ_ServicingAPI_Link_MasterReferenceFunc(Broker_CMR_ID, RMR_ID, Enums.GetEnumDescription(Enums.Association.Agent));
                string SubAgent_LMR_ID        = _rubiDataConnect.PQ_ServicingAPI_Link_MasterReferenceFunc(Broker_CMR_ID, RMR_ID, Enums.GetEnumDescription(Enums.Association.SubAgent));
                string SubmittingAgent_LMR_ID = _rubiDataConnect.PQ_ServicingAPI_Link_MasterReferenceFunc(Broker_CMR_ID, RMR_ID, Enums.GetEnumDescription(Enums.Association.SubmittingAgent));
            }

            // Deal Keys
            string NestoSubmissionID_YMR_ID     = _rubiDataConnect.PQ_ServicingAPI_Keys_MasterReferenceFunc(RMR_ID, request.RequestID, Enums.GetEnumDescription(Enums.Keys.NestoSubmissionID));
            string MortgageAccountNumber_YMR_ID = _rubiDataConnect.PQ_ServicingAPI_Keys_MasterReferenceFunc(RMR_ID, request.AccountDetails.MortgageAccountNumber, Enums.GetEnumDescription(Enums.Keys.NestoAccountID));

            // Details
            string LoanDetails_RLM_ID  = _rubiDataConnect.PQ_ServicingAPI_Product_LoanMDTFunc(RMR_ID, Enums.GetEnumDescription(request.LoanDetails.LoanPurpose), null, null);
            string LoanDetails_RCTk_ID = _rubiDataConnect.PQ_ServicingAPI_Product_ControlTaskFunc(RMR_ID, Enums.GetEnumDescription(request.LoanDetails.PaymentFrequency), 0, 0);

            string GDS_RCTi_ID = _rubiDataConnect.PQ_ServicingAPI_Product_ControlRatioFunc(RMR_ID, null, request.LoanDetails.CombinedGDS);
            string TDS_RCTi_ID = _rubiDataConnect.PQ_ServicingAPI_Product_ControlRatioFunc(RMR_ID, null, request.LoanDetails.CombinedTDS);

            string MaturityDate_RCD_ID = _rubiDataConnect.PQ_ServicingAPI_Product_ControlDateFunc(RMR_ID, 0, request.LoanDetails.MaturityDate);

            // Balances
            string PrincipalBalance_RCB_ID         = _rubiDataConnect.PQ_ServicingAPI_Product_ControlBalanceFunc(RMR_ID, Enums.GetEnumDescription(Enums.BalanceType.Principal), request.LoanDetails.OriginalLoanAmount);
            string CurrentLoanAmountBalance_RCB_ID = _rubiDataConnect.PQ_ServicingAPI_Product_ControlBalanceFunc(RMR_ID, Enums.GetEnumDescription(Enums.BalanceType.LoanAmount), request.LoanDetails.CurrentLoanAmount);
            string ApprovedBalance_RCB_ID          = _rubiDataConnect.PQ_ServicingAPI_Product_ControlBalanceFunc(RMR_ID, Enums.GetEnumDescription(Enums.BalanceType.Approved), request.LoanDetails.ApprovedBalance);
            string LoanLTV_RCB_ID = _rubiDataConnect.PQ_ServicingAPI_Product_ControlBalanceFunc(RMR_ID, Enums.GetEnumDescription(Enums.BalanceType.LoanLTV), request.SecurityPropertyDetails.LoanToValue);
            string LoanDetails_OriginalLTV_RCB_ID       = _rubiDataConnect.PQ_ServicingAPI_Product_ControlBalanceFunc(RMR_ID, Enums.GetEnumDescription(Enums.BalanceType.CMHCLoanLTV), request.LoanDetails.OriginalLTV);
            string MortgageInsurer_PremiumAmount_RCB_ID = _rubiDataConnect.PQ_ServicingAPI_Product_ControlBalanceFunc(RMR_ID, Enums.GetEnumDescription(Enums.BalanceType.MortgageInsurancePremium), request.MortgageInsuranceDetails.PremiumAmount);
            string MortgageInsurer_TaxAmount_RCB_ID     = _rubiDataConnect.PQ_ServicingAPI_Product_ControlBalanceFunc(RMR_ID, Enums.GetEnumDescription(Enums.BalanceType.MortgageInsuranceTax), request.MortgageInsuranceDetails.TaxAmount);

            string CertificateNumber_RLMI_ID = _rubiDataConnect.PQ_ServicingAPI_Product_LoanInsuranceFunc(RMR_ID, request.MortgageInsuranceDetails.BulkFlag, null, 0, 0, 0, null, null, false, false, null, null, false, false, request.MortgageInsuranceDetails.CertificateNumber);

            // Product Term and Amortization
            string ProductTerm_RCTe_ID          = _rubiDataConnect.PQ_ServicingAPI_Product_ControlTermFunc(RMR_ID, request.LoanDetails.ProductTerm_Years, request.LoanDetails.ProductTerm_Months, (request.LoanDetails.ProductTerm_Years * 12) + request.LoanDetails.ProductTerm_Months, 1);
            string AmortizationOriginal_RCTe_ID = _rubiDataConnect.PQ_ServicingAPI_Product_ControlTermFunc(RMR_ID, request.LoanDetails.AmortizationOriginal_Years, request.LoanDetails.AmortizationOriginal_Months, (request.LoanDetails.ProductTerm_Years * 12) + request.LoanDetails.ProductTerm_Months, 2);

            // Features

            // Dates
            string ClosingDate_RCD_ID     = _rubiDataConnect.PQ_ServicingAPI_Product_ControlDateFunc(RMR_ID, 1001, request.LoanDetails.ClosingDate);
            string ApplicationDate_RCD_ID = _rubiDataConnect.PQ_ServicingAPI_Product_ControlDateFunc(RMR_ID, 1, request.LoanDetails.ApplicationDate);

            // Security
            int RSP_UnitCount;

            switch (request.SecurityPropertyDetails.PropertyType)
            {
            case Enums.PropertyTypes.Filogix_TwoStorey:
            case Enums.PropertyTypes.ApartmentLowRise:
            case Enums.PropertyTypes.Detached:
            case Enums.PropertyTypes.Stacked:
            case Enums.PropertyTypes.Filogix_ThreeStorey:
            case Enums.PropertyTypes.RowHousing:
            case Enums.PropertyTypes.ModularHome_Semi_Detached:
            case Enums.PropertyTypes.Semi_Detached:
            case Enums.PropertyTypes.Mobile:
            case Enums.PropertyTypes.Filogix_StoreyandaHalf:
            case Enums.PropertyTypes.ApartmentHighRise:
            case Enums.PropertyTypes.ModularHome_Detached:
                RSP_UnitCount = 1;
                break;

            case Enums.PropertyTypes.Duplex_Detached:
            case Enums.PropertyTypes.Duplex:
            case Enums.PropertyTypes.Duplex_Semi_Detached:
                RSP_UnitCount = 2;
                break;

            case Enums.PropertyTypes.TriPlex_Detached:
            case Enums.PropertyTypes.TriPlex_Semi_Detached:
                RSP_UnitCount = 3;
                break;

            case Enums.PropertyTypes.FourPlex_Detached:
            case Enums.PropertyTypes.FourPlex_Semi_Detached:
                RSP_UnitCount = 4;
                break;

            default:
                RSP_UnitCount = 0;
                break;
            }

            string RSP_ID = _rubiDataConnect.PQ_ServicingAPI_Product_SecurityPTYFunc(
                RMR_ID,
                request.SecurityPropertyDetails.StreetType,
                Enums.GetEnumDescription(Enums.Country.Canada),
                Enums.GetEnumDescription(request.SecurityPropertyDetails.PropertyType),
                Enums.GetEnumDescription(request.SecurityPropertyDetails.Occupancy),
                null,
                request.SecurityPropertyDetails.PropertyValue,
                request.SecurityPropertyDetails.PropertyValue,
                request.SecurityPropertyDetails.UnitNumber,
                request.SecurityPropertyDetails.StreetNumber,
                request.SecurityPropertyDetails.StreetName,
                request.SecurityPropertyDetails.City,
                Enums.GetEnumDescription(request.SecurityPropertyDetails.Province),
                request.SecurityPropertyDetails.PostalCode,
                request.SecurityPropertyDetails.Direction,
                Enums.GetEnumDescription(request.SecurityPropertyDetails.ConstructionType),
                0,
                Enums.GetEnumDescription(request.SecurityPropertyDetails.SewageType),
                Enums.GetEnumDescription(request.SecurityPropertyDetails.WaterType),
                RSP_UnitCount
                );

            // Borrowers
            foreach (Borrower borrower in request.Borrowers)
            {
                // Borrower Master Details
                string Borrower_CMR_ID = _rubiDataConnect.PQ_ServicingAPI_Client_MasterReferenceFunc(borrower.LastName + borrower.FirstName, Enums.GetEnumDescription(borrower.Language));
                string Borrower_CTI_ID = _rubiDataConnect.PQ_ServicingAPI_Client_TypeIndividualFunc(Borrower_CMR_ID, Enums.GetEnumDescription(borrower.MartialStatus), borrower.FirstName, borrower.MiddleName, borrower.LastName, borrower.DOB);

                // Address
                string MailingAddress_CAD_ID = _rubiDataConnect.PQ_ServicingAPI_Client_AddressDetailFunc(
                    Borrower_CMR_ID,
                    Enums.GetEnumDescription(Enums.AddressType.Mailing),
                    borrower.StreetType,
                    Enums.GetEnumDescription(borrower.Country),
                    borrower.Unit,
                    borrower.Number,
                    borrower.StreetName,
                    borrower.City,
                    Enums.GetEnumDescription(borrower.Province),
                    borrower.PostalCode
                    );
                string CurrentAddress_CAD_ID = _rubiDataConnect.PQ_ServicingAPI_Client_AddressDetailFunc(
                    Borrower_CMR_ID,
                    Enums.GetEnumDescription(Enums.AddressType.Current),
                    borrower.StreetType,
                    Enums.GetEnumDescription(borrower.Country),
                    borrower.Unit,
                    borrower.Number,
                    borrower.StreetName,
                    borrower.City,
                    Enums.GetEnumDescription(borrower.Province),
                    borrower.PostalCode
                    );

                // Association
                switch (borrower.ClientType)
                {
                case Enums.ClientType.PriBorrower:
                    string PriBorrower_LMR_ID = _rubiDataConnect.PQ_ServicingAPI_Link_MasterReferenceFunc(Borrower_CMR_ID, RMR_ID, Enums.GetEnumDescription(Enums.Association.PrimaryBorrower));
                    break;

                case Enums.ClientType.CoBorrower:
                    string CoBorrower_LMR_ID = _rubiDataConnect.PQ_ServicingAPI_Link_MasterReferenceFunc(Borrower_CMR_ID, RMR_ID, Enums.GetEnumDescription(Enums.Association.CoBorrower));
                    break;

                case Enums.ClientType.Guarantor:
                    string Guarantor_LMR_ID = _rubiDataConnect.PQ_ServicingAPI_Link_MasterReferenceFunc(Borrower_CMR_ID, RMR_ID, Enums.GetEnumDescription(Enums.Association.Guarantor));
                    break;

                default:
                    break;
                }

                // Keys
                string CustomerAccountNumber_YMR_ID = _rubiDataConnect.PQ_ServicingAPI_Keys_MasterReferenceFunc(Borrower_CMR_ID, borrower.CustomerAccountNumber, Enums.GetEnumDescription(Enums.Keys.CustomerAccountNumber));
                string CustomerBeaconScore_YMR_ID   = _rubiDataConnect.PQ_ServicingAPI_Keys_MasterReferenceFunc(Borrower_CMR_ID, borrower.CustomerAccountNumber, Enums.GetEnumDescription(Enums.Keys.CustomerBeaconScore));

                // Contact Info
                string HomePhone_CCD_ID   = _rubiDataConnect.PQ_ServicingAPI_Client_ContactDetailFunc(Borrower_CMR_ID, Enums.GetEnumDescription(Enums.ContactType.HomePhone), borrower.HomePhone, null);
                string MobilePhone_CCD_ID = _rubiDataConnect.PQ_ServicingAPI_Client_ContactDetailFunc(Borrower_CMR_ID, Enums.GetEnumDescription(Enums.ContactType.MobilePhone), borrower.MobilePhone, null);
                string Email_CCD_ID       = _rubiDataConnect.PQ_ServicingAPI_Client_ContactDetailFunc(Borrower_CMR_ID, Enums.GetEnumDescription(Enums.ContactType.Email), borrower.Email, null);


                if (borrower.Income != null)
                {
                    // Employment
                    string Employment_CED_ID = _rubiDataConnect.PQ_ServicingAPI_Client_IndividualEmploymentFunc(
                        Borrower_CMR_ID,
                        null,
                        null,
                        borrower.Income.EmploymentName,
                        borrower.Income.EmploymentAddress.UnitNumber,
                        borrower.Income.EmploymentAddress.StreetNumber,
                        borrower.Income.EmploymentAddress.StreetName,
                        borrower.Income.EmploymentAddress.City,
                        borrower.Income.EmploymentAddress.Province.ToString(),
                        borrower.Income.EmploymentAddress.PostalCode,
                        borrower.Income.TimeInServiceYear,
                        borrower.Income.TimeInServiceMonth
                        );

                    // Income
                    string Income_CINc_ID = _rubiDataConnect.PQ_ServicingAPI_client_individualincomeFunc(Borrower_CMR_ID, borrower.Income.IncomeType, null, borrower.Income.IncomeAmount, null);
                }

                //Client Bank detail
                string BankDetail_CBD_ID = _rubiDataConnect.PQ_ServicingAPI_Client_BankDetailFunc(Borrower_CMR_ID, null, request.PreauthorizedPaymentAccount.CustomerAccountNumber.ToString(), null, null, false, request.PreauthorizedPaymentAccount.Transit.ToString(), request.PreauthorizedPaymentAccount.BankID.ToString());
            }

            string OriginalPaymentAmount_RLP_ID = _rubiDataConnect.PQ_ServicingAPI_Product_LoanPaymentFunc(RMR_ID, 7700, (float)request.PrePaymentPrivileges.OriginalPaymentAmount, 0, 0, 0, 0, null);
            string CurrentPaymentAmount_RLP_ID  = _rubiDataConnect.PQ_ServicingAPI_Product_LoanPaymentFunc(RMR_ID, 1, (float)request.PrePaymentPrivileges.CurrentPaymentAmount, 0, 0, 0, 0, null);

            string CashBack_RCB_ID = _rubiDataConnect.PQ_ServicingAPI_Product_ControlBalanceFunc(RMR_ID, Enums.GetEnumDescription(Enums.BalanceType.CashBack), request.PrePaymentPrivileges.CashBack);

            // Results
            Deal               IngestedDeal    = _dealService.GetById(RMR_ID, Brand_CMR_ID);
            List <Client>      ClientsIngested = _clientService.GetAll(RMR_ID);
            SubmitDealResponse response        = new SubmitDealResponse(IngestedDeal, ClientsIngested);

            return(response);
        }
Exemple #4
0
 public SubmitDealResponse SubmitDeal(SubmitDealRequest request)
 {
     return(_rubiDataConnect.SubmitDealFunc(request));
 }
Exemple #5
0
        public IActionResult AskQuestion(SubmitDealRequest submitDealRequest)
        {
            SubmitDealResponse SubmitDealResponse = _SubmitDealService.SubmitDeal(submitDealRequest);

            return(Ok(SubmitDealResponse));
        }