private List <DatabaseFunction_Entity_ColumnDTO> ToDatabaseFunctionEntityColumnsDTO(DatabaseFunction_TableDrivedEntity cItem)
{
BizColumn bizColumn = new BizColumn();
List <DatabaseFunction_Entity_ColumnDTO> result = new List <DatabaseFunction_Entity_ColumnDTO>();
foreach (var column in cItem.DatabaseFunction_TableDrivedEntity_Columns)
{
var item = new DatabaseFunction_Entity_ColumnDTO();
item.ID = column.ID;
item.DatabaseFunctionParameterID = column.DatabaseFunctionParameterID;
item.DatabaseFunction_EntityID = column.DatabaseFunction_TableDrivedEntityID;
if (column.ColumnID != null)
{
item.ColumnID = column.ColumnID.Value;
item.ColumnName = column.Column.Name;
}
if (column.FixedParamID != null)
{
item.FixedParam = (Enum_FixedParam)column.FixedParamID;
}
item.FunctionColumnDotNetType = bizColumn.GetColumnDotNetType(column.DatabaseFunctionParameter.DataType, false);
item.FunctionColumnParamName = column.DatabaseFunctionParameter.ParamName;
result.Add(item);
}
return(result);
}
private void SetDatabaseFunctionParametersToGrid(List <DatabaseFunctionColumnDTO> functionColumns, DatabaseFunction_EntityDTO DatabaseFunctionEntity)
{
dtgDatabaseFunctionParams.ItemsSource = null;
List <DatabaseFunction_Entity_ColumnDTO> gridColumns = new List <DatabaseFunction_Entity_ColumnDTO>();
foreach (var item in functionColumns.Where(x => x.InputOutput == Enum_DatabaseFunctionParameterType.Input || x.InputOutput == Enum_DatabaseFunctionParameterType.InputOutput))
{
var row = new DatabaseFunction_Entity_ColumnDTO();
row.DatabaseFunctionParameterID = item.ID;
row.FunctionColumnParamName = item.ParameterName;
row.FunctionDataType = item.DataType;
row.FunctionColumnDotNetType = item.DotNetType;
var existingRow = DatabaseFunctionEntity.DatabaseFunctionEntityColumns.FirstOrDefault(x => x.FunctionColumnParamName == item.ParameterName);
if (existingRow != null)
{
row.ColumnID = existingRow.ColumnID;
}
gridColumns.Add(row);
}
dtgDatabaseFunctionParams.ItemsSource = gridColumns;
}
