public string AdvDBErrorExtract(int index)
{
string error = "";
AdvInitDBFunctoidHelperList();
try
{
if (myDBFunctoidHelperList.Contains(index))
{
AdvDBFunctoidHelper helper = (AdvDBFunctoidHelper)myDBFunctoidHelperList[index];
if (helper != null)
{
error = helper.Error;
}
}
}
catch (Exception)
{
}
if (error == null)
{
error = "";
}
return(error);
}
public string AdvDBValueExtract(int index, string columnName)
{
string str = "";
AdvInitDBFunctoidHelperList();
if (myDBFunctoidHelperList.Contains(index) && !string.IsNullOrEmpty(columnName))
{
AdvDBFunctoidHelper helper = (AdvDBFunctoidHelper)myDBFunctoidHelperList[index];
columnName = columnName.ToLower(CultureInfo.InvariantCulture);
object obj2 = helper.MapValues[columnName];
if (obj2 != null)
{
str = obj2.ToString();
}
}
return(str);
}
public string AdvDBLookup(int index, string connectionString, string table, string where)
{
AdvDBFunctoidHelper helper = null;
bool flag = false;
AdvInitDBFunctoidHelperList();
if (!myDBFunctoidHelperList.Contains(index))
{
helper = new AdvDBFunctoidHelper();
myDBFunctoidHelperList.Add(index, helper);
}
else
{
helper = (AdvDBFunctoidHelper)myDBFunctoidHelperList[index];
}
try
{
if (((helper.ConnectionString == null) || ((helper.ConnectionString != null) && (string.Compare(helper.ConnectionString, connectionString, StringComparison.Ordinal) != 0))) || (helper.Connection.State != ConnectionState.Open))
{
flag = true;
helper.MapValues.Clear();
helper.Error = "";
if (helper.Connection.State == ConnectionState.Open)
{
helper.Connection.Close();
}
helper.ConnectionString = connectionString;
helper.Connection.ConnectionString = connectionString;
helper.Connection.Open();
}
if ((flag || (string.Compare(helper.Table, table, StringComparison.Ordinal) != 0)) || (((string.Compare(helper.Where, where, StringComparison.OrdinalIgnoreCase) != 0)) || ((helper.Error != null) && (helper.Error.Length > 0))))
{
helper.Table = table;
helper.Where = where;
helper.MapValues.Clear();
helper.Error = "";
using (OleDbCommand command = new OleDbCommand("SELECT * FROM " + table + " WHERE " + where, helper.Connection))
{
IDataReader reader = command.ExecuteReader();
if (reader.Read())
{
for (int i = 0; i < reader.FieldCount; i++)
{
string str = reader.GetName(i).ToLower(CultureInfo.InvariantCulture);
object obj2 = reader.GetValue(i);
helper.MapValues[str] = obj2;
}
}
reader.Close();
}
}
}
catch (OleDbException exception)
{
if (exception.Errors.Count > 0)
{
helper.Error = exception.Errors[0].Message;
}
}
catch (Exception exception2)
{
helper.Error = exception2.Message;
}
finally
{
if (helper.Connection.State == ConnectionState.Open)
{
helper.Connection.Close();
}
}
return(index.ToString(CultureInfo.InvariantCulture));
}