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