/// <summary>
/// Set the DataAdapter into this CommandBuilder.
/// </summary>
/// <param name="adapter"></param>
protected override void SetRowUpdatingHandler(DbDataAdapter adapter)
{
IngresDataAdapter oldAdapter = this.DataAdapter as IngresDataAdapter;
IngresDataAdapter newAdapter = adapter as IngresDataAdapter;
// remove old event handler (this.DataAdapter is in use)
if (oldAdapter != null)
{
oldAdapter.RowUpdating -=
new IngresRowUpdatingEventHandler(this.RowUpdatingHandler);
return;
}
// add new event handler (this.DataAdapter is not in use)
if (newAdapter != null)
{
newAdapter.RowUpdating +=
new IngresRowUpdatingEventHandler(this.RowUpdatingHandler);
}
} // SetRowUpdatingHandler
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;
}
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;
}
/// <summary>
/// Ingres implementatin of DbCommandBuilder to assist in
/// automatically generating single-table commands for
/// DataSet to database reconciliation.
/// </summary>
/// <param name="adapter"></param>
public IngresCommandBuilder(IngresDataAdapter adapter)
: this()
{
this.DataAdapter = adapter;
}
// 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);
}
private void InitializeIngres()
{
versionDataSet = new DataSet();
// The following query text is used to show the syntax for
// executing a database procedure.
ingresSelectCommand4 = new IngresCommand(
"{ call get_my_airports( ccode = ?, area = ? ) }",
ingresConnection1);
ingresSelectCommand4.Connection = ingresConnection1;
ingresDataAdapter4 = new IngresDataAdapter(ingresSelectCommand4);
ingresSelectCommand7 = new IngresCommand(
"SELECT up_email FROM user_profile ORDER BY up_email");
ingresSelectCommand7.Connection = ingresConnection1;
ingresDataAdapter7 = new IngresDataAdapter(ingresSelectCommand7);
ingresSelectCommand8 = new IngresCommand(
"SELECT airport.ap_iatacode, airport.ap_place, " +
"country.ct_name " +
"FROM airport, country " +
"WHERE airport.ap_ccode = country.ct_code " +
"AND airport.ap_iatacode = ?");
ingresSelectCommand8.Connection = ingresConnection1;
ingresDataAdapter8 = new IngresDataAdapter(ingresSelectCommand8);
if (CheckVersion() == false)
{
// Incorrect version exception.
// Get the string from the string table
Exception badVersion = new Exception(rm.GetString("ErrorVersion"));
throw badVersion;
}
}
/// <summary>
/// Ingres implementatin of DbCommandBuilder to assist in
/// automatically generating single-table commands for
/// DataSet to database reconciliation.
/// </summary>
/// <param name="adapter"></param>
public IngresCommandBuilder(IngresDataAdapter adapter)
: this()
{
this.DataAdapter = adapter;
}
/// <summary>
/// Create a new DataAdapter object from an old DataAdapter.
/// </summary>
/// <param name="oldAdapter">Old DataAdapter to clone from.</param>
private IngresDataAdapter(IngresDataAdapter oldAdapter)
: base(oldAdapter)
{
}
} // end constructor DataAdapter
/// <summary>
/// Create a new DataAdapter object from an old DataAdapter.
/// </summary>
/// <param name="oldAdapter">Old DataAdapter to clone from.</param>
private IngresDataAdapter(IngresDataAdapter oldAdapter) :
base(oldAdapter)
{
} // end constructor DataAdapter