/// <summary>
/// Imports the database from SQL script
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void Btn_import_Click(object sender, RoutedEventArgs e)
{
var msgtext = "You are about to import into to the database. Are you sure?";
var txt = "Import Database";
var button = MessageBoxButton.YesNo;
var msgresult = MessageBox.Show(msgtext, txt, button);
switch (msgresult)
{
case MessageBoxResult.Yes:
var dlg = new OpenFileDialog
{
FileName = "database", // Default file name
DefaultExt = ".sql", // Default file extension
Filter = "All Files (*.*)|*.*" // Filter files by extension
};
var result = dlg.ShowDialog();
if (result == true)
{
txtBlock_importPath.Text = dlg.FileName;
if (DatabaseViewModel.importDatabase(dlg.FileName))
{
MessageBox.Show("Database successfully imported");
}
else
{
MessageBox.Show("Database failed to import file : " + dlg.FileName);
}
}
break;
case MessageBoxResult.No:
break;
}
}
