public static ImportPageStock getInstance(MainWindow mainWindow)
{
if (instance == null)
{
instance = new ImportPageStock(mainWindow);
}
instance.Loaded += instance.ImportPageStock_Loaded;
return(instance);
}
public ExportTransactions(List <Stock> transactions, MainWindow mainWindow, string currentFileName)
{
string earningMethod = ImportPageStock.getInstance(mainWindow).getMethod();
switch (earningMethod)
{
case "FIFO":
stockExportFIFO(transactions);
break;
case "LIFO":
stockExportLIFO(transactions);
break;
case "CUSTOM":
break;
}
}
public void MyAction(string commandName)
{
mainWindow.tableDock.Background = new SolidColorBrush(Color.FromRgb(217, 133, 59));
mainWindow.importDock.Background = new SolidColorBrush(Color.FromRgb(217, 133, 59));
mainWindow.stockChartDock.Background = new SolidColorBrush(Color.FromRgb(217, 133, 59));
mainWindow.tableMenuTop.Visibility = System.Windows.Visibility.Hidden;
mainWindow.importMenuTop.Visibility = System.Windows.Visibility.Hidden;
mainWindow.portfolioMenuTop.Visibility = System.Windows.Visibility.Hidden;
mainWindow.bankImport.Background = Brushes.Transparent;
mainWindow.stockImport.Background = Brushes.Transparent;
mainWindow.bankDatabase.Background = Brushes.Transparent;
mainWindow.stockDatabase.Background = Brushes.Transparent;
mainWindow.stockChart.Background = Brushes.Transparent;
mainWindow.stockDatagrid.Background = Brushes.Transparent;
if (commandName == "bankImportPushed")
{
ImportPageBank.getInstance(mainWindow).setUserStatistics(mainWindow.getCurrentUser());
mainWindow.MainFrame.Content = ImportPageBank.getInstance(mainWindow);
mainWindow.importMenuTop.Visibility = System.Windows.Visibility.Visible;
mainWindow.importDock.Background = new SolidColorBrush(Color.FromRgb(198, 61, 15));
mainWindow.bankImport.Background = new SolidColorBrush(Color.FromRgb(255, 140, 105));
}
else if (commandName == "stockImportPushed")
{
ImportPageStock.getInstance(mainWindow).setUserStatistics(mainWindow.getCurrentUser());
mainWindow.MainFrame.Content = ImportPageStock.getInstance(mainWindow);
mainWindow.importMenuTop.Visibility = System.Windows.Visibility.Visible;
mainWindow.importDock.Background = new SolidColorBrush(Color.FromRgb(198, 61, 15));
mainWindow.stockImport.Background = new SolidColorBrush(Color.FromRgb(255, 140, 105));
}
else if (commandName == "bankDatabasePushed")
{
DatabaseDataBank.getInstance(mainWindow).setTableAttributes();
mainWindow.MainFrame.Content = DatabaseDataBank.getInstance(mainWindow);
mainWindow.tableMenuTop.Visibility = System.Windows.Visibility.Visible;
mainWindow.tableDock.Background = new SolidColorBrush(Color.FromRgb(198, 61, 15));
mainWindow.bankDatabase.Background = new SolidColorBrush(Color.FromRgb(255, 140, 105));
}
else if (commandName == "stockDatabasePushed")
{
DatabaseDataStock.getInstance(mainWindow).setTableAttributes();
mainWindow.MainFrame.Content = DatabaseDataStock.getInstance(mainWindow);
mainWindow.tableMenuTop.Visibility = System.Windows.Visibility.Visible;
mainWindow.tableDock.Background = new SolidColorBrush(Color.FromRgb(198, 61, 15));
mainWindow.stockDatabase.Background = new SolidColorBrush(Color.FromRgb(255, 140, 105));
}
else if (commandName == "stockChartPushed")
{
StockChart stockChart = new StockChart(mainWindow);
mainWindow.MainFrame.Content = stockChart;
mainWindow.portfolioMenuTop.Visibility = System.Windows.Visibility.Visible;
mainWindow.stockChartDock.Background = new SolidColorBrush(Color.FromRgb(198, 61, 15));
mainWindow.stockChart.Background = new SolidColorBrush(Color.FromRgb(255, 140, 105));
}
else if (commandName == "stockDatagridPushed")
{
mainWindow.MainFrame.Content = new StockDataGrid(mainWindow);
mainWindow.portfolioMenuTop.Visibility = System.Windows.Visibility.Visible;
mainWindow.stockChartDock.Background = new SolidColorBrush(Color.FromRgb(198, 61, 15));
mainWindow.stockChart.Background = new SolidColorBrush(Color.FromRgb(255, 140, 105));
}
else if (commandName == "Exit")
{
mainWindow.Close();
}
}
public ExportTransactions(List <Stock> customTransactions, MainWindow mainWindow, string currentFileName, string customEarning)
{
for (int i = 0; i < customTransactions.Count; i++)
{
customTransactions[i].setImporter(mainWindow.getCurrentUser().getUsername());
customTransactions[i].setEarningMethod(customEarning);
}
MessageBox.Show("Exporting data from: " + currentFileName, "", MessageBoxButton.OK);
SavedTransactions.addToSavedTransactionsStock(customTransactions); //adding the freshyl imported transactions to the saved
WriteWorkbook = excel.Workbooks.Open(@"C:\Users\Tocki\Desktop\Kimutatas.xlsx");
WriteWorksheet = WriteWorkbook.Worksheets[2];
string todaysDate = DateTime.Now.ToString("yyyy-MM-dd");
int row_number = 1;
while (WriteWorksheet.Cells[row_number, 1].Value != null)
{
row_number++; // get the current last row
}
for (int i = 0; i < customTransactions.Count; i++)
{
WriteWorksheet.Cells[row_number, 1].Value = todaysDate;
WriteWorksheet.Cells[row_number, 2].Value = customTransactions[i].getTransactionDate();
WriteWorksheet.Cells[row_number, 3].Value = customTransactions[i].getStockName();
WriteWorksheet.Cells[row_number, 4].Value = customTransactions[i].getStockPrice();
Regex typeRegex1 = new Regex(@"Eladott");
Regex typeRegex2 = new Regex(@"Sold");
Regex typeRegex3 = new Regex(@"Sell");
Regex typeRegex4 = new Regex(@"Vásárolt");
Regex typeRegex5 = new Regex(@"Bought");
Regex typeRegex6 = new Regex(@"Buy");
if (typeRegex1.IsMatch(customTransactions[i].getTransactionType()) ||
typeRegex2.IsMatch(customTransactions[i].getTransactionType()) ||
typeRegex3.IsMatch(customTransactions[i].getTransactionType())) //Eladott
{
WriteWorksheet.Cells[row_number, 5].Value = customTransactions[i].getOriginalQuantityForCustomEarning(); //!! eredeti quantity
WriteWorksheet.Cells[row_number, 9].Value = customTransactions[i].getProfit();
WriteWorksheet.Cells[row_number, 10].Value = customEarning;
}
else if (typeRegex4.IsMatch(customTransactions[i].getTransactionType()) ||
typeRegex5.IsMatch(customTransactions[i].getTransactionType()) ||
typeRegex6.IsMatch(customTransactions[i].getTransactionType())) //Vásárolt
{
WriteWorksheet.Cells[row_number, 6].Value = customTransactions[i].getOriginalQuantityForCustomEarning(); //! eredeti quantity
WriteWorksheet.Cells[row_number, 8].Value = customTransactions[i].getOriginalQuantityForCustomEarning() * customTransactions[i].getStockPrice(); //!! eredeti quantity
}
WriteWorksheet.Cells[row_number, 7].Value = customTransactions[i].getQuantity(); //!! mostani quantity
WriteWorksheet.Cells[row_number, 11].Value = mainWindow.getCurrentUser().getUsername();
row_number++;
Range line = (Range)WriteWorksheet.Rows[row_number];
line.Insert();
}
try
{
excel.ActiveWorkbook.Save();
excel.Workbooks.Close();
excel.Quit();
}
catch (Exception e)
{
}
ImportPageStock.getInstance(mainWindow).setUserStatistics(mainWindow.getCurrentUser());
}
public ExportTransactions(List <Stock> transactions, MainWindow mainWindow, string currentFileName)
{
string earningMethod = ImportPageStock.getInstance(mainWindow).getMethod();
//we need the original quantity that's we going to get it from the original transactions List
//(after the switch it is zero for every object)
List <int> quantities = new List <int>();
for (int i = 0; i < transactions.Count; i++)
{
quantities.Add(transactions[i].getQuantity());
}
//but we need the profits too , which we going to get from the tempTransactions
switch (earningMethod)
{
case "FIFO":
stockExportFIFO(ref transactions);
break;
case "LIFO":
stockExportLIFO(ref transactions);
break;
case "CUSTOM":
mainWindow.MainFrame.Content = new CustomStockExportPage(mainWindow, transactions, currentFileName);
break;
}
if (earningMethod == "FIFO" || earningMethod == "LIFO")
{
//for DataBaseDataStock
for (int i = 0; i < transactions.Count; i++)
{
string value = quantities[i] + " (" + transactions[i].getQuantity() + ")";
transactions[i].setOriginalAndSellQuantity(value);
transactions[i].setImporter(mainWindow.getCurrentUser().getUsername());
transactions[i].setEarningMethod(earningMethod);
}
MessageBox.Show("Exporting data from: " + currentFileName, "", MessageBoxButton.OK);
SavedTransactions.addToSavedTransactionsStock(transactions);//adding the freshyl imported transactions to the saved
WriteWorkbook = excel.Workbooks.Open(@"C:\Users\Tocki\Desktop\Kimutatas.xlsx");
WriteWorksheet = WriteWorkbook.Worksheets[2];
string todaysDate = DateTime.Now.ToString("yyyy-MM-dd");
int row_number = 1;
while (WriteWorksheet.Cells[row_number, 1].Value != null)
{
row_number++; // get the current last row
}
for (int i = 0; i < transactions.Count; i++)
{
WriteWorksheet.Cells[row_number, 1].Value = todaysDate;
WriteWorksheet.Cells[row_number, 2].Value = transactions[i].getTransactionDate();
WriteWorksheet.Cells[row_number, 3].Value = transactions[i].getStockName();
WriteWorksheet.Cells[row_number, 4].Value = transactions[i].getStockPrice();
Regex typeRegex1 = new Regex(@"Eladott");
Regex typeRegex2 = new Regex(@"Sold");
Regex typeRegex3 = new Regex(@"Sell");
Regex typeRegex4 = new Regex(@"Vásárolt");
Regex typeRegex5 = new Regex(@"Bought");
Regex typeRegex6 = new Regex(@"Buy");
if (typeRegex1.IsMatch(transactions[i].getTransactionType()) ||
typeRegex2.IsMatch(transactions[i].getTransactionType()) ||
typeRegex3.IsMatch(transactions[i].getTransactionType())) //Eladott
{
WriteWorksheet.Cells[row_number, 5].Value = quantities[i]; //!! eredeti quantity
WriteWorksheet.Cells[row_number, 9].Value = transactions[i].getProfit();
WriteWorksheet.Cells[row_number, 10].Value = earningMethod;
}
else if (typeRegex4.IsMatch(transactions[i].getTransactionType()) ||
typeRegex5.IsMatch(transactions[i].getTransactionType()) ||
typeRegex6.IsMatch(transactions[i].getTransactionType())) //Vásárolt
{
WriteWorksheet.Cells[row_number, 6].Value = quantities[i]; //! eredeti quantity
WriteWorksheet.Cells[row_number, 8].Value = quantities[i] * transactions[i].getStockPrice(); //!! eredeti quantity
}
WriteWorksheet.Cells[row_number, 7].Value = transactions[i].getQuantity(); //!! mostani quantity
WriteWorksheet.Cells[row_number, 11].Value = mainWindow.getCurrentUser().getUsername();
row_number++;
Range line = (Range)WriteWorksheet.Rows[row_number];
line.Insert();
}
try
{
excel.ActiveWorkbook.Save();
excel.Workbooks.Close();
excel.Quit();
}
catch (Exception e)
{
}
ImportPageStock.getInstance(mainWindow).setUserStatistics(mainWindow.getCurrentUser());
}
}
private void Button_Click_1(object sender, RoutedEventArgs e)
{
mainWindow.MainFrame.Content = ImportPageStock.getInstance(mainWindow);
}
