public void Execute(object parameter) { if (buttonContent.Equals("Import Transactions")) { MessageBoxResult messageBoxResult = CustomMessageBox.ShowYesNo( "\tPlease choose an import type!", "Import type alert!", "Automatized", "User specified"); if (messageBoxResult == MessageBoxResult.Yes || messageBoxResult == MessageBoxResult.No) { Microsoft.Win32.OpenFileDialog dlg = new Microsoft.Win32.OpenFileDialog(); dlg.DefaultExt = ".xls,.csv"; dlg.Filter = "Excel files (*.xls)|*.xls|Excel Files (*.xlsx)|*.xlsx|Excel Files (*.xlsm)|*.xlsm|CSV Files (*.csv)|*.csv"; dlg.Multiselect = true; Nullable <bool> result = dlg.ShowDialog(); if (result == true) { List <string> fileAdresses = dlg.FileNames.ToList(); for (int i = 0; i < dlg.FileNames.ToList().Count; i++) { check_if_csv(i, ref fileAdresses); } if (messageBoxResult == MessageBoxResult.Yes) { importPage.getTransactions("Bank", fileAdresses); } else if (messageBoxResult == MessageBoxResult.No) { string[] fileName = dlg.FileNames.ToList()[0].Split('\\'); int lastPartIndex = fileName.Length - 1; // to see which file the user immporting first SpecifiedImport.getInstance(fileAdresses, importPage.mainWindow).setCurrentFileLabel(fileName[lastPartIndex]); //fájl felismerés StoredColumnChecker columnChecker = new StoredColumnChecker(); columnChecker.getDataTableFromSql(importPage.mainWindow); columnChecker.setAnalyseWorksheet(dlg.FileNames.ToList()[0]); columnChecker.setMostMatchesRow(columnChecker.findMostMatchingRow()); columnChecker.setSpecifiedImportPageTextBoxes(); importPage.mainWindow.MainFrame.Content = SpecifiedImport.getInstance(dlg.FileNames.ToList(), importPage.mainWindow); } } } } }
public void Execute(object parameter) { if (buttonContent.Equals("Import Transactions")) { MessageBoxResult messageBoxResult = CustomMessageBox.ShowYesNo( "\tPlease choose an import type!", "Import type alert!", "Automatized", "User specified"); if (messageBoxResult == MessageBoxResult.Yes || messageBoxResult == MessageBoxResult.No) { Microsoft.Win32.OpenFileDialog dlg = new Microsoft.Win32.OpenFileDialog(); dlg.DefaultExt = ".xls,.csv"; dlg.Filter = "Excel files (*.xls)|*.xls|Excel Files (*.xlsx)|*.xlsx|Excel Files (*.xlsm)|*.xlsm|CSV Files (*.csv)|*.csv"; dlg.Multiselect = true; Nullable <bool> result = dlg.ShowDialog(); if (result == true) { for (int i = 0; i < dlg.FileNames.ToList().Count; i++) { check_if_csv(i, dlg); } //importPage.FolderAddressLabel.Content = dlg.FileName.; if (messageBoxResult == MessageBoxResult.Yes) { importPage.getTransactions("All", dlg.FileNames.ToList()); } else if (messageBoxResult == MessageBoxResult.No) { string[] fileName = dlg.FileNames.ToList()[0].Split('\\'); int lastPartIndex = fileName.Length - 1; // to see which file the user immporting first SpecifiedImport.getInstance(dlg.FileNames.ToList(), importPage.mainWindow).setCurrentFileLabel(fileName[lastPartIndex]); //fájl felismerés checkIfFileInformationStored(dlg.FileNames.ToList()[0]); importPage.mainWindow.MainFrame.Content = SpecifiedImport.getInstance(dlg.FileNames.ToList(), importPage.mainWindow); } } } } }