public void CreateDatabase(string path)
{
//The file that was just created does not have a schema, so SQLite won't touch it.
//The file must have a schema or not exist for use with SQLite, so we'll delete
//it and install a schema
try
{
FileEx.SafeDelete(path);
}
catch (IOException x)
{
MessageDlg.ShowException(this, x);
return;
}
//Create file, initialize db
try
{
OptimizationDb.CreateOptimizationDb(path);
textDatabase.Text = path;
}
catch (Exception x)
{
var message = TextUtil.LineSeparate(string.Format(Resources.EditOptimizationLibraryDlg_CreateDatabase_The_file__0__could_not_be_created_, path),
x.Message);
MessageDlg.ShowWithException(this, message, x);
}
}
public void OpenDatabase(string path)
{
if (!File.Exists(path))
{
MessageDlg.Show(this, String.Format(Resources.EditOptimizationLibraryDlg_OpenDatabase_The_file__0__does_not_exist__Click_the_Create_button_to_create_a_new_library_or_the_Open_button_to_find_the_missing_file_,
path));
return;
}
try
{
OptimizationDb db = OptimizationDb.GetOptimizationDb(path, null, _document);
var dbOptimizations = db.GetOptimizations().ToArray();
SetOptimizations(dbOptimizations);
// Clone all of the optimizations to use for comparison in OkDialog
_original = dbOptimizations.Select(p => new DbOptimization(p)).ToArray();
textDatabase.Text = path;
}
catch (OptimizationsOpeningException e)
{
MessageDlg.ShowException(this, e);
}
}
private void AddOptimizationLibrary(OptimizationLibrary optLibrary, SrmDocument document)
{
IEnumerable <DbOptimization> optimizations = null;
using (var longWait = new LongWaitDlg
{
Text = Resources.LibraryGridViewDriver_AddOptimizationLibrary_Adding_optimization_library,
Message = string.Format(Resources.LibraryGridViewDriver_AddOptimizationLibrary_Adding_optimization_values_from__0_, optLibrary.DatabasePath),
FormBorderStyle = FormBorderStyle.Sizable
})
{
try
{
var status = longWait.PerformWork(MessageParent, 800, monitor =>
{
var optDb = OptimizationDb.GetOptimizationDb(optLibrary.DatabasePath, monitor, document);
if (optDb != null)
{
optimizations = optDb.GetOptimizations().Where(opt => Equals(opt.Type, (int)ViewDbType));
}
});
if (status.IsError)
{
MessageDlg.ShowException(MessageParent, status.ErrorException);
}
}
catch (Exception x)
{
var message = TextUtil.LineSeparate(string.Format(Resources.LibraryGridViewDriver_AddOptimizationLibrary_An_error_occurred_attempting_to_load_the_optimization_library_file__0__,
optLibrary.DatabasePath),
x.Message);
MessageDlg.ShowWithException(MessageParent, message, x);
}
}
AddToLibrary(optimizations);
}
public void OkDialog()
{
if (string.IsNullOrEmpty(textName.Text))
{
MessageDlg.Show(this, Resources.EditOptimizationLibraryDlg_OkDialog_Please_enter_a_name_for_the_optimization_library_);
textName.Focus();
return;
}
if (_existing != null)
{
foreach (var existing in _existing)
{
if (Equals(existing.Name, textName.Text) && !Equals(existing.Name, _editingName))
{
if (MessageBox.Show(this, string.Format(Resources.EditOptimizationLibraryDlg_OkDialog_A_library_with_the_name__0__already_exists__Do_you_want_to_overwrite_it_,
textName.Text),
Program.Name, MessageBoxButtons.YesNo) != DialogResult.Yes)
{
textName.Focus();
return;
}
}
}
}
string message;
if (string.IsNullOrEmpty(textDatabase.Text))
{
message = TextUtil.LineSeparate(Resources.EditOptimizationLibraryDlg_OkDialog_Please_choose_a_library_file_for_the_optimization_library_,
Resources.EditOptimizationLibraryDlg_OkDialog_Click_the_Create_button_to_create_a_new_library_or_the_Open_button_to_open_an_existing_library_file_);
MessageDlg.Show(this, message);
textDatabase.Focus();
return;
}
string path = Path.GetFullPath(textDatabase.Text);
if (!Equals(path, textDatabase.Text))
{
message = TextUtil.LineSeparate(Resources.EditOptimizationLibraryDlg_OkDialog_Please_use_a_full_path_to_a_library_file_for_the_optimization_library_,
Resources.EditOptimizationLibraryDlg_OkDialog_Click_the_Create_button_to_create_a_new_library_or_the_Open_button_to_open_an_existing_library_file_);
MessageDlg.Show(this, message);
textDatabase.Focus();
return;
}
if (!string.Equals(Path.GetExtension(path), OptimizationDb.EXT))
{
path += OptimizationDb.EXT;
}
if (!ValidateOptimizationList(LibraryOptimizations, Resources.EditOptimizationLibraryDlg_OkDialog_library))
{
gridViewLibrary.Focus();
return;
}
try
{
var library = new OptimizationLibrary(textName.Text, path);
OptimizationDb db = File.Exists(path)
? OptimizationDb.GetOptimizationDb(path, null, _document)
: OptimizationDb.CreateOptimizationDb(path);
db = db.UpdateOptimizations(LibraryOptimizations.ToArray(), _original ?? new DbOptimization[0]);
Library = library.ChangeDatabase(db);
}
catch (OptimizationsOpeningException x)
{
MessageDlg.ShowException(this, x);
textDatabase.Focus();
return;
}
catch (StaleStateException)
{
// CONSIDER: Not sure if this is the right thing to do. It would
// be nice to solve whatever is causing this, but this is
// better than showing an unexpected error form with stack trace.
MessageDlg.Show(this, Resources.EditOptimizationLibraryDlg_OkDialog_Failure_updating_optimizations_in_the_optimization_library__The_database_may_be_out_of_synch_);
return;
}
DialogResult = DialogResult.OK;
}
