/// <summary> /// Open a CSV file with serial numbers and MAC address, read it and create new entries in the database. /// </summary> /// <param name="sender">Ignored.</param> /// <param name="e">Ignored.</param> void mainWindow_SendToDatabase(object sender, RoutedEventArgs e) { const string tag = ClassName + ".LoadTrackersFromFile:"; string filename = ViewModel.FileSelectionViewModel.FileSelectionModel.Filename; Trace.TraceInformation(tag + string.Format("filename={0}", filename)); string message = string.Format( Local.Resources.LoadToDatabaseConfirmation, filename); MessageBoxResult confirmation = MessageBox.Show( message, Local.Resources.LoadToDatabaseConfirmationCaption, MessageBoxButton.OKCancel, MessageBoxImage.Question); if (confirmation == MessageBoxResult.Cancel) { Trace.TraceInformation(tag + "Cancelled by the user."); return; } try { var reader = new StreamReader(filename); DateTime batchDateTime = File.GetCreationTime(filename); Gateway.GatewayEntities gatewayEntities = GetGatewayEntities(); TrackerLoader.LoadTrackers(reader, gatewayEntities, batchDateTime); reader.Close(); } catch (FileNotFoundException) { Trace.TraceError(tag + "File not found."); } catch (ArgumentException) { Trace.TraceError(tag + "Empty filename."); } Trace.TraceInformation(tag + ExitText); }
/// <summary> /// Load a file, adding entries to the job list for possible printing later. /// </summary> /// <param name="sender">Ignored.</param> /// <param name="e">Ignored.</param> void mainWindow_LoadFile(object sender, RoutedEventArgs e) { string filename = ViewModel.FileSelectionViewModel.FileSelectionModel.Filename; List <Job> jobList = TrackerLoader.LoadTrackersFromFileToList(filename); if (jobList != null) { if (jobList.Count < 1) { MessageBox.Show( Local.Resources.NoRecordsFoundInFile, Local.Resources.ImportError, MessageBoxButton.OK, MessageBoxImage.Exclamation); } else { foreach (Job j in jobList) { ViewModel.JobListViewModel.JobList.Add(j); } } } }