private void miDBExport_Click(object sender, RoutedEventArgs e) { if (DataBaseFactory.Instance.IsAvailable) { Microsoft.Win32.SaveFileDialog dlg = new Microsoft.Win32.SaveFileDialog(); dlg.FileName = "InternetUsage"; // Default file name dlg.DefaultExt = ".export"; // Default file extension dlg.Filter = "Internet Usage (.export)|*.export"; // Filter files by extension // Show save file dialog box Nullable <bool> result = dlg.ShowDialog(); // Process save file dialog box results if (result == true) { Exception exportException; DailyUsageDAOFactory export = new DailyUsageDAOFactory(); int count; if (export.Export(dlg.FileName, out exportException, out count)) { MessageBox.Show(String.Format(CIV.strings.Dashboard_DB_ExportEnd, count)); } else { LogEngine.Instance.Add(exportException); MessageBox.Show(String.Format("{0}\r\n\r\n{1}", exportException.GetType(), exportException.Message), "CIV", MessageBoxButton.OK, MessageBoxImage.Error); } } } }
private void miDBImport_Click(object sender, RoutedEventArgs e) { if (DataBaseFactory.Instance.IsAvailable) { Microsoft.Win32.OpenFileDialog dlg = new Microsoft.Win32.OpenFileDialog(); dlg.FileName = "InternetUsage"; // Default file name dlg.DefaultExt = ".export"; // Default file extension dlg.Filter = "Internet Usage (.export)|*.export"; // Filter files by extension // Show open file dialog box Nullable<bool> result = dlg.ShowDialog(); // Process open file dialog box results if (result == true) { Exception importException; DailyUsageDAOFactory import = new DailyUsageDAOFactory(); int count; int total; if (import.Import(dlg.FileName, out importException, out count, out total)) MessageBox.Show(String.Format(CIV.strings.Dashboard_DB_ImportEnd, count, total)); else { LogEngine.Instance.Add(importException); MessageBox.Show(String.Format("{0}\r\n\r\n{1}", importException.GetType(), importException.Message), "CIV", MessageBoxButton.OK, MessageBoxImage.Error); } } } }