/// <summary>
/// Insert a Value into option_values
/// </summary>
/// <param name="OptionValue">The default Value to insert</param>
/// <param name="prompt">To prompt or not prompt for a user specified value</param>
/// <param name="PromptOptionPathText">Option Path for the prompt</param>
/// <param name="PromptOptionDescriptionText">Option Description for the prompt</param>
/// <returns>The Index of the new value from the option_values table</returns>
private int InsertValue(string OptionValue, bool prompt, string PromptOptionPathText, string PromptOptionDescriptionText)
{
string[] Sql = new string[1];
string Sql2 = null;
int Value_ID = 0;
DbDataReader Reader;
try
{
Sql[0] = "INSERT INTO option_values (string) VALUES ('" + OptionValue + "')";
Sql2 = "SELECT LAST_INSERT_ID() as value_id";
Reader = _dsn.RunQueryNonQuery(Sql, Sql2);
if (Reader.Read())
{
Value_ID = Reader.GetInt32(0);
}
else
{
Value_ID = 0;
}
}
catch (Exception ex)
{
Console.Write(ex.Message);
}
return(Value_ID);
}