Learning CRM 2011: Read XML into an Object Model using XDocument

The intent is to read an XML file, and create corresponding classes, collections of classes etc.

ENTRY POINT

using System;

using System.Collections.Generic;

using System.Linq;

using System.Xml.XPath;

using System.Xml.Linq;

using Applications.LoanAccounting.BillsAndStatements.LiqEntities;

public void ReadBillingEnhancementXML(string fileName)

{

try

{

XDocument xDoc = XDocument.Load(fileName);

foreach (XElement xElementBFC in xDoc.XPathSelectElements("//Bills/BillTextHeader/BatchBill/BillForContacts/BillForContact"))

{

BillForContact b = new BillForContact(xElementBFC);

_bills.Add(b);

}

catch (Exception ex)

{

throw;

}

BILLFORCONTACT CLASS

using System;

using System.Collections.Generic;

using System.Linq;

using System.Xml.Linq;

using System.Xml.XPath;

using FarmCreditBank.Common.Utilities;

namespace Applications.LoanAccounting.BillsAndStatements.LiqEntities

{

public class BillForContact

{

#region Constructor

public BillForContact(XElement xElement)

{

try

{

XDocument xDoc = XDocument.Parse(xElement.ToString());

foreach (XElement childElement in xDoc.XPathSelectElements("//BillForContact/Borrower"))

{

Borrower = new Borrower(childElement);

}

foreach (XElement childElement in xDoc.XPathSelectElements("//BillForContact/BillingContact"))

{

BillingContact = new BillingContact(childElement);

}

foreach (XElement childElement in xDoc.XPathSelectElements("//BillForContact/BillTotals"))

{

BillTotals = new BillTotals(childElement);

}

foreach (XElement childElement in xDoc.XPathSelectElements("//BillForContact/Deal"))

{

Deal = new Deal(childElement);

}

foreach (XElement childElement in xDoc.XPathSelectElements("//BillForContact/AgentContact"))

{

AgentContact = new Contact(childElement, "AgentContact");

}

BillAssociationOwners = new List<BillAssociationOwner>();

foreach (XElement childElement in xDoc.XPathSelectElements("//BillForContact/BillAssociationOwners/BillAssociationOwner"))

{

BillAssociationOwners.Add(new BillAssociationOwner(childElement));

}

RemittanceInstructions = new List<SingleRemittanceInstruction>();

foreach (XElement childElement in xDoc.XPathSelectElements("//BillForContact/RemittanceInstructions/SingleRemittanceInstruction"))

{

RemittanceInstructions.Add(new SingleRemittanceInstruction(childElement));

}

BillDueDate = ExtractDateTime(xDoc, "billDueDate");

DatePrepared = ExtractDateTime(xDoc, "datePrepared");

Branch = xDoc.Root.Element("branch").Value;

CorrectionIndicator = xDoc.Root.Element("correctionInd").Value;

FeesCashAccount = StringUtilities.ConvertStringToDecimal(xDoc.Root.Element("feesCashAccount").Value);

InterestCashAccount = StringUtilities.ConvertStringToDecimal(xDoc.Root.Element("interestCashAccount").Value);

InvoiceId = xDoc.Root.Element("invoiceId").Value;

PrincipalCashAmount = StringUtilities.ConvertStringToDecimal(xDoc.Root.Element("principalCashAccount").Value);

ProcessingAreaCode = xDoc.Root.Element("processingAreaCode").Value;

SBLCCashAccount = xDoc.Root.Element("SBLCCashAccount").Value;

}

catch (Exception ex)

{

throw;

}

#endregion

private Nullable<DateTime> ExtractDateTime(XDocument xDoc, string name)

{

try

{

DateTime theDate = DateTime.MinValue;

foreach (XElement childElement in xDoc.XPathSelectElements("//BillForContact/" + name))

{

string mm = (string)childElement.Element("month");

string dd = (string)childElement.Element("day");

string yyyy = (string)childElement.Element("year");

DateTime.TryParse(mm + "-" + dd + "-" + yyyy, out theDate);

}

if (theDate == DateTime.MinValue)

{

return null;

}

else

{

return theDate;

}

catch (Exception ex)

{

throw;

}

public Borrower Borrower { set; get; }

public BillingContact BillingContact{ set; get; }

public BillTotals BillTotals{ set; get; }

public DateTime? BillDueDate { set; get; }

public string Branch { set; get; }

public string CorrectionIndicator { set; get; }

public DateTime? DatePrepared { set; get; }

public Deal Deal { set; get; }

public decimal FeesCashAccount { set; get; }

public decimal InterestCashAccount { set; get; }

public string InvoiceId { set; get; }

public decimal PrincipalCashAmount { set; get; }

public string ProcessingAreaCode { set; get; }

public string SBLCCashAccount { set; get; }

public Contact AgentContact { set; get; }

public List<BillAssociationOwner> BillAssociationOwners { set; get; } //work to do here

public List<SingleRemittanceInstruction> RemittanceInstructions { set; get; }

}

BORROWER CLASS

using System;

using System.Collections.Generic;

using System.Linq;

using System.Xml.Linq;

using System.Xml.XPath;

namespace Applications.LoanAccounting.BillsAndStatements.LiqEntities

{

public class Borrower

{

#region Constructor

public Borrower(XElement xElement)

{

try

{

XDocument xDoc = XDocument.Parse(xElement.ToString());

Id = (string)xDoc.Root.Attribute("id");

Bank = (string)xDoc.Root.Element("bank");

Country = (string)xDoc.Root.Element("country");

CustomerDescription = (string)xDoc.Root.Element("customerDescription");

CustomerOrigin = (string)xDoc.Root.Element("customerOrigin");

Department = (string)xDoc.Root.Element("department");

ExpenseCode = (string)xDoc.Root.Element("expenseCode");

ExternalId = (string)xDoc.Root.Element("externalId");

Fullname = (string)xDoc.Root.Element("fullname");

LanguageCode = (string)xDoc.Root.Element("languageCode");

foreach (XElement childElement in xDoc.XPathSelectElements("//Borrower/LegalAddress"))

{

LegalAddress = new Address(childElement);

}

LegalCode = (string)xDoc.Root.Element("legalCode");

PrimarySIC = (string)xDoc.Root.Element("primarySIC");

Shortname = (string)xDoc.Root.Element("shortname");

SicCountryCode = (string)xDoc.Root.Element("sicCountryCode");

TreasuryReportingArea = (string)xDoc.Root.Element("treasuryReportingArea");

VatNumber = (string)xDoc.Root.Element("vatNumber");

}

catch (Exception ex)

{

throw;

}

#endregion

public string Id { get; set; }

public string Bank { get; set; }

public string Country { get; set; }

public string CustomerDescription { get; set; }

public string CustomerOrigin { get; set; }

public string Department { get; set; }

public string ExpenseCode { get; set; }

public string ExternalId { get; set; }

public string Fullname { get; set; }

public string LanguageCode { get; set; }

public Address LegalAddress { get; set; }

public string LegalCode { get; set; }

public string PrimarySIC { get; set; }

public string Shortname { get; set; }

public string SicCountryCode { get; set; }

public string TreasuryReportingArea { get; set; }

public string VatNumber { get; set; }

}

ADDRESS CLASS

using System;

using System.Collections.Generic;

using System.Linq;

using System.Xml.Linq;

namespace Applications.LoanAccounting.BillsAndStatements.LiqEntities

{

public class Address

{

#region Constructor

public Address(XElement xElement)

{

try

{

XDocument xDoc = XDocument.Parse(xElement.ToString());

Id = (string)xDoc.Root.Attribute("id");

Line1 = (string)xDoc.Root.Element("line1");

Line2 = (string)xDoc.Root.Element("line2");

Line3 = (string)xDoc.Root.Element("line3");

Line4 = (string)xDoc.Root.Element("line4");

City = (string)xDoc.Root.Element("city");

CountryCode = (string)xDoc.Root.Element("countryCode");

CustomerID = (string)xDoc.Root.Element("customerID");

Description = (string)xDoc.Root.Element("description");

LocationCode = (string)xDoc.Root.Element("locationCode");

Phone = (string)xDoc.Root.Element("phone");

ProvinceCode = (string)xDoc.Root.Element("provinceCode");

StateCode = (string)xDoc.Root.Element("stateCode");

Zip = (string)xDoc.Root.Element("zip");

}

catch (Exception ex)

{

throw;

}

#endregion

public string Id { get; set; }

public string Line1 { get; set; }

public string Line2 { get; set; }

public string Line3 { get; set; }

public string Line4 { get; set; }

public string City { get; set; }

public string CountryCode { get; set; }

public string CustomerID { get; set; }

public string Description { get; set; }

public string LocationCode { get; set; }

public string Phone { get; set; }

public string ProvinceCode { get; set; }

public string StateCode { get; set; }

public string Zip { get; set; }

}

THE XML FILE. THIS IS A BIG ONE.

<?xml version="1.0"?>
<Bills>
<BillTextHeader id="CGAL786A" createTSP="2013-4-16-13.1.21.6600">
<BatchBill>
<BillForContacts>
<BillForContact>
<Borrower id="AS8C4RTW">
<bank>110</bank>
<country>US</country>
<customerDescription>A10</customerDescription>
<customerOrigin/>
<department>001</department>
<expenseCode>999-999</expenseCode>
<externalId>3</externalId>
<fullname>Dirty Harry</fullname>
<languageCode/>
<LegalAddressX id="AS8C4RTW">
<line1/>
<line2/>
<line3/>
<line4/>
<city/>
<countryCode/>
<customerID/>
<description/>
<locationCode/>
<phone/>
<provinceCode/>
<stateCode/>
<zip/>
</LegalAddressX>
<legalCode/>
<primarySIC>6111</primarySIC>
<shortname>AS8C4RTW</shortname>
<sicCountryCode>US</sicCountryCode>
<treasuryReportingArea>US</treasuryReportingArea>
<vatNumber/>
</Borrower>
<BillingContact id="X-8MLATZ" purpose="SERV">
<custInternalID>AS8C4RTW</custInternalID>
<contactDepartment/>
<language>ENG</language>
<jobFunction/>
<title/>
<salutation/>
<namePrefix/>
<nameFirst>Servicing</nameFirst>
<nameMiddle/>
<nameLast>X-8MLATZ</nameLast>
<preferredName/>
<primaryFaxNumber/>
<CustomerAddress id="AS8C4RTY">
<line1>P.O. BOX 232</line1>
<line2/>
<line3/>
<line4/>
<city>BRYAN</city>
<countryCode>US</countryCode>
<customerID>AS8C4RTW</customerID>
<description>LEGAL ADDRESS</description>
<locationCode/>
<phone>979-822-3018</phone>
<provinceCode/>
<stateCode>TX</stateCode>
<zip>77806-0232</zip>
</CustomerAddress>
<emailID>X</emailID>
<primaryBusinessPhone>979-822-3018</primaryBusinessPhone>
</BillingContact>
<BillTotals>
<principalDueAmount>0.000</principalDueAmount>
<interestDueAmount>92.890</interestDueAmount>
<feesDueAmount>0.000</feesDueAmount>
<lateChargeFeesDueAmount>0.000</lateChargeFeesDueAmount>
<escrowDueAmount>0.000</escrowDueAmount>
<balanceForwardAmount>92.890</balanceForwardAmount>
<totalDueAmount>185.780</totalDueAmount>
<currency>USD</currency>
</BillTotals>
<billDueDate>
<year>2013</year>
<month>1</month>
<day>17</day>
</billDueDate>
<branch>DNOTE</branch>
<correctionInd>N</correctionInd>
<datePrepared>
<year>2013</year>
<month>1</month>
<day>10</day>
</datePrepared>
<Deal id="TA93UIYR">
<alias>TA93UIYR</alias>
<alternateId>TA93UIYR</alternateId>
<ansiId>TA93UIYR</ansiId>
<bank>110</bank>
<branch>DNOTE</branch>
<consolidatedBillingInd>Y</consolidatedBillingInd>
<currency>USD</currency>
<DealAdmin id="">
<hostIsAgent>Y</hostIsAgent>
<Customer id="AS8C4UXB">
<bank>110</bank>
<country>US</country>
<customerDescription>FCBT</customerDescription>
<customerOrigin/>
<department>DNOTE</department>
<expenseCode>999-999</expenseCode>
<externalId>21</externalId>
<fullname>Clean Harry</fullname>
<languageCode/>
<LegalAddress id="AS8C4UXB">
<line1/>
<line2/>
<line3/>
<line4/>
<city/>
<countryCode/>
<customerID/>
<description/>
<locationCode/>
<phone/>
<provinceCode/>
<stateCode/>
<zip/>
</LegalAddress>
<legalCode/>
<primarySIC>6111</primarySIC>
<shortname>AS8C4UXB</shortname>
<sicCountryCode>US</sicCountryCode>
<treasuryReportingArea>US</treasuryReportingArea>
<vatNumber/>
</Customer>
</DealAdmin>
<expenseCode>110-400</expenseCode>
<ExpenseCodeTable id="">
<expenseCode>110-400</expenseCode>
<expenseDesc>Net Direct Note</expenseDesc>
<CustomerAddress id="">
<line1/>
<line2/>
<line3/>
<line4/>
<city/>
<countryCode/>
<customerID/>
<description>110-400</description>
<locationCode/>
<phone/>
<provinceCode/>
<stateCode/>
<zip/>
</CustomerAddress>
</ExpenseCodeTable>
<ExpenseCodeAddress id="">
<line1/>
<line2/>
<line3/>
<line4/>
<city/>
<countryCode/>
<customerID/>
<description>110-400</description>
<locationCode/>
<phone/>
<provinceCode/>
<stateCode/>
<zip/>
</ExpenseCodeAddress>
<invoicePymtApplLogicRule>IPFLE</invoicePymtApplLogicRule>
<name>ZONE 2 WC</name>
<pastDueBasedOnBilledInd>N</pastDueBasedOnBilledInd>
<pastDueBillApplLogicRule>OIPFLE</pastDueBillApplLogicRule>
<processingArea>DNOTE</processingArea>
<trackingNum>81</trackingNum>
</Deal>
<feesCashAccount/>
<interestCashAccount/>
<invoiceId>0T2AL786AP</invoiceId>
<principalCashAccount/>
<processingAreaCode>DNOTE</processingAreaCode>
<SBLCCashAccount/>
<AgentContact id="X-8MLD6D" purpose="SERV">
<custInternalID>AS8C4UXB</custInternalID>
<contactDepartment/>
<language>ENG</language>
<jobFunction/>
<title/>
<salutation/>
<namePrefix/>
<nameFirst>Servicing</nameFirst>
<nameMiddle/>
<nameLast>X-8MLD6D</nameLast>
<preferredName/>
<primaryFaxNumber/>
<CustomerAddress id="AS8C4UXD">
<line1>4801 PLAZA ON THE LAKE DR.</line1>
<line2/>
<line3/>
<line4/>
<city>AUSTIN</city>
<countryCode>US</countryCode>
<customerID>AS8C4UXB</customerID>
<description>LEGAL ADDRESS</description>
<locationCode/>
<phone>512-465-0400</phone>
<provinceCode/>
<stateCode>TX</stateCode>
<zip>78746</zip>
</CustomerAddress>
<emailID>X</emailID>
<primaryBusinessPhone>512-465-0400</primaryBusinessPhone>
</AgentContact>
<BillAssociationOwners>
<BillAssociationOwner>
<Outstanding id="HNAL5R8Z" outstandingType="LOAN">
<Loan>
<accrualPeriod>1WK</accrualPeriod>
<accrueOnScheduleBalanceInd>N</accrueOnScheduleBalanceInd>
<alias>LOAN 875</alias>
<billAtMaturityInd>N</billAtMaturityInd>
<billBorrInd>Y</billBorrInd>
<billingDescription>5</billingDescription>
<billNumDays> 10</billNumDays>
<borrowerID>AS8C4RTW</borrowerID>
<borrowerName>AS8C4RTW</borrowerName>
<calcExpiryDate>
<year>0</year>
<month>0</month>
<day>0</day>
</calcExpiryDate>
<currency>USD</currency>
<effectiveDate>
<year>2013</year>
<month>1</month>
<day>3</day>
</effectiveDate>
<enteredExpiryDate/>
<Facility id="TA93UL2K">
<controlNumber>00000494</controlNumber>
<effectiveDate>
<year>2010</year>
<month>6</month>
<day>1</day>
</effectiveDate>
<expirationDate>
<year>2014</year>
<month>10</month>
<day>1</day>
</expirationDate>
<firstLoanDrawDate>
<year>2010</year>
<month>7</month>
<day>2</day>
</firstLoanDrawDate>
<firstLoanGeneralLedgerMap>DNLPN</firstLoanGeneralLedgerMap>
<maturityDate>
<year>2030</year>
<month>6</month>
<day>7</day>
</maturityDate>
<FacilityName>01 DIRECT NOTE</FacilityName>
<sicCountryCode>US</sicCountryCode>
<standardIndustryCode>6111</standardIndustryCode>
<terminationDate>
<year>0</year>
<month>0</month>
<day>0</day>
</terminationDate>
<type>RST</type>
<typeDescription>Revolver/Standard</typeDescription>
</Facility>
<finalExpiryDate>
<year>0</year>
<month>0</month>
<day>0</day>
</finalExpiryDate>
<foreignTaxWithholdCode/>
<foreignTaxWithholdPct>0.00000000000000</foreignTaxWithholdPct>
<lateChargeRuleId/>
<performingStatus>ACCR</performingStatus>
<pricingOption>DNLPN</pricingOption>
<pricingOption>Loan Portfolio DN</pricingOption>
<rateBasis>Actual/365/366</rateBasis>
<requestedAmountCurrency>USD</requestedAmountCurrency>
<sicCode>6111</sicCode>
<sicCountryCode>US</sicCountryCode>
<taxExemptPercent>0.00000000000000</taxExemptPercent>
<taxExemptType/>
<treasuryAreaReportingCode>US</treasuryAreaReportingCode>
</Loan>
</Outstanding>
<BillValue>
<globalCurrentOutstandingCommitmentAmount>250000.000</globalCurrentOutstandingCommitmentAmount>
</BillValue>
<BillAssociationsForOwner>
<BillAssociation id="CGAL786B" itemOwnerType="OST" itemType="ACC">
<Outstanding id="HNAL5R8Z" outstandingType="LOAN">
<Loan>
<accrualPeriod>1WK</accrualPeriod>
<accrueOnScheduleBalanceInd>N</accrueOnScheduleBalanceInd>
<alias>LOAN 875</alias>
<billAtMaturityInd>N</billAtMaturityInd>
<billBorrInd>Y</billBorrInd>
<billingDescription>5</billingDescription>
<billNumDays> 10</billNumDays>
<borrowerID>AS8C4RTW</borrowerID>
<borrowerName>AS8C4RTW</borrowerName>
<calcExpiryDate>
<year>0</year>
<month>0</month>
<day>0</day>
</calcExpiryDate>
<currency>USD</currency>
<effectiveDate>
<year>2013</year>
<month>1</month>
<day>3</day>
</effectiveDate>
<enteredExpiryDate/>
<Facility id="TA93UL2K">
<controlNumber>00000494</controlNumber>
<effectiveDate>
<year>2010</year>
<month>6</month>
<day>1</day>
</effectiveDate>
<expirationDate>
<year>2014</year>
<month>10</month>
<day>1</day>
</expirationDate>
<firstLoanDrawDate>
<year>2010</year>
<month>7</month>
<day>2</day>
</firstLoanDrawDate>
<firstLoanGeneralLedgerMap>DNLPN</firstLoanGeneralLedgerMap>
<maturityDate>
<year>2030</year>
<month>6</month>
<day>7</day>
</maturityDate>
<FacilityName>01 DIRECT NOTE</FacilityName>
<sicCountryCode>US</sicCountryCode>
<standardIndustryCode>6111</standardIndustryCode>
<terminationDate>
<year>0</year>
<month>0</month>
<day>0</day>
</terminationDate>
<type>RST</type>
<typeDescription>Revolver/Standard</typeDescription>
</Facility>
<finalExpiryDate>
<year>0</year>
<month>0</month>
<day>0</day>
</finalExpiryDate>
<foreignTaxWithholdCode/>
<foreignTaxWithholdPct>0.00000000000000</foreignTaxWithholdPct>
<lateChargeRuleId/>
<performingStatus>ACCR</performingStatus>
<pricingOption>DNLPN</pricingOption>
<pricingOption>Loan Portfolio DN</pricingOption>
<rateBasis>Actual/365/366</rateBasis>
<requestedAmountCurrency>USD</requestedAmountCurrency>
<sicCode>6111</sicCode>
<sicCountryCode>US</sicCountryCode>
<taxExemptPercent>0.00000000000000</taxExemptPercent>
<taxExemptType/>
<treasuryAreaReportingCode>US</treasuryAreaReportingCode>
</Loan>
</Outstanding>
<Accrual>
<AccrualCycle id="4GAL7819" ownerType="OST">
<amtPaid>0.000</amtPaid>
<amtPastDueWaived>0.000</amtPastDueWaived>
<adjustedDueDate>
<year>2013</year>
<month>1</month>
<day>17</day>
</adjustedDueDate>
<dueDate>
<year>2013</year>
<month>1</month>
<day>17</day>
</dueDate>
<startDate>
<year>2013</year>
<month>1</month>
<day>10</day>
</startDate>
<thruDate>
<year>2013</year>
<month>1</month>
<day>16</day>
</thruDate>
<withheldSoFar>0.000</withheldSoFar>
<singularityIndicator>N</singularityIndicator>
<reasonForWaiver/>
<minimumAccrualAmt>0.000</minimumAccrualAmt>
<minimumAmount>0.000</minimumAmount>
</AccrualCycle>
<AccrualLineItems>
<AccrualLineItem id="CGAL786C">
<ownerID>CGAL786B</ownerID>
<startDate>
<year>2013</year>
<month>1</month>
<day>10</day>
</startDate>
<endDate>
<year>2013</year>
<month>1</month>
<day>16</day>
</endDate>
<amountBalance>250000.000</amountBalance>
<rate>0.019373300000000</rate>
<spread>0.00000000000000</spread>
<penaltySpread>0.00000000000000</penaltySpread>
<racSpread>0.00000000000000</racSpread>
<amountAccrued>92.890</amountAccrued>
<amountAccruedCrumb>-0.004315068493156</amountAccruedCrumb>
<numberOfDays> 7</numberOfDays>
<accrualType/>
<ownerType>BOA</ownerType>
<accrualRate>0.019373300000000</accrualRate>
<rateCap>0.000000000000000</rateCap>
<rateFlr>0.000000000000000</rateFlr>
</AccrualLineItem>
</AccrualLineItems>
</Accrual>
<BillTransactionHistory/>
<BillRateHistory/>
<BillAssociationTotals>
<balanceForwardAmount>92.890</balanceForwardAmount>
<interestDueAmount>92.890</interestDueAmount>
<dueAmount>185.780</dueAmount>
</BillAssociationTotals>
</BillAssociation>
</BillAssociationsForOwner>
<BillAssociationOwnerTotals>
<allInRate>0.019373300000000</allInRate>
<balanceForwardAmount>92.890000000000001</balanceForwardAmount>
<escrowDueAmount>0.000</escrowDueAmount>
<feesDueAmount>0.000</feesDueAmount>
<interestDueAmount>92.890</interestDueAmount>
<lateChargeFeesDueAmount>0.000</lateChargeFeesDueAmount>
<principalBalanceAmount>250000.000</principalBalanceAmount>
<principalBalanceAfterPaymentAmount>250000.000</principalBalanceAfterPaymentAmount>
<principalDueAmount>0.000</principalDueAmount>
</BillAssociationOwnerTotals>
</BillAssociationOwner>
</BillAssociationOwners>
<RemittanceInstructions>
<SingleRemittanceInstruction>
<defaultRemittanceInstruction>Please remit payment</defaultRemittanceInstruction>
</SingleRemittanceInstruction>
</RemittanceInstructions>
</BillForContact>
<BillForContact>
<Borrower id="AS8C4RTW">
<bank>110</bank>
<country>US</country>
<customerDescription>A10</customerDescription>
<customerOrigin/>
<department>001</department>
<expenseCode>999-999</expenseCode>
<externalId>3</externalId>
<fullname>Dirty Harry</fullname>
<languageCode/>
<LegalAddressX id="AS8C4RTW">
<line1/>
<line2/>
<line3/>
<line4/>
<city/>
<countryCode/>
<customerID/>
<description/>
<locationCode/>
<phone/>
<provinceCode/>
<stateCode/>
<zip/>
</LegalAddressX>
<legalCode/>
<primarySIC>6111</primarySIC>
<shortname>AS8C4RTW</shortname>
<sicCountryCode>US</sicCountryCode>
<treasuryReportingArea>US</treasuryReportingArea>
<vatNumber/>
</Borrower>
<BillingContact id="X-8MLATZ" purpose="SERV">
<custInternalID>AS8C4RTW</custInternalID>
<contactDepartment/>
<language>ENG</language>
<jobFunction/>
<title/>
<salutation/>
<namePrefix/>
<nameFirst>Servicing</nameFirst>
<nameMiddle/>
<nameLast>X-8MLATZ</nameLast>
<preferredName/>
<primaryFaxNumber/>
<CustomerAddress id="AS8C4RTY">
<line1>P.O. BOX 232</line1>
<line2/>
<line3/>
<line4/>
<city>BRYAN</city>
<countryCode>US</countryCode>
<customerID>AS8C4RTW</customerID>
<description>LEGAL ADDRESS</description>
<locationCode/>
<phone>979-822-3018</phone>
<provinceCode/>
<stateCode>TX</stateCode>
<zip>77806-0232</zip>
</CustomerAddress>
<emailID>X</emailID>
<primaryBusinessPhone>979-822-3018</primaryBusinessPhone>
</BillingContact>
<BillTotals>
<principalDueAmount>0.000</principalDueAmount>
<interestDueAmount>92.890</interestDueAmount>
<feesDueAmount>0.000</feesDueAmount>
<lateChargeFeesDueAmount>0.000</lateChargeFeesDueAmount>
<escrowDueAmount>0.000</escrowDueAmount>
<balanceForwardAmount>92.890</balanceForwardAmount>
<totalDueAmount>185.780</totalDueAmount>
<currency>USD</currency>
</BillTotals>
<billDueDate>
<year>2013</year>
<month>1</month>
<day>17</day>
</billDueDate>
<branch>DNOTE</branch>
<correctionInd>N</correctionInd>
<datePrepared>
<year>2013</year>
<month>1</month>
<day>10</day>
</datePrepared>
<Deal id="TA93UIYR">
<alias>TA93UIYR</alias>
<alternateId>TA93UIYR</alternateId>
<ansiId>TA93UIYR</ansiId>
<bank>110</bank>
<branch>DNOTE</branch>
<consolidatedBillingInd>Y</consolidatedBillingInd>
<currency>USD</currency>
<DealAdmin id="">
<hostIsAgent>Y</hostIsAgent>
<Customer id="AS8C4UXB">
<bank>110</bank>
<country>US</country>
<customerDescription>FCBT</customerDescription>
<customerOrigin/>
<department>DNOTE</department>
<expenseCode>999-999</expenseCode>
<externalId>21</externalId>
<fullname>Clean Harry</fullname>
<languageCode/>
<LegalAddress id="AS8C4UXB">
<line1/>
<line2/>
<line3/>
<line4/>
<city/>
<countryCode/>
<customerID/>
<description/>
<locationCode/>
<phone/>
<provinceCode/>
<stateCode/>
<zip/>
</LegalAddress>
<legalCode/>
<primarySIC>6111</primarySIC>
<shortname>AS8C4UXB</shortname>
<sicCountryCode>US</sicCountryCode>
<treasuryReportingArea>US</treasuryReportingArea>
<vatNumber/>
</Customer>
</DealAdmin>
<expenseCode>110-400</expenseCode>
<ExpenseCodeTable id="">
<expenseCode>110-400</expenseCode>
<expenseDesc>Net Direct Note</expenseDesc>
<CustomerAddress id="">
<line1/>
<line2/>
<line3/>
<line4/>
<city/>
<countryCode/>
<customerID/>
<description>110-400</description>
<locationCode/>
<phone/>
<provinceCode/>
<stateCode/>
<zip/>
</CustomerAddress>
</ExpenseCodeTable>
<ExpenseCodeAddress id="">
<line1/>
<line2/>
<line3/>
<line4/>
<city/>
<countryCode/>
<customerID/>
<description>110-400</description>
<locationCode/>
<phone/>
<provinceCode/>
<stateCode/>
<zip/>
</ExpenseCodeAddress>
<invoicePymtApplLogicRule>IPFLE</invoicePymtApplLogicRule>
<name>ZONE 2 WC</name>
<pastDueBasedOnBilledInd>N</pastDueBasedOnBilledInd>
<pastDueBillApplLogicRule>OIPFLE</pastDueBillApplLogicRule>
<processingArea>DNOTE</processingArea>
<trackingNum>81</trackingNum>
</Deal>
<feesCashAccount/>
<interestCashAccount/>
<invoiceId>0T2AL786AP2</invoiceId>
<principalCashAccount/>
<processingAreaCode>DNOTE</processingAreaCode>
<SBLCCashAccount/>
<AgentContact id="X-8MLD6D" purpose="SERV">
<custInternalID>AS8C4UXB</custInternalID>
<contactDepartment/>
<language>ENG</language>
<jobFunction/>
<title/>
<salutation/>
<namePrefix/>
<nameFirst>Servicing</nameFirst>
<nameMiddle/>
<nameLast>X-8MLD6D</nameLast>
<preferredName/>
<primaryFaxNumber/>
<CustomerAddress id="AS8C4UXD">
<line1>4801 PLAZA ON THE LAKE DR.</line1>
<line2/>
<line3/>
<line4/>
<city>AUSTIN</city>
<countryCode>US</countryCode>
<customerID>AS8C4UXB</customerID>
<description>LEGAL ADDRESS</description>
<locationCode/>
<phone>512-465-0400</phone>
<provinceCode/>
<stateCode>TX</stateCode>
<zip>78746</zip>
</CustomerAddress>
<emailID>X</emailID>
<primaryBusinessPhone>512-465-0400</primaryBusinessPhone>
</AgentContact>
<BillAssociationOwners>
<BillAssociationOwner>
<Outstanding id="HNAL5R8Z" outstandingType="LOAN">
<Loan>
<accrualPeriod>1WK</accrualPeriod>
<accrueOnScheduleBalanceInd>N</accrueOnScheduleBalanceInd>
<alias>LOAN 875</alias>
<billAtMaturityInd>N</billAtMaturityInd>
<billBorrInd>Y</billBorrInd>
<billingDescription>5</billingDescription>
<billNumDays> 10</billNumDays>
<borrowerID>AS8C4RTW</borrowerID>
<borrowerName>AS8C4RTW</borrowerName>
<calcExpiryDate>
<year>0</year>
<month>0</month>
<day>0</day>
</calcExpiryDate>
<currency>USD</currency>
<effectiveDate>
<year>2013</year>
<month>1</month>
<day>3</day>
</effectiveDate>
<enteredExpiryDate/>
<Facility id="TA93UL2K">
<controlNumber>00000494</controlNumber>
<effectiveDate>
<year>2010</year>
<month>6</month>
<day>1</day>
</effectiveDate>
<expirationDate>
<year>2014</year>
<month>10</month>
<day>1</day>
</expirationDate>
<firstLoanDrawDate>
<year>2010</year>
<month>7</month>
<day>2</day>
</firstLoanDrawDate>
<firstLoanGeneralLedgerMap>DNLPN</firstLoanGeneralLedgerMap>
<maturityDate>
<year>2030</year>
<month>6</month>
<day>7</day>
</maturityDate>
<FacilityName>01 DIRECT NOTE</FacilityName>
<sicCountryCode>US</sicCountryCode>
<standardIndustryCode>6111</standardIndustryCode>
<terminationDate>
<year>0</year>
<month>0</month>
<day>0</day>
</terminationDate>
<type>RST</type>
<typeDescription>Revolver/Standard</typeDescription>
</Facility>
<finalExpiryDate>
<year>0</year>
<month>0</month>
<day>0</day>
</finalExpiryDate>
<foreignTaxWithholdCode/>
<foreignTaxWithholdPct>0.00000000000000</foreignTaxWithholdPct>
<lateChargeRuleId/>
<performingStatus>ACCR</performingStatus>
<pricingOption>DNLPN</pricingOption>
<pricingOption>Loan Portfolio DN</pricingOption>
<rateBasis>Actual/365/366</rateBasis>
<requestedAmountCurrency>USD</requestedAmountCurrency>
<sicCode>6111</sicCode>
<sicCountryCode>US</sicCountryCode>
<taxExemptPercent>0.00000000000000</taxExemptPercent>
<taxExemptType/>
<treasuryAreaReportingCode>US</treasuryAreaReportingCode>
</Loan>
</Outstanding>
<BillValue>
<globalCurrentOutstandingCommitmentAmount>250000.000</globalCurrentOutstandingCommitmentAmount>
</BillValue>
<BillAssociationsForOwner>
<BillAssociation id="CGAL786B" itemOwnerType="OST" itemType="ACC">
<Outstanding id="HNAL5R8Z" outstandingType="LOAN">
<Loan>
<accrualPeriod>1WK</accrualPeriod>
<accrueOnScheduleBalanceInd>N</accrueOnScheduleBalanceInd>
<alias>LOAN 875</alias>
<billAtMaturityInd>N</billAtMaturityInd>
<billBorrInd>Y</billBorrInd>
<billingDescription>5</billingDescription>
<billNumDays> 10</billNumDays>
<borrowerID>AS8C4RTW</borrowerID>
<borrowerName>AS8C4RTW</borrowerName>
<calcExpiryDate>
<year>0</year>
<month>0</month>
<day>0</day>
</calcExpiryDate>
<currency>USD</currency>
<effectiveDate>
<year>2013</year>
<month>1</month>
<day>3</day>
</effectiveDate>
<enteredExpiryDate/>
<Facility id="TA93UL2K">
<controlNumber>00000494</controlNumber>
<effectiveDate>
<year>2010</year>
<month>6</month>
<day>1</day>
</effectiveDate>
<expirationDate>
<year>2014</year>
<month>10</month>
<day>1</day>
</expirationDate>
<firstLoanDrawDate>
<year>2010</year>
<month>7</month>
<day>2</day>
</firstLoanDrawDate>
<firstLoanGeneralLedgerMap>DNLPN</firstLoanGeneralLedgerMap>
<maturityDate>
<year>2030</year>
<month>6</month>
<day>7</day>
</maturityDate>
<FacilityName>01 DIRECT NOTE</FacilityName>
<sicCountryCode>US</sicCountryCode>
<standardIndustryCode>6111</standardIndustryCode>
<terminationDate>
<year>0</year>
<month>0</month>
<day>0</day>
</terminationDate>
<type>RST</type>
<typeDescription>Revolver/Standard</typeDescription>
</Facility>
<finalExpiryDate>
<year>0</year>
<month>0</month>
<day>0</day>
</finalExpiryDate>
<foreignTaxWithholdCode/>
<foreignTaxWithholdPct>0.00000000000000</foreignTaxWithholdPct>
<lateChargeRuleId/>
<performingStatus>ACCR</performingStatus>
<pricingOption>DNLPN</pricingOption>
<pricingOption>Loan Portfolio DN</pricingOption>
<rateBasis>Actual/365/366</rateBasis>
<requestedAmountCurrency>USD</requestedAmountCurrency>
<sicCode>6111</sicCode>
<sicCountryCode>US</sicCountryCode>
<taxExemptPercent>0.00000000000000</taxExemptPercent>
<taxExemptType/>
<treasuryAreaReportingCode>US</treasuryAreaReportingCode>
</Loan>
</Outstanding>
<Accrual>
<AccrualCycle id="4GAL7819" ownerType="OST">
<amtPaid>0.000</amtPaid>
<amtPastDueWaived>0.000</amtPastDueWaived>
<adjustedDueDate>
<year>2013</year>
<month>1</month>
<day>17</day>
</adjustedDueDate>
<dueDate>
<year>2013</year>
<month>1</month>
<day>17</day>
</dueDate>
<startDate>
<year>2013</year>
<month>1</month>
<day>10</day>
</startDate>
<thruDate>
<year>2013</year>
<month>1</month>
<day>16</day>
</thruDate>
<withheldSoFar>0.000</withheldSoFar>
<singularityIndicator>N</singularityIndicator>
<reasonForWaiver/>
<minimumAccrualAmt>0.000</minimumAccrualAmt>
<minimumAmount>0.000</minimumAmount>
</AccrualCycle>
<AccrualLineItems>
<AccrualLineItem id="CGAL786C">
<ownerID>CGAL786B</ownerID>
<startDate>
<year>2013</year>
<month>1</month>
<day>10</day>
</startDate>
<endDate>
<year>2013</year>
<month>1</month>
<day>16</day>
</endDate>
<amountBalance>250000.000</amountBalance>
<rate>0.019373300000000</rate>
<spread>0.00000000000000</spread>
<penaltySpread>0.00000000000000</penaltySpread>
<racSpread>0.00000000000000</racSpread>
<amountAccrued>92.890</amountAccrued>
<amountAccruedCrumb>-0.004315068493156</amountAccruedCrumb>
<numberOfDays> 7</numberOfDays>
<accrualType/>
<ownerType>BOA</ownerType>
<accrualRate>0.019373300000000</accrualRate>
<rateCap>0.000000000000000</rateCap>
<rateFlr>0.000000000000000</rateFlr>
</AccrualLineItem>
</AccrualLineItems>
</Accrual>
<BillTransactionHistory/>
<BillRateHistory/>
<BillAssociationTotals>
<balanceForwardAmount>92.890</balanceForwardAmount>
<interestDueAmount>92.890</interestDueAmount>
<dueAmount>185.780</dueAmount>
</BillAssociationTotals>
</BillAssociation>
</BillAssociationsForOwner>
<BillAssociationOwnerTotals>
<allInRate>0.019373300000000</allInRate>
<balanceForwardAmount>92.890000000000001</balanceForwardAmount>
<escrowDueAmount>0.000</escrowDueAmount>
<feesDueAmount>0.000</feesDueAmount>
<interestDueAmount>92.890</interestDueAmount>
<lateChargeFeesDueAmount>0.000</lateChargeFeesDueAmount>
<principalBalanceAmount>250000.000</principalBalanceAmount>
<principalBalanceAfterPaymentAmount>250000.000</principalBalanceAfterPaymentAmount>
<principalDueAmount>0.000</principalDueAmount>
</BillAssociationOwnerTotals>
</BillAssociationOwner>
</BillAssociationOwners>
<RemittanceInstructions>
<SingleRemittanceInstruction>
<defaultRemittanceInstruction>Please remit payment</defaultRemittanceInstruction>
</SingleRemittanceInstruction>
</RemittanceInstructions>
</BillForContact>
</BillForContacts>
</BatchBill>
</BillTextHeader>
</Bills>

Learning CRM 2011

Friday, May 17, 2013

Read XML into an Object Model using XDocument

ENTRY POINT

BILLFORCONTACT CLASS

BORROWER CLASS

ADDRESS CLASS

THE XML FILE. THIS IS A BIG ONE.

No comments:

Post a Comment

Translate