public static void AppendEmailLog(DbManager db, cmLog logItem)
{
MySqlParameter[] parameters = new MySqlParameter[]
{
new MySqlParameter("@EmailType", logItem.EmailType),
new MySqlParameter("@From", logItem.From),
new MySqlParameter("@ReplyTo", logItem.ReplyTo),
new MySqlParameter("@To", logItem.To),
new MySqlParameter("@Subject", logItem.Subject),
new MySqlParameter("@Body", logItem.Body),
new MySqlParameter("@UserID", logItem.UserID),
new MySqlParameter("@SessionID", logItem.SessionID),
new MySqlParameter("@IP", logItem.IP),
new MySqlParameter("@ServerName", logItem.ServerName),
new MySqlParameter("@Operatorname", logItem.OperatorName),
};
db.SetCommand(INSERT_EMAIL_LOG, parameters);
db.ExecuteNonQuery();
}
public static void AppendLog(DbManager db, cmLog logItem)
{
MySqlParameter[] parameters = new MySqlParameter[]
{
new MySqlParameter("@AccessLogID", logItem.ID),
new MySqlParameter("@LogType", logItem.LogType),
new MySqlParameter("@Source", logItem.Source),
new MySqlParameter("@Message", logItem.Message),
new MySqlParameter("@ServerName", logItem.ServerName),
new MySqlParameter("@Operatorname", logItem.OperatorName),
new MySqlParameter("@IP", logItem.IP),
new MySqlParameter("@UserID", logItem.UserID),
new MySqlParameter("@SessionID", logItem.SessionID),
new MySqlParameter("@Url", logItem.PathAndQuery),
new MySqlParameter("@StackTrace", logItem.StackTrace),
};
db.SetCommand(INSERT_LOG, parameters);
db.ExecuteNonQuery();
}
public static void AppendAccessLog(DbManager db, cmLog logItem)
{
MySqlParameter[] parameters = new MySqlParameter[]
{
new MySqlParameter("@ID", logItem.ID),
new MySqlParameter("@IP", logItem.IP),
new MySqlParameter("@ServerName", logItem.ServerName),
new MySqlParameter("@OperatorName", logItem.OperatorName),
new MySqlParameter("@ElapsedSeconds", logItem.ElapsedSeconds),
new MySqlParameter("@UserID", logItem.UserID),
new MySqlParameter("@SessionID", logItem.SessionID),
new MySqlParameter("@HttpMethod", logItem.HttpMethod),
new MySqlParameter("@BaseUrl", logItem.BaseUrl),
new MySqlParameter("@PathAndQuery", logItem.PathAndQuery),
new MySqlParameter("@UrlReferrer", logItem.UrlReferrer),
new MySqlParameter("@UserAgent", logItem.Data),
};
db.SetCommand(INSERT_ACCESS_LOG, parameters);
db.ExecuteNonQuery();
}