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 TemplateStockReadIn(ImportReadIn _stockHandler, string filePath)
{
stockHandler = _stockHandler;
folderAddresses = filePath;
workbook = excel.Workbooks.Open(folderAddresses);
stockWorksheet = workbook.Worksheets[1];
}
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);
}
public TemplateStockReadIn(ImportReadIn _stockHandler, List <string> _folderAddresses)
{
stockHandler = _stockHandler;
folderAddresses = _folderAddresses;
}