public IViewComponentResult Invoke()
{
// var chart = JsonConvert.DeserializeObject<ChartJs> (chartData);
Ticks ticks = new Ticks {
beginAtZero = true
};
Yax yax = new Yax {
ticks = ticks
};
Yax[] y = new Yax[1];
y[0] = yax;
Scales scales = new Scales();
scales.yAxes = y;
Data data = new Data();
StaffSale saleData = GetStaffSaleData();
Dataset datasetY = new Dataset
{
borderWidth = 1,
label = "Yearly",
data = saleData.YearWise.ToArray(),
backgroundColor = new string[] {
"rgba(255, 99, 132, 0.2)",
"rgba(54, 162, 235, 0.2)",
"rgba(255, 206, 86, 0.2)",
"rgba(75, 192, 192, 0.2)",
"rgba(153, 102, 255, 0.2)",
"rgba(54, 162, 235, 0.2)",
"rgba(255, 203, 83, 0.2)",
"rgba(255, 159, 64, 0.2)",
//"rgba(255, 99, 132, 0.2)",
//"rgba(54, 162, 235, 0.2)",
//"rgba(255, 206, 86, 0.2)",
//"rgba(75, 192, 192, 0.2)",
},
borderColor = new string[] {
"rgba(255, 99, 132, 1)",
"rgba(54, 162, 235, 1)",
"rgba(255, 206, 86, 1)",
"rgba(75, 192, 192, 1)",
"rgba(153, 102, 255, 1)",
"rgba(255, 203, 83, 1)",
"rgba(255, 159, 64, 1)",
"rgba(255, 99, 132, 1)",
//"rgba(54, 162, 235, 1)",
//"rgba(255, 206, 86, 1)",
//"rgba(75, 192, 192, 1)",
//"rgba(153, 102, 255, 1)",
}
};
Dataset datasetM = new Dataset
{
borderWidth = 1,
label = "Monthly",
data = saleData.MonthWise.ToArray(),
backgroundColor = new string[] {
// "rgba(255, 99, 132, 0.2)",
// "rgba(54, 162, 235, 0.2)",
// "rgba(255, 206, 86, 0.2)",
"rgba(75, 192, 192, 0.2)",
"rgba(153, 102, 255, 0.2)",
"rgba(54, 162, 235, 0.2)",
"rgba(255, 203, 83, 0.2)",
// "rgba(255, 159, 64, 0.2)",
// "rgba(255, 99, 132, 0.2)",
"rgba(54, 162, 235, 0.2)",
"rgba(255, 206, 86, 0.2)",
//"rgba(75, 192, 192, 0.2)",
},
borderColor = new string[] {
// "rgba(255, 99, 132, 1)",
// "rgba(54, 162, 235, 1)",
// "rgba(255, 206, 86, 1)",
"rgba(75, 192, 192, 1)",
"rgba(153, 102, 255, 1)",
"rgba(255, 203, 83, 1)",
"rgba(255, 159, 64, 1)",
//"rgba(255, 99, 132, 1)",
// "rgba(54, 162, 235, 1)",
"rgba(255, 206, 86, 1)",
"rgba(75, 192, 192, 1)",
// "rgba(153, 102, 255, 1)",
}
};
Dataset datasetC = new Dataset
{
borderWidth = 1,
label = "Today",
data = saleData.CurrentWise.ToArray(),
backgroundColor = new string[] {
"rgba(255, 99, 132, 0.2)",
"rgba(54, 162, 235, 0.2)",
// "rgba(255, 206, 86, 0.2)",
// "rgba(75, 192, 192, 0.2)",
// "rgba(153, 102, 255, 0.2)",
// "rgba(54, 162, 235, 0.2)",
"rgba(255, 203, 83, 0.2)",
"rgba(255, 159, 64, 0.2)",
"rgba(255, 99, 132, 0.2)",
// "rgba(54, 162, 235, 0.2)",
//"rgba(255, 206, 86, 0.2)",
// "rgba(75, 192, 192, 0.2)",
},
borderColor = new string[] {
"rgba(255, 99, 132, 1)",
"rgba(54, 162, 235, 1)",
//"rgba(255, 206, 86, 1)",
//"rgba(75, 192, 192, 1)",
//"rgba(153, 102, 255, 1)",
//"rgba(255, 203, 83, 1)",
//"rgba(255, 159, 64, 1)",
"rgba(255, 99, 132, 1)",
"rgba(54, 162, 235, 1)",
"rgba(255, 206, 86, 1)",
//"rgba(75, 192, 192, 1)",
//"rgba(153, 102, 255, 1)",
}
};
ChartJs chart = new ChartJs
{
type = "bar",
responsive = true,
options = new Options {
scales = scales, title = new Title {
Display = true, Text = "Staff Sale"
}, legend = new Legend {
Position = "Top"
}
},
data = new Data {
datasets = new Dataset[] { datasetY, datasetM, datasetC }, labels = saleData.StaffName.ToArray()
}
};
var chartModel = new ChartJsViewModel
{
Chart = chart,
ChartJson = JsonConvert.SerializeObject(chart, new JsonSerializerSettings
{
NullValueHandling = NullValueHandling.Ignore
})
};
return(View(chartModel));
}
public IViewComponentResult Invoke()
{
// var chart = JsonConvert.DeserializeObject<ChartJs> (chartData);
Ticks ticks = new Ticks {
beginAtZero = true
};
Yax yax = new Yax {
ticks = ticks
};
Yax[] y = new Yax[1];
y[0] = yax;
Scales scales = new Scales();
scales.yAxes = y;
Data data = new Data();
YearlySaleData saleData = GetYearlySaleData();
Dataset dataset = new Dataset
{
borderWidth = 1,
label = "Yearly Sale",
data = saleData.Amount.ToArray(),
backgroundColor = new string[] {
"rgba(255, 99, 132, 0.2)",
"rgba(54, 162, 235, 0.2)",
"rgba(255, 206, 86, 0.2)",
"rgba(75, 192, 192, 0.2)",
"rgba(153, 102, 255, 0.2)",
"rgba(54, 162, 235, 0.2)",
"rgba(255, 203, 83, 0.2)",
"rgba(255, 159, 64, 0.2)"
},
borderColor = new string[] {
"rgba(255, 99, 132, 1)",
"rgba(54, 162, 235, 1)",
"rgba(255, 206, 86, 1)",
"rgba(75, 192, 192, 1)",
"rgba(153, 102, 255, 1)",
"rgba(255, 203, 83, 1)",
"rgba(153, 102, 255, 1)",
"rgba(255, 203, 83, 1)",
"rgba(255, 159, 64, 1)"
}
};
ChartJs chart = new ChartJs
{
type = "bar",
responsive = true,
options = new Options {
scales = scales
},
data = new Data {
datasets = new Dataset[] { dataset }, labels = saleData.Year.ConvertAll <string>(delegate(int i) { return(i.ToString()); }).ToArray()
}
};
var chartModel = new ChartJsViewModel
{
Chart = chart,
ChartJson = JsonConvert.SerializeObject(chart, new JsonSerializerSettings
{
NullValueHandling = NullValueHandling.Ignore
})
};
return(View(chartModel));
}
/*Creating Dashboards
*
* A Dashboard will have:
* Rows: A row can contain multiple item to display information (ex: one row can have a table right next to a graph)
* and a Dashboard Name
*
* Each items in a row are called a "panel" which can be multiple things that display information like graphs, tables, etc..
* To create a panels, we need to initalize them and then send that information to a 'Row' object
* A dashboard will need to be initalized with its name and a list of rows.
*
*/
/// <summary>
/// Initiates and formats JSON Dashboard object to send data to Grafana
/// </summary>
/// <param name="dashName"></param>
/// <returns>A string containing the HTTP response to the POST</returns>
public static string CreateDashboard(Session session)
{
//URI to contact Grafana's API for interacting with Dashboards
var uri = "http://ec2-13-57-134-131.us-west-1.compute.amazonaws.com:3000/api/dashboards/db";
//Creating lists to be use to initialize the Dashboard constructor
var reqs = new List <Require>();
var DashRows = new List <Row>();
var panelsList = new List <Panel>();
var targetsList = new List <Target>();
// Specify what the Yaxis shows
var Yaxes = new List <Yax>();
var Yaxis = new Yax {
format = "short", label = null, logBase = 1, show = true
};
var Yaxis1 = new Yax {
format = "short", label = null, logBase = 1, show = true
};
var timeRange = new Time {
from = "now-30d", to = "now"
};
Yaxes.Add(Yaxis);
Yaxes.Add(Yaxis1);
//Test list of integer, if it works, call GetTarget on this line to get
List <int> testList = new List <int> {
340, 341
}; //testList = getTarget(Session.InstrumentID)
//Initialize target data and call GetTarget here
List <Tag> targetTags = new List <Tag>();
char grafanaQueryIDs = 'A';
List <string> grafanaVarIDs = ChordsBot.GetTarget(session.InstrumentID);
for (int index = 0; index < session.StreamIDs.Count; index++)
{
//Get a datastream from the session and have Grafana point to it
var Stream = DataCenter.GetDataStream(session.NetworkAlias, session.StreamIDs[index]);
Tag testTag = new Tag {
key = "var", @operator = "=", value = grafanaVarIDs[index].ToString()
};
targetTags.Add(testTag);
Target testTarget = new Target
{
alias = Stream.Data[0].Site.Alias + " , " + Stream.Data[0].Deployment.Name + " , " + Stream.Data[0].DataType.Name + " , " + Stream.Data[0].Property.Name,
dsType = "influxdb",
measurement = "tsdata",
policy = "default",
refId = grafanaQueryIDs.ToString(),
resultFormat = "time_series",
tags = targetTags,
};
grafanaQueryIDs++;
targetsList.Add(testTarget);
targetTags = new List <Tag>();
}
//Initializing the Dashboard's "requirement" objects and target objects for Panel
var panelReqs = new Require {
type = "panel", id = "graph", name = "graph"
};
var dataReqs = new Require {
type = "datasource", id = "influxdb", name = "InfluxDB", version = "1.0.0"
};
// ChordsBot.GetTarget(sessionKey);
//Panel initialization
var panel = new Panel
{
title = session.Name,
// aliasColors = { },
description = session.Description,
bars = false,
datasource = "NRDC",
fill = 1,
nullPointMode = "null",
lines = true,
// links = { },
linewidth = 1,
pointradius = 5,
renderer = "flot",
//seriesOverrides = { },
span = 12,
targets = targetsList,
stack = false,
steppedLine = false,
tooltip = new Tooltip {
shared = true, sort = 0, value_type = "individual"
},
type = "graph",
xaxis = new Xaxis {
mode = "time ", name = null, show = true
},
yaxes = Yaxes,
legend = new Legend {
avg = false, current = false, max = false, min = false, show = true, total = false, values = false
}
};
//formats data and sends JSON request
reqs.Add(panelReqs);
reqs.Add(dataReqs);
panelsList.Add(panel);
var dashRow = new Row {
panels = panelsList, title = "Dashboard Row", titleSize = "h6", height = "250px"
};
DashRows.Add(dashRow);
Response testBoard = new Response {
dashboard = new Dashboard {
title = session.Name, rows = DashRows, time = timeRange, version = 3, refresh = "5s"
}
};
var jsonContent = JsonConvert.SerializeObject(testBoard, Config.DefaultSerializationSettings);
var stringContent = new StringContent(jsonContent, Encoding.UTF8, "application/json");
client.DefaultRequestHeaders.Authorization = new AuthenticationHeaderValue(header, credentials);
var response = client.PostAsync(uri, stringContent).Result;
return(response.Content.ReadAsStringAsync().Result);
}
