public void readOutTransactions()
{
if ((companyNameColumn != 0) && (transactionDateColumn != 0) && (priceColumn != 0))
{
importedStocks = new List <Stock>();
int blank_cell_counter = 0;
int row = 2;
while (blank_cell_counter < 2)
{
if ((stockWorksheet.Cells[row, companyNameColumn].Value != null) &&
(stockWorksheet.Cells[row, transactionDateColumn].Value != null) &&
(stockWorksheet.Cells[row, priceColumn].Value != null))
{
blank_cell_counter = 0;
string companyName = stockWorksheet.Cells[row, companyNameColumn].Value.ToString();
string transactionDate = stockWorksheet.Cells[row, transactionDateColumn].Value.ToString();
string transactionPriceString = stockWorksheet.Cells[row, priceColumn].Value.ToString().Replace(',', '.');
double transactionPrice = 0;
try
{
transactionPrice = double.Parse(transactionPriceString, CultureInfo.InvariantCulture);
}
catch (Exception e)
{
}
string transactionType = "-";
string quantityString = "";
int quantity = 0;
if (stockWorksheet.Cells[row, transactionTypeColumn].Value != null)
{
transactionType = stockWorksheet.Cells[row, transactionTypeColumn].Value.ToString();
}
if (stockWorksheet.Cells[row, quantityColumn].Value != null)
{
quantityString = stockWorksheet.Cells[row, quantityColumn].Value.ToString();
try
{
quantity = int.Parse(quantityString);
}
catch (Exception e)
{
}
}
Stock stock = new Stock(companyName, transactionPrice, quantity, transactionDate, transactionType);
importedStocks.Add(stock);
}
else
{
blank_cell_counter++;
}
row++;
}
stockHandler.addTransactions(importedStocks);
}
}
public ReadInKandH(ImportReadIn importReadin, Workbook workbook, Worksheet worksheet)
{
worksheet = workbook.Worksheets[1];
this.bankHanlder = importReadin;
transactions = new List <Transaction>();
string transactionDate = "";
string osszegString = "";
//string egyenlegString = "";
int osszeg = 0;
int currentEgyenleg = 0;
string accountNumber = worksheet.Cells[2, 4].Value.ToString();
int tempIndex = 2;
while (worksheet.Cells[tempIndex, 1].Value != null)
{
tempIndex++;
}
int i = tempIndex;
while (i != 2)
{
transactionDate = worksheet.Cells[i, 1].Value.ToString();
osszegString = worksheet.Cells[i, 8].Value.ToString();
osszeg = int.Parse(osszegString);
currentEgyenleg += osszeg;
transactions.Add(new Transaction(currentEgyenleg, transactionDate, osszeg, "old read IN OTP", accountNumber));
i--;
}
bankHanlder.addTransactions(transactions);
}
public ReadInOTP(ImportReadIn importReadin, Workbook workbook, Worksheet worksheet)
{
worksheet = workbook.Worksheets[1];
this.bankHanlder = importReadin;
transactions = new List <Transaction>();
int i = 1;
int egyenleg_rn = 0;
string transactionDate = "";
int osszeg = 0;
int new_egyenleg = 0;
bool need_values = true;
string osszeg_string = "";
string new_balance_string = "";
string accountNumber = worksheet.Cells[3, 2].Value.ToString();
i = 15;
while (worksheet.Cells[i, 1].Value != null)
{
//egyenleg += osszeg;
while (need_values)
{
transactionDate = worksheet.Cells[i, 3].Value.ToString();
osszeg_string = worksheet.Cells[i, 5].Value.ToString();
if (i > 15)
{
egyenleg_rn = new_egyenleg;
}
new_balance_string = worksheet.Cells[i, 6].Value.ToString();
if (i == 15)
{
egyenleg_rn = int.Parse(new_balance_string);
}
need_values = false;
osszeg = int.Parse(osszeg_string);
new_egyenleg = int.Parse(new_balance_string);
}
i++;
need_values = true;
transactions.Add(new Transaction(egyenleg_rn, transactionDate, osszeg, "old read IN OTP", accountNumber));
}
bankHanlder.addTransactions(transactions);
}
public ReadInFHB(ImportReadIn importReadin, Workbook workbook, Worksheet worksheet)
{
worksheet = workbook.Worksheets[1];
this.bankHanlder = importReadin;
transactions = new List <Transaction>();
int i = 20;
string transactionDate = "";
string osszegString = "";
string egyenlegString = "";
string accountNumberExtra = worksheet.Cells[8, 2].Value.ToString();
string accountNumber = accountNumberExtra.Substring(0, 25); //substraction the HUF word
int osszeg = 0;
int currentEgyenleg = 0;
while ((worksheet.Cells[i, 1].Value != null) || (worksheet.Cells[i + 1, 1].Value != null))//interesing FHB file..
{
if (worksheet.Cells[i, 1].Value != null)
{
transactionDate = worksheet.Cells[i, 1].Value.ToString();
if (worksheet.Cells[i, 9].Value != null) //cost
{
osszegString = worksheet.Cells[i, 9].Value.ToString();
osszeg = int.Parse(osszegString);
}
else if (worksheet.Cells[i, 11].Value != null)//income
{
osszegString = worksheet.Cells[i, 11].Value.ToString();
osszeg = int.Parse(osszegString) * (-1);
}
if (worksheet.Cells[i, 13].Value == null) //in case if the Egyenleg cell is null in the first transaction (interesting FHB file)
{
int tempIndex = i + 1; //don't scan the current cell because we already know it's null
while (worksheet.Cells[tempIndex, 13].Value == null)
{
tempIndex++;
}
string oldEgyenlegString = "";
oldEgyenlegString = worksheet.Cells[tempIndex, 13].Value.ToString();
int oldEgyenlegInt = int.Parse(oldEgyenlegString);
//adding or substracting other transactions -- to get the real Egyenleg
while (tempIndex != i - 1)
{
string tempOsszegString = "";
int tempOsszegInt = 0;
if (worksheet.Cells[tempIndex, 9].Value != null)//cost
{
tempOsszegString = worksheet.Cells[tempIndex, 9].Value.ToString();
tempOsszegInt = int.Parse(tempOsszegString);
}
else if (worksheet.Cells[tempIndex, 11].Value != null)//income
{
tempOsszegString = worksheet.Cells[tempIndex, 11].Value.ToString();
tempOsszegInt = int.Parse(tempOsszegString) * (-1);
}
oldEgyenlegInt += tempOsszegInt;
tempIndex--;//going back up
}
currentEgyenleg = oldEgyenlegInt;
}
else
{
if (worksheet.Cells[i, 13].value != null)
{
egyenlegString = worksheet.Cells[i, 13].Value.ToString();
currentEgyenleg = int.Parse(egyenlegString);
}
else
{
int tempEgyenleg = 0;
if (worksheet.Cells[i, 9].Value != null)
{
egyenlegString = worksheet.Cells[i, 9].Value.ToString();
tempEgyenleg = int.Parse(egyenlegString) * (-1);
currentEgyenleg += tempEgyenleg;
}
else if (worksheet.Cells[i, 11].Value != null)
{
egyenlegString = worksheet.Cells[i, 11].Value.ToString();
tempEgyenleg = int.Parse(egyenlegString);
currentEgyenleg += tempEgyenleg;
}
}
}
Console.WriteLine(currentEgyenleg);
transactions.Add(new Transaction(currentEgyenleg, transactionDate, osszeg, "old read IN FHB", accountNumber));
}
i++;
}
bankHanlder.addTransactions(transactions);
}