public LogResponseData GetLogs(LogRequestData LogreqData) { string responseData = GetTelemetry(BuildQuery(LogreqData)); Models.TableData azureTables = Newtonsoft.Json.JsonConvert.DeserializeObject <Models.TableData>(responseData); /// if table data returned is empty if (azureTables.tables.Count == 0) { return new LogResponseData() { ContainsErrors = false, NumberOfRows = 0, Logs = new System.Collections.Generic.List <LogData>() } } ; return(new LogResponseData() { ContainsErrors = false, NumberOfRows = azureTables.tables[0].rows.Count, // take default table Logs = azureTables.tables[0].rows.Select(x => new LogData() { TimeStamp = DateTime.Parse(x[0]), LogMessage = x[1], LogType = this.ParseEnum <LogType>(x[2]) }).ToList() }); }
public async Task<string> GetMeetupUsers( int draw, int start, string search, int orderColumn, string orderDirection, int length) { var td = new Models.TableData(Models.TableData.TableType.SERVER_SIDE); td.Length = length; td.Offset = start; td.OrderDirection = orderDirection; td.Draw = draw; td.Search = search; td.OrderColumn = orderColumn; td.JsonFilePath = Server.MapPath(Url.Content("~/Content/json.txt")); td.DBPath = Server.MapPath(Url.Content("~/Content/dbMeetup")); var res = await td.GetTable(); return res; }
/// <summary> /// returns cloud instances /// </summary> /// <returns></returns> public CloudInstanceResponseData GetCloudInstances() { string cloudInstanceQuery = System.Web.HttpUtility.UrlPathEncode(@"query=traces | extend scinstancename=parsejson(customDimensions).InstanceName | where timestamp > now(-1d) | summarize count(), any(tostring(scinstancename)) by cloud_RoleInstance | extend InstanceName=any_scinstancename | extend CloudRole=cloud_RoleInstance | project InstanceName, CloudRole | order by InstanceName asc"); var cloudInstanceData = GetTelemetry(cloudInstanceQuery); Models.TableData azureTables = Newtonsoft.Json.JsonConvert.DeserializeObject <Models.TableData>(cloudInstanceData); /// if table data returned is empty if (azureTables.tables.Count == 0) { return new CloudInstanceResponseData() { ContainsErrors = false, NumberOfRows = 0, Logs = new System.Collections.Generic.List <CloudInstancesData>() } } ; return(new CloudInstanceResponseData() { ContainsErrors = false, NumberOfRows = azureTables.tables[0].rows.Count, // take default table Logs = azureTables.tables[0].rows.Select(x => new CloudInstancesData() { InstanceName = x[0], CloudRole = x[1] }).ToList() }); }
public async Task<string> _TableOnly() { var td = new Models.TableData(Models.TableData.TableType.HTML_ONLY); var res= await td.GetTable(); return res; }