如何将 XML 文件读入单个 DataTable C#

Question

我有一个 XML 文件。

当我用 Excel 打开它时；我收到一个弹出窗口问我：

“请选择您希望如何打开此文件：”

然后有3个选项，默认选择第一个。该选项是：

“作为 XML 表”

然后我保留默认勾选并单击：“确定”，我得到一张数据（我使用的特定 XML 在 excel 的一张数据中有很多列）。

我尝试DataSet使用以下代码将 C# 中的同一个 XML 文件读入：

DataSet theMainXMLData = new DataSet();
theMainXMLData.ReadXml(fullFilePath);

问题是; 里面有DataSet多个DataTables。我需要将所有DataTable内容合二为一，就像 Excel 将所有内容都放在一张纸上一样。

我尝试过使用该方法的重载：ReadXml使用不同XmlReadMode的，但我尝试过的都没有给我 1 中的所有数据DataTable。

如何在 1 中获取所有数据DataTable？

Excel 是如何做到的？

Answer 1

没有简单的方法可以做到这一点。最好的方法是序列化数据。大多数人创建一个模式，并且有一些工具可以将模式转换为 C# 类。没有架构，您必须手动创建类。using System;using System.Collections.Generic;using System.Linq;using System.Text;using System.Xml;using System.Xml.Serialization;namespace ConsoleApplication110{&nbsp; &nbsp; class Program&nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; const string FILENAME = @"c:\temp\test.xml";&nbsp; &nbsp; &nbsp; &nbsp; static void Main(string[] args)&nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; XmlReader reader = XmlReader.Create(FILENAME);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; XmlSerializer serializer = new XmlSerializer(typeof(SupplierDataReport));&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; SupplierDataReport report = (SupplierDataReport)serializer.Deserialize(reader);&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; }&nbsp; &nbsp; public class SupplierDataReport&nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; public Header Header { get;set;}&nbsp; &nbsp; &nbsp; &nbsp; [XmlArray("Products")]&nbsp; &nbsp; &nbsp; &nbsp; [XmlArrayItem("ProductDetails")]&nbsp; &nbsp; &nbsp; &nbsp; public List<ProductDetails> ProductDetails { get; set; }&nbsp; &nbsp; }&nbsp; &nbsp; public class Header&nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; public string Note { get;set;}&nbsp; &nbsp; &nbsp; &nbsp; public string UserName { get;set;}&nbsp; &nbsp; &nbsp; &nbsp; public string DateDrawn { get;set;}&nbsp; &nbsp; &nbsp; &nbsp; public string Group { get;set;}&nbsp; &nbsp; &nbsp; &nbsp; public string Branch { get;set;}&nbsp; &nbsp; &nbsp; &nbsp; public string Product { get;set;}&nbsp; &nbsp; &nbsp; &nbsp; public string Administrator { get;set;}&nbsp; &nbsp; &nbsp; &nbsp; public string Claims { get;set;}&nbsp; &nbsp; &nbsp; &nbsp; public string Owner { get;set;}&nbsp; &nbsp; &nbsp; &nbsp; public string Underwriter { get;set;}&nbsp; &nbsp; &nbsp; &nbsp; private DateTime _StartDate { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string&nbsp; StartDate {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; get { return _StartDate.ToString("dd MMM yyyy"); }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; set { _StartDate = DateTime.ParseExact(value, "dd MMM yyyy", System.Globalization.CultureInfo.InvariantCulture);}&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; private DateTime _EndDate { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string EndDate&nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; get { return _EndDate.ToString("dd MMM yyyy"); }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; set { _EndDate = DateTime.ParseExact(value, "dd MMM yyyy", System.Globalization.CultureInfo.InvariantCulture); }&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; public string DeclinedTransactions { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string DraftMode { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string DraftMessage { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public int NumberofRecords { get; set; }&nbsp; &nbsp; }&nbsp; &nbsp; public class ProductDetails&nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; public Transaction Transaction { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public Client Client { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public Vehicle Vehicle { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public Product Product { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public BankingDetails BankingDetails { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public Company Company { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public cBatchNumber VehicleTyre1 { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public cBatchNumber VehicleTyre2 { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public cBatchNumber VehicleTyre3 { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public cBatchNumber VehicleTyre4 { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public cBatchNumber VehicleTyre5 { get; set; }&nbsp; &nbsp; }&nbsp; &nbsp; public class Transaction&nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; public string PolicyId { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string PolicyNumber { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; private DateTime _InceptionDate { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string InceptionDate&nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; get { return _InceptionDate.ToString("dd-MMM-yyyy"); }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; set { _InceptionDate = DateTime.ParseExact(value, "dd-MMM-yyyy", System.Globalization.CultureInfo.InvariantCulture); }&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; public string GroupId { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string GroupCode { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string GroupName { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string BranchId { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string BranchCode { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string BranchName { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string BranchPOAddressLine1 { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string BranchPOAddressLine2 { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string BranchPOAddressSuburb { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string BranchPOAddressCity { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string BranchPOAddressPostCode { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string BranchPHAddressLine1 { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string BranchPHAddressLine2 { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string BranchPHAddressSuburb { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string BranchPHAddressCity { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string BranchPHAddressPostCode { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string BranchTelephoneCode { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string BranchTelephoneNumber { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string BranchFaxCode { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string BranchFaxNumber { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string docFinanceCompanyCode { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string docFinanceCompanyName { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string docFinanceAccountNumber { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string docInsuranceCompanyCode { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string docInsuranceCompanyName { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string docInsuranceAccountNumber { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public decimal DepositValue { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public decimal FinanceAmount { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string ResidualValue { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string BusinessManagerId { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string BusinessManager { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string BMWorkTelephone { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string BMMobileNumber { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string BMEmailAddress { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string Notes { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string FinanceTerm { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string SalesPersonId { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string SalesPerson { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string InterestRateType { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public decimal InterestRate { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string DigitallySigned { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string CompanyConsent { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string OtherCompanyConsent { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string MarketingConsent { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string LegitimateInterestConsent { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string FinancePromotionCode { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string IncludedSchedule { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string MedicalAidScheme { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string MedicalAidNumber { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string EmergencyContactName1 { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string EmergencyContactNumber1 { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string EmergencyContactName2 { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string EmergencyContactNumber2 { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string CashTransaction { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string finContractStartDate { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string finFirstDebitDate { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string POPIConcent { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string VehicleUse { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string LatestReferenceNumber { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string LatestAlternativeReferenceNumber { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string LatestAccountNumber { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string DealerOwnerCode { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string PackageCode { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string FspCompanyName { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string FspCompanyNumber { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string GroupBranchRegistrationNumber { get; set; }&nbsp; &nbsp; }&nbsp; &nbsp; public class Client&nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; public string ClientCategory { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string ClientTitle { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string ClientFirstName { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string ClientLastName { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string ClientIDType { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string ClientIDNumber { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string ClientGender { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string ClientMobileNumber { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string ClientWorkTelephoneCode { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string ClientWorkTelephoneNumber { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string ClientHomeTelephoneCode { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string ClientHomeTelephoneNumber { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string ClientEmailAddress { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string ClientOccupationName { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string ClientPOAddressLine1 { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string ClientPOAddressLine2 { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string ClientPOAddressSuburb { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string ClientPOAddressCity { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string ClientPOAddressPostCode { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string ClientPOAddressProvinceName { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string ClientPOAddressCountryName { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string ClientPHAddressLine1 { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string ClientPHAddressLine2 { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string ClientPHAddressSuburb { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string ClientPHAddressCity { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string ClientPHAddressPostCode { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string ClientPHAddressProvinceName { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string ClientPHAddressCountryName { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string MaritalStatus { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string ClientEmploymentType { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string ClientPassportIssueDate { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string ClientPassportExpiryDate { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; private DateTime _ClientBirthDate { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string ClientBirthDate&nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; get { return _ClientBirthDate.ToString("dd-MMM-yyyy"); }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; set { _ClientBirthDate = DateTime.ParseExact(value, "dd-MMM-yyyy", System.Globalization.CultureInfo.InvariantCulture); }&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; public string ContactMethod { get; set; }&nbsp; &nbsp; }&nbsp; &nbsp; public class Vehicle&nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; public string StockNumber { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string MMCode { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string Manufacturer { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string Model { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string NewUsed { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; private DateTime _FirstRegistrationDate { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string FirstRegistrationDate&nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; get { return _FirstRegistrationDate.ToString("dd-MMM-yyyy"); }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; set { _FirstRegistrationDate = DateTime.ParseExact(value, "dd-MMM-yyyy", System.Globalization.CultureInfo.InvariantCulture); }&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; public string RegistrationNumber { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string VINNumber { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string EngineNumber { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public int OdometerReading { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public decimal RetailPrice { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public decimal DiscountAmount { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string RegistrationFee { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string DeliveryFee { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string Accessories { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public decimal AccessoryTotal { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public decimal VehicleValue { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string InspectorName { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string VehicleDamage { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string LeftFrontFenderDamage { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string LeftFrontDoorDamage { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string LeftBackFenderDamage { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string LeftBackDoorDamage { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string RightFrontFenderDamage { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string RightFrontDoorDamage { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string RightBackFenderDamage { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string RightBackDoorDamage { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string BonnetDamage { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string RoofDamage { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string BootDamage { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string FrontBumperDamage { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string BackBumperDamage { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string FullServiceHistory { get; set; }&nbsp; &nbsp; }&nbsp; &nbsp; public class Product&nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; public string ProductId { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string ProductName { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string ProductOptionId { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string ProductOptionCode { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string ProductOptionName { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public decimal ProductAmount { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public decimal ProductVATAmount { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public decimal ProductTotalAmount { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public decimal PayoverAmount { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public decimal PayoverVATAmount { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public decimal PayoverTotalAmount { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string CommissionAmount { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string CollectionFee { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string PaymentType { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string MonthlyPremium { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string CoverAmount { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string Term { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string ExpiryDate { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string mtnExpiryKilometres { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string mtnManufacturerPlanType { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string mtnManufacturerExpiryMonths { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string mtnManufacturerExpiryKilometres { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string warAdditionalMonths { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string warManufacturerExpiryMonths { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string SIFirstName { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string SILastName { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string SIIDType { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string SIIDNumber { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string SIGender { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string SIMobileNumber { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string SIWorkTelephoneCode { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string SIWorkTelephoneNumber { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string SIHomeTelephoneCode { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string SIHomeTelephoneNumber { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string SIEmailAddress { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string SIAddressLine1 { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string SIAddressLine2 { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string SIAddressSuburb { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string SIAddressCity { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string SIAddressPostCode { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string SIAddressProvinceName { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string SIAddressCountryName { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string FirstDebitDate { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string FirstDebitAmount { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string RecurringDebitDay { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string RecurringDebitAmount { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string CollectionAgent { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public decimal ProductPolicyFee { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string ReferenceNo { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public decimal ProductInspectionFee { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string mtnExistingPlanType { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string mtnExistingExpiryDate { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string mtnExistingExipryKilometrs { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string warManufacturePlan { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string warManufacturerExpiryKilometres { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string warExistingPlan { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string warExistingExpiryDate { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string warExistingExpiryKilometres { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string warAdditionalKilometres { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string warExpiryKilometres { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string SITitle { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string SIRelationship { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string ProductTypeCatergoryCode { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string ProductTypeCatergoryName { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string ProductOwner { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string ProductAdministrator { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string SIBirthDate { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string ProductClaimsCompany { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string ProductUnderwriterCompany { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public decimal ProductAdminFee { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public decimal BinderFee { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public decimal DealerDocumentationFee { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public decimal ValuationFee { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string ProductNote { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public decimal SupplierRecovery { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string BillToCompanyName { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string OptionDisclosure { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string OptionQuoteNumber { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; private DateTime _Commencement { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string Commencement&nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; get { return _Commencement.ToString("dd-MMM-yyyy"); }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; set { _Commencement = DateTime.ParseExact(value, "dd-MMM-yyyy", System.Globalization.CultureInfo.InvariantCulture); }&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; public string mtnKilometresCommencement { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string mtnAdditionalKilometres { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string BeneficiaryFirstName { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string BeneficiaryLastName { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string BeneficiaryIDType { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string BeneficiaryIDNumber { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string BeneficiaryMobileNumber { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string BeneficiaryWorkTelephoneCode { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string BeneficiaryWorkTelephoneNumber { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string BeneficiaryHomeTelephoneCode { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string BeneficiaryHomeTelephoneNumber { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string BeneficiaryRelationship { get; set; }&nbsp; &nbsp; }&nbsp; &nbsp; public class BankingDetails&nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; public string BankName { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string BankBranchName { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string BankBranchCode { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string BankAccountType { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string BankAccountNumber { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string AccountHolderName { get; set; }&nbsp; &nbsp; }&nbsp; &nbsp; public class Company&nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; public string CompanyName { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string CompanyRegistrationNumber { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string CompanyVATNumber { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string CompanyAddressLine1 { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string CompanyAddressLine2 { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string CompanyAddressSuburb { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string CompanyAddressCity { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string CompanyAddressPostCode { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string CompanyAddressProvinceName { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public string CompanyAddressCountryName { get; set; }&nbsp; &nbsp; }&nbsp; &nbsp; public class cBatchNumber&nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; public string BatchNumber { get; set; }&nbsp; &nbsp; }}