Ejemplo n.º 1
0
        private PendingTransaction MapAceesData(OleDbDataReader reader)
        {
            PendingTransaction tran = new PendingTransaction();

            if (reader != null)
            {
                tran.TransactionUID                 = CheckNull.ConvertToInt32(reader["TransactionUID"]);
                tran.OpenClosedFlag                 = CheckNull.ConvertToString(reader["OpenClosedFlag"]);
                tran.TypeCode                       = CheckNull.ConvertToString(reader["TypeCode"]);
                tran.CededAssumedFlag               = CheckNull.ConvertToString(reader["CededAssumedFlag"]);
                tran.DisputedFlag                   = CheckNull.ConvertToString(reader["DisputedFlag"]);
                tran.Pre1984Flag                    = CheckNull.ConvertToString(reader["Pre1984Flag"]);
                tran.CnaReProductSw                 = CheckNull.ConvertToString(reader["CnaReProductSw"]);
                tran.ReinsurerCode                  = CheckNull.ConvertToString(reader["ReinsurerCode"]);
                tran.ContractCode                   = CheckNull.ConvertToString(reader["ContractCode"]);
                tran.SourceCode                     = CheckNull.ConvertToInt32(reader["SourceCode"]);
                tran.CompanyCode                    = CheckNull.ConvertToString(reader["CompanyCode"]);
                tran.TableUID                       = CheckNull.ConvertToShort(reader["TableUID"]);
                tran.APFlag                         = CheckNull.ConvertToString(reader["APFlag"]);
                tran.NICOOffsetFlag                 = CheckNull.ConvertToString(reader["NICOOffsetFlag"]);
                tran.OriginalReinsurerCode          = CheckNull.ConvertToString(reader["OriginalReinsurerCode"]);
                tran.ContractCodeFAC                = CheckNull.ConvertToString(reader["ContractCodeFAC"]);
                tran.ContractUnderwritingYear       = CheckNull.ConvertToShort(reader["ContractUnderwritingYear"]);
                tran.ContractLayerEffectiveDate     = CheckNull.ConvertToDateTime(reader["ContractLayerEffectiveDate"]);
                tran.ContractLayerNumber            = CheckNull.ConvertToShort(reader["ContractLayerNumber"]);
                tran.CatastropheCode                = CheckNull.ConvertToString(reader["CatastropheCode"]);
                tran.LocationCodePart6              = CheckNull.ConvertToString(reader["LocationCodePart6"]);
                tran.CollateralDeferralEndDate      = CheckNull.ConvertToDateTime(reader["CollateralDeferralEndDate"]);
                tran.CertifiedRatingEffDt           = CheckNull.ConvertToDateTime(reader["CertifiedRatingEffDt"]);
                tran.CertifiedRecoRatingCd          = CheckNull.ConvertToString(reader["CertifiedRecoRatingCd"]);
                tran.CertifiedPercent               = CheckNull.ConvertToDouble(reader["CertifiedPercent"]);
                tran.OrigReinsCollateDeferralEndDt  = CheckNull.ConvertToDateTime(reader["OrigReinsCollateDeferralEndDt"]);
                tran.OrigReinsCertifiedRatingEffDt  = CheckNull.ConvertToDateTime(reader["OrigReinsCertifiedRatingEffDt"]);
                tran.OrigReinsCertifiedRecoRatingCd = CheckNull.ConvertToString(reader["OrigReinsCertifiedRecoRatingCd"]);
                tran.OrigReinsCertifiedPercent      = CheckNull.ConvertToInt32(reader["OrigReinsCertifiedPercent"]);
                tran.MultipleBeneficiaryAmt         = CheckNull.ConvertToDecimal(reader["MultipleBeneficiaryAmt"]);
            }

            return(tran);
        }
