//Builds the model.Parameters from the dto.Parameter definitions.
private static Dictionary <string, Models.Parameter> buildParameters(dto.Procedure source)
{
Dictionary <string, Parameter> parms = new Dictionary <string, Parameter>();
foreach (dto.Parameter dtoParm in source.Parameters)
{
string dataTypeName = null;
if (dtoParm.UserDefinedTypeSchema != null)
{
dataTypeName = $"[{dtoParm.UserDefinedTypeSchema}].[{dtoParm.UserDefinedTypeName}]";
}
ParameterDirection direction = SqlDataTypeMappings.SqlParameterModeToParameterDirection(dtoParm.ParameterMode);
Type type = SqlDataTypeMappings.SqlDataTypeToCSharpType(dtoParm.DataType);
SqlDbType sqlDbType = SqlDataTypeMappings.SqlDataTypeToSqlDbType(dtoParm.DataType);
Parameter mdlParm = new Parameter(
dtoParm.ParameterName, direction, sqlDbType, dtoParm.CharacterMaximumLength,
dtoParm.DateTimePrecision, dtoParm.NumericScale, dtoParm.NumericPrecision,
dtoParm.NumericMinimumValue, dtoParm.NumericMaximumValue, dtoParm.RegularExpression,
dtoParm.IsNullable, type, dataTypeName);
parms.Add(dtoParm.ParameterName, mdlParm);
}
return(parms);
}
//Builds parameter name mapping. The parameter name map allows quick mapping of friendly names to the actual parameter name @FIRST_NAME maps to @FIRST_NAME, FIRST_NAME, FirstName and firstName
private static Dictionary <string, string> buildParameterNameMapping(dto.Procedure source)
{
Dictionary <string, string> result = new Dictionary <string, string>();
foreach (dto.Parameter dtoParm in source.Parameters)
{
string parameterName = dtoParm.ParameterName;
string shortName = dtoParm.ParameterName.Substring(1); //pulls off @
string JsonName = shortName.ToCamel();
string propertyName = shortName.ToProperCase();
result.Add(parameterName, parameterName);
result.Add(shortName, parameterName);
result.Add(JsonName, parameterName);
result.Add(propertyName, parameterName);
}
return(result);
}
/// <summary>Routine to handle the conversion of the dto.Procedure to model.Procedure.</summary>
/// <param name="source">Source dto.Procedure to convert.</param>
public static Procedure Convert(dto.Procedure source)
{
//Only place this should ever be set!
string procedureName = $"[{source.SpecificSchema}].[{source.SpecificName}]";
Dictionary <string, Models.Parameter> parameters = buildParameters(source);
Dictionary <string, string> parameterNameMapping = buildParameterNameMapping(source);
Procedure proc = new Procedure
(
source.ConnectionString,
procedureName, source.isJsonResult,
source.IsSingleResult,
source.IsNonQuery,
parameters,
parameterNameMapping
);
return(proc);
}
