/// <summary>
/// Gets the method parameter list for object array.
/// </summary>
/// <param name="proc">The proc.</param>
/// <returns></returns>
public string GetMethodParamListForObjectArray(Procedure proc)
{
var b = new TextBuilder();
var objectIndex = 0;
for (var i = 0; i < proc.Parameters.Count(); i++)
{
var parameter = proc.Parameters.ElementAt(i);
if (i != 0)
{
b.Append(", ");
}
if (parameter.IsOutput)
{
b.AppendFormat("out {0}Output", parameter.Name);
}
else
{
if (parameter.IsTableValue)
{
b.AppendFormat("(IEnumerable<ITableValuedParamRow>)parameters[{0}]", objectIndex.ToString());
}
else
{
b.AppendFormat("({1})parameters[{0}]", objectIndex.ToString(), parameter.DataTypes[TypeFormat.DotNetFrameworkType]);
}
objectIndex++;
}
}
return(b.ToString());
}
/// <summary>
/// Gets the parameter list for the method.
/// </summary>
/// <param name="proc">The procedure to get the parameter list for.</param>
/// <param name="genericTableValue">if set to <c>true</c> [generic table value].</param>
/// <param name="includeType">if set to <c>true</c> [include type].</param>
/// <param name="convertType">if set to <c>true</c> [convert type].</param>
/// <returns>
/// The generated parameter list.
/// </returns>
public string GetMethodParamList(Procedure proc, bool genericTableValue, bool includeType, bool convertType)
{
var b = new TextBuilder();
for (var i = 0; i < proc.Parameters.Count(); i++)
{
var parameter = proc.Parameters.ElementAt(i);
if (i != 0)
{
b.Append(", ");
}
if (parameter.IsTableValue)
{
if (includeType)
{
if (genericTableValue)
{
var format = convertType ? "(IEnumerable<ITableValuedParamRow>){0}" : "IEnumerable<ITableValuedParamRow> {0}";
b.AppendFormat(format, parameter.Name);
}
else
{
var format = convertType ? "(IEnumerable<{0}_{1}ParamDto>){1}" : "IEnumerable<{0}_{1}ParamDto> {1}";
b.AppendFormat(format, proc.Name, parameter.Name);
}
}
else
{
b.Append(parameter.Name);
}
}
else
{
if (parameter.IsOutput)
{
b.Append("out ");
}
if (includeType)
{
var format = convertType ? "({0}){1}" : "{0} {1}";
b.AppendFormat(format, parameter.DataTypes[TypeFormat.DotNetFrameworkType], parameter.Name);
}
else
{
b.Append(parameter.Name);
}
}
}
return(b.ToString());
}
/// <summary>
/// Gets the method parameter list for methods that call an overload
/// with input DTO properties as parameters.
/// </summary>
/// <param name="proc">The proc.</param>
/// <returns></returns>
public string GetMethodParamListForInputDto(Procedure proc)
{
var b = new TextBuilder();
for (var i = 0; i < proc.Parameters.Count(); i++)
{
var parameter = proc.Parameters.ElementAt(i);
if (i != 0)
{
b.Append(", ");
}
b.AppendFormat(parameter.IsOutput ? "out {0}Output" : "input.{0}", parameter.Name);
}
return(b.ToString());
}
/// <summary>
/// Gets the DTO return objects that represent a row of each result set of each procedure.
/// </summary>
/// <param name="proc">The procedure to generate the DTO from.</param>
/// <param name="indent">The number of tabs to indent the generated code.</param>
/// <returns>
/// The generated DTO objects.
/// </returns>
public string GetDtoObject(Procedure proc, int indent = 0)
{
var b = new TextBuilder();
b.Indent(indent);
if (proc.Parameters.Any())
{
// Create the input DTO.
b.AppendLine("/// <summary>");
b.AppendFormatLine("/// DTO for the input of the \"{0}\" stored procedure.", proc.RawName);
b.AppendLine("/// </summary>");
b.AppendFormatLine("public partial class {0}InputDto", proc.Name);
b.AppendLine("{");
b.Indent();
foreach (var p in proc.Parameters)
{
b.AppendLine("/// <summary>");
b.AppendFormatLine(p.IsOutput ?
"/// Property that gets filled with the {0} output parameter." :
"/// Property that fills the {0} input parameter.", p.Name);
b.AppendLine("/// </summary>");
if (p.IsTableValue)
{
b.AppendFormatLine("public IEnumerable<{0}_{1}ParamDto> {1} {{ get; set; }}", proc.Name, p.Name);
}
else
{
var cSharpType = p.DataTypes[TypeFormat.DotNetFrameworkType];
b.AppendFormatLine("public {0} {1} {{ get; {2}set; }}", cSharpType, p.Name, p.IsOutput ? "internal " : "");
}
}
b.Unindent();
b.AppendLine("}");
b.AppendLine();
// Create DTOs for any table-valued parameters.
foreach (var p in proc.Parameters.Where(x => x.IsTableValue))
{
b.AppendLine("/// <summary>");
b.AppendFormatLine("/// DTO for the input of the \"{0}\" table-valued parameter of the \"{1}\" stored procedure.", p.Name, proc.RawName);
b.AppendLine("/// </summary>");
b.AppendFormatLine("public partial class {0}_{1}ParamDto : ITableValuedParamRow", proc.Name, p.Name);
b.AppendLine("{");
b.Indent();
foreach (var c in p.TableValue.Columns)
{
var cSharpType = c.DataTypes[TypeFormat.DotNetFrameworkType];
if (!c.IsNullable)
{
cSharpType = cSharpType.TrimEnd('?');
}
b.AppendFormatLine("public {0} {1} {{ get; set; }}", cSharpType, c.Name);
}
b.AppendLine();
b.AppendLine("public SqlDataRecord ToSqlDataRecord()");
b.AppendLine("{");
b.Indent();
b.AppendLine("var sdr = new SqlDataRecord(");
b.Indent();
for (var i = 0; i < p.TableValue.Columns.Count(); i++)
{
var c = p.TableValue.Columns.ElementAt(i);
var comma = i == p.TableValue.Columns.Count() - 1 ? "" : ",";
b.AppendFormatLine("new SqlMetaData(\"{0}\", SqlDbType.{1}){2}", c.Name, c.DataTypes[TypeFormat.SqlDbTypeEnum], comma);
}
b.Unindent();
b.AppendLine(");");
for (var i = 0; i < p.TableValue.Columns.Count(); i++)
{
var c = p.TableValue.Columns.ElementAt(i);
var setFn = "Set" + c.DataTypes[TypeFormat.SqlDataReaderDbType].Substring(3);
if (c.IsNullable && c.DataTypes[TypeFormat.DotNetFrameworkType].EndsWith("?"))
{
b.AppendFormatLine("if({2}.HasValue) sdr.{0}({1}, {2}.GetValueOrDefault()); else sdr.SetDBNull({1});", setFn, i.ToString(), c.Name);
}
else
{
b.AppendFormatLine("sdr.{0}({1}, {2});", setFn, i.ToString(), c.Name);
}
}
b.AppendLine("return sdr;");
b.Unindent();
b.AppendLine("}");
b.Unindent();
b.AppendLine("}");
b.AppendLine();
}
}
// If only one select and one column, no output DTO is needed.
if (proc.Selects.Count() == 1 && proc.Selects.First().Columns.Count() == 1)
{
return(b.ToString());
}
// Create output DTOs.
for (var i = 0; i < proc.Selects.Count(); i++)
{
b.AppendLine("/// <summary>");
b.AppendFormatLine("/// DTO for the output of the \"{0}\" stored procedure.", proc.RawName);
b.AppendLine("/// </summary>");
b.AppendFormat("public partial class {0}OutputDto", proc.Name);
if (i > 0)
{
b.StringBuilder.Append((i + 1).ToString());
}
b.AppendLine();
b.AppendLine("{");
b.Indent();
foreach (var col in proc.Selects.ElementAt(i).Columns)
{
var cSharpType = col.DataTypes[TypeFormat.DotNetFrameworkType];
if (!col.IsNullable)
{
cSharpType = cSharpType.TrimEnd('?');
}
b.AppendFormatLine("public {0} {1} {{ get; set; }}", cSharpType, col.Name);
}
b.Unindent();
b.AppendLine("}");
b.AppendLine();
}
// If multiple selects, create an object to hold all the results.
if (proc.Selects.Count() > 1)
{
b.AppendFormatLine("public partial class {0}Results", proc.Name);
b.AppendLine("{");
b.Indent();
b.AppendLine("public int RecordsAffected { get; set; }");
for (var i = 0; i < proc.Selects.Count(); i++)
{
var inc = i > 0 ? (i + 1).ToString() : "";
b.AppendFormatLine("public IEnumerable<{0}OutputDto{1}> Result{1} {{ get; set; }}", proc.Name, inc);
}
b.Unindent();
b.AppendLine("}");
b.AppendLine();
}
b.Unindent();
return(b.ToString());
}
/// <summary>
/// Gets the method parameter list for object array.
/// </summary>
/// <param name="proc">The proc.</param>
/// <returns></returns>
public string GetMethodParamListForObjectArray(Procedure proc)
{
var b = new TextBuilder();
var objectIndex = 0;
for (var i = 0; i < proc.Parameters.Count(); i++)
{
var parameter = proc.Parameters.ElementAt(i);
if (i != 0) b.Append(", ");
if (parameter.IsOutput)
b.AppendFormat("out {0}Output", parameter.Name);
else
{
if (parameter.IsTableValue)
{
b.AppendFormat("(IEnumerable<ITableValuedParamRow>)parameters[{0}]", objectIndex.ToString());
}
else
{
b.AppendFormat("({1})parameters[{0}]", objectIndex.ToString(), parameter.DataTypes[TypeFormat.DotNetFrameworkType]);
}
objectIndex++;
}
}
return b.ToString();
}
/// <summary>
/// Gets the method parameter list for methods that call an overload
/// with input DTO properties as parameters.
/// </summary>
/// <param name="proc">The proc.</param>
/// <returns></returns>
public string GetMethodParamListForInputDto(Procedure proc)
{
var b = new TextBuilder();
for (var i = 0; i < proc.Parameters.Count(); i++)
{
var parameter = proc.Parameters.ElementAt(i);
if (i != 0) b.Append(", ");
b.AppendFormat(parameter.IsOutput ? "out {0}Output" : "input.{0}", parameter.Name);
}
return b.ToString();
}
/// <summary>
/// Gets the parameter list for the method.
/// </summary>
/// <param name="proc">The procedure to get the parameter list for.</param>
/// <param name="genericTableValue">if set to <c>true</c> [generic table value].</param>
/// <param name="includeType">if set to <c>true</c> [include type].</param>
/// <param name="convertType">if set to <c>true</c> [convert type].</param>
/// <returns>
/// The generated parameter list.
/// </returns>
public string GetMethodParamList(Procedure proc, bool genericTableValue, bool includeType, bool convertType)
{
var b = new TextBuilder();
for (var i = 0; i < proc.Parameters.Count(); i++)
{
var parameter = proc.Parameters.ElementAt(i);
if (i != 0) b.Append(", ");
if (parameter.IsTableValue)
{
if (includeType)
{
if (genericTableValue)
{
var format = convertType ? "(IEnumerable<ITableValuedParamRow>){0}" : "IEnumerable<ITableValuedParamRow> {0}";
b.AppendFormat(format, parameter.Name);
}
else
{
var format = convertType ? "(IEnumerable<{0}_{1}ParamDto>){1}" : "IEnumerable<{0}_{1}ParamDto> {1}";
b.AppendFormat(format, proc.Name, parameter.Name);
}
}
else b.Append(parameter.Name);
}
else
{
if (parameter.IsOutput) b.Append("out ");
if (includeType)
{
var format = convertType ? "({0}){1}" : "{0} {1}";
b.AppendFormat(format, parameter.DataTypes[TypeFormat.DotNetFrameworkType], parameter.Name);
}
else b.Append(parameter.Name);
}
}
return b.ToString();
}
/// <summary>
/// Gets the DTO return objects that represent a row of each result set of each procedure.
/// </summary>
/// <param name="proc">The procedure to generate the DTO from.</param>
/// <param name="indent">The number of tabs to indent the generated code.</param>
/// <returns>
/// The generated DTO objects.
/// </returns>
public string GetDtoObject(Procedure proc, int indent = 0)
{
var b = new TextBuilder();
b.Indent(indent);
if (proc.Parameters.Any())
{
// Create the input DTO.
b.AppendLine("/// <summary>");
b.AppendFormatLine("/// DTO for the input of the \"{0}\" stored procedure.", proc.RawName);
b.AppendLine("/// </summary>");
b.AppendFormatLine("public partial class {0}InputDto", proc.Name);
b.AppendLine("{");
b.Indent();
foreach (var p in proc.Parameters)
{
b.AppendLine("/// <summary>");
b.AppendFormatLine(p.IsOutput ?
"/// Property that gets filled with the {0} output parameter." :
"/// Property that fills the {0} input parameter.", p.Name);
b.AppendLine("/// </summary>");
if (p.IsTableValue)
{
b.AppendFormatLine("public IEnumerable<{0}_{1}ParamDto> {1} {{ get; set; }}", proc.Name, p.Name);
}
else
{
var cSharpType = p.DataTypes[TypeFormat.DotNetFrameworkType];
b.AppendFormatLine("public {0} {1} {{ get; {2}set; }}", cSharpType, p.Name, p.IsOutput ? "internal " : "");
}
}
b.Unindent();
b.AppendLine("}");
b.AppendLine();
// Create DTOs for any table-valued parameters.
foreach (var p in proc.Parameters.Where(x => x.IsTableValue))
{
b.AppendLine("/// <summary>");
b.AppendFormatLine("/// DTO for the input of the \"{0}\" table-valued parameter of the \"{1}\" stored procedure.", p.Name, proc.RawName);
b.AppendLine("/// </summary>");
b.AppendFormatLine("public partial class {0}_{1}ParamDto : ITableValuedParamRow", proc.Name, p.Name);
b.AppendLine("{");
b.Indent();
foreach (var c in p.TableValue.Columns)
{
var cSharpType = c.DataTypes[TypeFormat.DotNetFrameworkType];
if (!c.IsNullable) cSharpType = cSharpType.TrimEnd('?');
b.AppendFormatLine("public {0} {1} {{ get; set; }}", cSharpType, c.Name);
}
b.AppendLine();
b.AppendLine("public SqlDataRecord ToSqlDataRecord()");
b.AppendLine("{");
b.Indent();
b.AppendLine("var sdr = new SqlDataRecord(");
b.Indent();
for (var i = 0; i < p.TableValue.Columns.Count(); i++)
{
var c = p.TableValue.Columns.ElementAt(i);
var comma = i == p.TableValue.Columns.Count() - 1 ? "" : ",";
b.AppendFormatLine("new SqlMetaData(\"{0}\", SqlDbType.{1}){2}", c.Name, c.DataTypes[TypeFormat.SqlDbTypeEnum], comma);
}
b.Unindent();
b.AppendLine(");");
for (var i = 0; i < p.TableValue.Columns.Count(); i++)
{
var c = p.TableValue.Columns.ElementAt(i);
var setFn = "Set" + c.DataTypes[TypeFormat.SqlDataReaderDbType].Substring(3);
if (c.IsNullable && c.DataTypes[TypeFormat.DotNetFrameworkType].EndsWith("?"))
b.AppendFormatLine("if({2}.HasValue) sdr.{0}({1}, {2}.GetValueOrDefault()); else sdr.SetDBNull({1});", setFn, i.ToString(), c.Name);
else
b.AppendFormatLine("sdr.{0}({1}, {2});", setFn, i.ToString(), c.Name);
}
b.AppendLine("return sdr;");
b.Unindent();
b.AppendLine("}");
b.Unindent();
b.AppendLine("}");
b.AppendLine();
}
}
// If only one select and one column, no output DTO is needed.
if (proc.Selects.Count() == 1 && proc.Selects.First().Columns.Count() == 1)
return b.ToString();
// Create output DTOs.
for (var i = 0; i < proc.Selects.Count(); i++)
{
b.AppendLine("/// <summary>");
b.AppendFormatLine("/// DTO for the output of the \"{0}\" stored procedure.", proc.RawName);
b.AppendLine("/// </summary>");
b.AppendFormat("public partial class {0}OutputDto", proc.Name);
if (i > 0) b.StringBuilder.Append((i + 1).ToString());
b.AppendLine();
b.AppendLine("{");
b.Indent();
foreach (var col in proc.Selects.ElementAt(i).Columns)
{
var cSharpType = col.DataTypes[TypeFormat.DotNetFrameworkType];
if (!col.IsNullable) cSharpType = cSharpType.TrimEnd('?');
b.AppendFormatLine("public {0} {1} {{ get; set; }}", cSharpType, col.Name);
}
b.Unindent();
b.AppendLine("}");
b.AppendLine();
}
// If multiple selects, create an object to hold all the results.
if (proc.Selects.Count() > 1)
{
b.AppendFormatLine("public partial class {0}Results", proc.Name);
b.AppendLine("{");
b.Indent();
b.AppendLine("public int RecordsAffected { get; set; }");
for (var i = 0; i < proc.Selects.Count(); i++)
{
var inc = i > 0 ? (i + 1).ToString() : "";
b.AppendFormatLine("public IEnumerable<{0}OutputDto{1}> Result{1} {{ get; set; }}", proc.Name, inc);
}
b.Unindent();
b.AppendLine("}");
b.AppendLine();
}
b.Unindent();
return b.ToString();
}
