public virtual int AppendLog(SAFLogData logData) { logData.Id = -1; using (IDbConnection connection = GetConnection()) { // Open the connection for each event, this takes advantage // of the builtin connection pooling connection.Open(); using (IDbCommand command = connection.CreateCommand()) { InitializeCommandInsert(command); SetCommandValues(command, logData); command.ExecuteNonQuery(); //logID = (int)command.ExecuteScalar(); if (command.Parameters.Contains("@LogID")) { IDataParameter logID = command.Parameters["@LogID"] as IDataParameter; if (logID != null && logID.Value is int) logData.Id = (int)logID.Value; } } } return logData.Id; }
public virtual int AppendLog(SAFLogData logData) { logData.Id = -1; using (IDbConnection connection = GetConnection()) { // Open the connection for each event, this takes advantage // of the builtin connection pooling connection.Open(); using (IDbCommand command = connection.CreateCommand()) { InitializeCommandInsert(command); SetCommandValues(command, logData); command.ExecuteNonQuery(); //logID = (int)command.ExecuteScalar(); if (command.Parameters.Contains("@LogID")) { IDataParameter logID = command.Parameters["@LogID"] as IDataParameter; if (logID != null && logID.Value is int) { logData.Id = (int)logID.Value; } } } } return(logData.Id); }
public virtual void UpdateLog(int logID, SAFLogData logData) { using (IDbConnection connection = this.GetConnection()) { connection.Open(); using (IDbCommand dbCommand = connection.CreateCommand()) { this.InitializeCommandUpdate(dbCommand); this.SetCommandValues(dbCommand, logData); dbCommand.ExecuteNonQuery(); } } }
public virtual int DoAppend(SAFLogData logData) { int result = -1; using (IDbConnection connection = this.GetConnection()) { connection.Open(); using (IDbCommand dbCommand = connection.CreateCommand()) { this.InitializeCommandInsert(dbCommand); this.SetCommandValues(dbCommand, logData); result = (int)dbCommand.ExecuteScalar(); } } return result; }
public virtual int DoAppend(SAFLogData logData) { int result = -1; using (IDbConnection connection = this.GetConnection()) { connection.Open(); using (IDbCommand dbCommand = connection.CreateCommand()) { this.InitializeCommandInsert(dbCommand); this.SetCommandValues(dbCommand, logData); result = (int)dbCommand.ExecuteScalar(); } } return(result); }
public virtual void UpdateLog(SAFLogData logData) { using (IDbConnection connection = GetConnection()) { // Open the connection for each event, this takes advantage // of the builtin connection pooling connection.Open(); using (IDbCommand command = connection.CreateCommand()) { InitializeCommandUpdate(command); SetCommandValues(command, logData); command.ExecuteNonQuery(); } } }
virtual protected void SetCommandValues(IDbCommand command, SAFLogData logData) { //Update Only if (command.Parameters.Contains("@Id")) { ((IDbDataParameter)command.Parameters["@Id"]).Value = logData.Id; } //Insert & Update if (command.Parameters.Contains("@Level")) { if (string.IsNullOrEmpty(logData.LevelName)) { ((IDbDataParameter)command.Parameters["@Level"]).Value = DBNull.Value; //It reverts to 'INFO' } else { ((IDbDataParameter)command.Parameters["@Level"]).Value = logData.LevelName; } } //Insert & Update if (command.Parameters.Contains("@Message")) { if (string.IsNullOrEmpty(logData.MessageString)) { ((IDbDataParameter)command.Parameters["@Message"]).Value = DBNull.Value; } else { ((IDbDataParameter)command.Parameters["@Message"]).Value = logData.MessageString; } } //Insert & Update if (command.Parameters.Contains("@Exception")) { if (string.IsNullOrEmpty(logData.ExceptionString)) { ((IDbDataParameter)command.Parameters["@Exception"]).Value = DBNull.Value; } else { ((IDbDataParameter)command.Parameters["@Exception"]).Value = logData.ExceptionString; } } //Insert Only if (command.Parameters.Contains("@Date")) { if (logData.TimeStampUTC == DateTime.MinValue) { ((IDbDataParameter)command.Parameters["@Date"]).Value = DBNull.Value; } else { ((IDbDataParameter)command.Parameters["@Date"]).Value = logData.TimeStampUTC; } } //Insert Only if (command.Parameters.Contains("@Thread")) { if (string.IsNullOrEmpty(logData.ThreadName)) { ((IDbDataParameter)command.Parameters["@Thread"]).Value = string.Empty; } else { ((IDbDataParameter)command.Parameters["@Thread"]).Value = logData.ThreadName; } } //Insert Only if (command.Parameters.Contains("@Logger")) { if (string.IsNullOrEmpty(logData.LoggerName)) { ((IDbDataParameter)command.Parameters["@Logger"]).Value = string.Empty; } else { ((IDbDataParameter)command.Parameters["@Logger"]).Value = logData.LoggerName; } } //Insert Only if (command.Parameters.Contains("@User")) { if (string.IsNullOrEmpty(logData.UserName)) { ((IDbDataParameter)command.Parameters["@User"]).Value = DBNull.Value; } else { ((IDbDataParameter)command.Parameters["@User"]).Value = logData.UserName; } } //Insert Only if (command.Parameters.Contains("@TrnCode")) { ((IDbDataParameter)command.Parameters["@TrnCode"]).Value = logData.TrnCode; } //Insert & Update if (command.Parameters.Contains("@TrnRes")) { ((IDbDataParameter)command.Parameters["@TrnRes"]).Value = logData.TrnRes; } //Insert & Update if (command.Parameters.Contains("@ResponseTime")) { ((IDbDataParameter)command.Parameters["@ResponseTime"]).Value = (DateTime.Now - logData.InitialTimeStamp).Milliseconds; } }
protected virtual void SetCommandValues(IDbCommand command, SAFLogData logData) { if (command.Parameters.Contains("@Id")) { ((IDbDataParameter)command.Parameters["@Id"]).Value = logData.Id; } if (command.Parameters.Contains("@Level")) { if (logData.LevelName == null || logData.LevelName == string.Empty) { ((IDbDataParameter)command.Parameters["@Level"]).Value = DBNull.Value; } else { ((IDbDataParameter)command.Parameters["@Level"]).Value = logData.LevelName; } } if (command.Parameters.Contains("@Message")) { if (logData.MessageString == null || logData.MessageString == string.Empty) { ((IDbDataParameter)command.Parameters["@Message"]).Value = DBNull.Value; } else { ((IDbDataParameter)command.Parameters["@Message"]).Value = logData.MessageString; } } if (command.Parameters.Contains("@Exception")) { if (logData.ExceptionString == null || logData.ExceptionString == string.Empty) { ((IDbDataParameter)command.Parameters["@Exception"]).Value = DBNull.Value; } else { ((IDbDataParameter)command.Parameters["@Exception"]).Value = logData.ExceptionString; } } if (command.Parameters.Contains("@Date")) { if (logData.TimeStampUTC == DateTime.MinValue) { ((IDbDataParameter)command.Parameters["@Date"]).Value = DBNull.Value; } else { ((IDbDataParameter)command.Parameters["@Date"]).Value = logData.TimeStampUTC; } } if (command.Parameters.Contains("@Thread")) { if (logData.ThreadName == null) { ((IDbDataParameter)command.Parameters["@Thread"]).Value = DBNull.Value; } else { ((IDbDataParameter)command.Parameters["@Thread"]).Value = logData.ThreadName; } } if (command.Parameters.Contains("@Logger")) { if (logData.LoggerName == null || logData.LoggerName == string.Empty) { ((IDbDataParameter)command.Parameters["@Logger"]).Value = DBNull.Value; } else { ((IDbDataParameter)command.Parameters["@Logger"]).Value = logData.LoggerName; } } if (command.Parameters.Contains("@User")) { if (logData.UserName == null || logData.UserName == string.Empty) { ((IDbDataParameter)command.Parameters["@User"]).Value = DBNull.Value; return; } ((IDbDataParameter)command.Parameters["@User"]).Value = logData.UserName; } }
virtual protected void SetCommandValues(IDbCommand command, SAFLogData logData) { //Update Only if (command.Parameters.Contains("@Id")) ((IDbDataParameter)command.Parameters["@Id"]).Value = logData.Id; //Insert & Update if (command.Parameters.Contains("@Level")) if (string.IsNullOrEmpty(logData.LevelName)) ((IDbDataParameter)command.Parameters["@Level"]).Value = DBNull.Value; //It reverts to 'INFO' else ((IDbDataParameter)command.Parameters["@Level"]).Value = logData.LevelName; //Insert & Update if (command.Parameters.Contains("@Message")) { if (string.IsNullOrEmpty(logData.MessageString)) ((IDbDataParameter)command.Parameters["@Message"]).Value = DBNull.Value; else ((IDbDataParameter)command.Parameters["@Message"]).Value = logData.MessageString; } //Insert & Update if (command.Parameters.Contains("@Exception")) if (string.IsNullOrEmpty(logData.ExceptionString)) ((IDbDataParameter)command.Parameters["@Exception"]).Value = DBNull.Value; else ((IDbDataParameter)command.Parameters["@Exception"]).Value = logData.ExceptionString; //Insert Only if (command.Parameters.Contains("@Date")) if (logData.TimeStampUTC == DateTime.MinValue) ((IDbDataParameter)command.Parameters["@Date"]).Value = DBNull.Value; else ((IDbDataParameter)command.Parameters["@Date"]).Value = logData.TimeStampUTC; //Insert Only if (command.Parameters.Contains("@Thread")) if (string.IsNullOrEmpty(logData.ThreadName)) ((IDbDataParameter)command.Parameters["@Thread"]).Value = string.Empty; else ((IDbDataParameter)command.Parameters["@Thread"]).Value = logData.ThreadName; //Insert Only if (command.Parameters.Contains("@Logger")) if (string.IsNullOrEmpty(logData.LoggerName)) ((IDbDataParameter)command.Parameters["@Logger"]).Value = string.Empty; else ((IDbDataParameter)command.Parameters["@Logger"]).Value = logData.LoggerName; //Insert Only if (command.Parameters.Contains("@User")) if (string.IsNullOrEmpty(logData.UserName)) ((IDbDataParameter)command.Parameters["@User"]).Value = DBNull.Value; else ((IDbDataParameter)command.Parameters["@User"]).Value = logData.UserName; //Insert Only if (command.Parameters.Contains("@TrnCode")) ((IDbDataParameter)command.Parameters["@TrnCode"]).Value = logData.TrnCode; //Insert & Update if (command.Parameters.Contains("@TrnRes")) ((IDbDataParameter)command.Parameters["@TrnRes"]).Value = logData.TrnRes; //Insert & Update if (command.Parameters.Contains("@ResponseTime")) ((IDbDataParameter)command.Parameters["@ResponseTime"]).Value = (DateTime.Now-logData.InitialTimeStamp).Milliseconds; }
public WSStackerData(string trnName, int trnCode, byte serverID, short trnRes, string loggerName, string user) { StatsData = new SAFStatsData(trnCode, serverID, trnRes); LogData = new SAFLogData(trnCode, trnName, loggerName, user); }