public async Task <List <EnergyPriceClass> > QueryEnergyPriceAsync()
{
Methods = new METHOD();
string fileToday = $"CurrentEnergyPrice{METHOD.DateTimeTZ():dd-MM-yyyy}";
string fileYesterday = $"CurrentEnergyPrice{METHOD.DateTimeTZ().AddDays(-1):dd-MM-yyyy}";
fileToday = Methods.GetFilePath(fileToday);
//delete yesterday file, we dont need to collect them
fileYesterday = Methods.GetFilePath(fileYesterday);
if (File.Exists(fileYesterday))
{
File.Delete(fileYesterday);
}
if (File.Exists(fileToday)) //is there already file with today energy prices
{
var dataFromFile = await Methods.OpenExistingFile(fileToday);
energyPriceToday = JsonSerializer.Deserialize <List <EnergyPriceClass> >(dataFromFile.ToString());
}
if (!File.Exists(fileToday)) //file with today energy price is missing
{
try
{
string MarketPriceToday = METHOD.DateTimeTZ().ToString("dd.MM.yyyy");
energyPriceToday = await GetMarketPrice(MarketPriceToday);
var jsonString = JsonSerializer.Serialize(energyPriceToday);
await Methods.SaveStringToLocalFile(fileToday, jsonString);
}
catch (Exception e)
{
Console.WriteLine("Receive energy price from Cosmos exception: " + e.Message);
}
}
return(energyPriceToday);
}
public async void QueryWiFiProbes()
{
http.DefaultRequestHeaders.Authorization = new AuthenticationHeaderValue("Basic", Convert.ToBase64String(Encoding.ASCII.GetBytes($"{username}:{password}")));
var filename = Methods.GetFilePath(CONSTANT.FILENAME_HOME_DEVICES);
try
{
//open file and -> list of devices from Raspberry if the file exists
if (File.Exists(filename))
{
var result = await Methods.OpenExistingFile(filename);
WiFiDevice.WellKnownDevices = JsonSerializer.Deserialize <List <WiFiDevice> >(result).ToList();
}
else
{
double unixTimestamp = DateTime.UtcNow.Subtract(new DateTime(1970, 1, 1)).TotalSeconds;
//following will happen only if there is no file on Raspberry and the list will be loaded from the environment variables
WiFiDevice.WellKnownDevices.ForEach(x => x.StatusUnixTime = unixTimestamp);
}
}
catch (Exception e)
{
Console.WriteLine($"open file {e}");
}
await SendMacAddressToCosmos(WiFiDevice.WellKnownDevices);
bool isAnyDeviceChanged = true;
var UnknownDevices = new List <WiFiDevice>();
while (true)
{
double unixTimestamp = METHOD.DateTimeToUnixTimestamp(DateTime.UtcNow);
double timeOffset = METHOD.DateTimeTZ().Offset.TotalHours;
//if there are some items from PowerApps then proceed
if (WiFiDevicesFromPowerApps.Any())
{
//Add, Remove or Change WiFiDevices list according to WiFiDevices From PowerApps
WiFiDevice.WellKnownDevices = AddRemoveChangeDevices(WiFiDevicesFromPowerApps, WiFiDevice.WellKnownDevices);
WiFiDevicesFromPowerApps.Clear();
//send all devices to CosmosDB
await SendMacAddressToCosmos(WiFiDevice.WellKnownDevices);
}
//prepare multimac query
//create a list of the MAC Addresses for multimac query
List <string> deviceMacs = new List <string>();
WiFiDevice.WellKnownDevices.ForEach(x => deviceMacs.Add(x.MacAddress));
string jsonMacAddresses = JsonSerializer.Serialize(deviceMacs);
string urlMultiMac = $"{urlKismet}/devices/multimac/devices.json";
string jsonContentFieldsMac = "json={\"fields\":" + jsonFields + ",\"devices\":" + jsonMacAddresses + "}";
List <WiFiDevice> KismetKnownDevices = await GetDevices(urlMultiMac, jsonContentFieldsMac);
//clear devices list.
WiFiDevicesToPowerApps.Clear();
//building list of the local devices which are last seen
foreach (var knownDevice in WiFiDevice.WellKnownDevices)
{
foreach (var kismet in KismetKnownDevices)
{
if (knownDevice.MacAddress == kismet.MacAddress)
{
knownDevice.LastUnixTime = kismet.LastUnixTime;
knownDevice.LastSignal = kismet.LastSignal;
knownDevice.SignalType = kismet.SignalType;
knownDevice.SSID = kismet.SSID;
knownDevice.WiFiName = kismet.ProbedSSID;
if (kismet.SignalType.Contains("Wi-Fi"))
{
knownDevice.AccessPoint = WiFiDevice.WellKnownDevices.Where(x => x.MacAddress == kismet.LastBSSID).Select(x => x.DeviceName).DefaultIfEmpty("No AP").First();
if (string.IsNullOrEmpty(knownDevice.WiFiName) || knownDevice.WiFiName == "0")
{
knownDevice.WiFiName = WiFiDevice.WellKnownDevices.Where(x => x.MacAddress == kismet.LastBSSID).Select(x => x.SSID).DefaultIfEmpty("No AP").First();
}
}
break;
}
}
//checking active devices and setting Active/NonActive statuses. Each device can have individual timewindow
knownDevice.IsChanged = false; //this is just for debugging, no other reason
var durationUntilNotActive = (unixTimestamp - knownDevice.LastUnixTime) / 60; //timestamp in minutes
knownDevice.IsPresent = durationUntilNotActive < knownDevice.ActiveDuration;
if (knownDevice.IsPresent && !knownDevice.StatusChange)
{
knownDevice.StatusUnixTime = unixTimestamp;
knownDevice.StatusChange = true;
isAnyDeviceChanged = true;
knownDevice.IsChanged = true;
}
if (!knownDevice.IsPresent && knownDevice.StatusChange)
{
knownDevice.StatusUnixTime = knownDevice.LastUnixTime;
knownDevice.StatusChange = false;
isAnyDeviceChanged = true;
knownDevice.IsChanged = true;
}
//following list WiFiDevicesToPowerApps is used to send minimal data to PowerApps (sending only userdevices)
//this list will be sent as a response after PowerApps asks something or refreshing it's data
if (knownDevice.DeviceType != WiFiDevice.DEVICE)
{
WiFiDevicesToPowerApps.Add(new Localdevice()
{
DeviceOwner = knownDevice.DeviceOwner,
DeviceName = knownDevice.DeviceName,
DeviceType = knownDevice.DeviceType,
IsPresent = knownDevice.IsPresent,
StatusFrom = METHOD.UnixTimeStampToDateTime(knownDevice.StatusUnixTime),
ActiveDuration = knownDevice.ActiveDuration,
MacAddress = knownDevice.MacAddress,
SignalType = knownDevice.SignalType,
IsChanged = knownDevice.IsChanged
});
}
//build a list with the names who is expected to track
//this list will be sent through Azure Functions to the owners e-mail
if (knownDevice.DeviceType == WiFiDevice.MOBILE || knownDevice.DeviceType == WiFiDevice.WATCH || knownDevice.DeviceType == WiFiDevice.CAR)
{
//to be sure that every person is listed just once
if (!WiFiDevicesWhoIsChanged.Any(x => x.DeviceOwner == knownDevice.DeviceOwner) || !WiFiDevicesWhoIsChanged.Any())
{
WiFiDevicesWhoIsChanged.Add(new Localdevice()
{
DeviceOwner = knownDevice.DeviceOwner,
DeviceName = knownDevice.DeviceName,
IsPresent = knownDevice.IsPresent,
StatusFrom = METHOD.UnixTimeStampToDateTime(knownDevice.StatusUnixTime),
SignalType = knownDevice.SignalType,
IsChanged = knownDevice.IsChanged
});
}
}
}
//update the list of the correct statuses, are they home or away
foreach (var item in WiFiDevicesWhoIsChanged)
{
item.IsChanged = false;
foreach (var device in WiFiDevicesToPowerApps)
{
if (item.DeviceOwner == device.DeviceOwner && (device.DeviceType == WiFiDevice.MOBILE || device.DeviceType == WiFiDevice.WATCH || device.DeviceType == WiFiDevice.CAR))
{
if (device.IsChanged)
{
item.IsChanged = device.IsChanged;
item.DeviceName = device.DeviceName;
item.StatusFrom = device.StatusFrom.AddHours(timeOffset);
item.SignalType = device.SignalType;
item.IsPresent = device.IsPresent;
}
//if device is exist and has'nt been changed, then mark it as unchanged and move to next item
//if device is not exist (not seen) but has been changed then mark it as unchanged and move to next item = do not notify leaving devices
//this is XOR
if (device.IsPresent ^ device.IsChanged)
{
item.IsChanged = false;
break;
}
}
}
}
//save the data locally into Raspberry
var jsonString = JsonSerializer.Serialize(WiFiDevice.WellKnownDevices);
await Methods.SaveStringToLocalFile(filename, jsonString);
//send an e-mail only if someone has arrived at home or left the home
if (WiFiDevicesWhoIsChanged.Any(x => x.IsChanged))
{
string status = "Look who is at home:\n\n";
WiFiDevicesWhoIsChanged.ForEach(x => status += $"{(x.IsPresent ? x.DeviceOwner + " " + x.DeviceName + " at home from" : x.DeviceOwner + " not seen since")} {x.StatusFrom:HH:mm dd.MM.yyyy} \n ");
var x = WiFiDevicesWhoIsChanged.First(x => x.IsChanged);
string whoChanged = $"{(x.IsPresent ? x.DeviceOwner + " at home " : x.DeviceOwner + " not seen since")} {x.StatusFrom:HH:mm dd.MM.yyyy}";
_sendListData = new SendDataAzure();
TelemetryDataClass.SourceInfo = $"{whoChanged}";
//send data to CosmosDB
var monitorData = new
{
DeviceID = "HomeController",
TelemetryDataClass.SourceInfo,
status,
DateAndTime = METHOD.DateTimeTZ().DateTime,
isHomeSecured = true
};
await _sendListData.PipeMessage(monitorData, Program.IoTHubModuleClient, TelemetryDataClass.SourceInfo, "output");
}
//if any mobile phone or watch is present then someone is at home
IsAnyMobileAtHome = WiFiDevice.WellKnownDevices.Any(x => x.IsPresent && (x.DeviceType == WiFiDevice.MOBILE || x.DeviceType == WiFiDevice.WATCH || x.DeviceType == WiFiDevice.CAR));
//if security mode automatic and home secured then unsecure home if any known mobile device is seen
if (IsAnyMobileAtHome && TelemetryDataClass.isHomeSecured && !SomeoneAtHome.IsSecurityManuallyOn)
{
SomeoneAtHome.SomeoneAtHomeChanged();
}
#region Known Device Listing, only for debugging
//for local debugging only show the active/non active devices in console window
if (isAnyDeviceChanged)
{
isAnyDeviceChanged = false;
var sortedList = WiFiDevice.WellKnownDevices.OrderByDescending(y => y.IsPresent).ThenBy(w => w.AccessPoint).ThenBy(z => z.SignalType).ThenBy(x => x.DeviceName).ToList();
Console.WriteLine();
Console.WriteLine($"All known devices at: {METHOD.DateTimeTZ().DateTime:G}");
Console.WriteLine();
Console.WriteLine($" | From | Status | Device | WiFi network | AccessPoint | SignalType");
Console.WriteLine($" | ------ | ------- | -------- | ----- | ----- | -------- ");
foreach (var device in sortedList)
{
if (device.LastUnixTime > 0 && device.SignalType != "Wi-Fi AP" && device.DeviceOwner != "Unknown" && device.DeviceType != WiFiDevice.DEVICE) //show only my own ever seen LocalUserDevices devices
{
Console.WriteLine($" {(device.IsChanged ? "1" : " ")} " +
$"| {METHOD.UnixTimeStampToDateTime(device.StatusUnixTime).AddHours(timeOffset):T} " +
$"| {(device.IsPresent ? "Active " : "Not Act")} " +
$"| {device.DeviceName}{"".PadRight(26 - (device.DeviceName.Length > 26 ? 26 : device.DeviceName.Length))}" +
$"| {device.WiFiName}{"".PadRight(26 - (!string.IsNullOrEmpty(device.WiFiName) ? (device.WiFiName.Length > 26 ? 26 : device.WiFiName.Length) : 0))}" +
$"| {device.AccessPoint}{"".PadRight(26 - (!string.IsNullOrEmpty(device.AccessPoint) ? (device.AccessPoint.Length > 26 ? 26 : device.AccessPoint.Length) : 0))}" +
$"| {device.SignalType} ");
}
}
Console.WriteLine();
}
#endregion
#region Unknown Devices Debugging
//prepare last active devices query
string urlLastActive = $"{urlKismet}/devices/last-time/{CONSTANT.ACTIVE_DEVICES_IN_LAST}/devices.json";
string jsonContentFields = "json={\"fields\":" + jsonFields + "}";
List <WiFiDevice> KismetActiveDevices = await GetDevices(urlLastActive, jsonContentFields);
//removing all known devices from the last seen devices list
//known devices are all locally registered devices in the list WiFiDevice.WifiDevices
var tempDelList = new List <WiFiDevice>();
var AllActiveDevices = new List <WiFiDevice>(KismetActiveDevices);
foreach (var kismet in KismetActiveDevices)
{
foreach (var knownDevice in WiFiDevice.WellKnownDevices)
{
if (kismet.MacAddress == knownDevice.MacAddress || kismet.LastSignal < CONSTANT.SIGNAL_TRESHOLD || (kismet.CommonName == kismet.MacAddress && kismet.Manufacture == "Unknown"))
{
tempDelList.Add(kismet);
break;
}
}
}
KismetActiveDevices.RemoveAll(i => tempDelList.Contains(i));
//adding new members to the close devices list
if (KismetActiveDevices.Any())
{
var tempAddList = new List <WiFiDevice>();
bool isNewItem = true;
foreach (var kismet in KismetActiveDevices)
{
foreach (var unknownDevice in UnknownDevices)
{
if (kismet.MacAddress == unknownDevice.MacAddress)
{
unknownDevice.Count++;
unknownDevice.LastUnixTime = kismet.LastUnixTime;
unknownDevice.WiFiName = kismet.ProbedSSID;
if (kismet.SignalType.Contains("Wi-Fi"))
{
//get device AccessPoint and WIFI network names from Kismet (if reported by device)
List <WiFiDevice> KismetOneMac = new List <WiFiDevice>();
string urlOneMac = $"{urlKismet}/devices/by-mac/{kismet.MacAddress}/devices.json";
KismetOneMac = await GetDevices(urlOneMac, jsonContentFields);
//have to check KismetOneMac list because sometimes it is empty
if (KismetOneMac.Any())
{
unknownDevice.AccessPoint = AllActiveDevices.Where(x => x.MacAddress == KismetOneMac.First().LastBSSID).Select(x => x.BaseName).DefaultIfEmpty("No AP").First();
if (string.IsNullOrEmpty(kismet.ProbedSSID) || unknownDevice.WiFiName == "0")
{
unknownDevice.WiFiName = AllActiveDevices.Where(x => x.MacAddress == KismetOneMac.First().LastBSSID).Select(x => x.SSID).DefaultIfEmpty("No AP").First();
}
}
}
isNewItem = false;
break;
}
else
{
isNewItem = true;
}
}
if (isNewItem)
{
tempAddList.Add(kismet);
}
}
UnknownDevices.AddRange(tempAddList.ToArray());
UnknownDevices.RemoveAll(x => (unixTimestamp - x.LastUnixTime) / 60 > 120); //remove all entries older that 2 hour
//local debugging: show the devices list in console only if some device has been added
if (tempAddList.Any() && UnknownDevices.Any())
{
var sortedList = UnknownDevices.OrderBy(x => x.SignalType).ThenByDescending(y => y.LastUnixTime).ToList();
Console.WriteLine();
Console.WriteLine($"All unknown devices at: {METHOD.DateTimeTZ().DateTime:G}");
Console.WriteLine();
Console.WriteLine($"dB | First | Last | Mac Address |Count | SignalType | WiFi network | AccessPoint | Common Name | Manufacturer ");
Console.WriteLine($" - | ---- | ---- | ----------- | --- | ---------- | --------- | --------- | ----------- | ----------- ");
foreach (var device in sortedList)
{
Console.WriteLine($"{device.LastSignal}{"".PadRight(device.LastSignal < 0 ? 1 : 3)}" +
$"| {METHOD.UnixTimeStampToDateTime(device.FirstUnixTime).AddHours(timeOffset):t} " +
$"| {METHOD.UnixTimeStampToDateTime(device.LastUnixTime).AddHours(timeOffset):t} " +
$"| {device.MacAddress} " +
$"| {device.Count}{"".PadRight(device.Count < 10 ? 3 : device.Count < 100 ? 2 : 1)} " +
$"| {device.SignalType}{"".PadRight(14 - (!string.IsNullOrEmpty(device.SignalType) ? (device.SignalType.Length > 14 ? 14 : device.SignalType.Length) : 0))}" +
$"| {device.WiFiName}{"".PadRight(26 - (!string.IsNullOrEmpty(device.WiFiName) ? (device.WiFiName.Length > 26 ? 26 : device.WiFiName.Length) : 0))}" +
$"| {device.AccessPoint}{"".PadRight(26 - (!string.IsNullOrEmpty(device.AccessPoint) ? (device.AccessPoint.Length > 26 ? 26 : device.AccessPoint.Length) : 0))}" +
$"| {device.CommonName}{"".PadRight(19 - (!string.IsNullOrEmpty(device.CommonName) ? (device.CommonName.Length > 19 ? 19 : device.CommonName.Length) : 0))}" +
$"| {device.Manufacture}");
}
Console.WriteLine();
}
}
#endregion
await Task.Delay(TimeSpan.FromSeconds(60)); //check statuses every 10 millisecond
}
}
private async Task <MethodResponse> HomeEdgeDeviceManagement(MethodRequest methodRequest, object userContext)
{
ReceiveData receiveData = new ReceiveData();
List <string> command = new List <string>();
try
{
var HomeCommands = JsonDocument.Parse(methodRequest.DataAsJson).RootElement;
if (HomeCommands.TryGetProperty("Ventilation", out JsonElement ventilation) && ventilation.GetBoolean() == !TelemetryDataClass.isVentilationOn)
{
string cmd = ventilation.GetBoolean() ? CommandNames.OPEN_VENT : CommandNames.CLOSE_VENT;
command.Add(cmd);
}
if (HomeCommands.TryGetProperty("Sauna", out JsonElement sauna) && (sauna.GetBoolean() == !TelemetryDataClass.isSaunaOn))
{
string cmd = sauna.GetBoolean() ? CommandNames.TURN_ON_SAUNA : CommandNames.TURN_OFF_SAUNA;
command.Add(cmd);
}
if (HomeCommands.TryGetProperty("Water", out JsonElement water) && water.GetBoolean() == !TelemetryDataClass.isWaterHeatingOn)
{
string cmd = water.GetBoolean() ? CommandNames.TURN_ON_HOTWATERPUMP : CommandNames.TURN_OFF_HOTWATERPUMP;
command.Add(cmd);
}
if (HomeCommands.TryGetProperty("Heating", out JsonElement heating) && heating.GetBoolean() == !TelemetryDataClass.isHeatingOn)
{
string cmd = heating.GetBoolean() ? CommandNames.TURN_ON_HEATING : CommandNames.TURN_OFF_HEATING;
command.Add(cmd);
}
if (HomeCommands.TryGetProperty("NormalTemp", out JsonElement normalTemp) && normalTemp.GetBoolean() == !TelemetryDataClass.isNormalHeating)
{
string cmd = normalTemp.GetBoolean() ? CommandNames.NORMAL_TEMP_COMMAND : CommandNames.REDUCE_TEMP_COMMAND;
command.Add(cmd);
}
if (HomeCommands.TryGetProperty("Vacation", out JsonElement vacation) && vacation.GetBoolean() == !TelemetryDataClass.isHomeInVacation)
{
string cmd = vacation.GetBoolean() ? CommandNames.TURN_ON_VACATION : CommandNames.TURN_OFF_VACATION;
SomeoneAtHome.IsSecurityManuallyOn = false; //if "vacation" is turned on or off then security is back in automatic mode
command.Add(cmd);
}
if (HomeCommands.TryGetProperty("Security", out JsonElement security) && security.GetBoolean() == !TelemetryDataClass.isHomeSecured)
{
string cmd = security.GetBoolean() ? CommandNames.TURN_ON_SECURITY : CommandNames.TURN_OFF_SECURITY;
SomeoneAtHome.IsSecurityManuallyOn = true; //override automatic security, this can be turned off with "vacation" mode
command.Add(cmd);
}
if (HomeCommands.TryGetProperty("Temperatures", out JsonElement temperatures))
{
//this data is coming from PowerApps
var Temperatures = JsonSerializer.Deserialize <List <SensorReading> >(temperatures.GetRawText());
string jsonString = JsonSerializer.Serialize(Temperatures);
var filename = Methods.GetFilePath(CONSTANT.FILENAME_ROOM_TEMPERATURES);
await Methods.SaveStringToLocalFile(filename, jsonString);
HomeTemperature.SetTemperatures(Temperatures);
}
}
catch (Exception e)
{
Console.WriteLine("Home device management: " + e.ToString());
}
foreach (string cmd in command)
{
if (cmd != null)
{
receiveData.ProcessCommand(cmd);
}
}
//This data goes back directly to PowerApps through Azure Functions
var reportedProperties = new TwinCollection();
reportedProperties["Ventilation"] = TelemetryDataClass.isVentilationOn;
reportedProperties["Water"] = TelemetryDataClass.isWaterHeatingOn;
reportedProperties["Heating"] = TelemetryDataClass.isHeatingOn;
reportedProperties["NormalTemp"] = TelemetryDataClass.isNormalHeating;
reportedProperties["Vacation"] = TelemetryDataClass.isHomeInVacation;
reportedProperties["VacationTime"] = TelemetryDataClass.VacationTime.ToString("HH:mm dd.MM.yyyy");
reportedProperties["Security"] = TelemetryDataClass.isHomeSecured;
reportedProperties["HomeSecuredTime"] = TelemetryDataClass.HomeSecuredTime.ToString("HH:mm dd.MM.yyyy");
reportedProperties["IsSecurityManuallyOn"] = SomeoneAtHome.IsSecurityManuallyOn;
reportedProperties["Co2"] = NetatmoDataClass.Co2;
reportedProperties["Temperature"] = NetatmoDataClass.Temperature;
reportedProperties["Humidity"] = NetatmoDataClass.Humidity;
reportedProperties["TemperatureOut"] = NetatmoDataClass.TemperatureOut;
reportedProperties["BatteryPercent"] = NetatmoDataClass.BatteryPercent;
reportedProperties["isRoomHeatingNow"] = Pins.IsRoomHeatingOn;
reportedProperties["isWaterHeatingNow"] = Pins.IsWaterHeatingOn;
reportedProperties["Sauna"] = TelemetryDataClass.isSaunaOn;
reportedProperties["isSaunaDoorOpen"] = Pins.IsSaunaDoorOpen;
reportedProperties["SaunaStartedTime"] = TelemetryDataClass.SaunaStartedTime.ToString("HH:mm");
reportedProperties["isSaunaHeatingNow"] = !(bool)Pins.PinRead(Pins.saunaHeatOutPin);
reportedProperties["isSomeoneAtHome"] = TelemetryDataClass.isSomeoneAtHome;
reportedProperties["isOutsideLightsOn"] = TelemetryDataClass.isOutsideLightsOn;
reportedProperties["isGarageLightsOn"] = TelemetryDataClass.isGarageLightsOn;
reportedProperties["isHomeDoorOpen"] = TelemetryDataClass.isHomeDoorOpen;
reportedProperties["Temperatures"] = HomeTemperature.ListOfAllSensors.Temperatures;
reportedProperties["Localdevices"] = WiFiProbes.WiFiDevicesToPowerApps;
var response = Encoding.ASCII.GetBytes(reportedProperties.ToJson());
return(new MethodResponse(response, 200));
}
