private void UpdateCommandParameters(DbCommand dbCommand, JsCommand jsCommand)
{
foreach (DbParameter param in dbCommand.Parameters)
{
JsCommandParameter jparam = [email protected](x => x.name == param.ParameterName);
if (jparam == null)
{
continue;
}
jparam.value = param.Value;
}
}
private void AddCommandParameters(DbCommand dbCommand, JsCommand jsCommand, object prev = null)
{
dbCommand.Parameters.Clear();
for (int i = 0; i < [email protected]; i++)
{
JsCommandParameter cp = jsCommand.@params[i];
DbParameter param = dbCommand.CreateParameter();
param.ParameterName = cp.name;
object paramVal = cp.value;
//Check if the parameter is a special $prev parameter.
//If so, then use the prev argument.
if (paramVal != null && paramVal.ToString().ToLower() == "$prev")
{
paramVal = prev;
}
if (paramVal == null)
{
param.Value = DBNull.Value;
}
else
{
param.Value = paramVal;
}
param.Direction = (ParameterDirection)cp.direction;
param.IsNullable = cp.isNullable;
if (cp.precision != null)
{
param.Precision = (byte)cp.precision;
}
if (cp.scale != null)
{
param.Scale = (byte)cp.scale;
}
if (cp.size != null)
{
param.Size = (byte)cp.size;
}
dbCommand.Parameters.Add(param);
}
}
