public DataRow GetRow()
{
if (!DbEnabled)
return null;
DataRow row = null;
switch (DatabaseManager.DatabaseConnectionType.ToLower())
{
case "firebird":
try
{
var dataSet = new DataSet();
using (var adapter = new FbDataAdapter(CommandFireBird))
adapter.Fill(dataSet);
if ((dataSet.Tables.Count > 0) && (dataSet.Tables[0].Rows.Count == 1))
row = dataSet.Tables[0].Rows[0];
}
catch (Exception exception)
{
Writer.Writer.LogQueryError(exception, CommandFireBird.CommandText);
throw exception;
}
break;
case "ingres":
case "ingress":
try
{
var dataSet = new DataSet();
using (var adapter = new IngresDataAdapter(CommandIngress))
adapter.Fill(dataSet);
if ((dataSet.Tables.Count > 0) && (dataSet.Tables[0].Rows.Count == 1))
row = dataSet.Tables[0].Rows[0];
}
catch (Exception exception)
{
Writer.Writer.LogQueryError(exception, CommandIngress.CommandText);
throw exception;
}
break;
case "pgsql":
try
{
var dataSet = new DataSet();
using (var adapter = new NpgsqlDataAdapter(CommandPgSql))
adapter.Fill(dataSet);
if ((dataSet.Tables.Count > 0) && (dataSet.Tables[0].Rows.Count == 1))
row = dataSet.Tables[0].Rows[0];
}
catch (Exception exception)
{
Writer.Writer.LogQueryError(exception, CommandPgSql.CommandText);
throw exception;
}
break;
default:
try
{
var dataSet = new DataSet();
using (var adapter = new MySqlDataAdapter(CommandMySql))
adapter.Fill(dataSet);
if ((dataSet.Tables.Count > 0) && (dataSet.Tables[0].Rows.Count == 1))
row = dataSet.Tables[0].Rows[0];
}
catch (Exception exception)
{
Writer.Writer.LogQueryError(exception, CommandMySql.CommandText);
throw exception;
}
break;
}
return row;
}
public DataTable GetTable()
{
var dataTable = new DataTable();
if (!DbEnabled)
return dataTable;
switch (DatabaseManager.DatabaseConnectionType.ToLower())
{
case "firebird":
try
{
using (var adapter = new FbDataAdapter(CommandFireBird))
adapter.Fill(dataTable);
}
catch (Exception exception)
{
Writer.Writer.LogQueryError(exception, CommandFireBird.CommandText);
throw exception;
}
break;
case "ingres":
case "ingress":
try
{
using (var adapter = new IngresDataAdapter(CommandIngress))
adapter.Fill(dataTable);
}
catch (Exception exception)
{
Writer.Writer.LogQueryError(exception, CommandIngress.CommandText);
throw exception;
}
break;
case "pgsql":
try
{
using (var adapter = new NpgsqlDataAdapter(CommandPgSql))
adapter.Fill(dataTable);
}
catch (Exception exception)
{
Writer.Writer.LogQueryError(exception, CommandPgSql.CommandText);
throw exception;
}
break;
default:
try
{
using (var adapter = new MySqlDataAdapter(CommandMySql))
adapter.Fill(dataTable);
}
catch (Exception exception)
{
Writer.Writer.LogQueryError(exception, CommandMySql.CommandText);
throw exception;
}
break;
}
return dataTable;
}
// Name: CheckVersion - Test the stored schema version
//
// Description:
// Compares the specified version number with the stored version
// If the verson matches or exceeds the required version the
// function returns true.
//
// Inputs:
// Major Major version number.
// Minor Minor version number.
// Release Release version number.
//
// Outputs:
// None.
//
// Returns:
// true Version matches or exceeds the required version.
// false Incorrect version level.
//
// History
// 02-Oct-2006 ([email protected])
// Created.
public bool CheckVersion(int Major, int Minor, int Release)
{
bool retcode = false;
IngresCommand ingresVersionSelect = new IngresCommand();
IngresDataAdapter ingresVersionAdapter;
// Create query parameters and store the method parameter values
// into each one.
IngresParameter majorVersion = new IngresParameter("ver_major", IngresType.Int);
IngresParameter minorVersion = new IngresParameter("ver_minor", IngresType.Int); ;
IngresParameter releaseVersion = new IngresParameter("ver_release", IngresType.Int);
majorVersion.Value = Major;
minorVersion.Value = Minor;
releaseVersion.Value = Release;
ingresVersionSelect = new IngresCommand(
"SELECT FIRST 1 ver_major, ver_minor, ver_release, ver_date, ver_install" +
" FROM version" +
" WHERE ver_major >= ? AND ver_minor >= ? AND ver_release >=?" +
" ORDER BY ver_id DESC",
ingresConnection1);
ingresVersionSelect.Connection = ingresConnection1;
ingresVersionAdapter = new IngresDataAdapter(ingresVersionSelect);
try
{
ingresVersionSelect.Connection.Open();
ingresVersionSelect.Prepare();
ingresVersionSelect.Parameters.Clear();
ingresVersionSelect.Parameters.Add(majorVersion);
ingresVersionSelect.Parameters.Add(minorVersion);
ingresVersionSelect.Parameters.Add(releaseVersion);
versionDataSet.Clear();
ingresVersionAdapter.Fill(versionDataSet);
if (versionDataSet.Tables[0].Rows.Count > 0)
{
retcode = true;
}
}
catch (Ingres.Client.IngresException ex)
{
if (DisplayError(ex) == DialogResult.OK)
{
throw;
}
else
{
Application.Exit();
}
}
finally
{
if (ingresVersionSelect != null &&
ingresVersionSelect.Connection != null)
ingresVersionSelect.Connection.Close();
}
return (retcode);
}
