/// <summary>
/// Inserts a log item
/// </summary>
/// <param name="logTypeId">Log item type identifier</param>
/// <param name="severity">The severity</param>
/// <param name="message">The short message</param>
/// <param name="exception">The full exception</param>
/// <param name="ipAddress">The IP address</param>
/// <param name="customerId">The customer identifier</param>
/// <param name="pageUrl">The page URL</param>
/// <param name="referrerUrl">The referrer URL</param>
/// <param name="createdOn">The date and time of instance creationL</param>
/// <returns>Log item</returns>
public override DBLog InsertLog(int logTypeId, int severity, string message,
string exception, string ipAddress, int customerId,
string pageUrl, string referrerUrl, DateTime createdOn)
{
DBLog item = null;
Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString);
DbCommand dbCommand = db.GetStoredProcCommand("Nop_LogInsert");
db.AddOutParameter(dbCommand, "LogID", DbType.Int32, 0);
db.AddInParameter(dbCommand, "LogTypeID", DbType.Int32, logTypeId);
db.AddInParameter(dbCommand, "Severity", DbType.Int32, severity);
db.AddInParameter(dbCommand, "Message", DbType.String, message);
db.AddInParameter(dbCommand, "Exception", DbType.String, exception);
db.AddInParameter(dbCommand, "IPAddress", DbType.String, ipAddress);
db.AddInParameter(dbCommand, "CustomerID", DbType.Int32, customerId);
db.AddInParameter(dbCommand, "PageURL", DbType.String, pageUrl);
db.AddInParameter(dbCommand, "ReferrerURL", DbType.String, referrerUrl);
db.AddInParameter(dbCommand, "CreatedOn", DbType.DateTime, createdOn);
if (db.ExecuteNonQuery(dbCommand) > 0)
{
int logId = Convert.ToInt32(db.GetParameterValue(dbCommand, "@LogID"));
item = GetLogById(logId);
}
return(item);
}
private DBLog GetLogFromReader(IDataReader dataReader)
{
DBLog log = new DBLog();
log.LogID = NopSqlDataHelper.GetInt(dataReader, "LogID");
log.LogTypeID = NopSqlDataHelper.GetInt(dataReader, "LogTypeID");
log.Severity = NopSqlDataHelper.GetInt(dataReader, "Severity");
log.Message = NopSqlDataHelper.GetString(dataReader, "Message");
log.Exception = NopSqlDataHelper.GetString(dataReader, "Exception");
log.IPAddress = NopSqlDataHelper.GetString(dataReader, "IPAddress");
log.CustomerID = NopSqlDataHelper.GetInt(dataReader, "CustomerID");
log.PageURL = NopSqlDataHelper.GetString(dataReader, "PageURL");
log.CreatedOn = NopSqlDataHelper.GetUtcDateTime(dataReader, "CreatedOn");
return(log);
}
/// <summary>
/// Gets a log item
/// </summary>
/// <param name="LogID">Log item identifier</param>
/// <returns>Log item</returns>
public override DBLog GetLogByID(int LogID)
{
DBLog log = null;
Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString);
DbCommand dbCommand = db.GetStoredProcCommand("Nop_LogLoadByPrimaryKey");
db.AddInParameter(dbCommand, "LogID", DbType.Int32, LogID);
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
if (dataReader.Read())
{
log = GetLogFromReader(dataReader);
}
}
return(log);
}
private DBLog GetLogFromReader(IDataReader dataReader)
{
var item = new DBLog();
item.LogId = NopSqlDataHelper.GetInt(dataReader, "LogID");
item.LogTypeId = NopSqlDataHelper.GetInt(dataReader, "LogTypeID");
item.Severity = NopSqlDataHelper.GetInt(dataReader, "Severity");
item.Message = NopSqlDataHelper.GetString(dataReader, "Message");
item.Exception = NopSqlDataHelper.GetString(dataReader, "Exception");
item.IPAddress = NopSqlDataHelper.GetString(dataReader, "IPAddress");
item.CustomerId = NopSqlDataHelper.GetInt(dataReader, "CustomerID");
item.PageUrl = NopSqlDataHelper.GetString(dataReader, "PageURL");
item.ReferrerUrl = NopSqlDataHelper.GetString(dataReader, "ReferrerURL");
item.CreatedOn = NopSqlDataHelper.GetUtcDateTime(dataReader, "CreatedOn");
return(item);
}
/// <summary>
/// Gets all log items
/// </summary>
/// <returns>Log item collection</returns>
public override DBLogCollection GetAllLogs()
{
DBLogCollection logCollection = new DBLogCollection();
Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString);
DbCommand dbCommand = db.GetStoredProcCommand("Nop_LogLoadAll");
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
while (dataReader.Read())
{
DBLog log = GetLogFromReader(dataReader);
logCollection.Add(log);
}
}
return(logCollection);
}
/// <summary>
/// Inserts a log item
/// </summary>
/// <param name="LogTypeID">Log item type identifier</param>
/// <param name="Severity">The severity</param>
/// <param name="Message">The short message</param>
/// <param name="Exception">The full exception</param>
/// <param name="IPAddress">The IP address</param>
/// <param name="CustomerID">The customer identifier</param>
/// <param name="PageURL">The page URL</param>
/// <param name="CreatedOn">The date and time of instance creationL</param>
/// <returns>Log item</returns>
public override DBLog InsertLog(int LogTypeID, int Severity, string Message,
string Exception, string IPAddress, int CustomerID, string PageURL, DateTime CreatedOn)
{
DBLog log = null;
Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString);
DbCommand dbCommand = db.GetStoredProcCommand("Nop_LogInsert");
db.AddOutParameter(dbCommand, "LogID", DbType.Int32, 0);
db.AddInParameter(dbCommand, "LogTypeID", DbType.Int32, LogTypeID);
db.AddInParameter(dbCommand, "Severity", DbType.Int32, Severity);
db.AddInParameter(dbCommand, "Message", DbType.String, Message);
db.AddInParameter(dbCommand, "Exception", DbType.String, Exception);
db.AddInParameter(dbCommand, "IPAddress", DbType.String, IPAddress);
db.AddInParameter(dbCommand, "CustomerID", DbType.Int32, CustomerID);
db.AddInParameter(dbCommand, "PageURL", DbType.String, PageURL);
db.AddInParameter(dbCommand, "CreatedOn", DbType.DateTime, CreatedOn);
if (db.ExecuteNonQuery(dbCommand) > 0)
{
int LogID = Convert.ToInt32(db.GetParameterValue(dbCommand, "@LogID"));
log = GetLogByID(LogID);
}
return(log);
}