public FillDB(DbToXml dbToXml, string login, string password) { Login = login; Password = password; connection = new OracleConnection { ConnectionString = "User Id=" + login.ToLower() + ";Password="******"; Data Source = (DESCRIPTION = " + " (ADDRESS = (PROTOCOL = TCP)(HOST = 217.173.198.135)(PORT = 1522 ))" + " (CONNECT_DATA =" + " (SERVER = DEDICATED)" + " (SERVICE_NAME = orcltp.iaii.local)" + ")" + ");" }; sequence = SequenceValidator.setOrder(dbToXml.tables, dbToXml.foreignKeys); try { connection.Open(); DeleteDb(dbToXml.tables); CreateTables(dbToXml.tables); CreatePrimaryKeys(dbToXml.primaryKeys); CreateForeignKeys(dbToXml.foreignKeys); InsertData(dbToXml.tables, dbToXml.dataFromTables); connection.Close(); } catch { throw new System.ArgumentException("Bad loginor password"); } }
private async void ExportXmlToDB_Click(object sender, RoutedEventArgs e) { string filename = ""; Microsoft.Win32.OpenFileDialog dlg = new Microsoft.Win32.OpenFileDialog(); dlg.DefaultExt = ".xml"; dlg.Filter = "Xml Files (*.xml)|*.xml|JSON Files (*.json)|*.json"; bool correctFile = true; Nullable <bool> result = dlg.ShowDialog(); if (result == true) { var extension = System.IO.Path.GetExtension(dlg.FileName); switch (extension.ToLower()) { case ".xml": filename = dlg.FileName; try { t = DeserializeObject(filename); } catch { correctFile = false; } break; case ".json": using (FileStream fs = File.OpenRead(dlg.FileName)) { t = await JsonSerializer.DeserializeAsync <DbToXml>(fs); } break; } if (correctFile && t.dataFromTables != null && t.foreignKeys != null && t.primaryKeys != null && t.tables != null) { login = Login.Text; password = Passowrd.Password; Login.IsEnabled = false; Passowrd.IsEnabled = false; CreateXml.IsEnabled = false; ExportXmlToDB.IsEnabled = false; Comunicate.Content = "Trwa odtwarzenie bazy z pliku xml..."; try { await Task.Run(() => Upload()); MessageBox.Show("Pomyślnie dodano", "Succes"); } catch { MessageBox.Show("zły login lub hasło", "Error"); } Comunicate.Content = ""; Login.IsEnabled = true; Passowrd.IsEnabled = true; CreateXml.IsEnabled = true; ExportXmlToDB.IsEnabled = true; } else { MessageBox.Show("Niewłaściwy plik", "error"); } } }