public TaxpayerImport CreateTaxpayerImport(DataRow row)
{
var taxpayer = new TaxpayerImport
{
Import = GetBool(row["Import"].ToString().Trim().ToLower()),
EntityCode = row["EntityCode"].ToString().Trim(),
TaxNumber = row["TaxNumber"].ToString().Trim(),
TaxpayerOrFirstName = row["FirstName"].ToString().Trim(),
LastName = row["LastName"].ToString().Trim(),
EntityType = GetEntityType(row["EntityType"].ToString().Trim().ToLower()),
DateOfBirth = GetDate(row["DateOfBirth"].ToString().Trim()),
BsbNumber = row["BsbNumber"].ToString().Trim(),
BankAccountNumber = row["BankAccountNumber"].ToString().Trim(),
BalanceAccountName = row["BalanceAccountName"].ToString().Trim(),
BaseRateEntityIndicator = GetBool(row["BaseRateEntityIndicator"].ToString().Trim().ToLower()),
NoticesRecipientCorporateName = row["NoticesRecipientCorporateName"].ToString().Trim(),
NoticesRecipientCorporateABN = row["NoticesRecipientCorporateABN"].ToString().Trim(),
NoticesRecipientIndividualFirstName = row["NoticesRecipientIndividualFirstName"].ToString().Trim(),
NoticesRecipientIndividualLastName = row["NoticesRecipientIndividualLastName"].ToString().Trim(),
FamilyTrustElectionYear = GetFamilyTrustElectionYear(row["FamilyTrustElectionYear"].ToString().Trim()),
FamilyTrustElection = row["FamilyTrustElection"].ToString().Trim(),
};
return(taxpayer);
}
public List <TaxpayerImport> CreateTaxpayerFromExcelAsync(string filename)
{
Workbook workbook = new Workbook();
using System.IO.Stream stream = _resourceFileLoader.LoadStreamResource(str => str.EndsWith(filename));
workbook.LoadFromStream(stream);
Worksheet sheet = workbook.Worksheets[0];
DataTable data = sheet.ExportDataTable();
List <TaxpayerImport> imports = new List <TaxpayerImport>();
foreach (DataRow row in data.Rows)
{
TaxpayerImport import = CreateTaxpayerImport(row);
imports.Add(import);
}
return(imports);
}