public void WriteTrace(string RequestID, string WebMethodName, string TaskName, int SerialNumCount, DateTime startTime, DateTime endTime, double duration) { try { SqlParameter[] arParms = new SqlParameter[7]; arParms[0] = new SqlParameter("@RequestID", SqlDbType.VarChar, 50); arParms[0].Value = RequestID; arParms[0].Direction = ParameterDirection.Input; arParms[1] = new SqlParameter("@WebMethodName", SqlDbType.VarChar, 50); arParms[1].Value = WebMethodName; arParms[1].Direction = ParameterDirection.Input; arParms[2] = new SqlParameter("@TaskName", SqlDbType.VarChar, 255); arParms[2].Value = TaskName; arParms[2].Direction = ParameterDirection.Input; arParms[3] = new SqlParameter("@SNumCount", SqlDbType.Int); arParms[3].Value = SerialNumCount; arParms[3].Direction = ParameterDirection.Input; arParms[4] = new SqlParameter("@StartTime", SqlDbType.DateTime); arParms[4].Value = startTime; arParms[4].Direction = ParameterDirection.Input; arParms[5] = new SqlParameter("@EndTime", SqlDbType.DateTime); arParms[5].Value = endTime; arParms[5].Direction = ParameterDirection.Input; arParms[6] = new SqlParameter("@Duration", SqlDbType.Float); arParms[6].Value = duration; arParms[6].Direction = ParameterDirection.Input; using (SqlConnection objCon = new SqlConnection(connectionString)) { string strSQL = @"INSERT INTO TAA_PerformanceAnalyzerTrace (RequestID, WebMethodName, [TaskName],[SNumCount], [StartTime], [EndTime], Duration) values (@RequestID, @WebMethodName, @TaskName,@SNumCount,@StartTime, @EndTime, @Duration)" ; objCon.Open(); using (SqlCommand objCMD = new SqlCommand(strSQL, objCon)) { objCMD.CommandType = CommandType.Text; objCMD.Connection = objCon; objCMD.Parameters.AddRange(arParms); objCMD.ExecuteNonQuery(); } } } catch (Exception ex) { objEventLogger.WriteEntry(ex.Message); } }
//pTAA_LogTransaction //check if time can be tracked here public void LogTransaction(string RequestId, DateTime RequestDatetime, string RequestingSystem, string Request, string ResponseID, DateTime ResponseDateTime, string Response, int ResponseStatus, string ResponseMessage, int TransactionID) { try { using (SqlConnection objCon = new SqlConnection(connectionString)) { SqlParameter[] arParms = new SqlParameter[10]; arParms[0] = new SqlParameter("@RequestDatetime", SqlDbType.DateTime); arParms[0].Value = RequestDatetime; arParms[0].Direction = ParameterDirection.Input; arParms[1] = new SqlParameter("@RequestingSystem", SqlDbType.VarChar, 40); arParms[1].Value = (RequestingSystem == null ? "-1" : RequestingSystem); arParms[1].Direction = ParameterDirection.Input; arParms[2] = new SqlParameter("@Request", SqlDbType.Xml); arParms[2].Value = (Request == null ? "" : Request); arParms[2].Direction = ParameterDirection.Input; arParms[3] = new SqlParameter("@ResponseID", SqlDbType.VarChar, 40); arParms[3].Value = (ResponseID == null ? "-1" : ResponseID); arParms[3].Direction = ParameterDirection.Input; arParms[4] = new SqlParameter("@ResponseDateTime", SqlDbType.DateTime); arParms[4].Value = ResponseDateTime; arParms[4].Direction = ParameterDirection.Input; arParms[5] = new SqlParameter("@Response", SqlDbType.Xml); arParms[5].Value = (Response == null ? "" : Response); arParms[5].Direction = ParameterDirection.Input; arParms[6] = new SqlParameter("@ResponseStatus", SqlDbType.Int); arParms[6].Value = ResponseStatus; arParms[6].Direction = ParameterDirection.Input; arParms[7] = new SqlParameter("@ResponseMessage", SqlDbType.VarChar, 100); arParms[7].Value = ResponseMessage == null ? "" : ResponseMessage; arParms[7].Direction = ParameterDirection.Input; arParms[8] = new SqlParameter("@TransactionID", SqlDbType.Int); if (TransactionID > 0) { arParms[8].Value = TransactionID; } arParms[8].Direction = ParameterDirection.Input; arParms[9] = new SqlParameter("@RequestID", SqlDbType.VarChar, 40); arParms[9].Value = RequestId; arParms[9].Direction = ParameterDirection.Input; using (SqlCommand objCMD = new SqlCommand("pTAA_LogTransaction", objCon)) { objCon.Open(); objCMD.CommandType = CommandType.StoredProcedure; objCMD.Connection = objCon; objCMD.Parameters.AddRange(arParms); objCMD.ExecuteNonQuery(); } } } catch (Exception ex) { objEventLogger.WriteEntry("LogTransaction" + ex.Message + Environment.NewLine + ex.StackTrace); //WriteEntry(ex.Message); } }