Beispiel #1
0
        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();
        }
Beispiel #2
0
        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();
        }
Beispiel #3
0
        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();
        }