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