public void Parse(SqlCommand sqlCommand)
{
IList<Replacement> lsReplacement = new List<Replacement>();
foreach (Match match in RegexPattern.CustomParameterPattern.Matches(sqlCommand.Text))
{
string envParam = match.Groups["EnvValParam"].Value.Trim();
if (string.IsNullOrEmpty(envParam)) continue;
EnvValName envValText = new EnvValName(envParam);
if (_hasArgs)
{
if (!envValText.HasArgs()) continue;
}
else
{
if (envValText.HasArgs()) continue;
}
var envVal = EnvValRepository.Instance.GetEvnVal(envValText);
if (!string.IsNullOrEmpty(envVal == null ? null : envVal.ToString()))
{
lsReplacement.Add(new Replacement()
{
OldText = match.Value,
NewText = envVal.ToString()
});
continue;
}
}
foreach (var replacement in lsReplacement)
{
sqlCommand.Text = sqlCommand.Text.Replace(replacement.OldText, replacement.NewText);
}
}
