private static void AddOrRemplaceParameters(DbParameterCollection existingParameters, IEnumerable <DbParameter> newParameters)
{
string prefix = DataParameter.GetPrefixParameter(existingParameters);
// Remove existing parameters found in Values properties
for (int i = existingParameters.Count - 1; i >= 0; i--)
{
string parameterName = existingParameters[i].ParameterName;
if (newParameters.Any(p => String.Compare(p.ParameterName, parameterName, true) == 0 ||
String.Compare($"{prefix}{p.ParameterName}", parameterName, true) == 0))
{
existingParameters.RemoveAt(i);
}
}
// Add parameters found in Values properties
foreach (var param in newParameters)
{
if (!param.ParameterName.EndsWith(prefix))
{
param.ParameterName = $"{prefix}{param.ParameterName}";
}
existingParameters.Add(param);
}
}
/// <summary>
/// This sub removes a parameter.
/// </summary>
/// <param name="paramName">Name of the parameter.</param>
/// <seealso cref="AddParameter(string,object,PKSim.Infrastructure.ORM.DAS.DAS.ParameterModes)"></seealso>
/// <seealso
/// cref="AddParameter(string,object,PKSim.Infrastructure.ORM.DAS.DAS.ParameterModes,PKSim.Infrastructure.ORM.DAS.DAS.ServerTypes)">
/// </seealso>
/// <exception cref="NotConnectedException">Thrown when there is no established connection.</exception>
public void RemoveParameter(string paramName)
{
if (IsConnected)
{
if (paramName.StartsWith("@"))
{
_parameters.RemoveAt(paramName);
}
else
{
_parameters.RemoveAt(string.Concat("@", paramName));
}
}
else
{
throw new NotConnectedException();
}
}
public override void RemoveAt(string parameterName)
{
int k = -1;
for (int i = 0; i < list_params.Count; ++i)
{
if (parameterName == list_params[i].ParameterName)
{
k = i;
break;
}
}
if (k > -1)
{
list_params.RemoveAt(k);
}
m_parameters.RemoveAt(parameterName);
}
public static FbParameter SetValue(this DbParameterCollection parameters, string parameterName, FbDbType dbType, FbCharset charset, int size)
{
var param = new FbParameter {
ParameterName = parameterName, FbDbType = dbType, Charset = charset, Size = size
};
if (parameters.Contains(parameterName))
{
parameters.RemoveAt(parameterName);
}
parameters.Add(param);
return(param);
}
public static SqlParameter SetValue(this DbParameterCollection parameters, string parameterName, SqlDbType dbType, int size)
{
var param = new SqlParameter {
ParameterName = parameterName, SqlDbType = dbType, Size = size
};
if (parameters.Contains(parameterName))
{
parameters.RemoveAt(parameterName);
}
parameters.Add(param);
return(param);
}
public static SQLiteParameter SetValue(this DbParameterCollection parameters, string parameterName, DbType dbType)
{
var param = new SQLiteParameter {
ParameterName = parameterName, DbType = dbType
};
if (parameters.Contains(parameterName))
{
parameters.RemoveAt(parameterName);
}
parameters.Add(param);
return(param);
}
public override void RemoveAt(string parameterName)
{
_parameterCollection.RemoveAt(parameterName);
}
