C# OpenCbsReader.GetString方法代码示例

        private static void SetSavingsEvent(OpenCbsReader r, SavingEvent e, ISavingProduct pProduct)
        {
            e.Id = r.GetInt("id");
            e.ContracId = r.GetInt("contract_id");
            e.Code = r.GetString("code");
            e.Amount = r.GetMoney("amount");
            e.Description = r.GetString("description");
            e.Deleted = r.GetBool("deleted");
            e.Date = r.GetDateTime("creation_date");
            e.Cancelable = r.GetBool("cancelable");
            e.IsFired = r.GetBool("is_fired");
            e.CancelDate = r.GetNullDateTime("cancel_date");

            if(pProduct != null)
                e.ProductType = pProduct.GetType();

            if (r.GetNullSmallInt("savings_method").HasValue)
                e.SavingsMethod = (OSavingsMethods)r.GetNullSmallInt("savings_method").Value;

            e.IsPending = r.GetBool("pending");
            e.PendingEventId = r.GetNullInt("pending_event_id");
            e.TellerId = r.GetNullInt("teller_id");
            e.LoanEventId = r.GetNullInt("loan_event_id");

            if (pProduct != null)
            {
                e.ProductType = pProduct.GetType();
            }

            if (e is SavingTransferEvent)
            {
                ((SavingTransferEvent)e).RelatedContractCode = r.GetString("related_contract_code");
            }

            if (e is ISavingsFees)
            {
                ((ISavingsFees) e).Fee = r.GetMoney("fees");
            }

            e.User = new User
                         {
                             Id = r.GetInt("user_id"),
                             UserName = r.GetString("user_name"),
                             Password = r.GetString("user_pass"),
                             LastName = r.GetString("last_name"),
                             FirstName = r.GetString("first_name")
                         };
            e.User.SetRole(r.GetString("role_code"));

            e.ClientType = OClientTypes.All;

            switch (r.GetString("client_type_code"))
            {
                case "I":
                    e.ClientType = OClientTypes.Person; break;
                case "C":
                    e.ClientType = OClientTypes.Corporate; break;
                case "G":
                    e.ClientType = OClientTypes.Group; break;
                case "V":
                    e.ClientType = OClientTypes.Village; break;
            }

            e.Branch = new Branch { Id = r.GetInt("branch_id") };
            e.Currency = new Currency
                             {
                                 Id = r.GetInt("currency_id"),
                                 Code = r.GetString("currency_code"),
                                 IsPivot = r.GetBool("is_pivot"),
                                 IsSwapped = r.GetBool("is_swapped")
                             };
            e.SavingProduct = new SavingsBookProduct { Id = r.GetInt("product_id") };
        }

 private static Account GetAccount(OpenCbsReader pReader)
 {
     return new Account
     {
         Id = pReader.GetInt("id"),
         Number = pReader.GetString("account_number"),
         Label = pReader.GetString("label"),
         DebitPlus = pReader.GetBool("debit_plus"),
         TypeCode = pReader.GetString("type_code"),
         AccountCategory = ((OAccountCategories)pReader.GetSmallInt("account_category_id")),
         Type = pReader.GetBool("type"),
         ParentAccountId = pReader.GetNullInt("parent_account_id"),
         Left = pReader.GetInt("lft"),
         Right = pReader.GetInt("rgt")
     };
 }

        private static SavingEvent ReadEvent(OpenCbsReader r, ISavingProduct pProduct)
        {
            string code = r.GetString("code");
            SavingEvent e = GetSavingsEvent(code);
            SetSavingsEvent(r, e, pProduct);

            return e;
        }

        private static Booking GetBooking(OpenCbsReader reader)
        {
            return new Booking
                       {
                           Id = reader.GetInt("id"),
                           Amount = reader.GetMoney("amount"),
                           IsExported = reader.GetBool("is_exported"),
                           DebitAccount =
                               new Account
                                   {
                                       Id = reader.GetInt("debit_account_number_id")
                                   },
                           CreditAccount =
                               new Account
                                   {
                                       Id = reader.GetInt("credit_account_number_id")
                                   },
                           EventId = reader.GetInt("event_id"),
                           ContractId = reader.GetInt("contract_id"),

                           Date = reader.GetDateTime("transaction_date"),
                           Currency =
                               new Currency
                                   {Id = reader.GetInt("currency_id")},
                           ExchangeRate = reader.GetDouble("exchange_rate"),
                           Description = reader.GetString("description"),
                           Branch = new Branch {Id = reader.GetInt("branch_id")}

                       };
        }

 private void GetSavingBookFromReader(SavingBookContract saving, OpenCbsReader reader)
 {
     saving.FlatWithdrawFees = reader.GetNullDecimal("flat_withdraw_fees");
     saving.RateWithdrawFees = reader.GetNullDouble("rate_withdraw_fees");
     saving.FlatTransferFees = reader.GetNullDecimal("flat_transfer_fees");
     saving.RateTransferFees = reader.GetNullDouble("rate_transfer_fees");
     saving.DepositFees = reader.GetNullDecimal("flat_deposit_fees");
     saving.ChequeDepositFees = reader.GetNullDecimal("cheque_deposit_fees");
     saving.CloseFees = reader.GetNullDecimal("flat_close_fees");
     saving.ManagementFees = reader.GetNullDecimal("flat_management_fees");
     saving.OverdraftFees = reader.GetNullDecimal("flat_overdraft_fees");
     saving.InOverdraft = reader.GetBool("in_overdraft");
     saving.AgioFees = reader.GetNullDouble("rate_agio_fees");
     saving.ReopenFees = reader.GetNullDecimal("flat_reopen_fees");
     saving.FlatInterBranchTransferFee = reader.GetNullDecimal("flat_ibt_fee");
     saving.RateInterBranchTransferFee =reader.GetNullDouble("rate_ibt_fee");
     saving.UseTermDeposit = reader.GetBool("use_term_deposit");
     saving.NumberOfPeriods = reader.GetInt("term_deposit_period");
     saving.TermDepositPeriodMin = reader.GetNullInt("term_deposit_period_min");
     saving.TermDepositPeriodMax = reader.GetNullInt("term_deposit_period_max");
     saving.TransferAccount = new SavingBookContract(ApplicationSettings.GetInstance(_user.Md5), _user)
     { Code = reader.GetString("transfer_account") };
     saving.NextMaturity = reader.GetNullDateTime("next_maturity");
     if (saving.UseTermDeposit)
         saving.Rollover = (OSavingsRollover) reader.GetInt("rollover");
     // This is the bozo's way of fetching branch information.
     // Ideally it should be available through the saving's client object.
     // But that object is initialized in many places so that modifying
     // it does not look feasible.
     // Instead, we constract a new Branch object *partially* and then
     // through the OnSavingSelected below call back into the Service layer
     // to finalize the construction.
     saving.Branch = new Branch {Id = reader.GetInt("branch_id")};
 }

        private static ISavingProduct GetProduct(OpenCbsReader r)
        {
            ISavingProduct product;

            switch (r.GetChar("product_type"))
            {
                case 'B' : product = new SavingsBookProduct(); break;
               default : product = null; break;
            }

            product.Id = r.GetInt("id");
            product.Delete = r.GetBool("deleted");
            product.Name = r.GetString("name");
            product.Code = r.GetString("code");

            product.ClientType = r.GetChar("client_type") == 'C' ? OClientTypes.Corporate
                                 : r.GetChar("client_type") == 'G' ? OClientTypes.Group
                                 : r.GetChar("client_type") == 'I' ? OClientTypes.Person
                                 : OClientTypes.All;

            product.InitialAmountMin = r.GetMoney("initial_amount_min");
            product.InitialAmountMax = r.GetMoney("initial_amount_max");
            product.BalanceMin = r.GetMoney("balance_min");
            product.BalanceMax = r.GetMoney("balance_max");
            product.DepositMin = r.GetMoney("deposit_min");
            product.DepositMax = r.GetMoney("deposit_max");
            product.WithdrawingMin = r.GetMoney("withdraw_min");
            product.WithdrawingMax = r.GetMoney("withdraw_max");
            product.TransferMin = r.GetMoney("transfer_min");
            product.TransferMax = r.GetMoney("transfer_max");
            product.InterestRate = r.GetNullDouble("interest_rate");
            product.InterestRateMin = r.GetNullDouble("interest_rate_min");
            product.InterestRateMax = r.GetNullDouble("interest_rate_max");
            product.EntryFees = r.GetMoney("entry_fees");
            product.EntryFeesMax = r.GetMoney("entry_fees_max");
            product.EntryFeesMin = r.GetMoney("entry_fees_min");

            if (product is SavingsBookProduct)
            {
                var savingBookProduct = (SavingsBookProduct) product;

                savingBookProduct.InterestBase = (OSavingInterestBase)r.GetSmallInt("interest_base");
                savingBookProduct.InterestFrequency = (OSavingInterestFrequency)r.GetSmallInt("interest_frequency");

                if (savingBookProduct.InterestBase == OSavingInterestBase.Monthly ||
                    savingBookProduct.InterestBase == OSavingInterestBase.Weekly)
                    savingBookProduct.CalculAmountBase = (OSavingCalculAmountBase)r.GetSmallInt("calcul_amount_base");

                savingBookProduct.WithdrawFeesType = (OSavingsFeesType)r.GetSmallInt("withdraw_fees_type");
                if (savingBookProduct.WithdrawFeesType == OSavingsFeesType.Flat)
                {
                    savingBookProduct.FlatWithdrawFeesMin = r.GetMoney("flat_withdraw_fees_min");
                    savingBookProduct.FlatWithdrawFeesMax = r.GetMoney("flat_withdraw_fees_max");
                    savingBookProduct.FlatWithdrawFees = r.GetMoney("flat_withdraw_fees");
                }
                else
                {
                    savingBookProduct.RateWithdrawFeesMin = r.GetNullDouble("rate_withdraw_fees_min");
                    savingBookProduct.RateWithdrawFeesMax = r.GetNullDouble("rate_withdraw_fees_max");
                    savingBookProduct.RateWithdrawFees = r.GetNullDouble("rate_withdraw_fees");
                }

                savingBookProduct.TransferFeesType = (OSavingsFeesType)r.GetSmallInt("transfer_fees_type");
                if (savingBookProduct.TransferFeesType == OSavingsFeesType.Flat)
                {
                    savingBookProduct.FlatTransferFeesMin = r.GetMoney("flat_transfer_fees_min");
                    savingBookProduct.FlatTransferFeesMax = r.GetMoney("flat_transfer_fees_max");
                    savingBookProduct.FlatTransferFees = r.GetMoney("flat_transfer_fees");
                }
                else
                {
                    savingBookProduct.RateTransferFeesMin = r.GetNullDouble("rate_transfer_fees_min");
                    savingBookProduct.RateTransferFeesMax = r.GetNullDouble("rate_transfer_fees_max");
                    savingBookProduct.RateTransferFees = r.GetNullDouble("rate_transfer_fees");
                }

                Fee fee = savingBookProduct.InterBranchTransferFee;
                fee.IsFlat = r.GetBool("is_ibt_fee_flat");
                fee.Min = r.GetNullDecimal("ibt_fee_min");
                fee.Max = r.GetNullDecimal("ibt_fee_max");
                fee.Value = r.GetNullDecimal("ibt_fee");

                savingBookProduct.DepositFees = r.GetMoney("deposit_fees");
                savingBookProduct.DepositFeesMax = r.GetMoney("deposit_fees_max");
                ((SavingsBookProduct)product).DepositFeesMin = r.GetMoney("deposit_fees_min");

                savingBookProduct.ChequeDepositMin = r.GetMoney("cheque_deposit_min");
                savingBookProduct.ChequeDepositMax = r.GetMoney("cheque_deposit_max");
                savingBookProduct.ChequeDepositFees = r.GetMoney("cheque_deposit_fees");
                savingBookProduct.ChequeDepositFeesMin = r.GetMoney("cheque_deposit_fees_min");
                savingBookProduct.ChequeDepositFeesMax = r.GetMoney("cheque_deposit_fees_max");

                savingBookProduct.CloseFees = r.GetMoney("close_fees");
                savingBookProduct.CloseFeesMax = r.GetMoney("close_fees_max");
                savingBookProduct.CloseFeesMin = r.GetMoney("close_fees_min");

                savingBookProduct.ManagementFees = r.GetMoney("management_fees");
                savingBookProduct.ManagementFeesMax = r.GetMoney("management_fees_max");
                savingBookProduct.ManagementFeesMin = r.GetMoney("management_fees_min");

//.........这里部分代码省略.........

        private static void GetEvent(OpenCbsReader r, Event pEvent)
        {
            //abstract class Event attributes
            string eventType = r.GetString("event_type");
            pEvent.Code = eventType;
            pEvent.ContracId = r.GetInt("contract_id");
            pEvent.Date = r.GetDateTime("event_date");
            pEvent.EntryDate = r.GetDateTime("entry_date");
            pEvent.Deleted = r.GetBool("event_deleted");
            pEvent.IsFired = true;
            pEvent.Cancelable = true;
            pEvent.ExportedDate = DateTime.MinValue;
            pEvent.Comment = r.GetString("comment");
            pEvent.TellerId = r.GetNullInt("teller_id");
            pEvent.ParentId = r.GetNullInt("parent_id");
            pEvent.CancelDate = r.GetNullDateTime("cancel_date");
            pEvent.ClientType = OClientTypes.All;

            switch (r.GetString("client_type_code"))
            {
                case "I":
                    pEvent.ClientType = OClientTypes.Person;
                    break;
                case "C":
                    pEvent.ClientType = OClientTypes.Corporate;
                    break;
                case "G":
                    pEvent.ClientType = OClientTypes.Group;
                    break;
                case "V":
                    pEvent.ClientType = OClientTypes.Village;
                    break;
            }

            //User associated to the event
            pEvent.User = new User
                              {
                                  Id = r.GetInt("user_id"),
                                  UserName = r.GetString("user_username"),
                                  Password = r.GetString("user_password"),
                                  LastName = r.GetString("user_lastname"),
                                  FirstName = r.GetString("user_firstname")
                              };

            pEvent.Currency = new Currency
                                  {
                                      Id = r.GetInt("currency_id"),
                                      Code = r.GetString("currency_code"),
                                      IsPivot = r.GetBool("is_pivot"),
                                      IsSwapped = r.GetBool("is_swapped")
                                  };

            pEvent.Branch = new Branch { Id = r.GetInt("branch_id") };
            pEvent.LoanProduct = new LoanProduct { Id = r.GetInt("product_id") };

            pEvent.User.SetRole(r.GetString("user_role"));
            if (
                eventType.Equals("ULIE") ||
                eventType.Equals("ULOE")
                )
                return;

            if (r.HasColumn("contract_code"))
                pEvent.Description = r.GetString("contract_code");
        }

        private static Event GetSavingEvent(OpenCbsReader r)
        {
            SavingEvent e;

            switch (r.GetString("code"))
            {
                case OSavingEvents.Deposit:
                    e = new SavingDepositEvent();
                    break;
                case OSavingEvents.Withdraw:
                    e = new SavingWithdrawEvent();
                    break;
                case OSavingEvents.InitialDeposit:
                    e = new SavingInitialDepositEvent();
                    break;
                case OSavingEvents.CreditTransfer:
                    e = new SavingCreditTransferEvent();
                    break;
                case OSavingEvents.DebitTransfer:
                    e = new SavingDebitTransferEvent();
                    break;
                case OSavingEvents.SpecialOperationCredit:
                    e = new SavingCreditOperationEvent();
                    break;
                case OSavingEvents.SpecialOperationDebit:
                    e = new SavingDebitOperationEvent();
                    break;
                case OSavingEvents.InterBranchCreditTransfer:
                    e = new SavingCreditInterBranchTransferEvent();
                    break;
                case OSavingEvents.InterBranchDebitTransfer:
                    e = new SavingDebitInterBranchTransferEvent();
                    break;
                default:
                    throw new Exception();
            }

            e.Amount = r.GetMoney("se_amount");
            if (e is ISavingsFees)
                ((ISavingsFees)e).Fee = r.GetMoney("se_fees");
            if (e is SavingTransferEvent)
                ((SavingTransferEvent)e).RelatedContractCode = r.GetString("se_transfer_code");

            return e;
        }

        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");
//.........这里部分代码省略.........

 private static ExoticInstallmentsTable _GetExoticProduct(OpenCbsReader r)
 {
     return new ExoticInstallmentsTable
                {
                    Id = r.GetInt("id"),
                    Name = r.GetString("name")
                };
 }

 private static EntryFee GetEntryFee(OpenCbsReader r)
 {
     EntryFee entryFee = new EntryFee
                        {
                            Id = r.GetInt("id"),
                            Name = r.GetString("name_of_fee"),
                            Min = r.GetNullDecimal("min"),
                            Max = r.GetNullDecimal("max"),
                            Value = r.GetNullDecimal("value"),
                            IsRate = r.GetNullBool("rate") ?? false,
                            Index = r.GetInt("fee_index"),
                            CycleId = r.GetNullInt("cycle_id")
                        };
     return entryFee;
 }

        private Village GetVillageFromReader(OpenCbsReader r)
        {
            Village village;
            village = new Village
                          {
                              Id = r.GetInt("tiers_id"),

                              ZipCode = r.GetString("zipCode"),
                              Status =
                                  ((OClientStatus)r.GetSmallInt("status")),
                              Type = r.GetChar("client_type_code") == 'I'
                                         ? OClientTypes.Person
                                         : r.GetChar("client_type_code") == 'G'
                                               ? OClientTypes.Group
                                               : OClientTypes.Corporate,
                              Scoring = r.GetNullDouble("scoring"),
                              LoanCycle = r.GetInt("loan_cycle"),
                              Active = r.GetBool("active"),
                              BadClient = r.GetBool("bad_client")
                          };
            village.MeetingDay = (DayOfWeek?)r.GetNullInt("meeting_day");
            village.City = r.GetString("city");
            village.Address = r.GetString("address");
            village.Name = r.GetString("name");
            village.EstablishmentDate = r.GetNullDateTime("establishment_date");
            village.Branch = new Branch { Id = r.GetInt("branch_id") };
            return village;
        }

 private Person GetPersonFromReader(OpenCbsReader r)
 {
     Person person;
     person = new Person
                  {
                      Id = r.GetInt("tiers_id"),
                      HomePhone = r.GetString("home_phone"),
                      Email = r.GetString("e_mail"),
                      Status = (OClientStatus)r.GetSmallInt("status"),
                      SecondaryEmail = r.GetString("secondary_e_mail"),
                      HomeType = r.GetString("home_type"),
                      SecondaryHomeType = r.GetString("secondary_hometype"),
                      ZipCode = r.GetString("zipCode"),
                      SecondaryZipCode = r.GetString("secondary_zipCode"),
                      OtherOrgComment = r.GetString("other_org_comment"),
                      PersonalPhone = r.GetString("personal_phone"),
                      SecondaryHomePhone = r.GetString("secondary_home_phone"),
                      SecondaryPersonalPhone = r.GetString("secondary_personal_phone"),
                      CashReceiptIn = r.GetNullInt("cash_input_voucher_number"),
                      CashReceiptOut = r.GetNullInt("cash_output_voucher_number"),
                      Type = r.GetChar("client_type_code") == 'I'
                                 ? OClientTypes.Person
                                 : r.GetChar("client_type_code") == 'G'
                                       ? OClientTypes.Group
                                       : OClientTypes.Corporate,
                      Scoring = r.GetNullDouble("scoring"),
                      LoanCycle = r.GetInt("loan_cycle"),
                      Active = r.GetBool("active"),
                      BadClient = r.GetBool("bad_client"),
                      OtherOrgName = r.GetString("other_org_name"),
                      OtherOrgAmount = r.GetMoney("other_org_amount"),
                      OtherOrgDebts = r.GetMoney("other_org_debts"),
                      City = r.GetString("city"),
                      Address = r.GetString("address"),
                      SecondaryCity = r.GetString("secondary_city"),
                      SecondaryAddress = r.GetString("secondary_address"),
                      FirstName = r.GetString("first_name"),
                      Sex = r.GetChar("sex"),
                      IdentificationData = r.GetString("identification_data"),
                      DateOfBirth = r.GetNullDateTime("birth_date"),
                      LastName = r.GetString("last_name"),
                      FatherName = r.GetString("father_name"),
                      Image = r.GetString("image_path"),
                      BirthPlace = r.GetString("birth_place"),
                      Nationality = r.GetString("nationality"),
                      FollowUpComment = r.GetString("follow_up_comment"),
                      Sponsor1 = r.GetString("sponsor1"),
                      Sponsor2 = r.GetString("sponsor2"),
                      Sponsor1Comment = r.GetString("sponsor1_comment"),
                      Sponsor2Comment = r.GetString("sponsor2_comment"),
                      FavouriteLoanOfficerId = r.GetNullInt("loan_officer_id"),
                      Branch = new Branch { Id = r.GetInt("branch_id") }
                  };
     return person;
 }

        private static ContractAccountingRule GetContractAccountingRule(OpenCbsReader reader)
        {
            ContractAccountingRule rule = new ContractAccountingRule();

            rule.Id = reader.GetInt("id");
            rule.EventType = new EventType
                                 {
                                     EventCode = reader.GetString("event_type"),
                                     Description = reader.GetString("event_description")
                                 };
            rule.EventAttribute = new EventAttribute
                                      {
                                          Id = reader.GetInt("event_attribute_id"),
                                          Name = reader.GetString("attribute_name")
                                      };
            rule.DebitAccount = new Account { Id = reader.GetInt("debit_account_number_id") };
            rule.CreditAccount = new Account { Id = reader.GetInt("credit_account_number_id") };
            rule.BookingDirection = (OBookingDirections)reader.GetSmallInt("booking_direction");
            rule.Order = reader.GetInt("order");
            rule.Description = reader.GetString("rule_description");

            rule.ProductType = (OProductTypes)reader.GetSmallInt("product_type");

            int? loanProductId = reader.GetNullInt("loan_product_id");
            if (loanProductId.HasValue)
                rule.LoanProduct = new LoanProduct { Id = loanProductId.Value };

            int? currencyId = reader.GetNullInt("currency_id");
            if (currencyId.HasValue)
                rule.Currency = new Currency { Id = currencyId.Value };

            int? savingsProductId = reader.GetNullInt("savings_product_id");
            if (savingsProductId.HasValue)
                rule.SavingProduct = new SavingsBookProduct { Id = savingsProductId.Value };

            rule.ClientType = reader.GetChar("client_type").ConvertToClientType();

            int? activityId = reader.GetNullInt("activity_id");

            if (activityId.HasValue)
                rule.EconomicActivity = new EconomicActivity { Id = activityId.Value };

            return rule;
        }

        private RepaymentEvent GetRepaymentEvent(OpenCbsReader r)
        {
            RepaymentEvent e = new RepaymentEvent {Id = r.GetInt("rpe_id")};
            switch (r.GetString("event_type"))
            {
                case "RBLE":
                    {
                        e = new BadLoanRepaymentEvent {Id = r.GetInt("rpe_id")};
                        break;
                    }
                case "RRLE":
                    {
                        e = new RescheduledLoanRepaymentEvent {Id = r.GetInt("rpe_id")};
                        break;
                    }
                case "ROWO":
                    {
                        e = new RepaymentOverWriteOffEvent { Id = r.GetInt("rpe_id") };
                        break;
                    }
                case "PRLR":
                    {
                        e = new PendingRepaymentEvent(r.GetString("event_type"))
                                {Id = r.GetInt("rpe_id")};
                        break;
                    }
                case "PBLR":
                    {
                        e = new PendingRepaymentEvent(r.GetString("event_type"))
                                {Id = r.GetInt("rpe_id")};
                        break;
                    }
                case "PRWO":
                    {
                        e = new PendingRepaymentEvent(r.GetString("event_type"))
                                {Id = r.GetInt("rpe_id")};
                        break;
                    }
                case "PERE":
                    {
                        e = new PendingRepaymentEvent(r.GetString("event_type"))
                                {Id = r.GetInt("rpe_id")};
                        break;
                    }
            }

            e.Principal = r.GetMoney("rpe_principal");
            e.Interests = r.GetMoney("rpe_interests");
            e.Penalties = r.GetMoney("rpe_penalties");
            e.Commissions = r.GetMoney("rpe_commissions");
            e.PastDueDays = r.GetInt("rpe_past_due_days");
            e.InstallmentNumber = r.GetInt("rpe_installment_number");
            e.PaymentMethodId = r.GetNullInt("rpe_pm");
            e.PaymentMethod = e.PaymentMethodId == null ? null :
                _paymentMethodManager.SelectPaymentMethodById(e.PaymentMethodId.Value);

            e.CalculatedPenalties = r.GetMoney("rpe_calculated_penalties");
            e.WrittenOffPenalties = r.GetMoney("rpe_written_off_penalties");
            e.UnpaidPenalties = r.GetMoney("rpe_unpaid_penalties");

            e.Code = r.GetString("event_type");

            if (e.Code != "RBLE")
                e.RepaymentType = OPaymentType.StandardPayment;

            // set type of payment
            switch (r.GetString("event_type").Trim())
            {
                case "ATR":
                    {
                        e.RepaymentType = OPaymentType.TotalPayment;
                        break;
                    }
                case "APR":
                    {
                        e.RepaymentType = OPaymentType.PartialPayment;
                        break;
                    }
                case "APTR":
                    {
                        e.RepaymentType = OPaymentType.PersonTotalPayment;
                        break;
                    }
            }

            return e;
        }