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);
}
}
}
}
}
