} // Find private void NLCashRequestAdd() { AddCashRequest nlAddCashRequest = new AddCashRequest(new NL_CashRequests { CashRequestOriginID = (int)this.cashRequestOriginator, CustomerID = this.customerID, OldCashRequestID = CashRequestID, RequestTime = DateTime.UtcNow, UserID = this.underwriterID, }) { Transaction = this.transaction, }; nlAddCashRequest.Context.CustomerID = this.customerID; nlAddCashRequest.Context.UserID = this.underwriterID; nlAddCashRequest.Execute(); NLCashRequestID = nlAddCashRequest.CashRequestID; } // NLCashRequestAdd
public override void Execute() { string query = "select top 20 Id from Loan l left join NL_Loans nl on nl.OldLoanID=l.Id and l.Id=null and l.Modified=0"; NL_AddLog(LogType.Info, "Strategy start", query, null, null, null); List<MigrateLoanTransaction.LoanId> loansList = DB.Fill<MigrateLoanTransaction.LoanId>(query, CommandSpecies.Text); if (loansList.Count == 0) { Error = "Loans to migrate to NL not found"; Log.Debug(Error); NL_AddLog(LogType.Info, "Strategy end", query, null, Error, null); return; } NL_AddLog(LogType.Info, "Loans to migrate", null, loansList.Count, null, null); foreach (MigrateLoanTransaction.LoanId l in loansList) { Loan loan = loanRep.Get(l.Id); if (loan == null) { Error = string.Format("Failed to load old loan {0}", l.Id); Log.Info(Error); NL_AddLog(LogType.Info, Error, l.Id, null, Error, null); continue; } Context.CustomerID = loan.Customer.Id; Context.UserID = loan.CashRequest.IdUnderwriter; try { // [ELINAR-PC].[ezbob].[dbo].[NL_CashRequestGetByOldID] query = "select CashRequestID from NL_CashRequests where [OldCashRequestID]=" + loan.CashRequest.Id; Log.Debug("Processing loan {0}, cr {1}, {2}", loan.Id, loan.CashRequest.Id, query); MigrateLoanTransaction.CashReqModel crModel = DB.FillFirst<MigrateLoanTransaction.CashReqModel>(query, CommandSpecies.Text, new QueryParameter("@crID", loan.CashRequest.Id)); NL_AddLog(LogType.Info, "crModel", new object[] { query, loan.CashRequest.Id, l.Id }, crModel, null, null); // copy to NL_CashRequests if (crModel.CashRequestID == 0L) { AddCashRequest sCashRequest = new AddCashRequest(new NL_CashRequests { CustomerID = loan.Customer.Id, RequestTime = (DateTime)loan.CashRequest.CreationDate, CashRequestOriginID = loan.CashRequest.Originator.HasValue ? (int)loan.CashRequest.Originator.Value : 5, // NL_CashRequestOrigins "Other" UserID = loan.CashRequest.IdUnderwriter ?? 1, OldCashRequestID = loan.CashRequest.Id }); sCashRequest.Context.CustomerID = Context.CustomerID; sCashRequest.Context.UserID = Context.UserID; sCashRequest.Execute(); crModel.CashRequestID = sCashRequest.CashRequestID; } if (crModel.CashRequestID == 0L) { Error = string.Format("Failed to add/find nl CR, oldID {0}, crID {1}", loan.Id, loan.CashRequest.Id); Log.Info(Error); NL_AddLog(LogType.Info, "NL CR failed", loan.CashRequest.Id, null, Error, null); continue; } // copy decisions foreach (DecisionHistory dh in loan.CashRequest.DecisionHistories) { query = string.Format("select DecisionID from [dbo].[NL_Decisions] d join [dbo].[NL_CashRequests] c on d.CashRequestID=c.CashRequestID and c.OldCashRequestID={0} and d.UserID={1} " + "and d.DecisionNameID={2} and d.DecisionTime='{3}'", dh.CashRequest.Id, dh.Underwriter.Id, (int)dh.Action, dh.Date.ToString("yyyy-MM-dd HH:mm:ss")); //query = "select DecisionID from [dbo].[NL_Decisions] d join [dbo].[NL_CashRequests] c on d.CashRequestID=c.CashRequestID and c.OldCashRequestID=@crID " + // "and d.UserID=@uID and d.DecisionNameID=@dID and d.DecisionTime='@dDate'"; //"datediff(DAY, d.DecisionTime, '@dDate')=0"; MigrateLoanTransaction.CashReqModel dModel = DB.FillFirst<MigrateLoanTransaction.CashReqModel>(query, CommandSpecies.Text/*, new QueryParameter("@crID", dh.CashRequest.Id), new QueryParameter("@uID", dh.Underwriter.Id), new QueryParameter("@dID", (int)dh.Action), new QueryParameter("@dDate", dh.Date.ToString("yyyy-MM-dd HH:mm:ss"))*/); NL_AddLog(LogType.Info, "dModel", new object[] { query, dh.CashRequest.Id, dh.Underwriter.Id, (int)dh.Action, dh.Date }, dModel, null, null); if (dModel.DecisionID == 0L) { List<NL_DecisionRejectReasons> rejectReasons = new List<NL_DecisionRejectReasons>(); if (dh.RejectReasons.Count > 0) { dh.RejectReasons.ForEach(x => rejectReasons.Add(new NL_DecisionRejectReasons() { RejectReasonID = x.RejectReason.Id })); } AddDecision sDesicion = new AddDecision(new NL_Decisions { CashRequestID = dh.CashRequest.Id, UserID = dh.Underwriter.Id, DecisionNameID = (int)dh.Action, DecisionTime = dh.Date, Notes = string.Format("{0}. (migrated: old crID {1}, loan {2})", dh.Comment, loan.CashRequest.Id, l.Id) }, loan.CashRequest.Id, rejectReasons); sDesicion.Context.CustomerID = dh.Customer.Id; sDesicion.Context.UserID = dh.Underwriter.Id; sDesicion.Execute(); dModel.DecisionID = sDesicion.DecisionID; crModel.DecisionID = dModel.DecisionID; } // NL_Offers for approve decision if (dh.Action.Equals(DecisionActions.Approve)) { NL_OfferFees offerFee = new NL_OfferFees { LoanFeeTypeID = (int)NLFeeTypes.SetupFee, Percent = loan.CashRequest.ManualSetupFeePercent ?? 0, OneTimePartPercent = 1, DistributedPartPercent = 0 }; if (loan.CashRequest.SpreadSetupFee != null && loan.CashRequest.SpreadSetupFee == true) { offerFee.LoanFeeTypeID = (int)NLFeeTypes.ServicingFee; offerFee.OneTimePartPercent = 0; offerFee.DistributedPartPercent = 1; } NL_OfferFees[] fees = { offerFee }; AddOffer sOffer = new AddOffer(new NL_Offers { DecisionID = dModel.DecisionID, LoanTypeID = (int)NL_Model.LoanTypeNameToNLLoanType(loan.CashRequest.LoanType.Name), LoanSourceID = loan.CashRequest.LoanSource.ID, RepaymentIntervalTypeID = (int)RepaymentIntervalTypes.Month, Amount = loan.CashRequest.ApprovedSum(), StartTime = (DateTime)loan.CashRequest.OfferStart, EndTime = (DateTime)loan.CashRequest.OfferValidUntil, CreatedTime = (DateTime)loan.CashRequest.UnderwriterDecisionDate, // TODO ???? DiscountPlanID = loan.CashRequest.DiscountPlan.Id, // supposed discounts transformed right MonthlyInterestRate = loan.CashRequest.InterestRate, RepaymentCount = loan.CashRequest.ApprovedRepaymentPeriod ?? loan.CashRequest.RepaymentPeriod, BrokerSetupFeePercent = loan.CashRequest.BrokerSetupFeePercent, IsLoanTypeSelectionAllowed = loan.CashRequest.IsCustomerRepaymentPeriodSelectionAllowed, IsRepaymentPeriodSelectionAllowed = loan.CashRequest.IsCustomerRepaymentPeriodSelectionAllowed, SendEmailNotification = !loan.CashRequest.EmailSendingBanned, Notes = string.Format("{0}. (migrated: old crID {1}, loan {2})", loan.CashRequest.UnderwriterComment, loan.CashRequest.Id, l.Id), ProductSubTypeID = loan.CashRequest.ProductSubTypeID ?? null }, fees); sOffer.Context.CustomerID = dh.Customer.Id; sOffer.Context.UserID = dh.Underwriter.Id; sOffer.Execute(); crModel.OfferID = sOffer.OfferID; } } // do in backfill - after migration end // update .[dbo].[MedalCalculations], .[dbo].[MedalCalculationsAV] // query = // "IF (SELECT [NLCashRequestID] FROM [dbo].[MedalCalculations] WHERE [CashRequestID]=@crID) is null begin update [dbo].[MedalCalculations] set [NLCashRequestID]=@nlcrID where [CashRequestID]=@crID end " + // "IF (SELECT [NLCashRequestID] FROM [dbo].[MedalCalculationsAV] WHERE [CashRequestID]=@crID) is null begin update [dbo].[MedalCalculationsAV] set [NLCashRequestID]=@nlcrID where [CashRequestID]=@crID end"; // + "IF (SELECT [NLOfferID] FROM [dbo].[I_InvestorSystemBalance] WHERE [CashRequestID]=@crID) is null begin update [dbo].[I_InvestorSystemBalance] set [NLOfferID]=@nlcrID where [CashRequestID]=@crID end "; // DB.ExecuteNonQuery(query, CommandSpecies.Text, new QueryParameter("@crID", loan.CashRequest.Id), new QueryParameter("@nlcrID", crModel.CashRequestID)); NL_AddLog(LogType.Info, "Strategy end", loansList, Error, null, null); // ReSharper disable once CatchAllClause } catch (Exception exc) { Error = exc.Message; Log.Alert(exc); NL_AddLog(LogType.Error, "Strategy failed", null, Error, exc.ToString(), exc.StackTrace); return; } } }