示例#1
0
        /// <summary>
        /// Schreibt einen neuen Eintrag in die Tabelle 'Log'.
        /// </summary>
        /// <param name="message"></param>
        internal void CreateLogEntry(MainWindow.Topic topic, MainWindow.Prio prio, ulong contentNo, string content)
        {
            const string query = "INSERT INTO Log(Time, Topic, Prio, ContentNo, Content) VALUES (@timeStamp, @topic, @prio, @contentNo, @content)";

            var args = new Dictionary <string, object>
            {
                { "@timeStamp", HelperClass.ConvertToUnixTime(DateTime.Now) },
                { "@topic", topic.ToString() },
                { "@prio", (ushort)prio },
                { "@contentNo", contentNo },
                { "@content", content }
            };

            ExecuteWrite(query, args);
        }
示例#2
0
        /// <summary>
        /// Schreibt einen neuen Eintrag in die Tabelle 'Log'.
        /// </summary>
        /// <param name="message"></param>
        internal void CreateLogEntry(MainWindow.Topic topic, MainWindow.Prio prio, ulong contentNo, string content)
        {
            const string query = "INSERT INTO Log(Time, Topic, Prio, ContentNo, Content) VALUES (@timeStamp, @topic, @prio, @contentNo, @content)";

            var args = new Dictionary <string, object>
            {
                { "@timeStamp", DateTimeOffset.UtcNow.ToUnixTimeSeconds() },
                { "@topic", topic.ToString() },
                { "@prio", (ushort)prio },
                { "@contentNo", contentNo },
                { "@content", content }
            };

            ExecuteWrite(query, args);

            // ShowLastLofEntries();
        }