/// <summary>
/// Transform a set of records according to the filetype set upon instantiation.
/// </summary>
/// <param name="records"></param>
/// <returns></returns>
public List <AccountRecord> TransformRecords()
{
TargetRecords = new List <AccountRecord>();
TransformSingleRecord fileSpecificTransform;
switch (fileReader.inputFileType)
{
case InputFileType.Type1:
fileSpecificTransform = new TransformSingleRecord(transformRecordType1);
break;
case InputFileType.Type2:
fileSpecificTransform = new TransformSingleRecord(transformRecordType2);
break;
default:
fileSpecificTransform = new TransformSingleRecord(returnBlankRecord);
break;
}
for (int i = 0; i < fileReader.recordsCount; i++)
{
string[] fields = fileReader.getFields(i);
AccountRecord transformResult = fileSpecificTransform(fields);
TargetRecords.Add(transformResult);
}
return(TargetRecords);
}
/// <summary>
///
/// </summary>
private AccountRecord transformRecordType1(string[] fields)
{
AccountRecord targetRecord = new AccountRecord();
// Record 0 -- Identifier
string identifier = fields[0].ToString(); // eg. 123|AbcCode
string accountCode = identifier.Split('|')[1]; // eg. AbcCode
targetRecord.AccountCode = accountCode;
// Record 1 -- Account Name
string name = fields[1].ToString(); // eg. My Account
targetRecord.Name = name;
// Record 2 -- Account Type
int accountInput = 0;
Int32.TryParse(fields[2].ToString(), out accountInput); // eg. 1, 2, 3, 4
if (accountInput >= 1 && accountInput <= 4)
{
targetRecord.Type = (AccountType)accountInput;
}
// Record 3 -- Opened Date
DateTime openDate = DateTime.MinValue; // DateTime is not nullable
if (DateTime.TryParse(fields[3].ToString(), out openDate))
{
targetRecord.OpenDate = openDate;
}
// Record 4 -- Currency Type
CurrencyType currencyType = CurrencyType.Unknown;
string currencyInput = fields[4].ToString();
if (currencyInput == "CD")
{
currencyType = CurrencyType.CAD;
}
else if (currencyInput == "US")
{
currencyType = CurrencyType.USD;
}
targetRecord.Currency = currencyType;
return(targetRecord);
}
private AccountRecord transformRecordType2(string[] fields)
{
AccountRecord targetRecord = new AccountRecord();
// AccountCode
string custodianCode = fields[3].ToString(); // Custodian Code
targetRecord.AccountCode = custodianCode;
// Name
string name = fields[0].ToString(); // eg. My Account
targetRecord.Name = name;
// Type
string accountInput = fields[1];
AccountType accountType;
if (Enum.TryParse(accountInput, out accountType))
{
targetRecord.Type = accountType;
}
// Open Date
// not available in this file format
// Currency
string currencyInput = fields[2].ToString();
if (currencyInput == "C")
{
targetRecord.Currency = CurrencyType.CAD;
}
else if (currencyInput == "U")
{
targetRecord.Currency = CurrencyType.USD;
}
return(targetRecord);
}