/// <summary>
/// Constructs the parameter using the DESQLParamater instance
/// </summary>
/// <param name="paramName">Name of the parameter.</param>
/// <param name="paramValue">The parameter value.</param>
/// <param name="paramType">Type of the parameter. Default SqlDbType.NVarchar</param>
/// <param name="paramDirection">The parameter direction. Default ParameterDirection.Input</param>
/// <returns>DESQLParameter instance with details</returns>
protected DESQLParameter ConstructParameter(string paramName, object paramValue, SqlDbType paramType = SqlDbType.NVarChar, ParameterDirection paramDirection = ParameterDirection.Input)
{
DESQLParameter parameterPiece = new DESQLParameter();
parameterPiece.ParamDirection = paramDirection;
parameterPiece.ParamName = paramName;
parameterPiece.ParamType = paramType;
parameterPiece.ParamValue = paramValue;
return(parameterPiece);
}
/// <summary>
/// Attaches the parameters to the given SQL command instance
/// </summary>
/// <param name="givenSqlCommand">The given SQL command.</param>
/// <returns></returns>
private ErrorObj AttachParametersToCommand(SqlCommand givenSqlCommand)
{
ErrorObj err = new ErrorObj();
if (!(_commandElement.CommandParameter == null))
{
if (_commandElement.CommandParameter.Count > 0)
{
System.Collections.Generic.List <DESQLParameter> paramaterList = _commandElement.CommandParameter;
DESQLParameter parameterPiece = default(DESQLParameter);
foreach (DESQLParameter tempLoopVar_parameterPiece in paramaterList)
{
parameterPiece = tempLoopVar_parameterPiece;
SqlParameter tempSqlParameter = new SqlParameter();
if ((!(err.HasError)) && HasValue(parameterPiece.ParamName))
{
tempSqlParameter.ParameterName = parameterPiece.ParamName;
}
else
{
err.HasError = true;
err.ErrorMessage = ERROR_COMMANDPARAMETERNAME;
break;
}
//If paramValue is nothing considering it as DBNull.Value
if (parameterPiece.ParamValue == null)
{
tempSqlParameter.Value = DBNull.Value;
}
else
{
if ((!(err.HasError)) && HasValue(parameterPiece.ParamValue, parameterPiece.ParamType))
{
tempSqlParameter.SqlDbType = parameterPiece.ParamType;
tempSqlParameter.Value = parameterPiece.ParamValue;
}
else
{
err.HasError = true;
err.ErrorMessage = ERROR_COMMANDPARAMETERTYPEVALUE;
break;
}
}
if (!(err.HasError))
{
if (parameterPiece.ParamDirection == null)
{
parameterPiece.ParamDirection = ParameterDirection.Input;
}
tempSqlParameter.Direction = parameterPiece.ParamDirection;
}
if (!(err.HasError))
{
givenSqlCommand.Parameters.Add(tempSqlParameter);
}
tempSqlParameter = null;
}
parameterPiece = null;
//tempSqlParameter = Nothing
}
}
return(err);
}
