private void OWLConfigurationForm_Load(object sender, EventArgs e) { BL.DatabaseMap databaseMap = new BL.DatabaseMap(); for (int i = 0; i < databaseMap.DatabaseMaps.Count; i++) { cmbMappings.Items.Add(databaseMap.DatabaseMaps[i].Attribute(XName.Get("name")).Value); } }
private void btnManualTransfer_Click(object sender, EventArgs e) { BL.DatabaseMap databaseMap = new BL.DatabaseMap(); for (int i = 0; i < databaseMap.DatabaseMaps.Count; i++) { BL.DataTransfer dtransfer = new BL.DataTransfer(); dtransfer.StartTransfer(databaseMap.DatabaseMaps[i]); } }
private void cmbExistingMap_SelectedIndexChanged(object sender, EventArgs e) { //cleare nodes treeListViewMap.Nodes.Clear(); //load selected definition to the map tree BL.DatabaseMap databaseMap = new BL.DatabaseMap(); XElement xElement = databaseMap.DatabaseMaps.Find(x => x.FirstAttribute.Value == XName.Get(cmbExistingMap.Text)); if (xElement != null) { loadTree(treeListViewMap, xElement); } }
public DatabaseMappingForm() { InitializeComponent(); this.treeListViewDatabase.Columns.Add(new CommonTools.TreeListColumn("name", "Name", 250)); this.treeListViewDatabase.Columns.Add(new CommonTools.TreeListColumn("type", "Type", 75)); this.treeListViewDatabase.Columns.Add(new CommonTools.TreeListColumn("size", "Size", 75)); this.treeListViewDatabase.Images = new ImageList(); this.treeListViewDatabase.Images.Images.AddStrip(Resources.DataTable); this.treeListViewDatabase.Images.Images.AddStrip(Resources.DataRow); this.treeListViewStagingDatabase.Columns.Add(new CommonTools.TreeListColumn("name", "Name", 250)); this.treeListViewStagingDatabase.Columns.Add(new CommonTools.TreeListColumn("type", "Type", 75)); this.treeListViewStagingDatabase.Columns.Add(new CommonTools.TreeListColumn("size", "Size", 75)); this.treeListViewStagingDatabase.Images = new ImageList(); this.treeListViewStagingDatabase.Images.Images.AddStrip(Resources.DataTable); this.treeListViewStagingDatabase.Images.Images.AddStrip(Resources.DataRow); this.treeListViewMap.Columns.Add(new CommonTools.TreeListColumn("nameFrom", "Name From", 250)); this.treeListViewMap.Columns.Add(new CommonTools.TreeListColumn("typeFrom", "Type From", 75)); this.treeListViewMap.Columns.Add(new CommonTools.TreeListColumn("nameTo", "Name To", 250)); this.treeListViewMap.Columns.Add(new CommonTools.TreeListColumn("typeTo", "Type To", 75)); this.treeListViewMap.Images = new ImageList(); this.treeListViewMap.Images.Images.AddStrip(Resources.rdf_icon); this.treeListViewMap.Images.Images.AddStrip(Resources.rdf_foldr); this.openFileDialog1.AddExtension = true; this.openFileDialog1.CheckFileExists = true; this.openFileDialog1.CheckPathExists = true; this.openFileDialog1.DefaultExt = "*.owl"; this.openFileDialog1.Multiselect = false; this.openFileDialog1.Title = "Select Resoruce Description File"; this.openFileDialog1.AddExtension = true; this.openFileDialog1.Filter = "Web Ontology Language (*.owl)|*.owl|All files (*.*)|*.*"; this.openFileDialog1.FileName = "Select a file ..."; this.openFileDialog1.ValidateNames = true; BL.DatabaseMap databaseMap = new BL.DatabaseMap(); for (int i = 0; i < databaseMap.DatabaseMaps.Count; i++) { cmbExistingMap.Items.Add(databaseMap.DatabaseMaps[i].Attribute(XName.Get("name")).Value); } }
private void cmbMappings_SelectedIndexChanged(object sender, EventArgs e) { BL.DatabaseMap databaseMap = new BL.DatabaseMap(); BL.ResourceDescription ResourceDesc = new BL.ResourceDescription(databaseMap.DatabaseMaps[cmbMappings.SelectedIndex]); txtRDFPath.Text = ResourceDesc.OWLResource.Path; }
private void btnGenerateMapFile_Click(object sender, EventArgs e) { bool isExistingMapSelected = false; if (cmbExistingMap.Text == String.Empty) { MessageBox.Show("Select map name from list or type name for new map..."); return; } if (!DatabaseMappingForm.isValid.HasValue) { MessageBox.Show("Mapping has not check for validation!, Please click Validate button to check", "Validation requires"); return; } if (!DatabaseMappingForm.isValid.Value) { MessageBox.Show("Mapping is not valid!, Please click Validate button to display invalid parts", "is not Valid"); return; } if (cmbExistingMap.SelectedIndex != -1) { if (MessageBox.Show("Existing map will destroy,are you sure?", "Existing Map Confirmation", MessageBoxButtons.YesNo) == System.Windows.Forms.DialogResult.No) { return; } isExistingMapSelected = true; } BL.DatabaseMap databaseMap = new BL.DatabaseMap(); if (isExistingMapSelected) { //delete map from DatabaseMap.xml XElement _deleteElement = databaseMap.DatabaseMaps.Find(x => x.Attribute(XName.Get("name")).Value.Contains(cmbExistingMap.Text)); databaseMap.DatabaseMaps.Remove(_deleteElement); databaseMap.Save(); } //insert DatabaseMap object XElement _newElement = new XElement("DatabaseMap", new XAttribute("name", cmbExistingMap.Text)); //Source _newElement.Add(new XElement("Database", new XAttribute("type", "source"), new XAttribute("connectionString", txtSourceConnectionString.Text))); //Staging _newElement.Add(new XElement("Database", new XAttribute("type", "staging"), new XAttribute("connectionString", txtStagingDatabaseConnectionString.Text))); //OWL File Path _newElement.Add(new XElement("OWL", new XAttribute("type", "file"), new XAttribute("path", txtOWLFilePath.Text))); //Tables foreach (Node table in treeListViewMap.Nodes) { XElement _newTableElement = new XElement("Table", new XAttribute("name", table[0])); foreach (Node map in table.Nodes) { _newTableElement.Add(new XElement("Map", new XAttribute("from", map[0]), new XAttribute("fromtype", map[1]), new XAttribute("to", map[2]), new XAttribute("totype", map[3]))); } _newElement.Add(_newTableElement); } databaseMap.DatabaseMaps.Add(_newElement); databaseMap.Save(); BL.OWLConfiguration owlConfiguration = new BL.OWLConfiguration(); //insert OWLConfiguration object _newElement = new XElement("OWLConfiguration"); //Staging _newElement.Add(new XElement("Database", new XAttribute("type", "staging"), new XAttribute("connectionString", txtStagingDatabaseConnectionString.Text))); //OWL Item _newElement.Add(new XElement("OWLItem", new XAttribute("type", "Accurate"), new XAttribute("low", "-1"), new XAttribute("medium", "-1"), new XAttribute("high", "-1"), new XAttribute("businessrequired", "-1"), new XAttribute("businessrecommend", "-1"), new XAttribute("noconstraint", "-1"))); owlConfiguration.OWLConfigurations.RemoveRange(0, owlConfiguration.OWLConfigurations.Count); owlConfiguration.OWLConfigurations.Add(_newElement); owlConfiguration.Save(); MessageBox.Show(cmbExistingMap.Text + " is generated."); }