Ejemplo n.º 2
0
        private PendingTransaction MapAceesDataManual(OleDbDataReader reader)
        {
            PendingTransaction tran = new PendingTransaction();

            if (reader != null)
            {
                // common
                tran.TransactionUID                 = CheckNull.ConvertToInt32(reader["TransactionUID"]);
                tran.OpenClosedFlag                 = CheckNull.ConvertToString(reader["OpenClosedFlag"], "O");
                tran.TypeCode                       = CheckNull.ConvertToString(reader["TypeCode"], "M");
                tran.ReinsurerCode                  = CheckNull.ConvertToString(reader["ReinsurerCode"]);
                tran.CededAssumedFlag               = CheckNull.ConvertToString(reader["CededAssumedFlag"]);
                tran.ContractCode                   = CheckNull.ConvertToString(reader["ContractCode"]);
                tran.SourceCode                     = CheckNull.ConvertToInt32(reader["SourceCode"]);
                tran.CompanyCode                    = CheckNull.ConvertToString(reader["CompanyCode"]);
                tran.DisputedFlag                   = CheckNull.ConvertToString(reader["DisputedFlag"]);
                tran.Pre1984Flag                    = CheckNull.ConvertToString(reader["Pre1984Flag"]);
                tran.CnaReProductSw                 = CheckNull.ConvertToString(reader["CnaReProductSw"]);
                tran.TableUID                       = CheckNull.ConvertToShort(reader["TableUID"]);
                tran.APFlag                         = CheckNull.ConvertToString(reader["APFlag"]);
                tran.NICOOffsetFlag                 = CheckNull.ConvertToString(reader["NICOOffsetFlag"]);
                tran.OriginalReinsurerCode          = CheckNull.ConvertToString(reader["OriginalReinsurerCode"]);
                tran.ContractCodeFAC                = CheckNull.ConvertToString(reader["ContractCodeFAC"]);
                tran.ContractUnderwritingYear       = CheckNull.ConvertToShort(reader["ContractUnderwritingYear"]);
                tran.ContractLayerEffectiveDate     = CheckNull.ConvertToDateTime(reader["ContractLayerEffectiveDate"]);
                tran.ContractLayerNumber            = CheckNull.ConvertToShort(reader["ContractLayerNumber"]);
                tran.CatastropheCode                = CheckNull.ConvertToString(reader["CatastropheCode"]);
                tran.LocationCodePart6              = CheckNull.ConvertToString(reader["LocationCodePart6"]);
                tran.CollateralDeferralEndDate      = CheckNull.ConvertToDateTime(reader["CollateralDeferralEndDate"]);
                tran.CertifiedRatingEffDt           = CheckNull.ConvertToDateTime(reader["CertifiedRatingEffDt"]);
                tran.CertifiedRecoRatingCd          = CheckNull.ConvertToString(reader["CertifiedRecoRatingCd"]);
                tran.CertifiedPercent               = CheckNull.ConvertToDouble(reader["CertifiedPercent"]);
                tran.OrigReinsCollateDeferralEndDt  = CheckNull.ConvertToDateTime(reader["OrigReinsCollateDeferralEndDt"]);
                tran.OrigReinsCertifiedRatingEffDt  = CheckNull.ConvertToDateTime(reader["OrigReinsCertifiedRatingEffDt"]);
                tran.OrigReinsCertifiedRecoRatingCd = CheckNull.ConvertToString(reader["OrigReinsCertifiedRecoRatingCd"]);
                tran.OrigReinsCertifiedPercent      = CheckNull.ConvertToInt32(reader["OrigReinsCertifiedPercent"]);
                tran.MultipleBeneficiaryAmt         = CheckNull.ConvertToDecimal(reader["MultipleBeneficiaryAmt"]);
                // specific to this method
                tran.Product                 = CheckNull.ConvertToString(reader["Product"]);
                tran.Coverage                = CheckNull.ConvertToString(reader["Coverage"]);
                tran.TreatyFacFlag           = CheckNull.ConvertToString(reader["TreatyFacFlag"]);
                tran.PaidLossCurrentAmt      = CheckNull.ConvertToDecimal(reader["TreatyFacFlag"]);
                tran.PaidLoss1to29Amt        = CheckNull.ConvertToDecimal(reader["PaidLoss1to29Amt"]);
                tran.PaidLoss30to90Amt       = CheckNull.ConvertToDecimal(reader["PaidLoss30to90Amt"]);
                tran.PaidLoss91to120Amt      = CheckNull.ConvertToDecimal(reader["PaidLoss91to120Amt"]);
                tran.PaidLossOver120Amt      = CheckNull.ConvertToDecimal(reader["PaidLossOver120Amt"]);
                tran.PaidLAECurrAmt          = CheckNull.ConvertToDecimal(reader["PaidLAECurrAmt"]);
                tran.PaidLAE1to29Amt         = CheckNull.ConvertToDecimal(reader["PaidLAE1to29Amt"]);
                tran.PaidLAE30to90Amt        = CheckNull.ConvertToDecimal(reader["PaidLAE30to90Amt"]);
                tran.PaidLAE91to120Amt       = CheckNull.ConvertToDecimal(reader["PaidLAE91to120Amt"]);
                tran.PaidLAEOver120Amt       = CheckNull.ConvertToDecimal(reader["PaidLAEOver120Amt"]);
                tran.WrittenPremiumAmt       = CheckNull.ConvertToDecimal(reader["WrittenPremiumAmt"]);
                tran.UnearnedPremiumAmt      = CheckNull.ConvertToDecimal(reader["UnearnedPremiumAmt"]);
                tran.CaseReserveAmt          = CheckNull.ConvertToDecimal(reader["CaseReserveAmt"]);
                tran.CaseLAEReserveAmt       = CheckNull.ConvertToDecimal(reader["CaseLAEReserveAmt"]);
                tran.StatPaidALAEAmt         = CheckNull.ConvertToDecimal(reader["StatPaidALAEAmt"]);
                tran.StatPaidLossAmt         = CheckNull.ConvertToDecimal(reader["StatPaidLossAmt"]);
                tran.CommissionAmt           = CheckNull.ConvertToDecimal(reader["CommissionAmt"]);
                tran.PremiumPayableAmt       = CheckNull.ConvertToDecimal(reader["PremiumPayableAmt"]);
                tran.Prior90DayCashAmt       = CheckNull.ConvertToDecimal(reader["Prior90DayCashAmt"]);
                tran.IBNRLossReserveAmt      = CheckNull.ConvertToDecimal(reader["IBNRLossReserveAmt"]);
                tran.IBNRSuppReserveAmt      = CheckNull.ConvertToDecimal(reader["IBNRSuppReserveAmt"]);
                tran.IBNRLAEReserveAmt       = CheckNull.ConvertToDecimal(reader["IBNRLAEReserveAmt"]);
                tran.FundsOnDepositWReinsAmt = CheckNull.ConvertToDecimal(reader["FundsOnDepositWReinsAmt"]);
                tran.AssetsPledgedForLOCAmt  = CheckNull.ConvertToDecimal(reader["AssetsPledgedForLOCAmt"]);
                tran.LetterOfCreditAmt       = CheckNull.ConvertToDecimal(reader["LetterOfCreditAmt"]);
                tran.OtherAllowedOffsetAmt   = CheckNull.ConvertToDecimal(reader["OtherAllowedOffsetAmt"]);
                tran.MiscBalanceAmt          = CheckNull.ConvertToDecimal(reader["MiscBalanceAmt"]);
                tran.CreationDate            = CheckNull.ToDateTimeDefault(reader["CreationDate"]);
                tran.CreationLogonID         = "SCH_CAE7093";
                tran.Source             = CheckNull.ConvertToString(reader["Source"]);
                tran.OperId             = CheckNull.ConvertToString(reader["OperId"]);
                tran.Ledger             = CheckNull.ConvertToString(reader["Ledger"]);
                tran.PsUID              = CheckNull.ConvertToString(reader["PsUID"]);
                tran.ProCedeClaimUID    = CheckNull.ConvertToShort(reader["ProCedeClaimUID"]);
                tran.FacultativeCode    = CheckNull.ConvertToString(reader["FacultativeCode"]);
                tran.ClaimFileNumber    = CheckNull.ConvertToString(reader["ClaimFileNumber"]);
                tran.ClaimSuffix        = CheckNull.ConvertToString(reader["ClaimSuffix"]);
                tran.BusinessUnit       = CheckNull.ConvertToString(reader["BusinessUnit"]);
                tran.ClaimProgramCode   = CheckNull.ConvertToString(reader["ClaimProgramCode"]);
                tran.PolicyNumber       = CheckNull.ConvertToString(reader["PolicyNumber"]);
                tran.PRPT               = CheckNull.ConvertToString(reader["PRPT"]);
                tran.MLSL               = CheckNull.ConvertToString(reader["MLSL"]);
                tran.JVNumber           = CheckNull.ConvertToString(reader["JVNumber"]);
                tran.KindOfLoss         = CheckNull.ConvertToString(reader["KindOfLoss"]);
                tran.ClaimTransactionID = CheckNull.ConvertToShort(reader["ClaimTransactionID"]);
                tran.TableSourceCode    = CheckNull.ConvertToShort(reader["TableSourceCode"]);
                tran.TableSourceRecID   = CheckNull.ConvertToInt32(reader["TableSourceRecID"]);
                tran.PeoplesoftSource   = CheckNull.ConvertToString(reader["PeoplesoftSource"]);
                tran.ValidProduct       = CheckNull.ConvertToString(reader["ValidProduct"]);
                tran.ValidReinsurer     = CheckNull.ConvertToString(reader["ValidReinsurer"]);
                tran.ValidContract      = CheckNull.ConvertToString(reader["ValidContract"]);
                tran.TableLoadType      = CheckNull.ConvertToString(reader["TableLoadType"]);
            }

            return(tran);
        }