1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
|
using System.Collections.Generic;
using System.Diagnostics;
using System.Web.UI.WebControls;
namespace System.Web.DynamicData.Util {
internal class RouteParametersHelper {
private static Parameter CreateParameter(string name, string value, MetaColumn configurationColumn) {
var param = new Parameter() {
Name = name,
DefaultValue = value
};
DataSourceUtil.SetParameterTypeCodeAndDbType(param, configurationColumn);
return param;
}
internal static IEnumerable<Parameter> GetColumnParameters(MetaTable table, string columnName) {
if (String.IsNullOrEmpty(columnName)) {
// If no column is specified, we're setting the primary key from the query string
return GetPrimaryKeyParameters(table);
} else {
var column = table.GetColumn(columnName);
var fkColumn = column as MetaForeignKeyColumn;
if (fkColumn != null) {
// Handle the case where we're setting one of our foreign keys from the query string
return GetForeignKeyParameters(fkColumn);
} else {
// Handle other columns (e.g. booleans)
return GetRegularColumnParameters(column);
}
}
}
internal static IEnumerable<Parameter> GetForeignKeyParameters(MetaForeignKeyColumn fkColumn) {
Debug.Assert(fkColumn.ForeignKeyNames.Count == fkColumn.ParentTable.PrimaryKeyColumns.Count);
var result = new List<Parameter>();
for (int i = 0; i < fkColumn.ForeignKeyNames.Count; i++) {
string name = fkColumn.ForeignKeyNames[i];
string value = Misc.GetRouteValue(name);
MetaColumn parentTablePKColumn = fkColumn.ParentTable.PrimaryKeyColumns[i];
var param = CreateParameter(name, value, parentTablePKColumn);
result.Add(param);
}
return result;
}
internal static IEnumerable<Parameter> GetPrimaryKeyParameters(MetaTable table) {
var result = new List<Parameter>();
foreach (var primaryKeyColumn in table.PrimaryKeyColumns) {
string name = primaryKeyColumn.Name;
string value = Misc.GetRouteValue(name);
var param = CreateParameter(name, value, primaryKeyColumn);
result.Add(param);
}
return result;
}
internal static IEnumerable<Parameter> GetRegularColumnParameters(MetaColumn column) {
// Handle other columns (e.g. booleans)
string name = column.Name;
string value = Misc.GetRouteValue(name);
var param = CreateParameter(name, value, column);
return new List<Parameter>() { param };
}
}
}
|
