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;
}
