private void SetPostDate(string columnValue, FinanceData.FinanceDataItem financeData)
{
double excellTransDate = double.Parse(columnValue);
DateTime postDate = DateTime.FromOADate(excellTransDate);
financeData.PostDate = postDate;
}
private void SetAmount(string columnValue, FinanceData.FinanceDataItem financeData)
{
decimal excellAmount;
Decimal.TryParse(columnValue, out excellAmount);
financeData.Amount = excellAmount;
}
private void PopulateChaseData(Excel.Worksheet workSheet)
{
bool readData = false;
foreach (Excel.Range row in workSheet.UsedRange.Rows)
{
int whichColumn = 1;
if (!readData) // Skipping the first row which is just the column headers
{
readData = true;
continue;
}
FinanceData.FinanceDataItem financeData = new FinanceData.FinanceDataItem();
foreach (Excel.Range column in row.Columns)
{
string columnValue = (column.Value2 != null) ? column.Value2.ToString() : String.Empty;
switch (whichColumn)
{
case 1: // Type
financeData.Type = EnumHelper.ParseEnum <FinanceType>(columnValue);;
break;
case 2: // Trans Date
double excellTransDate = double.Parse(columnValue);
DateTime transDate = DateTime.FromOADate(excellTransDate);
financeData.TransDate = transDate;
break;
case 3: // Post Date
SetPostDate(columnValue, financeData);
break;
case 4: // Description
SetDescription(columnValue, financeData);
break;
case 5: // Amount
SetAmount(columnValue, financeData);
break;
}
whichColumn++;
}
financeData.SetCategory();
_chaseFinanceData.AddFinanceDataItem(financeData);
}
}
private void PopulateCyprusData(Excel.Worksheet workSheet)
{
bool readData = false;
foreach (Excel.Range row in workSheet.UsedRange.Rows)
{
int whichColumn = 1;
if (!readData) // Skipping the first row which is just the column headers
{
readData = true;
continue;
}
FinanceData.FinanceDataItem financeData = new FinanceData.FinanceDataItem();
foreach (Excel.Range column in row.Columns)
{
string columnValue = (column.Value2 != null) ? column.Value2.ToString() : String.Empty;
switch (whichColumn)
{
case 1: //Account Number
break;
case 2: //Post Date
SetPostDate(columnValue, financeData);
break;
case 3: //Check Number
break;
case 4: // Description
SetDescription(columnValue, financeData);
break;
case 5: // Debit
if (columnValue.Trim() != String.Empty)
{
SetAmount("-" + columnValue, financeData);
}
break;
case 6: // Credit
if (columnValue.Trim() != String.Empty)
{
SetAmount(columnValue, financeData);
}
break;
case 7: // Status
break;
case 8: // Balance
break;
}
whichColumn++;
}
financeData.SetCategory();
_cyprusFinanceData.AddFinanceDataItem(financeData);
}
}
private void SetDescription(string columnValue, FinanceData.FinanceDataItem financeData)
{
financeData.Description = columnValue;
}