public async Task AddDataFromSensors(SmartHome smartHome)
{
await _smartHome.InsertOneAsync(smartHome);
string groupName = "dataFromSensor";
_ = _hub.Clients.Group(groupName).SendAsync("ReceiveMessage", smartHome);
}
public async Task <IActionResult> AddDataFromSensor([FromBody] SmartHome sm)
{
await _repository.AddDataFromSensors(sm);
string message = JsonSerializer.Serialize(sm);
double temperature = sm.Temperature;
_messageService.Enqueue(temperature.ToString());
return(Ok("Success. Data added"));
}
public SmartHome mapToModel(string dataArray)
{
string[] splitedDataArray = dataArray.Split(",");
SmartHome newSmartHomeObject = new SmartHome();
if (splitedDataArray[0] != " ")
{
DateTimeOffset dateTimeOffset = DateTimeOffset.FromUnixTimeSeconds(Convert.ToInt32(splitedDataArray[0]));
DateTime dateTimeCounted = dateTimeOffset.DateTime;
newSmartHomeObject.Time = dateTimeCounted;
}
else
{
DateTime epoch = new DateTime(1970, 1, 1, 0, 0, 0, DateTimeKind.Utc);
newSmartHomeObject.Time = epoch;
}
newSmartHomeObject.Use = splitedDataArray[1] == " " ? 0 : Convert.ToDouble(splitedDataArray[1]);
newSmartHomeObject.Gen = splitedDataArray[2] == " " ? 0 : Convert.ToDouble(splitedDataArray[2]);
newSmartHomeObject.HouseOverall = splitedDataArray[3] == " " ? 0 : Convert.ToDouble(splitedDataArray[3]);
newSmartHomeObject.Dishwasher = splitedDataArray[4] == " " ? 0 : Convert.ToDouble(splitedDataArray[4]);
newSmartHomeObject.Furnace1 = splitedDataArray[5] == " " ? 0 : Convert.ToDouble(splitedDataArray[5]);
newSmartHomeObject.Furnace2 = splitedDataArray[6] == " " ? 0 : Convert.ToDouble(splitedDataArray[6]);
newSmartHomeObject.HomeOffice = splitedDataArray[7] == " " ? 0 : Convert.ToDouble(splitedDataArray[7]);
newSmartHomeObject.Fridge = splitedDataArray[8] == " " ? 0 : Convert.ToDouble(splitedDataArray[8]);
newSmartHomeObject.WineCellar = splitedDataArray[9] == " " ? 0 : Convert.ToDouble(splitedDataArray[9]);
newSmartHomeObject.GarageDoor = splitedDataArray[10] == " " ? 0 : Convert.ToDouble(splitedDataArray[10]);
newSmartHomeObject.Kitchen1 = splitedDataArray[11] == " " ? 0 : Convert.ToDouble(splitedDataArray[11]);
newSmartHomeObject.Kitchen2 = splitedDataArray[12] == " " ? 0 : Convert.ToDouble(splitedDataArray[12]);
newSmartHomeObject.Kitchen3 = splitedDataArray[13] == " " ? 0 : Convert.ToDouble(splitedDataArray[13]);
newSmartHomeObject.Barn = splitedDataArray[14] == " " ? 0 : Convert.ToDouble(splitedDataArray[14]);
newSmartHomeObject.Well = splitedDataArray[15] == " " ? 0 : Convert.ToDouble(splitedDataArray[15]);
newSmartHomeObject.Microwave = splitedDataArray[16] == " " ? 0 : Convert.ToDouble(splitedDataArray[16]);
newSmartHomeObject.LivingRoom = splitedDataArray[17] == " " ? 0 : Convert.ToDouble(splitedDataArray[17]);
newSmartHomeObject.Solar = splitedDataArray[18] == " " ? 0 : Convert.ToDouble(splitedDataArray[18]);
newSmartHomeObject.Temperature = splitedDataArray[19] == " " ? 0 : Convert.ToDouble(splitedDataArray[19]);
newSmartHomeObject.Icon = splitedDataArray[20];
newSmartHomeObject.Humidity = splitedDataArray[21] == " " ? 0 : Convert.ToDouble(splitedDataArray[21]);
newSmartHomeObject.Visibility = splitedDataArray[22] == " " ? 0 : Convert.ToDouble(splitedDataArray[22]);
newSmartHomeObject.Summary = splitedDataArray[23];
newSmartHomeObject.ApparentTemperature = splitedDataArray[24] == " " ? 0 : Convert.ToDouble(splitedDataArray[24]);
newSmartHomeObject.Pressure = splitedDataArray[25] == " " ? 0 : Convert.ToDouble(splitedDataArray[25]);
newSmartHomeObject.WindSpeed = splitedDataArray[26] == " " ? 0 : Convert.ToDouble(splitedDataArray[26]);
newSmartHomeObject.CloudCover = splitedDataArray[27];
newSmartHomeObject.WindBearing = splitedDataArray[28] == " " ? 0 : Convert.ToDouble(splitedDataArray[28]);
newSmartHomeObject.PrecipIntensity = splitedDataArray[29] == " " ? 0 : Convert.ToDouble(splitedDataArray[29]);
newSmartHomeObject.DewPoint = splitedDataArray[30] == " " ? 0 : Convert.ToDouble(splitedDataArray[30]);
newSmartHomeObject.PrecipProbability = splitedDataArray[31] == " " ? 0 : Convert.ToDouble(splitedDataArray[31]);
return(newSmartHomeObject);
}
public SmartHome GetSmartHomeById(int id)
{
SmartHome smartHome = null;
using (var dbContext = new LocalDbContext())
{
smartHome = dbContext
.SmartHomes
.Include(smh => smh.User) // eagerly loading
.FirstOrDefault(smh => smh.Id == id);
}
return(smartHome);
}
public async Task <string> AddDataFromSensors(SmartHome smartHome)
{
using (var httpClient = new HttpClient())
{
var c = JsonConvert.SerializeObject(smartHome);
StringContent content = new StringContent(c, Encoding.UTF8, "application/json");
using (var response = await httpClient.PostAsync("http://Data_Service:80/api/smartHomeData", content))
{
string apiResponse = await response.Content.ReadAsStringAsync();
return(apiResponse);
}
}
}
public Object setSensorType(SmartHome smartHome)
{
if (StaticClasses.SmartHomeStaticData.sensorType == 1)
{
return(smartHome);
}
else if (StaticClasses.SmartHomeStaticData.sensorType == 2)
{
SmartHomeElectricityDto electricityDto = new SmartHomeElectricityDto();
electricityDto.Time = smartHome.Time;
electricityDto.Use = smartHome.Use;
electricityDto.Gen = smartHome.Gen;
electricityDto.HouseOverall = smartHome.HouseOverall;
electricityDto.Dishwasher = smartHome.Dishwasher;
electricityDto.Furnace1 = smartHome.Furnace1;
electricityDto.Furnace2 = smartHome.Furnace2;
electricityDto.HomeOffice = smartHome.HomeOffice;
electricityDto.Fridge = smartHome.Fridge;
electricityDto.WineCellar = smartHome.WineCellar;
electricityDto.GarageDoor = smartHome.GarageDoor;
electricityDto.Kitchen1 = smartHome.Kitchen1;
electricityDto.Kitchen2 = smartHome.Kitchen2;
electricityDto.Kitchen3 = smartHome.Kitchen3;
electricityDto.Barn = smartHome.Barn;
electricityDto.Well = smartHome.Well;
electricityDto.Microwave = smartHome.Microwave;
electricityDto.LivingRoom = smartHome.LivingRoom;
electricityDto.Solar = smartHome.Solar;
return(electricityDto);
}
else
{
SmartHomeSensorsExceptElectricityDto otherSensors = new SmartHomeSensorsExceptElectricityDto();
otherSensors.Time = smartHome.Time;
otherSensors.Temperature = smartHome.Temperature;
otherSensors.Icon = smartHome.Icon;
otherSensors.Humidity = smartHome.Humidity;
otherSensors.Visibility = smartHome.Visibility;
otherSensors.Summary = smartHome.Summary;
otherSensors.ApparentTemperature = smartHome.ApparentTemperature;
otherSensors.Pressure = smartHome.Pressure;
otherSensors.WindSpeed = smartHome.WindSpeed;
otherSensors.CloudCover = smartHome.CloudCover;
otherSensors.WindBearing = smartHome.WindBearing;
otherSensors.PrecipIntensity = smartHome.PrecipIntensity;
otherSensors.DewPoint = smartHome.DewPoint;
otherSensors.PrecipProbability = smartHome.PrecipProbability;
return(otherSensors);
}
}
public async Task DoWork(CancellationToken stoppingToken)
{
System.Text.Encoding.RegisterProvider(System.Text.CodePagesEncodingProvider.Instance);
if (!stoppingToken.IsCancellationRequested)
{
string host = "xz04k8.messaging.internetofthings.ibmcloud.com";
string clientid = "d:xz04k8:Sensors:SmartHomeSensor";
string username = "******";
string password = "******";
string topic = "iot-2/evt/smarthomesensor/fmt/json";
MqttClient mQttClient = new MqttClient(host);
mQttClient.Connect(clientid, username, password);
string filePath = "./Data/SOA_DATA.xlsx";
using (var stream = File.Open(filePath, FileMode.Open, FileAccess.Read))
{
using (var reader = ExcelReaderFactory.CreateReader(stream))
{
do
{
while (!stoppingToken.IsCancellationRequested && reader.Read())
{
string currentRow = "";
for (int i = 0; i < reader.FieldCount; i++)
{
if (reader.GetValue(i) == null)
{
currentRow += " ,";
}
else
{
currentRow += reader.GetValue(i).ToString() + ",";
}
}
SmartHome newSmartHomeObject = mapToModel(currentRow);
var json = new JavaScriptSerializer().Serialize(newSmartHomeObject);
mQttClient.Publish(topic, Encoding.UTF8.GetBytes(json));
_logger.LogInformation(json);
await Task.Delay(2500, stoppingToken);
}
} while (reader.NextResult());
}
}
mQttClient.Disconnect();
}
}
public async Task DoWork(CancellationToken stoppingToken)
{
System.Text.Encoding.RegisterProvider(System.Text.CodePagesEncodingProvider.Instance);
if (!stoppingToken.IsCancellationRequested)
{
//string filePath = "C:/Users/Stefan-PC/Desktop/SOA/SOA/SOA/SOA_PROJEKAT_1/SOA_PROJEKAT_1/Data_Service/Data/SOA_DATA.xlsx";
string filePath = "./Data/SOA_DATA.xlsx";
using (var stream = File.Open(filePath, FileMode.Open, FileAccess.Read))
{
using (var reader = ExcelReaderFactory.CreateReader(stream))
{
do
{
while (!stoppingToken.IsCancellationRequested && reader.Read())
{
string currentRow = "";
for (int i = 0; i < reader.FieldCount; i++)
{
if (reader.GetValue(i) == null)
{
currentRow += " ,";
}
else
{
currentRow += reader.GetValue(i).ToString() + ",";
}
}
SmartHome newSmartHomeObject = mapToModel(currentRow);
Object smartHomeObject = setSensorType(newSmartHomeObject);
await sendData(smartHomeObject);
_logger.LogInformation(smartHomeObject.ToString());
int timeInterval = StaticClasses.SmartHomeStaticData.timeInterval * 1000;
await Task.Delay(timeInterval, stoppingToken);
}
} while (reader.NextResult());
}
}
}
}
public async Task <IActionResult> AddDataFromSensors([FromBody] SmartHome sm)
{
string result = await _gatewayService.AddDataFromSensors(sm);
return(Ok(result));
}
public async Task SendMessage(SmartHome mess, string groupName)
{
//await Clients.Group(groupName).SendAsync("Send",mess);
await Clients.Group(groupName).SendAsync("ReceiveMessage", mess);
}
public void sendToAll(SmartHome sm)
{
Clients.All.SendAsync("sendToDashBoard", sm);
}
// ReSharper disable once UnusedParameter.Local
private static void Main(string[] args)
{
Console.WriteLine("Netatmo Presence App");
var auth = new Authentication();
var fileName = @"C:\Temp\Netatmo.cfg";
if (!File.Exists(fileName))
{
Console.WriteLine($"Missing config file: {fileName}");
Console.WriteLine("Containing one text line clientId <TAB> clientSecret <TAB> username <TAB> password");
Environment.Exit(1);
}
var authParams = File.ReadAllLines(fileName).First().Split('\t');
var token = auth.GetAccessTokens(authParams[0], authParams[1], authParams[2], authParams[3],
new List <string> {
Scopes.ReadCamera, Scopes.ReadPresence
});
if (token == null)
{
Console.WriteLine("Failed to authenticate.");
Environment.Exit(1);
}
Console.WriteLine($"AccessToken = {token.AccessToken}");
var homeData = SmartHome.GetHomeData(token.AccessToken);
foreach (var home in homeData.Homes)
{
Console.WriteLine($"Home({home.Id}): {home.Name}, {home.Place.City}");
foreach (var camera in home.Cameras)
{
Console.WriteLine($"Camera({camera.Id}): {camera.Name}");
}
}
var firstCamera = homeData.Homes.First().Cameras.First();
var events = Presence.GetCameraEvents(token.AccessToken, firstCamera.Id, 5);
foreach (var ev in events)
{
Console.WriteLine($"{ev.LocalTime():g} {ev.Type}({ev.Category}): {ev.MessageText()}");
}
fileName = @"C:\Temp\WebHook.cfg";
if (File.Exists(fileName))
{
var hookUrl = File.ReadAllLines(fileName).First().Trim();
Console.WriteLine("Start WebHook Server");
var hook = new WebHookServer(60606);
hook.OnEvent += ev =>
{
Console.WriteLine($"HookEvent: {ev.EventType} {ev.Message}");
};
hook.Start();
Console.WriteLine($"Register WebHook Server on {hookUrl}");
var ok = WebHook.Add(token.AccessToken, hookUrl);
Console.WriteLine("Register WebHook Server: " + (ok ? "OK" : "FAILED"));
Console.WriteLine();
Console.WriteLine("Press RETURN to exit.");
Console.ReadLine();
Console.WriteLine("Unegister WebHook Server");
ok = WebHook.Drop(token.AccessToken);
Console.WriteLine("Unegister WebHook Server: " + (ok ? "OK" : "FAILED"));
Console.WriteLine("Terminate WebHook Server");
hook.Terminate();
}
else
{
Console.WriteLine("No WebHook configured.");
Console.WriteLine();
Console.WriteLine("Press RETURN to exit.");
Console.ReadLine();
}
Console.WriteLine("Netatmo Presence App DONE.");
}
//PUT api/smartHome
public void Put(int id, [FromBody] SmartHome smartHome)
{
DataAccessHelper <SmartHome> .UpdateEntity(id, smartHome);
}
//POST api/smartHome
public SmartHome CreateSmartHome([FromBody] SmartHome smartHome)
{
return(DataAccessHelper <SmartHome> .AddEntity(smartHome));
}
