public override bool Back() { foreach (DataGridViewRow row in gridMappings.Rows) { string associatedColumnAlias = row.Cells[1].Value == null ? "" : row.Cells[1].Value.ToString(); string associatedParameterAlias = row.Cells[2].Value == null ? "" : row.Cells[2].Value.ToString(); if (associatedColumnAlias.IndexOf("(") > 0) { associatedColumnAlias = associatedColumnAlias.Substring(0, associatedColumnAlias.IndexOf("(")).Trim(); } if (associatedParameterAlias.IndexOf("(") > 0) { associatedParameterAlias = associatedParameterAlias.Substring(0, associatedParameterAlias.IndexOf("(")).Trim(); } associatedParameterAlias = associatedParameterAlias.Replace("@", ""); Model.Column primaryColumn = (Model.Column)row.Tag; Model.Association.Mapping mapping = frmAssociationWizard.Association.FindMappingByPrimaryColumn(primaryColumn); if (mapping != null) { mapping.AssociatedColumn = FindAssociatedColumn(associatedColumnAlias); } else { Model.Association.Mapping newMapping = new Model.Association.Mapping(primaryColumn, FindAssociatedColumn(associatedColumnAlias), FindAssociatedParameter(associatedParameterAlias)); frmAssociationWizard.Association.Mappings.Add(newMapping); } } return(true); }
public override bool Save() { frmAssociationWizard.Association.Mappings.Clear(); frmAssociationWizard.Association.Enabled = true; foreach (DataGridViewRow row in gridMappings.Rows) { string primaryColumnName = row.Cells[0].Value == null ? "" : row.Cells[0].Value.ToString(); string associatedColumnName = row.Cells[1].Value == null ? "" : row.Cells[1].Value.ToString(); string associatedParameterName = row.Cells[2].Value == null ? "" : row.Cells[2].Value.ToString(); primaryColumnName = primaryColumnName.Substring(0, primaryColumnName.IndexOf("(")).Trim(); if (!string.IsNullOrEmpty(associatedColumnName)) { associatedColumnName = associatedColumnName.Substring(0, associatedColumnName.IndexOf("(")).Trim(); } if (!string.IsNullOrEmpty(associatedParameterName)) { associatedParameterName = associatedParameterName.Substring(1, associatedParameterName.IndexOf("(") - 1).Trim(); } Model.Column primaryColumn = null; Model.Column associatedColumn = null; Model.StoredProcedure.Parameter associatedParameter = null; foreach (Model.Column column in frmAssociationWizard.Association.PrimaryObject.Columns) { if (Slyce.Common.Utility.StringsAreEqual(column.Alias, primaryColumnName, false)) { primaryColumn = column; break; } } foreach (Model.Column column in frmAssociationWizard.Association.AssociatedObject.Columns) { if (Slyce.Common.Utility.StringsAreEqual(column.Alias, associatedColumnName, false)) { associatedColumn = column; break; } } if (typeof(Model.StoredProcedure).IsInstanceOfType(frmAssociationWizard.Association.AssociatedObject)) { foreach (Model.StoredProcedure.Parameter parameter in ((Model.StoredProcedure)frmAssociationWizard.Association.AssociatedObject).Parameters) { if (Slyce.Common.Utility.StringsAreEqual(parameter.Alias, associatedParameterName, false)) { associatedParameter = parameter; break; } } } Model.Association.Mapping mapping = new Model.Association.Mapping(primaryColumn, associatedColumn, associatedParameter); frmAssociationWizard.Association.Mappings.Add(mapping); } return(true); }
private void AddTreelistNode(Model.Column column) { Model.Association.Mapping mapping = frmAssociationWizard.Association.FindMappingByPrimaryColumn(column); string associatedColumnName = ""; if (mapping != null && mapping.AssociatedColumn != null && mapping.AssociatedColumn.Parent == frmAssociationWizard.Association.AssociatedObject) { associatedColumnName = string.Format("{0} ({1})", mapping.AssociatedColumn.Alias, mapping.AssociatedColumn.DataType); } int newIndex = gridMappings.Rows.Add(new object[] { string.Format("{0} ({1})", column.Alias, column.DataType), associatedColumnName }); gridMappings.Rows[newIndex].Tag = column; }
public override bool Back() { foreach (DataGridViewRow row in gridMappings.Rows) { string associatedColumnAlias = row.Cells[1].Value == null ? "" : row.Cells[1].Value.ToString(); string associatedParameterAlias = row.Cells[2].Value == null ? "" : row.Cells[2].Value.ToString(); if (associatedColumnAlias.IndexOf("(") > 0) { associatedColumnAlias = associatedColumnAlias.Substring(0, associatedColumnAlias.IndexOf("(")).Trim(); } if (associatedParameterAlias.IndexOf("(") > 0) { associatedParameterAlias = associatedParameterAlias.Substring(0, associatedParameterAlias.IndexOf("(")).Trim(); } associatedParameterAlias = associatedParameterAlias.Replace("@", ""); Model.Column primaryColumn = (Model.Column)row.Tag; Model.Association.Mapping mapping = frmAssociationWizard.Association.FindMappingByPrimaryColumn(primaryColumn); if (mapping != null) { mapping.AssociatedColumn = FindAssociatedColumn(associatedColumnAlias); } else { Model.Association.Mapping newMapping = new Model.Association.Mapping(primaryColumn, FindAssociatedColumn(associatedColumnAlias), FindAssociatedParameter(associatedParameterAlias)); frmAssociationWizard.Association.Mappings.Add(newMapping); } } return true; }
public override bool Save() { frmAssociationWizard.Association.Mappings.Clear(); frmAssociationWizard.Association.Enabled = true; foreach (DataGridViewRow row in gridMappings.Rows) { string primaryColumnName = row.Cells[0].Value == null ? "" : row.Cells[0].Value.ToString(); string associatedColumnName = row.Cells[1].Value == null ? "" : row.Cells[1].Value.ToString(); string associatedParameterName = row.Cells[2].Value == null ? "" : row.Cells[2].Value.ToString(); primaryColumnName = primaryColumnName.Substring(0, primaryColumnName.IndexOf("(")).Trim(); if (!string.IsNullOrEmpty(associatedColumnName)) { associatedColumnName = associatedColumnName.Substring(0, associatedColumnName.IndexOf("(")).Trim(); } if (!string.IsNullOrEmpty(associatedParameterName)) { associatedParameterName = associatedParameterName.Substring(1, associatedParameterName.IndexOf("(") - 1).Trim(); } Model.Column primaryColumn = null; Model.Column associatedColumn = null; Model.StoredProcedure.Parameter associatedParameter = null; foreach (Model.Column column in frmAssociationWizard.Association.PrimaryObject.Columns) { if (Slyce.Common.Utility.StringsAreEqual(column.Alias, primaryColumnName, false)) { primaryColumn = column; break; } } foreach (Model.Column column in frmAssociationWizard.Association.AssociatedObject.Columns) { if (Slyce.Common.Utility.StringsAreEqual(column.Alias, associatedColumnName, false)) { associatedColumn = column; break; } } if (typeof(Model.StoredProcedure).IsInstanceOfType(frmAssociationWizard.Association.AssociatedObject)) { foreach (Model.StoredProcedure.Parameter parameter in ((Model.StoredProcedure)frmAssociationWizard.Association.AssociatedObject).Parameters) { if (Slyce.Common.Utility.StringsAreEqual(parameter.Alias, associatedParameterName, false)) { associatedParameter = parameter; break; } } } Model.Association.Mapping mapping = new Model.Association.Mapping(primaryColumn, associatedColumn, associatedParameter); frmAssociationWizard.Association.Mappings.Add(mapping); } return true; }