Exemplo n.º 1
0
        public static void CreateCart()
        {
            var query = "INSERT INTO Carts ";

            Dictionary <string, object> values = new Dictionary <string, object>
            {
                { "CustomerName", "GameBreakers" },
                { "Status", "Active" },
                { "LastUpdated", DateTime.Now }
            };

            DatabaseManager.RunQueryWithArgs(query, values);

            StatusChanged();
        }
Exemplo n.º 2
0
        public static void LogActivity(string message, string extraData = "")
        {
            lock (_syncObject)
            {
                Dictionary <string, object> values = new Dictionary <string, object>
                {
                    { "Action", message },
                    { "TimeOfActivity", DateTime.Now.ToString() },
                    { "ExtraData", extraData },
                };

                var query = "INSERT INTO ActivityLog ";

                DatabaseManager.RunQueryWithArgs(query, values);
            }
        }
Exemplo n.º 3
0
        public static void LogError(string attemptedAction, string error, string extraData)
        {
            lock (_syncObject)
            {
                if (error == "Thread was being aborted.")
                {
                    return;
                }

                Dictionary <string, object> values = new Dictionary <string, object>
                {
                    { "AttemptedAction", attemptedAction },
                    { "Error", error },
                    { "ExtraData", extraData },
                    { "TimeOfError", DateTime.Now.ToString() },
                    { "ParentFunction", new StackFrame(1).GetMethod().Name }
                };

                var query = "INSERT INTO Errors ";

                DatabaseManager.RunQueryWithArgs(query, values);
            }
        }