protected void RecordEvent(string strEvent)
{
DateTime dtNow = DateTime.UtcNow.AddHours(-5.0D);
string strSession = Session.SessionID;
string strClientIP = Request.UserHostAddress;
string strEmail = "";
myTvTestPatterns.TvTestDiscTableAdapters.EVENT_LOGTableAdapter adptEvent = new EVENT_LOGTableAdapter();
using (adptEvent)
{
adptEvent.InsertEvent(dtNow, strClientIP, strSession, "Transport", strEvent, strEmail);
}
}
public ActionResult Test()
{
EVENT_LOGTableAdapter ta = new EVENT_LOGTableAdapter();
string colorBarCount = ta.Count12CB50V2().ToString();
string testDiscCount = ta.Count12TD5().ToString();
Dictionary <string, string> Counts = new Dictionary <string, string>();
Counts.Add("ColorBarDVD", colorBarCount);
Counts.Add("myTvTestDisc", testDiscCount);
return(Json(Counts));
}
public string EventLog()
{
EVENT_LOGTableAdapter adptEvent = new EVENT_LOGTableAdapter();
DataTable dt = new DataTable();
using (adptEvent)
{
dt = adptEvent.GetData();
}
string xml = "";
using (StringWriter sw = new StringWriter())
{
dt.WriteXml(sw);
xml = sw.ToString();
}
return(xml);
}
public ActionResult GetDownloads()
{
EVENT_LOGTableAdapter ta = new EVENT_LOGTableAdapter();
DataTable dt = new DataTable();
DataSet ds = new DataSet();
String[,] data = new String[3, 3];
String x = "";
String jsonString = "[ ";
try
{
//ds.Tables.Add(dt);
dt = ta.GetData();
for (int i = 0; i < 200; i++)
{
x = Convert.ToDateTime(dt.Rows[i]["Timestamp"]).ToString();
jsonString = String.Concat(jsonString, "{ ", '"', "Timestamp", '"', ": ", '"');
jsonString = String.Concat(jsonString, (dt.Rows[i]["Timestamp"] == null) ? "" : x, '"', ", ");
x = dt.Rows[i]["Client_IP"].ToString();
jsonString = String.Concat(jsonString, '"', "Client_IP", '"', ": ", '"');
jsonString = String.Concat(jsonString, (dt.Rows[i]["Client_IP"] == null) ? "" : x, '"', ", ");
x = dt.Rows[i]["Event"].ToString();
jsonString = String.Concat(jsonString, '"', "Event", '"', ": ", '"');
jsonString = String.Concat(jsonString, (dt.Rows[i]["Event"] == null) ? "" : x, '"', " }, ");
}
jsonString = jsonString.Substring(0, jsonString.Length - 2);
jsonString = String.Concat(jsonString, " ]");
return(Json(jsonString));
}
catch (Exception ex)
{
return(Json(ex.Message));
}
}
