.NET Answers

Brian:

Thanks for the great tutorial. I’m not as patient as you as far as going back in to “fix” generated code. Tried it twice before I had to update the CodeSmith template. Below is the modified template for the “Controller” class if its of any use to anybody:
———————————————————————————–

using System;
using System.Collections;
using System.Data;
using DotNetNuke.Framework;
using ;

namespace
{
public class Controller : DotNetNuke.Entities.Modules.ISearchable, DotNetNuke.Entities.Modules.IPortable : DotNetNuke.Entities.Modules.IPortable
{
#region “Public Methods”

public (,int moduleId )
{
table = new ();
table.Load(DataProvider.Instance().Get(, moduleId ));
if (table.Count > 0) return table[0];
return null;
}

public ()
{
table = new ();
table.Load(DataProvider.Instance().());
return table;
}

<% for (int K = 0; K

public ArrayList By()
{
return DotNetNuke.Common.Utilities.CBO.FillCollection(DataProvider.Instance().By(), typeof());
}

public int ( obj)
{
return (int)DataProvider.Instance().();
}

public void ( obj)
{
DataProvider.Instance().(, );
}

public void ()
{
DataProvider.Instance().();
}

#endregion

#region “Optional Interfaces”

public DotNetNuke.Services.Search.SearchItemInfoCollection GetSearchItems(DotNetNuke.Entities.Modules.ModuleInfo ModInfo)
{
return null;
}

public string ExportModule(int ModuleID)
{
return “”;
}

public void ImportModule(int ModuleID, string Content, string Version, int UserId)
{
}

#endregion

}
}

public string GetMemberVariableDeclarationStatement(ColumnSchema column)
{
return GetMemberVariableDeclarationStatement(“protected”, column);
}

public string GetTableName(TableSchema table)
{
if( ObjectQualifier.Length > 0 )
{
return table.Name.Replace(ObjectQualifier, “”);
}
else
{
return table.Name;
}
}

public string GetMemberVariableDeclarationStatement(string protectionLevel, ColumnSchema column)
{
//string statement = “Dim ” + GetMemberVariableName(column) + ” as ” + GetVBVariableType(column);
string statement = GetCSharpVariableType(column) + ” ” + GetMemberVariableName(column) + “;”;// as ” + GetVBVariableType(column);
return statement;
}

public string GetReaderAssignmentStatement(ColumnSchema column, int index)
{
string statement = “if (!reader.IsDBNull(” + index.ToString() + “)) “;
statement += GetMemberVariableName(column) + ” = “;

if (column.Name.EndsWith(“TypeCode”)) statement += “(” + column.Name + “)”;

statement += “reader.” + GetReaderMethod(column) + “(” + index.ToString() + “);”;

return statement;
}

public string GetCamelCaseName(string value)
{
return value.Substring(0, 1).ToLower() + value.Substring(1);
}

public string GetMemberVariableName(ColumnSchema column)
{
string propertyName = GetPropertyName(column);
string memberVariableName = “_” + GetCamelCaseName(propertyName);

return memberVariableName;
}

public string GetPropertyName(ColumnSchema column)
{
string propertyName = column.Name;

if (propertyName == column.Table.Name + “Name”) return “Name”;
if (propertyName == column.Table.Name + “Description”) return “Description”;

if (propertyName.EndsWith(“TypeCode”)) propertyName = propertyName.Substring(0, propertyName.Length – 4);

return propertyName;
}

public string GetMemberVariableDefaultValue(ColumnSchema column)
{
switch (column.DataType)
{
case DbType.Guid:
{
return “Guid.Empty”;
}
case DbType.AnsiString:
case DbType.AnsiStringFixedLength:
case DbType.String:
case DbType.StringFixedLength:
{
return “string.Empty”;
}
default:
{
return “”;
}
}
}

public string GetCSharpVariableType(ColumnSchema column)
{
if (column.Name.EndsWith(“TypeCode”)) return column.Name;

switch (column.DataType)
{
case DbType.AnsiString: return “string”;
case DbType.AnsiStringFixedLength: return “string”;
case DbType.Binary: return “byte()”;
case DbType.Boolean: return “bool”;
case DbType.Byte: return “byte”;
case DbType.Currency: return “decimal”;
case DbType.Date: return “DateTime”;
case DbType.DateTime: return “DateTime”;
case DbType.Decimal: return “decimal”;
case DbType.Double: return “double”;
case DbType.Guid: return “Guid”;
case DbType.Int16: return “short”;
case DbType.Int32: return “int”;
case DbType.Int64: return “long”;
case DbType.Object: return “object”;
case DbType.SByte: return “sbyte”;
case DbType.Single: return “float”;
case DbType.String: return “string”;
case DbType.StringFixedLength: return “string”;
case DbType.Time: return “TimeSpan”;
case DbType.UInt16: return “ushort”;
case DbType.UInt32: return “uint”;
case DbType.UInt64: return “ulong”;
case DbType.VarNumeric: return “decimal”;
default:
{
return “__UNKNOWN__” + column.NativeType;
}
}
}

public string GetVBVariableType(ColumnSchema column)
{
if (column.Name.EndsWith(“TypeCode”)) return column.Name;

switch (column.DataType)
{
case DbType.AnsiString: return “string”;
case DbType.AnsiStringFixedLength: return “string”;
case DbType.Binary: return “byte()”;
case DbType.Boolean: return “Boolean”;
case DbType.Byte: return “byte”;
case DbType.Currency: return “decimal”;
case DbType.Date: return “DateTime”;
case DbType.DateTime: return “DateTime”;
case DbType.Decimal: return “decimal”;
case DbType.Double: return “double”;
case DbType.Guid: return “Guid”;
case DbType.Int16: return “short”;
case DbType.Int32: return “Integer”;
case DbType.Int64: return “long”;
case DbType.Object: return “object”;
case DbType.SByte: return “sbyte”;
case DbType.Single: return “float”;
case DbType.String: return “String”;
case DbType.StringFixedLength: return “String”;
case DbType.Time: return “TimeSpan”;
case DbType.UInt16: return “ushort”;
case DbType.UInt32: return “uint”;
case DbType.UInt64: return “ulong”;
case DbType.VarNumeric: return “decimal”;
default:
{
return “__UNKNOWN__” + column.NativeType;
}
}
}

public string GetReaderMethod(ColumnSchema column)
{
switch (column.DataType)
{
case DbType.Byte:
{
return “GetByte”;
}
case DbType.Int16:
{
return “GetInt16″;
}
case DbType.Int32:
{
return “GetInt32″;
}
case DbType.Int64:
{
return “GetInt64″;
}
case DbType.AnsiStringFixedLength:
case DbType.AnsiString:
case DbType.String:
case DbType.StringFixedLength:
{
return “GetString”;
}
case DbType.Boolean:
{
return “GetBoolean”;
}
case DbType.Guid:
{
return “GetGuid”;
}
case DbType.Currency:
case DbType.Decimal:
{
return “GetDecimal”;
}
case DbType.DateTime:
case DbType.Date:
{
return “GetDateTime”;
}
default:
{
return “__SQL__” + column.DataType;
}
}
}

public string GetClassName(TableSchema table)
{
if( ObjectQualifier.Length > 0 )
{
return (“DataSet” + table.Name + “.”).Replace(ObjectQualifier, “”) + table.Name + “DataTable”;
}
else
{
return “DataSet” + table.Name + “.” + table.Name + “DataTable”;
}
}

public string GetClassNameInfo(TableSchema table)
{
if( ObjectQualifier.Length > 0 )
{
return (“DataSet” + table.Name + “.”).Replace(ObjectQualifier, “”) + table.Name + “Row”;
}
else
{
return “DataSet” + table.Name + “.” + table.Name + “Row”;
}
}

public string GetSqlDbType(ColumnSchema column)
{
switch (column.NativeType)
{
case “bigint”: return “BigInt”;
case “binary”: return “Binary”;
case “bit”: return “Bit”;
case “char”: return “Char”;
case “datetime”: return “DateTime”;
case “decimal”: return “Decimal”;
case “float”: return “Float”;
case “image”: return “Image”;
case “int”: return “Int”;
case “money”: return “Money”;
case “nchar”: return “NChar”;
case “ntext”: return “NText”;
case “numeric”: return “Decimal”;
case “nvarchar”: return “NVarChar”;
case “real”: return “Real”;
case “smalldatetime”: return “SmallDateTime”;
case “smallint”: return “SmallInt”;
case “smallmoney”: return “SmallMoney”;
case “sql_variant”: return “Variant”;
case “sysname”: return “NChar”;
case “text”: return “Text”;
case “timestamp”: return “Timestamp”;
case “tinyint”: return “TinyInt”;
case “uniqueidentifier”: return “UniqueIdentifier”;
case “varbinary”: return “VarBinary”;
case “varchar”: return “VarChar”;
default: return “__UNKNOWN__” + column.NativeType;
}
}

public string GetPrimaryKeyType(TableSchema table)
{
if (table.PrimaryKey != null)
{
if (table.PrimaryKey.MemberColumns.Count == 1)
{
return GetCSharpVariableType(table.PrimaryKey.MemberColumns[0]);
}
else
{
throw new ApplicationException(“This template will not work on primary keys with more than one member column.”);
}
}
else
{
throw new ApplicationException(“This template will only work on tables with a primary key.”);
}
}

public string GetPrimaryKeyName(TableSchema table)
{
if (table.PrimaryKey != null)
{
if (table.PrimaryKey.MemberColumns.Count == 1)
{
return table.PrimaryKey.MemberColumns[0].Name;
}
else
{
throw new ApplicationException(“This template will not work on primary keys with more than one member column.”);
}
}
else
{
throw new ApplicationException(“This template will only work on tables with a primary key.”);
}
}

public string GetPrimaryKeyParameters(TableSchema table, bool includeTypes)
{
string parameters = “”;
if (table.PrimaryKey != null)
{
for( int i = 0; i < table.PrimaryKey.MemberColumns.Count; i++ )
{
if(parameters.Length == 0)
{
if( includeTypes )
parameters = parameters;// + “ByVal “;

parameters = parameters + GetCamelCaseName(table.PrimaryKey.MemberColumns[i].Name);

if( includeTypes )
{
parameters = GetCSharpVariableType(table.PrimaryKey.MemberColumns[i]) + ” ” + parameters + ” “;
}
}
else
{
parameters = parameters + “, “;
if( includeTypes )
parameters = parameters;// + “ByVal “;

parameters = parameters + GetCamelCaseName(table.PrimaryKey.MemberColumns[i].Name);

if( includeTypes )
{
parameters = GetCSharpVariableType(table.PrimaryKey.MemberColumns[i]) + ” ” + parameters + ” “;
}
}
}
}
else
{
throw new ApplicationException(“This template will only work on tables with a primary key.”);
}
return parameters;
}

public string GetNonPrimaryKeyParameters(TableSchema table, bool includeTypes)
{
string parameters = “”;
if (table.PrimaryKey != null)
{
for( int i = 0; i < table.NonPrimaryKeyColumns.Count; i++ )
{
if(parameters.Length == 0)
{
if( includeTypes )
parameters = parameters;// + “ByVal “;

if( includeTypes )
{
parameters = GetCSharpVariableType(table.NonPrimaryKeyColumns[i]) + ” ” + GetCamelCaseName(table.NonPrimaryKeyColumns[i].Name) + ” “;
}
else
{
parameters = parameters + GetCamelCaseName(table.NonPrimaryKeyColumns[i].Name);
}
}
else
{
parameters = parameters + “, “;
if( includeTypes )
parameters = parameters;// + “ByVal “;

if( includeTypes )
{
parameters = parameters + GetCSharpVariableType(table.NonPrimaryKeyColumns[i]) + ” ” + GetCamelCaseName(table.NonPrimaryKeyColumns[i].Name) + ” “;
}
else
{
parameters = parameters + GetCamelCaseName(table.NonPrimaryKeyColumns[i].Name);
}
}
}
}
else
{
throw new ApplicationException(“This template will only work on tables with a primary key.”);
}
return parameters;
}

public string GetPrimaryKeyParametersForObject(TableSchema table, string obj)
{
string parameters = “”;
if (table.PrimaryKey != null)
{
for( int i = 0; i < table.PrimaryKey.MemberColumns.Count; i++ )
{
if(parameters.Length == 0)
{
parameters = parameters + obj + “.” + table.PrimaryKey.MemberColumns[i].Name;
}
else
{
parameters = parameters + “, “;
parameters = parameters + obj + “.” + table.PrimaryKey.MemberColumns[i].Name;
}
}
}
else
{
throw new ApplicationException(“This template will only work on tables with a primary key.”);
}
return parameters;
}

public string GetNonPrimaryKeyParametersForObject(TableSchema table, string obj)
{
string parameters = “”;

for( int i = 0; i < table.NonPrimaryKeyColumns.Count; i++ )
{
if(parameters.Length == 0)
{
parameters = parameters + obj + “.” + table.NonPrimaryKeyColumns[i].Name;
}
else
{
parameters = parameters + “, “;
parameters = parameters + obj + “.” + table.NonPrimaryKeyColumns[i].Name;
}
}

return parameters;
}