public override void Execute(object parameter)
{
SaveFileDialog sfd = new SaveFileDialog();
sfd.Filter = "Database file (*.db3) |*.db3";
if (sfd.ShowDialog() == true)
{
SqliteDataProvider dataProvider = new SqliteDataProvider();
dataProvider.Open(sfd.FileName);
// string sql = "CREATE TABLE Fossils (id INTEGER PRIMARY KEY AUTOINCREMENT, fossilname TEXT, Descrip TEXT, area REAL, circularity REAL, elongation REAL, perimeter REAL, irregularity REAL , bitmap BLOB)";
string sql = "CREATE TABLE Authors (Author_id INTEGER PRIMARY KEY AUTOINCREMENT, Author_name TEXT)";
dataProvider.ExecuteNonQuery(sql);
string sql1 = "CREATE TABLE Description (Description_id INTEGER PRIMARY KEY AUTOINCREMENT, synonymy TEXT, shell TEXT, init_shell TEXT, crop TEXT, key_edge TEXT, front_end TEXT, rear_end TEXT, ventral_margin TEXT, growth_lines TEXT, sculpture TEXT, compare TEXT)";
dataProvider.ExecuteNonQuery(sql1);
string sql2 = "CREATE TABLE Genus (genus_id INTEGER PRIMARY KEY AUTOINCREMENT, genus_name TEXT)";
dataProvider.ExecuteNonQuery(sql2);
string sql3 = "CREATE TABLE GenusToAuthor (genus_id INTEGER, author_id INTEGER)";
dataProvider.ExecuteNonQuery(sql3);
string sql4 = "CREATE TABLE Parameters (parameters_id INTEGER PRIMARY KEY AUTOINCREMENT, init_shell TEXT, front_rear_end TEXT, age TEXT, length TEXT, sculpture TEXT, h_l REAL)";
dataProvider.ExecuteNonQuery(sql4);
string sql5 = "CREATE TABLE Photo (id INTEGER PRIMARY KEY AUTOINCREMENT, square REAL, vertex_x REAL, vertex_y REAL, furrow REAL, bitmap BLOB)";
dataProvider.ExecuteNonQuery(sql5);
string sql6 = "CREATE TABLE Species (species_id INTEGER PRIMARY KEY AUTOINCREMENT,species_name TEXT, genus_id INTEGER, description_id INTEGER)";
dataProvider.ExecuteNonQuery(sql6);
string sql7 = "CREATE TABLE SpeciesToAuthor (species_id INTEGER, author_id INTEGER)";
dataProvider.ExecuteNonQuery(sql7);
string sql8 = "CREATE TABLE Mollusk (mollusk_id INTEGER PRIMARY KEY AUTOINCREMENT, species_id INTEGER, photo_id INTEGER, parameters_id INTEGER)";
dataProvider.ExecuteNonQuery(sql8);
UIManager.man.Provider = dataProvider;
}
}
public override void Execute(object parameter)
{
OpenFileDialog sfd = new OpenFileDialog();
// sfd.Filter = "Database file (*.db3) |*.db3";
if (sfd.ShowDialog() == true)
{
SqliteDataProvider dataProvider = new SqliteDataProvider();
dataProvider.Open(sfd.FileName);
UIManager.man.Provider = dataProvider;
//Здесь изменить запрос
//string sql = string.Format("SELECT Species.Species_name, Genus.Genus_name, Photo.bitmap, d.synonymy, d.shell, d.init_shell, d.crop, d.key_edge, d.front_end, d.rear_end, d.ventral_margin, d.growth_lines, d.sculpture, d.compare FROM Species, Genus, Photo, Description d, Mollusk, Parameters p WHERE Mollusk.species_id=Species.species_id AND Species.genus_id=Genus.genus_id AND Mollusk.photo_id=Photo.id AND Species.description_id=d.description_id AND Mollusk.parameters_id=p.parameters_id AND p.init_shell='{0}' AND p.front_rear_end='{1}' AND p.age='{2}' AND p.length='{3}' AND p.sculpture='{4}' AND p.h_l='{5}'",
// MainWindow.itis.init_shell.Text,
// MainWindow.itis.front_rear_end.Text,
// MainWindow.itis.age.Text,
// MainWindow.itis.length.Text,
// MainWindow.itis.length.Text,
// MainWindow.itis.h_l.Text);
string sql = "SELECT Photo.id, Species.Species_name, Genus.Genus_name, Photo.bitmap, d.synonymy, d.shell, d.init_shell, d.crop, d.key_edge, d.front_end, d.rear_end, d.ventral_margin, d.growth_lines, d.sculpture, d.compare FROM Mollusk LEFT OUTER JOIN Species ON Mollusk.species_id=Species.species_id LEFT OUTER JOIN Genus ON Species.genus_id=Genus.genus_id LEFT OUTER JOIN Photo ON Mollusk.photo_id=Photo.id LEFT OUTER JOIN Description d ON Species.description_id=d.description_id";
DataTable data = dataProvider.ExecuteQuery(sql);
UIManager.man.GetDataGrid().ItemsSource = data.DefaultView;
}
}
