protected void Page_Load(object sender, EventArgs e)
{
var db = new x360ce.Engine.Data.x360ceModelContainer();
var data = ExecuteStoredProcedure(db, "x360ce_GetNewDeviceStats", null);
var table = data.Tables[0];
DateTime fromDate = new DateTime();
DateTime toDate = new DateTime();
for (int i = 0; i < table.Rows.Count; i++)
{
var row = table.Rows[i];
var date = (System.DateTime)row["Date"];
var newDevices = (int)row["NewDevices"];
var newDevicesSum = (int)row["NewDevicesSum"];
this.Chart1.Series["Controllers"].Points.Add(newDevicesSum);
if (i == 0) fromDate = date;
toDate = date;
}
this.Chart1.Titles["Title1"].Text = string.Format("Controllers in Database • Monthly, {0:yyyy-MM} - {1:yyyy-MM}", fromDate, toDate);
}
protected void Page_Load(object sender, EventArgs e)
{
var db = new x360ce.Engine.Data.x360ceModelContainer();
var data = ExecuteStoredProcedure(db, "x360ce_GetNewDeviceStats", null);
var table = data.Tables[0];
DateTime fromDate = new DateTime();
DateTime toDate = new DateTime();
for (int i = 0; i < table.Rows.Count; i++)
{
var row = table.Rows[i];
var date = (System.DateTime)row["Date"];
var newDevices = (int)row["NewDevices"];
var newDevicesSum = (int)row["NewDevicesSum"];
this.Chart1.Series["Controllers"].Points.Add(newDevicesSum);
if (i == 0)
{
fromDate = date;
}
toDate = date;
}
this.Chart1.Titles["Title1"].Text = string.Format("Controllers in Database • Monthly, {0:yyyy-MM} - {1:yyyy-MM}", fromDate, toDate);
}
