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