private void UploadButton_Click(object sender, RoutedEventArgs e)
{
// Create OpenFileDialog
Microsoft.Win32.OpenFileDialog dlg = new Microsoft.Win32.OpenFileDialog();
// Set filter for file extension and default file extension
dlg.DefaultExt = ".csv";
dlg.Filter = "Excel Files (*.xls;*.xlsx;*.csv)|*.xls;*.xlsx;*.csv";
// Display OpenFileDialog by calling ShowDialog method
bool?result = dlg.ShowDialog();
if (result == true)
{
// Open document
string filename = dlg.FileName;
if (Path.GetExtension(filename) == ".csv" || Path.GetExtension(filename) == ".CSV")
{
ReportFormat bank = ReportFormats.Where(r => r.IsChecked == true).First();
string holder = HoldersItems.Where(r => r.IsChecked == true).Select(x => x.HolderName).First();
ExcelImport.ImportFromExcel(filename, bank, holder, date_statement.SelectedDate);
UpdateSalaries();
UpdateDataGrid();
}
}
}
