public List <WebLogTable> QueryByReferenceGuid(WebLogTableData data)
{
string command = "";
#region # sql command #
command = " SELECT " +
" rm.RawMessageID AS 'ID', " +
" rm.GroupKey AS 'Logger', " +
" rm.Thread, " +
" rm.RawMessageData AS 'Message', " +
" rm.Created AS 'Date'" +
" FROM [Cashflow].[log].[RawMessage] AS rm " +
" INNER JOIN [Cashflow].[core].[ActionContext] AS ac ON rm.ActionContextID = ac.ActionContextID " +
" INNER JOIN [Cashflow].[core].[ActionContextGroup] AS acg ON ac.ActionContextGroupID = acg.ActionContextGroupID " +
" WHERE acg.ActionContextGroupID = (SELECT TOP 1 acg1.ActionContextGroupID FROM [Cashflow].[log].[RawMessage] AS rm1 " +
" INNER JOIN [Cashflow].[core].[ActionContext] AS ac1 ON rm1.ActionContextID = ac1.ActionContextID "+
" INNER JOIN [Cashflow].[core].[ActionContextGroup] AS acg1 ON ac1.ActionContextGroupID = acg1.ActionContextGroupID "+
" WHERE "+
" rm1.Created >= '" + data.From.ToString() + "' AND rm1.Created <= '" + data.To.ToString() + "' " +
" AND rm1.RawMessageData LIKE '%"+ data.SessionID + "%') " +
" ORDER BY rm.Created ASC ";
#endregion
this._result = new List <WebLogTable>();
DirectContainer container = CashflowDirect.Instance.LoadContainer(command);
this._result = container.ConvertList <WebLogTable>();
return(this._result);
}
public List <WebLogTable> QueryByIdentificationSessionGuid(WebLogTableData data)
{
string command = "";
#region # sql command #
command = " SELECT " +
" rm.RawMessageID AS 'ID', " +
" rm.GroupKey AS 'Logger', " +
" rm.Thread, " +
" rm.RawMessageData AS 'Message', " +
" rm.Created AS 'Date' " +
" FROM Cashflow.core.IdentificationSession AS ids " +
" LEFT OUTER JOIN Cashflow.core.ActionContext AS ac ON ids.ActionContextID=ac.ActionContextID " +
" LEFT OUTER JOIN Cashflow.core.ActionContextGroup AS acg ON ac.ActionContextGroupID=acg.ActionContextGroupID " +
" LEFT OUTER JOIN Cashflow.core.ActionContext AS ac2 ON acg.ActionContextGroupID=ac2.ActionContextGroupID " +
" LEFT OUTER JOIN Cashflow.log.RawMessage AS rm ON rm.ActionContextID=ac2.ActionContextID " +
" WHERE " +
" ids.IdentificationSessionGuid='" + data.SessionID + "' AND rm.RawMessageID IS NOT NULL " +
" ORDER BY rm.Created ASC; ";
#endregion
this._result = new List <WebLogTable>();
DirectContainer container = CashflowDirect.Instance.LoadContainer(command);
this._result = container.ConvertList <WebLogTable>();
return(this._result);
}
// SUMMARY: Report -> Informations about click
public ActionResult GetInformations(WebLogTableData data)
{
InformationManager manager = new InformationManager();
manager.Query(data);
return(View("~/Views/Report/_LogTable.cshtml", new LogModel {
Informations = manager.Result, InformationsLabel = "info"
}));
}
// SUMMARY: Report -> Load paywall logs from Log database
public ActionResult GetPaywallLogDatabase(WebLogTableData data)
{
WebLogManager manager = new WebLogManager();
manager.QueryLogDatabase(data);
return(View("~/Views/Report/_LogBlock.cshtml", new LogModel()
{
Tables = manager.Result
}));
}
public List <WebLogTable> Query2(WebLogTableData data)
{
string command = "";
#region # sql command #
command = " SELECT "
+ "wl.WebLogID, "
+ "wl.Date, "
+ "wl.Logger, "
+ "wl.Message, "
+ "wl.Exception, "
+ "wl.Method, "
+ "wl.Line "
+ " FROM MobilePaywallLog.log.WebLogUserSessionMap AS map "
+ " LEFT OUTER JOIN MobilePaywallLog.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>();
MobilePaywallLogDirect database = MobilePaywallLogDirect.Instance;
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);
}
public List <WebLogTable> Query(WebLogTableData data)
{
string command = "";
#region # sql command #
command = " SELECT " +
" FrameLogID AS 'ID', " +
" Created AS 'Date', " +
" Code AS 'Code', " +
" Text AS 'Text', " +
" Scenario, " +
" ConfigurationID, " +
" CarrierID, " +
" CountryID, " +
" TemplateID " +
" FROM Clickenzi.FrameLog " +
" WHERE Pxid=" + data.SessionID + " " +
" AND Created >='" + data.From + "' AND Created <= '" + data.To + "' " +
" ORDER BY FrameLogID DESC; ";
#endregion
this._result = new List <WebLogTable>();
ClickenziDirect db = ClickenziDirect.Instance;
DataTable table = db.Load(command);
if (table == null)
{
return(this._result);
}
foreach (DataRow row in table.Rows)
{
WebLogTable tableRow = new WebLogTable();
tableRow.ID = !string.IsNullOrEmpty(row[(int)OverlayColumns.ID].ToString()) ? row[(int)OverlayColumns.ID].ToString() : (string)null;
tableRow.Date = !string.IsNullOrEmpty(row[(int)OverlayColumns.Created].ToString()) ? row[(int)OverlayColumns.Created].ToString() : (string)null;
tableRow.Logger = !string.IsNullOrEmpty(row[(int)OverlayColumns.Code].ToString()) ? row[(int)OverlayColumns.Code].ToString() : (string)null;
tableRow.Message = "Scenario: " + (!string.IsNullOrEmpty(row[(int)OverlayColumns.Scenario].ToString()) ? row[(int)OverlayColumns.Scenario].ToString() : "") + "\r\n" +
"Configuration: " + (!string.IsNullOrEmpty(row[(int)OverlayColumns.Configuration].ToString()) ? row[(int)OverlayColumns.Configuration].ToString() : "") + "\r\n" +
"Carrier: " + (!string.IsNullOrEmpty(row[(int)OverlayColumns.Carrier].ToString()) ? row[(int)OverlayColumns.Carrier].ToString() : "") + "\r\n" +
"Country: " + (!string.IsNullOrEmpty(row[(int)OverlayColumns.Country].ToString()) ? row[(int)OverlayColumns.Country].ToString() : "") + "\r\n" +
"Template: " + (!string.IsNullOrEmpty(row[(int)OverlayColumns.Template].ToString()) ? row[(int)OverlayColumns.Template].ToString() : "") + "\r\n" +
(!string.IsNullOrEmpty(row[(int)OverlayColumns.Text].ToString()) ? row[(int)OverlayColumns.Text].ToString() : "");
this._result.Add(tableRow);
}
return(this._result);
}
// SUMMARY: Sql for getting all records for the click
public List <WebLogTable> Query(WebLogTableData data, string UseRefence)
{
string command = "";
#region # sql command #
if (UseRefence.Equals("true"))
{
command = " SELECT " +
" rm.RawMessageID AS 'ID', " +
" rm.GroupKey AS 'Logger', " +
" rm.Thread, " +
" rm.RawMessageData AS 'Message', " +
" rm.Created AS 'Date'" +
" FROM [Cashflow].[log].[RawMessage] AS rm " +
" INNER JOIN [Cashflow].[core].[ActionContext] AS ac ON rm.ActionContextID = ac.ActionContextID " +
" INNER JOIN [Cashflow].[core].[ActionContextGroup] AS acg ON ac.ActionContextGroupID = acg.ActionContextGroupID " +
" WHERE acg.ActionContextGroupID = (SELECT TOP 1 acg1.ActionContextGroupID FROM [Cashflow].[log].[RawMessage] AS rm1 " +
" INNER JOIN [Cashflow].[core].[ActionContext] AS ac1 ON rm1.ActionContextID = ac1.ActionContextID "+
" INNER JOIN [Cashflow].[core].[ActionContextGroup] AS acg1 ON ac1.ActionContextGroupID = acg1.ActionContextGroupID "+
" WHERE "+
" rm1.Created >= '" + data.From.ToString() + "' AND rm1.Created <= '" + data.To.ToString() + "' " +
" AND rm1.RawMessageData LIKE '%"+ data.SessionGuid + "%') " +
" ORDER BY rm.Created ASC ";
}
else
{
command = " SELECT " +
" rm.RawMessageID AS 'ID', " +
" rm.GroupKey AS 'Logger', " +
" rm.Thread, " +
" rm.RawMessageData AS 'Message', " +
" rm.Created AS 'Date' " +
" FROM Cashflow.core.IdentificationSession AS ids " +
" LEFT OUTER JOIN Cashflow.core.ActionContext AS ac ON ids.ActionContextID=ac.ActionContextID " +
" LEFT OUTER JOIN Cashflow.core.ActionContextGroup AS acg ON ac.ActionContextGroupID=acg.ActionContextGroupID " +
" LEFT OUTER JOIN Cashflow.core.ActionContext AS ac2 ON acg.ActionContextGroupID=ac2.ActionContextGroupID " +
" LEFT OUTER JOIN Cashflow.log.RawMessage AS rm ON rm.ActionContextID=ac2.ActionContextID " +
" WHERE " +
" ids.IdentificationSessionGuid='" + data.SessionGuid + "' " +
" AND rm.Created >= '" + data.From.ToString() + "' AND rm.Created <= '" + data.To.ToString() + "' " +
" ORDER BY rm.Created ASC; ";
}
#endregion
this._result = new List <WebLogTable>();
DirectContainer container = CashflowDirect.Instance.LoadContainer(command);
this._result = container.ConvertList <WebLogTable>();
return(this._result);
}
public List <WebLogTable> QueryByReferenceIntID(WebLogTableData data)
{
string command = "";
#region # sql command #
command = @"SELECT rm.RawMessageID AS 'ID', rm.GroupKey AS 'Logger', rm.Thread, rm.RawMessageData AS 'Message', rm.Created AS 'Date'
FROM Cashflow.core.ActionContextGroupReferenceMap AS map
LEFT OUTER JOIN Cashflow.core.ActionContext AS c ON map.ActionContextGroupID=c.ActionContextGroupID
LEFT OUTER JOIN Cashflow.log.RawMessage AS rm ON rm.ActionContextID=c.ActionContextID
WHERE map.ReferenceIntID=" + data.SessionID + " AND rm.RawMessageID IS NOT NULL ;";
#endregion
this._result = new List <WebLogTable>();
DirectContainer container = CashflowDirect.Instance.LoadContainer(command);
this._result = container.ConvertList <WebLogTable>();
return(this._result);
}
public List <UserRequestTable> Query(WebLogTableData data)
{
string command = "";
#region # command #
command = " SELECT " +
" uhr.RequestedUrl, "+
" uhr.Created " +
" FROM " +
" MobilePaywall.core.UserHttpRequest AS uhr " +
" LEFT OUTER JOIN MobilePaywall.core.UserSession AS us ON uhr.UserSessionID=us.UserSessionID " +
" WHERE us.UserSessionID='" + data.SessionID + "' " +
" ORDER BY uhr.Created DESC; ";
#endregion
DirectContainer container = MobilePaywallDirect.Instance.LoadContainer(command);
this._result = container.ConvertList <UserRequestTable>();
return(this._result);
}
public List <WebLogTable> QueryBySubscriptionRequestGuid(WebLogTableData data)
{
string command = "";
#region # sql command #
command = @"SELECT rm.RawMessageID AS 'ID', rm.GroupKey AS 'Logger', rm.Thread, rm.RawMessageData AS 'Message', rm.Created AS 'Date'
FROM Cashflow.core.SubscriptionRequest AS sr
LEFT OUTER JOIN Cashflow.core.ActionContext AS ac ON sr.ActionContextID=ac.ActionContextID
LEFT OUTER JOIN Cashflow.core.ActionContextGroup AS acg ON ac.ActionContextGroupID=acg.ActionContextGroupID
LEFT OUTER JOIN Cashflow.core.ActionContext AS ac2 ON acg.ActionContextGroupID=ac2.ActionContextGroupID
LEFT OUTER JOIN Cashflow.log.RawMessage AS rm ON rm.ActionContextID=ac2.ActionContextID
WHERE sr.SubscriptionRequestGuid='" + data.SessionID + "' AND rm.RawMessageID IS NOT NULL ORDER BY rm.Created ASC;";
#endregion
this._result = new List <WebLogTable>();
DirectContainer container = CashflowDirect.Instance.LoadContainer(command);
this._result = container.ConvertList <WebLogTable>();
return(this._result);
}
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);
}
