public ServiceResponse <TabularResponse> ChartData([FromQuery] TabularQuery tabularQuery)
{
try
{
//var seriesNames = new Dictionary<string, string>();
//var byDate = data.GroupBy(d => d.StatTime)
// .OrderBy(g => g.Key)
// .ToList();
//foreach(var date in byDate)
//{
// var dataPoint = new Dictionary<string, object>
// {
// { "date", date.Key }
// };
// foreach(
//}
var data = Db.Backlog.AsQueryable();
var result = data.ApplyQuery(tabularQuery);
return(new ServiceResponse <TabularResponse>(true, result));
}
catch (Exception ex)
{
Logger.LogError($"{nameof(ChartData)} : {ex.GetType()} : {ex.Message}");
return(new ServiceResponse <TabularResponse>(false, null, ex.Message));
}
}
public ServiceResponse <TabularResponse> GetGridData([FromQuery] GridQuery query, [FromQuery] TabularQuery tabularQuery)
{
try
{
IQueryable <GridDataModel> data = null;
if (query.DataSet == GridDataSetType.Backlog)
{
data = Db.Backlog.Select(b => new GridDataModel
{
CustomerId = b.CustomerId,
CustomerName = b.CustomerName,
StatTime = b.StatTime,
Backlog = b.Backlog,
LastReceivedOn = b.LastReceivedOn,
TotalReceived = b.TotalReceived
}).AsQueryable();
}
else
{
data = Db.Performance.Select(b => new GridDataModel
{
CustomerId = b.CustomerId,
CustomerName = b.CustomerName,
StatTime = b.StatTime,
DatabaseConnections = b.DatabaseConnections,
IdleDatabaseConnections = b.IdleDatabaseConnections,
TotalDatabaseConnections = b.TotalDatabaseConnections,
TotalIdleDatabaseConnections = b.TotalIdleDatabaseConnections,
PctProcessorTime = b.PctProcessorTime / 100.0,
AvailableMBytes = b.AvailableMBytes,
PctPagingFileUsage = b.PctPagingFileUsage / 100.0
}).AsQueryable();
}
var result = data.ApplyQuery(tabularQuery);
return(new ServiceResponse <TabularResponse>(true, result));
}
catch (Exception ex)
{
Logger.LogError($"{nameof(GetGridData)} : {ex.GetType()} : {ex.Message}");
return(new ServiceResponse <TabularResponse>(false, null, ex.Message));
}
}
