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); }