/// <summary>
/// Programmatically generate an insert command
/// </summary>
/// <param name="args"> The array of Values in an insert command </param>
/// <returns> The insert command string </returns>
protected string insertValues(params object[] args)
{
try
{
insertQuery = "INSERT INTO " + tableName + "(";
int n = fieldsname.Length;
int lastIndex = n - 1;
for (int i = 0; i < n; i++)
{
if (i == lastIndex)
{
insertQuery += fieldsname[i];
}
else
{
insertQuery += fieldsname[i] + ", ";
}
}
insertQuery += ") VALUES(";
n = args.Length;
lastIndex = n - 1;
for (int i = 0; i < n; i++)
{
string argsWithQuote = "'{" + i + "}'";
string argsWithoutQuote = "{" + i + "}";
if (args[i] is Int32 || args[i] is Decimal)
{
if (i == lastIndex)
{
insertQuery += argsWithoutQuote;
}
else
{
insertQuery += argsWithoutQuote + ", ";
}
}
if (args[i] is string)
{
string foo = (string)args[i];
if (foo.Contains('(') && foo.Contains(')') || foo == "null")
{
if (i == lastIndex)
{
insertQuery += argsWithoutQuote;
}
else
{
insertQuery += argsWithoutQuote + ", ";
}
continue;
}
if (i == lastIndex)
{
insertQuery += argsWithQuote;
}
else
{
insertQuery += argsWithQuote + ", ";
}
}
}
insertQuery += ")";
return(String.Format(insertQuery, args));
}
catch (Exception ex)
{
ErrorLog.Log(ex);
return(string.Empty);
}
}