public object GetData()
{
var data = new AverageData();
var st = new DataTable();
using (var connection = SqlConnections.NewByKey("Store"))
//using (var connection = SqlConnections.NewFor<Entities.StoreRow>())
{
//using (var da = )
//return connection.Query<Item>("sp_GetStore",
// param: new
// {
// TenantId = Tenant
// },
// commandType: System.Data.CommandType.StoredProcedure);
var s = StoreRow.Fields;
data.StoreList = connection.List <StoreRow>(q => q
.SelectTableFields()
.Where(s.TenantId == (int)this.Tenant)
.OrderBy(s.ShopID, s.Key, s.Date, s.OperationID, s.MoveID));
return(data);
}
}
public AverageData NextAverage(double measurament)
{
var avg = new AverageData();
avg.measures = this.measures + 1;
double newAverage = (this.average * this.measures + measurament) / avg.measures;
avg.average = newAverage;
return(avg);
}
public object GetData()
{
var data = new AverageData();
var st = new DataTable();
using (var connection = SqlConnections.NewByKey("Store"))
{
var s = WarehouseRow.Fields;
data.StoreList = connection.List <WarehouseRow>(q => q
.SelectTableFields()
.Where(s.TenantId == (int)this.Tenant)
.OrderBy(s.ShopId, s.Key, s.Date, s.OperationId, s.MoveId));
return(data);
}
}
public void Average(string message)
{
Clients.All.broadcastAverageJson(message);
var data = JsonConvert.DeserializeObject <AverageDataStorm>(message, new JsonSerializerSettings
{
ContractResolver = new CamelCasePropertyNamesContractResolver()
});
var typedData = new AverageData
{
DeviceId = data.Device,
Average = Convert.ToDouble(data.Average),
Date = Convert.ToDateTime(data.Timestamp),
DeviceName = data.DeviceName
};
Clients.All.broadcastAverageData(JsonConvert.SerializeObject(typedData, new JsonSerializerSettings
{
ContractResolver = new CamelCasePropertyNamesContractResolver()
}));
var task = Task.Run(() =>
{
try
{
//This is the alpha version of PowerBI API Client.
//This version is obsolete, pls use the release one.
//More informations : https://github.com/Vtek/PowerBI.Api.Client
new PowerBiApi().Authenticate().Send("MyDatasetId", typedData);
}
catch
{
// ';..;' i'm a bad guy...
}
});
}
