private void ConfigureParameters(string procedureName, List <string> parameterNames)
{
foreach (var parameterName in parameterNames)
{
SimpleNodeViewModel parameterViewModel = new ParameterNodeViewModel(parameterName, parameterName, this);
Children.Add(parameterViewModel);
}
SimpleDragText = String.Format("{0}", procedureName);
ExtendedDragText = String.Format("EXECUTE RETURN_VALUE = {0}{1}{2}", procedureName, (parameterNames.Count > 0) ? Environment.NewLine : String.Empty,
String.Join(String.Format(",{0}", Environment.NewLine), parameterNames.Select(item => "\t" + item).ToArray()));
}
private void LoadAllChildren()
{
Children.Clear();
DatabaseModel.Column[] columns;
string error;
if (GetCachedTableColumns(out columns, out error))
{
foreach (var column in columns)
{
string dragText = $"{sqlGenerator.Delimiter}{column.Name}{sqlGenerator.Delimiter}";
SimpleNodeViewModel columnViewModel = new ParameterNodeViewModel(column.Name + " [" + column.DataType.ToString() + "]", dragText, this);
Children.Add(columnViewModel);
}
}
else
{
Children.Add(new SimpleNodeViewModel(error, false, this));
}
this.childrenLoaded = true;
}
