private Loan _GetLoan(OpenCbsReader r) { return new Loan(_user, ApplicationSettings.GetInstance(_user.Md5), NonWorkingDateSingleton.GetInstance(_user.Md5), ProvisionTable.GetInstance(_user), ChartOfAccounts.GetInstance(_user)) { Id = r.GetInt("credit_id"), ClientType = r.GetChar("client_type_code") == 'I' ? OClientTypes.Person : r.GetChar("client_type_code") == 'G' ? OClientTypes.Group : OClientTypes.Corporate, ContractStatus = (OContractStatus) r.GetSmallInt("status"), CreditCommiteeDate = r.GetNullDateTime("credit_commitee_date"), CreditCommiteeComment = r.GetString("credit_commitee_comment"), CreditCommitteeCode = r.GetString("credit_commitee_code"), Amount = r.GetMoney("amount"), InterestRate = r.GetDecimal("interest_rate"), NbOfInstallments = r.GetInt("nb_of_installment"), NonRepaymentPenalties = new NonRepaymentPenalties { InitialAmount = r.GetDouble("non_repayment_penalties_based_on_initial_amount"), OLB = r.GetDouble("non_repayment_penalties_based_on_olb"), OverDueInterest = r.GetDouble("non_repayment_penalties_based_on_overdue_interest"), OverDuePrincipal = r.GetDouble("non_repayment_penalties_based_on_overdue_principal") }, AnticipatedTotalRepaymentPenalties = r.GetDouble("anticipated_total_repayment_penalties"), AnticipatedPartialRepaymentPenalties = r.GetDouble("anticipated_partial_repayment_penalties"), AnticipatedPartialRepaymentPenaltiesBase = (OAnticipatedRepaymentPenaltiesBases) r.GetSmallInt("anticipated_partial_repayment_base"), AnticipatedTotalRepaymentPenaltiesBase =(OAnticipatedRepaymentPenaltiesBases) r.GetSmallInt("anticipated_total_repayment_base"), Disbursed = r.GetBool("disbursed"), GracePeriod = r.GetNullInt("grace_period"), GracePeriodOfLateFees = r.GetNullInt("grace_period_of_latefees"), WrittenOff = r.GetBool("written_off"), Rescheduled = r.GetBool("rescheduled"), Code = r.GetString("contract_code"), BranchCode = r.GetString("branch_code"), CreationDate = r.GetDateTime("creation_date"), StartDate = r.GetDateTime("start_date"), AlignDisbursementDate = r.GetDateTime("align_disbursed_date"), CloseDate = r.GetDateTime("close_date"), Closed = r.GetBool("closed"), BadLoan = r.GetBool("bad_loan"), Synchronize = r.GetBool("synchronize"), ScheduleChangedManually = r.GetBool("schedule_changed"), AmountUnderLoc = r.GetMoney("amount_under_loc"), CompulsorySavingsPercentage = r.GetNullInt("loan_percentage"), LoanPurpose = r.GetString("loan_purpose"), Comments = r.GetString("comments"), AmountMin = r.GetMoney("amount_min"), AmountMax = r.GetMoney("amount_max"), InterestRateMin = r.GetNullDecimal("ir_min"), InterestRateMax = r.GetNullDecimal("ir_max"), NmbOfInstallmentsMin = r.GetNullInt("nmb_of_inst_min"), NmbOfInstallmentsMax = r.GetNullInt("nmb_of_inst_max"), LoanCycle = r.GetNullInt("loan_cycle"), Insurance = r.GetDecimal("insurance"), NsgID = r.GetNullInt("nsg_id"), EconomicActivityId = r.GetInt("activity_id"), FirstInstallmentDate = r.GetDateTime("preferred_first_installment_date"), }; }
private static TrancheEvent GetTransh(OpenCbsReader r) { return new TrancheEvent { Number = r.GetInt("Number"), StartDate = r.GetDateTime("start_date"), Amount = r.GetMoney("amount"), Maturity = r.GetInt("countOfInstallments"), ApplyNewInterest = r.GetBool("ApplyNewInterest"), InterestRate = r.GetDecimal("interest_rate"), StartedFromInstallment = r.GetInt("started_from_installment"), Deleted = r.GetBool("is_deleted"), Id = r.GetInt("event_id") }; }
private static Event GetCreditInsuranceEvent(OpenCbsReader r) { CreditInsuranceEvent cie = new CreditInsuranceEvent(); cie.Id = r.GetInt("cie_id"); cie.Commission = r.GetDecimal("cie_commission"); cie.Principal = r.GetDecimal("cie_principal"); return cie; }
private static LoanProduct GetProduct(OpenCbsReader r) { LoanProduct package = new LoanProduct(); package.Id = r.GetInt("id"); package.Delete = r.GetBool("deleted"); package.Name = r.GetString("name"); package.Code = r.GetString("code"); package.ClientType = r.GetChar("client_type"); package.LoanType = (OLoanTypes)r.GetSmallInt("loan_type"); package.RoundingType = (ORoundingType)r.GetSmallInt("rounding_type"); package.Amount = r.GetMoney("amount"); package.AmountMin = r.GetMoney("amount_min"); package.AmountMax = r.GetMoney("amount_max"); package.InterestRate = r.GetNullDecimal("interest_rate"); package.InterestRateMin = r.GetNullDecimal("interest_rate_min"); package.InterestRateMax = r.GetNullDecimal("interest_rate_max"); package.GracePeriod = r.GetNullInt("grace_period"); package.GracePeriodMin = r.GetNullInt("grace_period_min"); package.GracePeriodMax = r.GetNullInt("grace_period_max"); package.GracePeriodOfLateFees = r.GetNullInt("grace_period_of_latefees"); package.NbOfInstallments = r.GetNullInt("number_of_installments"); package.NbOfInstallmentsMin = r.GetNullInt("number_of_installments_min"); package.NbOfInstallmentsMax = r.GetNullInt("number_of_installments_max"); package.AnticipatedTotalRepaymentPenalties = r.GetNullDouble("anticipated_total_repayment_penalties"); package.AnticipatedTotalRepaymentPenaltiesMin = r.GetNullDouble("anticipated_total_repayment_penalties_min"); package.AnticipatedTotalRepaymentPenaltiesMax = r.GetNullDouble("anticipated_total_repayment_penalties_max"); package.AnticipatedPartialRepaymentPenalties = r.GetNullDouble("anticipated_partial_repayment_penalties"); package.AnticipatedPartialRepaymentPenaltiesMin = r.GetNullDouble("anticipated_partial_repayment_penalties_min"); package.AnticipatedPartialRepaymentPenaltiesMax = r.GetNullDouble("anticipated_partial_repayment_penalties_max"); package.ChargeInterestWithinGracePeriod = r.GetBool("charge_interest_within_grace_period"); package.KeepExpectedInstallment = r.GetBool("keep_expected_installment"); package.AnticipatedTotalRepaymentPenaltiesBase = (OAnticipatedRepaymentPenaltiesBases)r.GetSmallInt("anticipated_total_repayment_base"); package.AnticipatedPartialRepaymentPenaltiesBase = (OAnticipatedRepaymentPenaltiesBases)r.GetSmallInt("anticipated_partial_repayment_base"); package.NonRepaymentPenalties.InitialAmount = r.GetNullDouble("non_repayment_penalties_based_on_initial_amount"); package.NonRepaymentPenalties.OLB = r.GetNullDouble("non_repayment_penalties_based_on_olb"); package.NonRepaymentPenalties.OverDueInterest = r.GetNullDouble("non_repayment_penalties_based_on_overdue_interest"); package.NonRepaymentPenalties.OverDuePrincipal = r.GetNullDouble("non_repayment_penalties_based_on_overdue_principal"); package.NonRepaymentPenaltiesMin.InitialAmount = r.GetNullDouble("non_repayment_penalties_based_on_initial_amount_min"); package.NonRepaymentPenaltiesMin.OLB = r.GetNullDouble("non_repayment_penalties_based_on_olb_min"); package.NonRepaymentPenaltiesMin.OverDuePrincipal = r.GetNullDouble("non_repayment_penalties_based_on_overdue_principal_min"); package.NonRepaymentPenaltiesMin.OverDueInterest = r.GetNullDouble("non_repayment_penalties_based_on_overdue_interest_min"); package.NonRepaymentPenaltiesMax.InitialAmount = r.GetNullDouble("non_repayment_penalties_based_on_initial_amount_max"); package.NonRepaymentPenaltiesMax.OLB = r.GetNullDouble("non_repayment_penalties_based_on_olb_max"); package.NonRepaymentPenaltiesMax.OverDueInterest = r.GetNullDouble("non_repayment_penalties_based_on_overdue_interest_max"); package.NonRepaymentPenaltiesMax.OverDuePrincipal = r.GetNullDouble("non_repayment_penalties_based_on_overdue_principal_max"); package.AllowFlexibleSchedule = r.GetBool("allow_flexible_schedule"); package.UseGuarantorCollateral = r.GetBool("use_guarantor_collateral"); package.SetSeparateGuarantorCollateral = r.GetBool("set_separate_guarantor_collateral"); package.PercentageTotalGuarantorCollateral = r.GetInt("percentage_total_guarantor_collateral"); package.PercentageSeparateGuarantour = r.GetInt("percentage_separate_guarantor"); package.PercentageSeparateCollateral = r.GetInt("percentage_separate_collateral"); package.UseCompulsorySavings = r.GetBool("use_compulsory_savings"); package.CompulsoryAmount = r.GetNullInt("compulsory_amount"); package.CompulsoryAmountMin = r.GetNullInt("compulsory_amount_min"); package.CompulsoryAmountMax = r.GetNullInt("compulsory_amount_max"); package.UseEntryFeesCycles = r.GetBool("use_entry_fees_cycles"); //if (DatabaseHelper.GetNullAuthorizedInt32("fundingLine_id", pReader).HasValue) //{ // package.FundingLine = new FundingLine { Id = r.GetNullInt("fundingLine_id").Value }; // package.FundingLine.Name = r.GetString("funding_line_name"); // package.FundingLine.Currency = new Currency { Id = r.GetInt("funding_line_currency_id") }; //} if (r.GetNullInt("currency_id").HasValue) { package.Currency = new Currency { Id = r.GetInt("currency_id"), Code = r.GetString("currency_code"), Name = r.GetString("currency_name"), IsPivot = r.GetBool("currency_is_pivot"), IsSwapped = r.GetBool("currency_is_swapped"), UseCents = r.GetBool("currency_use_cents") }; } /* Line of credit */ package.DrawingsNumber = r.GetNullInt("number_of_drawings_loc"); package.AmountUnderLoc = r.GetMoney("amount_under_loc"); package.AmountUnderLocMin = r.GetMoney("amount_under_loc_min"); package.AmountUnderLocMax = r.GetMoney("amount_under_loc_max"); package.MaturityLoc = r.GetNullInt("maturity_loc"); package.MaturityLocMin = r.GetNullInt("maturity_loc_min"); package.MaturityLocMax = r.GetNullInt("maturity_loc_max"); package.ActivatedLOC = r.GetBool("activated_loc"); package.CycleId = r.GetNullInt("cycle_id"); package.CreditInsuranceMin = r.GetDecimal("insurance_min"); package.CreditInsuranceMax = r.GetDecimal("insurance_max"); package.InterestScheme = (OInterestScheme)r.GetInt("interest_scheme"); return package; }
private static RescheduleLoanEvent GetReschedulingLoanEvent(OpenCbsReader r) { return new RescheduleLoanEvent{ Id = r.GetInt("rle_id"), Amount = r.GetMoney("rle_amount"), NbOfMaturity = r.GetInt("rle_maturity"), PreferredFirstInstallmentDate = r.GetDateTime("rle_preferred_first_installment_date"), PreviousInterestRate = r.GetDecimal("rle_previous_interest_rate") }; }
private static Event GetPenaltyWriteOffEvent(OpenCbsReader r) { var result = new PenaltyWriteOffEvent(); result.Id = r.GetInt("pwoe_id"); result.Amount = r.GetDecimal("pwoe_amount"); return result; }