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;
}
