}//END StoreProcUpdate method
// =====================================================================================
/// <summary>
/// public QueryUpdate method
///
/// Execute a SqlCommand (that returns no resultset) against the database specified in the connection string
/// using a stored procedure and the provided parameters.
/// </summary>
/// <remarks>
/// e.g.:
/// int result = StoreProcUpdate("PublishOrders", new SqlParameter("@prodid", 24));
/// </remarks>
/// <param name="UpdateCommand">the name of the stored procedure to be used.)</param>
/// <param name="CommandParameters">an array of SqlParamters used to execute the groupCommand</param>
/// <returns>an int representing the number of rows affected by the groupCommand</returns>
// -------------------------------------------------------------------------------------
public static int QueryUpdate(string UpdateCommand, params SqlParameter [] CommandParameters)
{
//
// Initialise method variables and objects.
//
int iResult = 0;
using (SqlConnection conn = new SqlConnection(_connectionString))
{
conn.Open( );
using (SqlTransaction trans = conn.BeginTransaction( ))
{
try
{
iResult = EvSqlMethods.ExecuteNonQuery(
trans, CommandType.Text, UpdateCommand, CommandParameters);
trans.Commit( );
}
catch (Exception Ex)
{
trans.Rollback( );
string eventMessage = "Status: + " + EvSqlMethods.Status
+ "\r\n Connection String" + _connectionString
+ "\r\n Query: \r\n" + UpdateCommand
+ "\r\n Exception: \r\n" + Evado.Model.EvStatics.getException(Ex);
Evado.Model.EvStatics.WriteToEventLog(_eventLogSource, eventMessage, EventLogEntryType.Error);
throw (Ex);
}
}
return(iResult);
}
}//END QueryUpdate method
}//END getBoolean static method
//++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
#endregion
#region Reader column count methods
/*
* // =====================================================================================
* /// <summary>
* /// public getGuid static method
* ///
* /// Description:
* /// Reads the row object and returns the newField name as a Gu
* /// </summary>
* /// <param name="Row">OdbcDataReader</param>
* /// <param name="_id.
* /// Document">Document</param>
* // -------------------------------------------------------------------------------------
* public static DocumentGuid getGuid ( SqlDataReader Reader, int Column )
* {
* if ( Reader [ Column ] != null )
* {
* string sValue = Reader [ Column ].ToString( ).Trim( );
* if ( sValue.Length == 36 )
* {
* return new DocumentGuid( sValue );
* }
* }
*
* return DocumentGuid.Empty;
*
* }//END getGuid static method
*
* // =====================================================================================
* /// <summary>
* /// public getInteger static method
* ///
* /// Description:
* /// Reads the row object and returns the newField name as a Integer.
* ///
* /// </summary>
* /// <param name="Row">OdbcDataReader</param>
* /// <param name="document">Document</param>
* // -------------------------------------------------------------------------------------
* public static int getInteger ( SqlDataReader Reader, int Column )
* {
* int iValue = 0;
*
* if ( Reader [ Column ] != null )
* {
* if ( int.TryParse( Reader [ Column ].ToString( ), out iValue ) == false )
* {
* return 0;
* }
* }
*
* return iValue;
*
* }//END getInteger static method
*
* // =====================================================================================
* /// <summary>
* /// public getDateTime static method
* ///
* /// Description:
* /// Reads the row object and returns the newField name as a DateTime object.
* ///
* /// </summary>
* /// <param name="Row">OdbcDataReader</param>
* /// <param name="document">Document</param>
* // -------------------------------------------------------------------------------------
* public static DateTime getDateTime ( SqlDataReader Reader, int Column )
* {
* DateTime dValue = DateTime.Parse( "1 Jan 1900" );
*
* if ( Reader [ Column ] != null )
* {
* if ( DateTime.TryParse( Reader [ Column ].ToString( ), out dValue ) == false )
* {
* return DateTime.Parse( "1 Jan 1900" );
* }
* }
*
* return dValue;
*
* }//END getDateTime static method
*
* // =====================================================================================
* /// <summary>
* /// public getString static method
* ///
* /// Description:
* /// Reads the row object and returns the newField name as a string.
* ///
* /// </summary>
* /// <param name="Row">OdbcDataReader</param>
* /// <param name="document">Document</param>
* // -------------------------------------------------------------------------------------
* public static string getString ( SqlDataReader Reader, int Column )
* {
* if ( Reader [ Column ] != null )
* {
* return Reader [ Column ].ToString( ).Trim( );
* }
* return String.Empty;
*
* }//END getString static method
*
* // =====================================================================================
* /// <summary>
* /// public getFloat static method
* ///
* /// Description:
* /// Reads the row object and returns the newField name as a FormUid.
* ///
* /// </summary>
* /// <param name="Row">OdbcDataReader</param>
* /// <param name="document">Document</param>
* // -------------------------------------------------------------------------------------
* public static float getFloat ( SqlDataReader Reader, int Column )
* {
* float fValue = 0 ;
*
* if ( Reader [ Column ] != null )
* {
* if ( float.TryParse( Reader [ Column ].ToString( ), out fValue ) == false )
* {
* return 0 ;
* }
* }
*
* return fValue;
*
* }//END getFloat static method
*/
//++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
#endregion
//++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
#endregion
#region Update Methods
// =====================================================================================
/// <summary>
/// public StoreProcUpdate method
///
/// Execute a SqlCommand (that returns no resultset) against the database specified in the connection string
/// using a stored procedure and the provided parameters.
/// </summary>
/// <remarks>
/// e.g.:
/// int result = StoreProcUpdate("PublishOrders", new SqlParameter("@prodid", 24));
/// </remarks>
/// <param name="StoreProcedureName">the name of the stored procedure to be used.)</param>
/// <param name="CommandParameters">an array of SqlParamters used to execute the groupCommand</param>
/// <returns>an int representing the number of rows affected by the groupCommand</returns>
// -------------------------------------------------------------------------------------
public static int StoreProcUpdate(string StoreProcedureName, params SqlParameter [] CommandParameters)
{
int iResult = 0;
using (SqlConnection conn = new SqlConnection(_connectionString))
{
conn.Open( );
using (SqlTransaction trans = conn.BeginTransaction( ))
{
try
{
iResult = EvSqlMethods.ExecuteNonQuery(
trans,
CommandType.StoredProcedure,
StoreProcedureName,
CommandParameters);
trans.Commit( );
}
catch (Exception Ex)
{
trans.Rollback( );
EventLog.WriteEntry(_eventLogSource, Ex.Message.ToString( ), EventLogEntryType.Error);
throw (Ex);
}
}
return(iResult);
}
}//END StoreProcUpdate method