private Model.View GetNewView(Microsoft.SqlServer.Management.Smo.View smoView)
{
Model.View view = new Model.View(smoView.Name, Script.GetSingluar(smoView.Name), false);
// Columns
int ordinalPosition = 0;
List <Microsoft.SqlServer.Management.Smo.Column> smoColumns = new List <Microsoft.SqlServer.Management.Smo.Column>();
foreach (Microsoft.SqlServer.Management.Smo.Column smoColumn in smoView.Columns)
{
smoColumns.Add(smoColumn);
}
smoColumns.Sort(new SortComparer <Microsoft.SqlServer.Management.Smo.Column>("ID", System.ComponentModel.ListSortDirection.Ascending));
foreach (Microsoft.SqlServer.Management.Smo.Column smoColumn in smoColumns)
{
if (UnsupportedDataTypes.ToLower().IndexOf("'" + smoColumn.DataType.Name.ToLower() + "'") >= 0)
{
continue;
}
Model.Column column = new Model.Column(smoColumn.Name, Script.GetSingluar(smoColumn.Name), false, smoColumn.Name, view, ordinalPosition, smoColumn.Nullable, smoColumn.DataType.Name, smoColumn.DataType.MaximumLength,
false, smoColumn.Identity, smoColumn.Default, true);
view.AddColumn(column);
ordinalPosition++;
}
return(view);
}
private Model.View GetNewView(Microsoft.SqlServer.Management.Smo.View smoView)
{
Model.View view = new Model.View(smoView.Name, Script.GetSingluar(smoView.Name), false);
// Columns
int ordinalPosition = 0;
List<Microsoft.SqlServer.Management.Smo.Column> smoColumns = new List<Microsoft.SqlServer.Management.Smo.Column>();
foreach (Microsoft.SqlServer.Management.Smo.Column smoColumn in smoView.Columns)
{
smoColumns.Add(smoColumn);
}
smoColumns.Sort(new SortComparer<Microsoft.SqlServer.Management.Smo.Column>("ID", System.ComponentModel.ListSortDirection.Ascending));
foreach (Microsoft.SqlServer.Management.Smo.Column smoColumn in smoColumns)
{
if (UnsupportedDataTypes.ToLower().IndexOf("'" + smoColumn.DataType.Name.ToLower() + "'") >= 0)
{
continue;
}
Model.Column column = new Model.Column(smoColumn.Name, Script.GetSingluar(smoColumn.Name), false, smoColumn.Name, view, ordinalPosition, smoColumn.Nullable, smoColumn.DataType.Name, smoColumn.DataType.MaximumLength,
false, smoColumn.Identity, smoColumn.Default, true);
view.AddColumn(column);
ordinalPosition++;
}
return view;
}
private void AutoMap()
{
List <string> unassignedAliases = UnMappedAssociatedColumnAliases;
for (int nodeCounter = 0; nodeCounter < gridMappings.Rows.Count; nodeCounter++)
{
DataGridViewRow row = gridMappings.Rows[nodeCounter];
string associatedColumnAlias = row.Cells[1].Value.ToString();
if (string.IsNullOrEmpty(associatedColumnAlias))
{
Model.Column column = (Model.Column)row.Tag;
for (int unassignedCounter = unassignedAliases.Count - 1; unassignedCounter >= 0; unassignedCounter--)
{
string availableAlias = unassignedAliases[unassignedCounter];
if (availableAlias.ToLower().Replace("_", "").IndexOf(column.Alias.ToLower().Replace("_", "")) >= 0)
{
Model.Column associatedColumn = FindAssociatedColumn(availableAlias);
if (associatedColumn != null && associatedColumn.DataType == column.DataType)
{
row.Cells[1].Value = string.Format("{0} ({1})", availableAlias, associatedColumn.DataType);
unassignedAliases.RemoveAt(unassignedCounter);
AutoMappedNodes.Add(nodeCounter);
row.Cells[1].Style.ForeColor = Color.Green;
}
}
}
}
}
AutoMappedNodes.Sort();
}
public override bool Next()
{
Owner.TheFilter.ClearFilterColumns();
gridFilterColumns.EndEdit();
foreach (DataGridViewRow row in gridFilterColumns.Rows)
{
Model.Filter.FilterColumn filterColumn;
if ((bool)row.Cells[(int)Cells.Selected].Value)
{
string logicalValue = row.Cells[(int)Cells.Logical].Value == null ? "" : row.Cells[(int)Cells.Logical].Value.ToString().Trim();
if (row.Tag is Model.Filter.FilterColumn)
{
filterColumn = (Model.Filter.FilterColumn)row.Tag;
filterColumn.CompareOperator = row.Cells[(int)Cells.Comparer].Value.ToString();
filterColumn.LogicalOperator = logicalValue;
}
else
{
Model.Column column = (Model.Column)row.Tag;
filterColumn = new Model.Filter.FilterColumn(column, logicalValue, row.Cells[(int)Cells.Comparer].Value.ToString(), column.Name);
}
Owner.TheFilter.AddFilterColumn(filterColumn);
}
}
return(true);
}
protected bool IsSupported(Model.Column column)
{
foreach (string unsupportedDataType in _unsupportedDataTypes)
{
if (column.DataType == unsupportedDataType)
{
return(false);
}
}
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;
}
private void GetTestData()
{
var r1 = new Row();
var c1 = new Model.Column();
var r2 = new Row();
var c2 = new Model.Column();
var r3 = new Row();
r1.Add(new Cartoon()
{
Link = ListOfImages[0], ParentType = r1.Type
});
r1.Add(c1);
r1.Add(new Cartoon()
{
Link = ListOfImages[1], ParentType = r1.Type
});
c1.Add(r2);
c1.Add(new Cartoon()
{
Link = ListOfImages[2], ParentType = c1.Type
});
r2.Add(new Cartoon()
{
Link = ListOfImages[3], ParentType = r2.Type
});
r2.Add(c2);
c2.Add(r3);
c2.Add(new Cartoon()
{
Link = ListOfImages[4], ParentType = c2.Type
});
r3.Add(new Cartoon()
{
Link = ListOfImages[5], ParentType = r3.Type
});
r3.Add(new Cartoon()
{
Link = ListOfImages[6], ParentType = r3.Type
});
//Window.StackP.Children.Add(ListOfImages[0]);
//SourceImage = ListOfImages[0];
GetResultImage(r1, 650);
}
public DataGridViewRow AddGridRow(Model.Column column, bool checkedColumnsOnly)
{
DataGridViewRow newRow = null;
Model.Filter.FilterColumn filterColumn = null;
foreach (ArchAngel.Providers.Database.Model.Filter.FilterColumn filterCol in Owner.TheFilter.FilterColumns)
{
if (filterCol.Column.Name == column.Name && filterCol.Column.Parent.Name == column.Parent.Name)
{
filterColumn = filterCol;
break;
}
}
if (filterColumn != null)
{
if (checkedColumnsOnly)
{
string logicalOperator = filterColumn.LogicalOperator;
if (string.IsNullOrEmpty(logicalOperator))
{
logicalOperator = " ";
}
int index = gridFilterColumns.Rows.Add(new object[] { true, filterColumn.Column.Parent.Name, filterColumn.Column.Name, filterColumn.Column.Alias, filterColumn.CompareOperator, logicalOperator });
gridFilterColumns.Rows[index].Tag = filterColumn;
newRow = gridFilterColumns.Rows[index];
}
}
else
{
if (!checkedColumnsOnly)
{
int index = gridFilterColumns.Rows.Add(new object[] { false, column.Parent.Name, column.Name, column.Alias, "=", "And" });
gridFilterColumns.Rows[index].Tag = column;
newRow = gridFilterColumns.Rows[index];
}
}
return(newRow);
}
//The issue context is specified by including one of the following columns in the result set: schema_context, table_context or column_context
//Default context is database context (also used if e.g. one of the specified tables does not exist in the model)
private static IssueContext getContextFromSQLIssue(DataTable result, DataRow issueRow, Model.Database database)
{
//Schema context
if (result.Columns.Contains("schema_context"))
{
String schemaName = (String)issueRow["schema_context"];
Model.Schema schema = database.Schemas.Where(s => s.SchemaName == schemaName).FirstOrDefault();
if (schema != null)
{
return(new SchemaContext(schema));
}
}
//Table context
else if (result.Columns.Contains("table_context"))
{
String tableName = (String)issueRow["table_context"];
Model.Table table = database.Tables.Where(t => t.TableName == tableName).FirstOrDefault();
if (table != null)
{
return(new TableContext(table));
}
}
//Column context
else if (result.Columns.Contains("column_context"))
{
String columnName = (String)issueRow["column_context"];
Model.Column column = database.Columns.Where(c => c.TableName == columnName).FirstOrDefault();
if (column != null)
{
return(new ColumnContext(column));
}
}
//Default context
return(new DatabaseContext(database));
}
