private void AddWorkerIDButton(object sender, System.Windows.RoutedEventArgs e)
{
if (globalDatabasePath != null)
{
CommonOpenFileDialog dialogFileSelect = new CommonOpenFileDialog();
dialogFileSelect.InitialDirectory = Environment.GetFolderPath(Environment.SpecialFolder.Desktop);
dialogFileSelect.Filters.Add(new CommonFileDialogFilter("Arkusz programu Microsoft Excel (*.xlsx)", ".xlsx"));
if (dialogFileSelect.ShowDialog() == CommonFileDialogResult.Ok)
{
//Update DB
if (DatabaseHandling.AddWorkerID(globalDatabasePath, dialogFileSelect.FileName) == 0)
{
this.ShowMessageAsync("Błąd pliku", "Wybrany plik jest niepoprawny, pusty lub otwarty");
return;
}
//Fill list
MainList.ItemsSource = DatabaseHandling.LoadAllByDate(globalDatabasePath);
this.ShowMessageAsync("Gotowe", "Załadowano kodowanie.");
}
}
else
{
this.ShowMessageAsync("Brak danych", "Dodaj najpierw plik");
}
}
private void ResetFilterButton(object sender, System.Windows.RoutedEventArgs e)
{
DateFromPicker.SelectedDate = null;
DateToPicker.SelectedDate = null;
CardID.Text = "Kod karty";
ServiceCard.Text = "Kod karty";
if (globalDatabasePath != null)
{
MainList.ItemsSource = DatabaseHandling.LoadAllByDate(globalDatabasePath);
}
}
private async void SelectFileButton(object sender, System.Windows.RoutedEventArgs e)
{
CommonOpenFileDialog dialogFileSelect = new CommonOpenFileDialog();
dialogFileSelect.InitialDirectory = Environment.GetFolderPath(Environment.SpecialFolder.Desktop);
dialogFileSelect.Filters.Add(new CommonFileDialogFilter("Arkusz programu Microsoft Excel (*.xlsx)", ".xlsx"));
if (dialogFileSelect.ShowDialog() == CommonFileDialogResult.Ok)
{
//Remove previous DB (if exists)
if (globalDatabasePath != null)
{
GC.Collect();
GC.WaitForPendingFinalizers();
File.Delete(globalDatabasePath);
}
globalDatabasePath = dialogFileSelect.FileName.Remove(dialogFileSelect.FileName.Length - 4, 4) + "sqlite";
//Get size and verify file
int rowNumber = DatabaseHandling.GetRowNumber(globalDatabasePath);
////////////////////////////////////////////////////////////////////////
// DEMO //
////////////////////////////////////////////////////////////////////////
//if (rowNumber > 50)
//{
// await this.ShowMessageAsync("DEMO", "Wersja demo obsługuje do 50 wierszy pliku wsadowego.");
// globalDatabasePath = null;
// return;
//}
////////////////////////////////////////////////////////////////////////
// DEMO //
////////////////////////////////////////////////////////////////////////
if (rowNumber == -1)
{
await this.ShowMessageAsync("Błąd pliku", "Załadowany plik jest niepoprawny");
globalDatabasePath = null;
return;
}
else if (rowNumber == -2)
{
await this.ShowMessageAsync("Plik w użyciu", "Wybrany plik jest otwarty. Zamknij go i spróbuj ponownie.");
globalDatabasePath = null;
return;
}
//Create DB
ProgressDialogController controller = await this.ShowProgressAsync("Ładowanie", "Dane są odczytywane");
controller.Maximum = (double)rowNumber;
controller.Minimum = 0;
IProgress <double> progress = new Progress <double>(value => controller.SetProgress(value));
progress.Report(0);
await Task.Run(() =>
{
DatabaseHandling.CreateTempDB(globalDatabasePath);
DatabaseHandling.FillDB(globalDatabasePath, progress);
});
await controller.CloseAsync();
//Fill list
MainList.ItemsSource = DatabaseHandling.LoadAllByDate(globalDatabasePath);
//Invalid file was loaded
if (MainList.Items.Count == 0)
{
await this.ShowMessageAsync("Błąd pliku", "Załadowany plik jest pusty lub niepoprawny.");
globalDatabasePath = null;
}
}
else
{
return;
}
}