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);
}
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);
}