private void processParameters(XmlDocument doc)
{
XmlNodeList xmlLst1 = doc.SelectNodes("/TransactionDetail/Parameters");
this.lst.Clear();
foreach (XmlNode xn in xmlLst1)
{
ParameterBE paramBe = new ParameterBE();
paramBe.Name = xn["Name"].InnerText;
if (xn["Value"] != null)
{
paramBe.Value = xn["Value"].InnerText;
}
paramBe.Type = xn["Type"].InnerText;
paramBe.Direction = xn["Direction"].InnerText;
this.lst.Add(paramBe);
}
}
private string getSQLValueTyped(ParameterBE param)
{
string res = string.Empty;
res = param.Value.Trim();
if (res.Length != 0)
{
if (param.Type.CompareTo("Alphanumeric") == 0)
{
res = "'" + res + "'";
}
if (param.Type.CompareTo("DateTime") == 0)
{
res = "TO_DATE ('" + res.Substring(0, 10).Trim() + "',DD/MM/RRRR)";
}
}
else
{
res = "NULL";
}
return(res);
}