/// <summary>
/// Execute a Stored Procedure and returns the result as a DataSet
/// </summary>
protected DataSet ExecuteDataSet(string storedProcedureName
, Hashtable param, int timeout = 0)
{
DataAccessObject dao = new DataAccessObject();
return(dao.GetDataSet(storedProcedureName, param, timeout));
}
/// <summary>
/// Returns a DataTable with rows from stored procedure.
/// Use this function when you need to increase the default db timeout value.
/// (DB timeout default value is 60sec)
/// </summary>
/// <param name="storedProcedureName">stored procedure name</param>
/// <param name="param">hashtable list of parameter name, parameter value.</param>
/// <param name="timeOutSeconds">db timeout value in seconds.</param>
public static DataTable ExecuteDataTable(string storedProcedureName, Hashtable param, int timeOutSeconds)
{
DataAccessObject dao = new DataAccessObject();
dao.TimeOutSeconds = timeOutSeconds;
return(dao.GetDataTable(storedProcedureName, param, timeOutSeconds));
}
/// <summary>
/// Execute a proc and return the results as a data reader.
/// The reader and connection must be closed by the calling function!
/// </summary>
/// <remarks>
/// For speed optimisations.
/// </remarks>
/// <example>
/// using(SqlDataReader results = Data.DataAccessObject.ExecuteDataReader("mysproc", param)){
/// while(result.Read()) {
/// this._outcompanyID = results["out_company"];
/// }
/// }
/// result.close();
/// </example>
public static MySqlDataReader ExecuteDataReader(string storedProcedureName, Hashtable param, int timeout = 0)
{
DataAccessObject dao = new DataAccessObject();
dao.TimeOutSeconds = timeout;
MySqlDataReader reader = dao.ExecuteReader(storedProcedureName, param);
return(reader);
}
public static MySqlDataReader ExecuteDataReaderQuery(string query, Hashtable param, int timeout = 0)
{
DataAccessObject dao = new DataAccessObject();
dao.TimeOutSeconds = timeout;
MySqlDataReader reader = dao.ExecuteReaderQuery(query, param);
return(reader);
}
/// <summary>
/// Executes a stored procedure and returns the first column of the first row in resultset
/// </summary>
public static int ExecuteScalar(string storedProcedureName, Hashtable param, int timeout = 0)
{
DataAccessObject dao = new DataAccessObject();
if (timeout > 0)
{
dao.TimeOutSeconds = timeout;
}
return(dao.ExecuteNonQueryFromSproc(storedProcedureName, param, string.Empty, true));
}
public static object ExecuteScalar(bool IsStoredProcedure, string query, Hashtable param, int timeout = 0)
{
DataAccessObject dao = new DataAccessObject();
if (timeout > 0)
{
dao.TimeOutSeconds = timeout;
}
return(dao.ExecuteScalarQuery(IsStoredProcedure, query, param));
}
/// <summary>
/// Returns a DataTable with rows from stored procedure.
/// Use this function when you need to increase the default db timeout value.
/// (DB timeout default value is 60sec)
/// </summary>
/// <param name="storedProcedureName">stored procedure name</param>
/// <param name="param">hashtable list of parameter name, parameter value.</param>
/// <param name="timeOutSeconds">db timeout value in seconds.</param>
public static DataTable ExecuteDataTable(string storedProcedureName, Hashtable param, int timeOutSeconds)
{
DataAccessObject dao = new DataAccessObject();
dao.TimeOutSeconds = timeOutSeconds;
return dao.GetDataTable(storedProcedureName, param, timeOutSeconds);
}
/// <summary>
/// Execute a Query and returns the result as a DataSet
/// </summary>
public static DataSet ExecuteDataSet(string query)
{
DataAccessObject dao = new DataAccessObject();
return dao.GetDataSet(query);
}
/// <summary>
/// Returns a DataTable with rows from stored procedure.
/// Use this function when the stored procedure requires only one parameter
/// </summary>
/// <param name="storedProcedureName">stored procedure name</param>
/// <param name="param">the MySqlParameter required by the sproc</param>
public static DataTable ExecuteDataTable(string storedProcedureName, MySqlParameter param)
{
DataAccessObject dao = new DataAccessObject();
return dao.GetDataTable(storedProcedureName, param);
}
public static MySqlDataReader ExecuteDataReaderQuery(string query, Hashtable param, int timeout = 0)
{
DataAccessObject dao = new DataAccessObject();
dao.TimeOutSeconds = timeout;
MySqlDataReader reader = dao.ExecuteReaderQuery(query, param);
return reader;
}
/// <summary>
/// Execute a Stored Procedure and returns the result as a DataSet
/// </summary>
protected DataSet ExecuteDataSet(string storedProcedureName
, Hashtable param, int timeout = 0)
{
DataAccessObject dao = new DataAccessObject();
return dao.GetDataSet(storedProcedureName, param, timeout);
}
/// <summary>
/// Execute a Query and returns the result as a DataSet
/// </summary>
public static DataSet ExecuteDataSet(string query)
{
DataAccessObject dao = new DataAccessObject();
return(dao.GetDataSet(query));
}
/// <summary>
/// Execute a proc and return the results as a data reader.
/// The reader and connection must be closed by the calling function!
/// </summary>
/// <remarks>
/// For speed optimisations.
/// </remarks>
/// <example>
/// using(SqlDataReader results = Data.DataAccessObject.ExecuteDataReader("mysproc", param)){
/// while(result.Read()) {
/// this._outcompanyID = results["out_company"];
/// }
/// }
/// result.close();
/// </example>
public static MySqlDataReader ExecuteDataReader(string storedProcedureName, Hashtable param, int timeout = 0)
{
DataAccessObject dao = new DataAccessObject();
dao.TimeOutSeconds = timeout;
MySqlDataReader reader = dao.ExecuteReader(storedProcedureName, param);
return reader;
}
/// <summary>
/// Executes a stored procedure and returns the first column of the first row in result set when idParam is provided.
/// </summary>
/// <param name="storedProcedureName">the name of the stored procedure to be executed</param>
/// <param name="idParam">name of the ID field for sprocs that return an incremental ID as integer</param>
/// <param name="param">a Hashtable list of parameters and values required by the stored procedure.</param>
public static int ExecuteNonQuery(string storedProcedureName, Hashtable param, string idParam)
{
DataAccessObject dao = new DataAccessObject();
return(dao.ExecuteNonQueryFromSproc(storedProcedureName, param, idParam, false));
}
/// <summary>
/// Returns a int with affected rows from the query.
/// </summary>
/// <param name="query">The Select query</param>
public static int ExecuteNonQuery(string query)
{
DataAccessObject dao = new DataAccessObject();
return dao.ExecuteNonQueryFromQuery(query);
}
/// <summary>
/// Returns a DataTable with rows from query.
/// </summary>
/// <param name="query">the query</param>
/// <param name="param">parameters of the query</param>
/// <param name="timeout">Timeout in miliseconds.</param>
public static DataTable ExecuteDataTableQuery(string query, Hashtable param, int timeout = 0)
{
DataAccessObject dao = new DataAccessObject();
return(dao.GetDataTableQuery(query, param, timeout));
}
/// <summary>
/// Executes a stored procedure and returns the first column of the first row in resultset
/// </summary>
public static int ExecuteScalar(string storedProcedureName, Hashtable param, int timeout = 0)
{
DataAccessObject dao = new DataAccessObject();
if (timeout > 0)
{
dao.TimeOutSeconds = timeout;
}
return dao.ExecuteNonQueryFromSproc(storedProcedureName, param, string.Empty, true);
}
/// <summary>
/// Returns a DataTable with rows from query.
/// </summary>
/// <param name="query">the query</param>
public static DataTable ExecuteDataTable(string query)
{
DataAccessObject dao = new DataAccessObject();
return(dao.GetDataTableQuery(query));
}
/// <summary>
/// Returns a int with affected rows from the query.
/// </summary>
/// <param name="query">The Select query</param>
public static int ExecuteNonQuery(string query)
{
DataAccessObject dao = new DataAccessObject();
return(dao.ExecuteNonQueryFromQuery(query));
}
/// <summary>
/// Returns a DataTable with rows from stored procedure.
/// Use this function when the stored procedure requires only one parameter
/// </summary>
/// <param name="storedProcedureName">stored procedure name</param>
/// <param name="param">the MySqlParameter required by the sproc</param>
public static DataTable ExecuteDataTable(string storedProcedureName, MySqlParameter param)
{
DataAccessObject dao = new DataAccessObject();
return(dao.GetDataTable(storedProcedureName, param));
}
/// <summary>
/// Returns a DataTable with rows from query.
/// </summary>
/// <param name="query">the query</param>
public static DataTable ExecuteDataTable(string query)
{
DataAccessObject dao = new DataAccessObject();
return dao.GetDataTableQuery(query);
}
/// <summary>
/// Returns a int with affected rows from the query.
/// </summary>
/// <param name="query">The Select query</param>
/// <param name="param">Hashtable with parameters</param>
public static int ExecuteNonQuery(string query, Hashtable param)
{
DataAccessObject dao = new DataAccessObject();
return dao.ExecuteNonQueryFromQuery(query, param);
}
/// <summary>
/// Returns a DataTable with rows from query.
/// </summary>
/// <param name="query">the query</param>
/// <param name="param">parameters of the query</param>
/// <param name="timeout">Timeout in miliseconds.</param>
public static DataTable ExecuteDataTableQuery(string query, Hashtable param, int timeout = 0)
{
DataAccessObject dao = new DataAccessObject();
return dao.GetDataTableQuery(query, param, timeout);
}
/// <summary>
/// Returns a int with affected rows from the query.
/// </summary>
/// <param name="query">The Select query</param>
/// <param name="param">Hashtable with parameters</param>
public static int ExecuteNonQuery(string query, Hashtable param)
{
DataAccessObject dao = new DataAccessObject();
return(dao.ExecuteNonQueryFromQuery(query, param));
}
public static object ExecuteScalar(bool IsStoredProcedure, string query, Hashtable param, int timeout = 0)
{
DataAccessObject dao = new DataAccessObject();
if (timeout > 0)
{
dao.TimeOutSeconds = timeout;
}
return dao.ExecuteScalarQuery(IsStoredProcedure, query, param);
}
/// <summary>
/// Executes a stored procedure and returns the first column of the first row in result set when idParam is provided.
/// </summary>
/// <param name="storedProcedureName">the name of the stored procedure to be executed</param>
/// <param name="idParam">name of the ID field for sprocs that return an incremental ID as integer</param>
/// <param name="param">a Hashtable list of parameters and values required by the stored procedure.</param>
public static int ExecuteNonQuery(string storedProcedureName, Hashtable param, string idParam)
{
DataAccessObject dao = new DataAccessObject();
return dao.ExecuteNonQueryFromSproc(storedProcedureName, param, idParam, false);
}
