private void AddVariableParameters(ref string sqlQuery, List <SqlParameter> queryParams)
{
if (!string.IsNullOrWhiteSpace(sqlQuery))
{
IDataManageEngine dataManageEngine = new DataManageEngine(base.EngineSharedModel, base.UnitOfWork);
List <string> extractedParams = DomainUtility.GetParameters(sqlQuery);
foreach (string parameter in extractedParams)
{
if (!queryParams.Any(c => c.ParameterName == parameter.Replace(".", "_")) && Regex.Matches(sqlQuery, "declare(\\s*?)" + parameter).Count == 0)
{
var result = dataManageEngine.GetValueByBinding(parameter.TrimStart('@'));
if (result != null)
{
queryParams.Add(new SqlParameter(parameter.Replace(".", "_"), result));
sqlQuery = sqlQuery.Replace(parameter, parameter.Replace(".", "_"));
}
}
}
}
}