/// <summary>
/// The third parameter is added for audit - framework
/// It will hold the entity id. If this id/user id is passed as empty no audit entry will be made
/// </summary>
/// <param name="cmd"></param>
/// <param name="userId"></param>
/// <param name="contextId"></param>
/// <returns></returns>
public int execInsertUpdate(String cmd, String userId)
{
int count = 0;
try
{
// orclCmd = new OracleCommand(cmd, orclConn);
// count = orclCmd.ExecuteNonQuery();
sqlCmd = new SqlCommand(cmd, sqlConn);
count = sqlCmd.ExecuteNonQuery();
AuditData.createAuditRecordForCommand(cmd,
System.Web.HttpContext.Current.Session[Connections.LOGGED_IN_USER_ID_STRING].ToString(),
System.Web.HttpContext.Current.Session[Connections.MAIN_BUSINESS_ENTITY_ID_STRING].ToString());
}
catch (Exception e)
{
//throw e;
}
finally
{
//It can be logged only if there is no problem in creating the connection
//cmd = INSERT_DB_LOG + "(" + cmd + "," + (DateTime.Now) + "," + (userId != null ? userId : "") + ")";
//orclCmd = new OracleCommand(cmd, orclConn);
//orclCmd.ExecuteNonQuery();
}
return(count);
}