private void AutoFillFields() { Mapping_rep x = (Mapping_rep)mapsBindingSource.Current; //IDataSource ds = DMEEditor.GetDataSource(x.Entity2DataSource); List <DefaultValue> defaults = DMEEditor.ConfigEditor.DataConnections[DMEEditor.ConfigEditor.DataConnections.FindIndex(i => i.ConnectionName == x.Entity2DataSource)].DatasourceDefaults; fldMappingBindingSource.Clear(); foreach (EntityField s in x.Entity2Fields.OrderBy(p => p.FieldIndex)) { fldMappingBindingSource.AddNew(); Mapping_rep_fields T = T = (Mapping_rep_fields)fldMappingBindingSource.Current; if (FieldExist(s.fieldname, x.Entity1Fields)) { T.FieldName1 = s.fieldname; T.FieldName2 = s.fieldname; T.FieldType1 = s.fieldtype; T.FieldType2 = s.fieldtype; } else { T.FieldName2 = s.fieldname; T.FieldType2 = s.fieldtype; } if (defaults != null) { if (defaults.Any(u => u.propertyName.ToLower() == s.fieldname.ToLower() && u.propertyType != DefaultValueType.DisplayLookup)) { string df = defaults.Where(u => u.propertyName.ToLower() == s.fieldname.ToLower() && u.propertyType != DefaultValueType.DisplayLookup).FirstOrDefault().propertyName; T.Rules = $":Default.{df}"; } } } }
private void EntityName1ComboBox_SelectedValueChanged(object sender, EventArgs e) { if (mapsBindingSource.Count > 0) { Mapping_rep x = (Mapping_rep)mapsBindingSource.Current; if (!string.IsNullOrEmpty(x.EntityName1)) { if (ds1 != null) { if (ds1.Entities.Count == 0 || !ds1.Entities.Any(i => i.EntityName == x.EntityName1)) { x.Entity1Fields = ds1.GetEntityStructure(x.EntityName1, false).Fields; DMEEditor.ConfigEditor.SaveDataSourceEntitiesValues(new DatasourceEntities { datasourcename = ds1.DatasourceName, Entities = ds1.Entities }); } else { x.Entity1Fields = ds1.Entities.Where(i => i.EntityName == x.EntityName1).FirstOrDefault().Fields; } } fieldName1ComboBox.Items.Clear(); foreach (EntityField s in x.Entity1Fields) { fieldName1ComboBox.Items.Add(s.fieldname); } } } }
private void CreateDataSources() { Mapping_rep x = (Mapping_rep)mappingsBindingSource.Current; ds1 = DMEEditor.GetDataSource(x.Entity1DataSource); ds2 = DMEEditor.GetDataSource(x.Entity2DataSource); }
private void FldMappingBindingSource_AddingNew(object sender, AddingNewEventArgs e) { Mapping_rep_fields x = new Mapping_rep_fields(); Mapping_rep y = (Mapping_rep)mappingsBindingSource.Current; x.EntityName1 = y.EntityName1; x.EntityName2 = y.EntityName2; e.NewObject = x; }
private void SyncMappingbutton_Click(object sender, EventArgs e) { if (mappingsBindingSource.Count > 0) { Mapping_rep x = (Mapping_rep)mappingsBindingSource.Current; if (x.EntityName1 != null && x.EntityName2 != null && x.Entity1DataSource != null && x.Entity2DataSource != null) { SyncFields(); } } }
private void CreateMappingbutton_Click(object sender, EventArgs e) { if (mappingsBindingSource.Count > 0) { Mapping_rep x = (Mapping_rep)mappingsBindingSource.Current; if (x.EntityName1 != null && x.EntityName2 != null && x.Entity1DataSource != null && x.Entity2DataSource != null) { GetFieldTypes(); CreateFieldMappingCombo(); } } }
private void GetFieldTypes() { if (mappingsBindingSource.Count > 0) { Mapping_rep x = (Mapping_rep)mappingsBindingSource.Current; if (ds1 != null) { x.Entity1Fields = ds1.GetEntityStructure(x.EntityName1, false).Fields; } if (ds2 != null) { x.Entity2Fields = ds2.GetEntityStructure(x.EntityName2, false).Fields; } } DMEEditor.ConfigEditor.SaveDataconnectionsValues(); }
private void CreateFieldMappingCombo() { FieldName1Comobobox.Items.Clear(); FieldName2Comobobox.Items.Clear(); if (mappingsBindingSource.Count > 0) { Mapping_rep x = (Mapping_rep)mappingsBindingSource.Current; foreach (EntityField s in x.Entity1Fields) { FieldName1Comobobox.Items.Add(s.fieldname); } foreach (EntityField s in x.Entity2Fields) { FieldName2Comobobox.Items.Add(s.fieldname); } } }
private void AutoFillDestDatasource() { if (this.mapsBindingSource.Count > 0) { if (this.DestDatasourelistBox.SelectedItem != null) { ConnectionProperties o = (ConnectionProperties)DestDatasourelistBox.SelectedItem; mapsBindingSource.MoveFirst(); for (int i = 0; i < mapsBindingSource.Count; i++) { Mapping_rep m = (Mapping_rep)mapsBindingSource.Current; m.Entity2DataSource = o.ConnectionName; mapsBindingSource.MoveNext(); } } } }
private void SyncFields() { fldMappingBindingSource.Clear(); Mapping_rep x = (Mapping_rep)mappingsBindingSource.Current; foreach (EntityField s in x.Entity1Fields) { if (FieldExist(s.fieldname, x.Entity2Fields)) { fldMappingBindingSource.AddNew(); Mapping_rep_fields T = (Mapping_rep_fields)fldMappingBindingSource.Current; T.FieldName1 = s.fieldname; T.FieldName2 = s.fieldname; T.FieldType1 = s.fieldtype; T.FieldType2 = s.fieldtype; } } }
private void FillData() { Mapping_rep m = (Mapping_rep)mapsBindingSource.Current; if (m != null) { if (this.fldMappingBindingSource.Count > 0) { if (MessageBox.Show("Would you like to overwrite the existing mapping", "Mapping", MessageBoxButtons.OKCancel) == DialogResult.OK) { AutoFillFields(); } } else { AutoFillFields(); } } }
private void Savebutton_Click(object sender, EventArgs e) { try { mappingsBindingSource.EndEdit(); Mapping_rep x = (Mapping_rep)mappingsBindingSource.Current; if (x.MappingName != null && x.EntityName1 != null && x.EntityName2 != null && x.Entity1DataSource != null && x.Entity2DataSource != null) { CleanMapping(); // DMEEditor.ConfigEditor.Mappings = DMEEditor.WorkFlowEditor.Mappings; DMEEditor.ConfigEditor.SaveMappingValues(); } else { MessageBox.Show("Please Complete all data fields before save"); } } catch (Exception ex) { ErrorObject.Flag = Errors.Failed; ErrorObject.Ex = ex; Logger.WriteLog($"Error in getting File Data ({ex.Message}) "); } }
private void MappingsBindingSource_AddingNew(object sender, AddingNewEventArgs e) { Mapping_rep x = new Mapping_rep(); e.NewObject = x; }
private void MappingsDataGridView_DragDrop(object sender, DragEventArgs e) { Mapping_rep x = null; DataGridViewRow dragRow = null; if (e.Data.GetData("System.String").ToString() == "SOURCE") { if (SrcDataSourcelistBox1.SelectedItems.Count > 1) { foreach (string item in SrcDataSourcelistBox1.SelectedItems) { x = new Mapping_rep(); x.Entity1DataSource = item; x.MappingName = $"From_{item}"; this.mapsBindingSource.Add(x); } } else { if (SrcDataSourcelistBox1.SelectedItems.Count == 1) { if (this.mapsBindingSource.Count == 0) { this.mapsBindingSource.AddNew(); } string o = (string)SrcDataSourcelistBox1.SelectedItem; x = (Mapping_rep)this.mapsBindingSource.Current; x.Entity1DataSource = o; x.MappingName = $"From_{ o}"; } } } else { if (DestDatasourelistBox.SelectedItems.Count == 1) { if (this.mapsBindingSource.Count == 0) { this.mapsBindingSource.AddNew(); } Point p = mappingsDataGridView.PointToClient(new Point(e.X, e.Y)); int dragIndex = mappingsDataGridView.HitTest(p.X, p.Y).RowIndex; // Determine if dragindex is valid row index if (dragIndex > -1) { dragRow = (DataGridViewRow)mappingsDataGridView.Rows[dragIndex]; } else { } // Do any message here if selected in column header and blank space. string o = (string)DestDatasourelistBox.SelectedItem; x = (Mapping_rep)dragRow.DataBoundItem; x.Entity2DataSource = o; x.MappingName = x.MappingName + $"_TO_{ o}"; } } this.mappingsDataGridView.Refresh(); }