private void Import_OnClick(object sender, RoutedEventArgs e)
{
var openFileDialog = new OpenFileDialog
{
Filter = "Файлы БД программы (USD.db)|USD.db|Все файлы БД (*.db)|*.db|Все файлы (*.*)|*.*"
};
if (openFileDialog.ShowDialog() == true)
{
using (var db = new LiteDatabase(DirectoryHelper.GetDataDirectory() + Settings.Default.LiteDbFileName))
{
using (var db1 = new LiteDatabase(openFileDialog.FileName))
{
if (!db1.CollectionExists("screenings"))
{
MessageBox.Show(
"Не подходящая база данных. Используйте базу данных, только от этой программы.", "УЗД",
MessageBoxButton.OK, MessageBoxImage.Error);
return;
}
var origCol = db.GetCollection("screenings");
var newCol = db1.GetCollection("screenings");
foreach (var source in newCol.FindAll().ToList())
{
source["Id"] = null;
origCol.Insert(source);
}
}
}
(DataContext as ListViewModel.ListViewModel)?.LoadData();
MessageBox.Show("Данные успешно импортированны", "УЗД", MessageBoxButton.OK, MessageBoxImage.Information);
}
}
public void DropCollection_Test()
{
using (var db = new LiteDatabase(DB.Path()))
{
Assert.IsFalse(db.CollectionExists("customerCollection"));
var collection = db.GetCollection<Customer>("customerCollection");
collection.Insert(new Customer());
Assert.IsTrue(db.CollectionExists("customerCollection"));
db.DropCollection("customerCollection");
Assert.IsFalse(db.CollectionExists("customerCollection"));
}
}
public Task ClearAsync()
{
using (var db = new LiteDB.LiteDatabase(dbPath))
if (db.CollectionExists(DataStoreCollectionName))
{
db.DropCollection(DataStoreCollectionName);
}
return(CompletedTask);
}
private static void DbMigration()
{
using (var db = new LiteDatabase(DirectoryHelper.GetDataDirectory() + Settings.Default.LiteDbFileName))
{
if (!db.CollectionExists("screenings")) return;
var col = db.GetCollection("screenings");
IEnumerable<BsonDocument> items = col.FindAll().ToList();
foreach (var item in items)
{
var isNeedUpdate = false;
var formations = item["FocalFormations"].AsArray;
foreach (var form in formations)
{
var size = form.AsDocument["Size"];
if (!size.IsString)
{
form.AsDocument.Set("Size", size.AsString);
isNeedUpdate = true;
}
if (size.IsNull)
{
form.AsDocument.Set("Size", string.Empty);
isNeedUpdate = true;
}
var cdk = form.AsDocument["CDK"];
if (cdk.AsString == "Avascular")
{
form.AsDocument.Set("CDK", "None");
isNeedUpdate = true;
}
}
var cysts = item["Cysts"].AsArray;
if (cysts != null)
{
foreach (var cyst in cysts)
{
var cdk = cyst.AsDocument["CDK"];
if (cdk.AsString == "Avascular")
{
cyst.AsDocument.Set("CDK", "None");
isNeedUpdate = true;
}
}
}
if (isNeedUpdate)
{
col.Update(item);
}
}
}
}
