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