示例#1
0
        public List <WebLogTable> Query(string sessionID)
        {
            DirectDatabaseMsSql database = MobilePaywallLogDirect.Instance;

            // first we check if data is stored in log database
            int?check = database.LoadInt(string.Format(@"
        SELECT COUNT(*) FROM MobilePaywall.log.CallbackLog AS log
        LEFT OUTER JOIN MobilePaywall.log.CallbackLogUserSessionMap AS map ON map.CallbackLogID=log.CallbackLogID
        WHERE map.UserSessionID={0}", sessionID));

            if (!check.HasValue || check.Value == 0)
            {
                database = MobilePaywallBackupDirect.Instance;
            }

            DirectContainer container = database.LoadContainer(@"SELECT c.CallbackLogID AS 'ID', c.Date, c.Logger, c.Message, c.Method, c.Line
          FROM MobilePaywall.log.CallbackLogUserSessionMap AS map
          LEFT OUTER JOIN MobilePaywall.log.CallbackLog AS c ON map.CallbackLogID=c.CallbackLogID
          WHERE map.UserSessionID=" + sessionID + ";");

            return(container.ConvertList <WebLogTable>());
        }
示例#2
0
        public List <WebLogTable> QueryLogDatabase(WebLogTableData data)
        {
            DirectDatabaseMsSql database = MobilePaywallLogDirect.Instance;

            // first we check if data is stored in log database
            int?check = database.LoadInt(string.Format(@"
        SELECT COUNT(*) FROM MobilePaywallLog.log.WebLog AS log
        LEFT OUTER JOIN MobilePaywallLog.log.WebLogUserSessionMap AS map ON map.WebLogID=log.WebLogID
        WHERE map.UserSessionID={0}", data.SessionID));

            if (!check.HasValue || check.Value == 0)
            {
                database = MobilePaywallBackupDirect.Instance;
            }


            string command = "";

            #region # sql command #

            command = " SELECT  "
                      + "wl.WebLogID, "
                      + "wl.Date, "
                      + "wl.Logger, "
                      + "wl.Message, "
                      + "wl.Exception, "
                      + "wl.Method, "
                      + "wl.Line "
                      + " FROM MobilePaywall.log.WebLogUserSessionMap AS map "
                      + " LEFT OUTER JOIN MobilePaywall.log.WebLog AS wl ON map.WebLogID=wl.WebLogID "
                      + " WHERE map.UserSessionID=" + data.SessionID + " AND "
                      + " map.Created >= '" + data.From + "' AND map.Created <= '" + data.To + "' "
                      + " ORDER BY wl.WebLogID ASC; ";

            #endregion

            this._result = new List <WebLogTable>();
            database.SetTimeout(0);
            DataTable table = database.Load(command);
            if (table == null)
            {
                return(this._result);
            }

            foreach (DataRow row in table.Rows)
            {
                WebLogTable tableRow = new WebLogTable();
                tableRow.ID     = row[(int)WebLogColumns.ID].ToString();
                tableRow.Date   = row[(int)WebLogColumns.Date].ToString();
                tableRow.Logger = row[(int)WebLogColumns.Logger].ToString();

                tableRow.Message = row[(int)WebLogColumns.Message].ToString();
                string exeption = row[(int)WebLogColumns.Exception].ToString();
                if (!string.IsNullOrEmpty(exeption))
                {
                    tableRow.Message += Environment.NewLine + Environment.NewLine + "<<<<<<<<<<<<<<<<: EXCEPTION:" + Environment.NewLine + exeption;
                }

                tableRow.Method = row[(int)WebLogColumns.Method].ToString();
                tableRow.Line   = row[(int)WebLogColumns.Line].ToString();
                this._result.Add(tableRow);
            }

            return(this._result);
        }