public void Unix_TimeStamp_Gives_Correct_Date()
{
TemperatureData tempObject = new TemperatureData("1511966889", "1", 1);
DateTime correctDatetime = new DateTime(2017, 11, 29, 15, 48, 9);
Assert.AreEqual(correctDatetime, tempObject.TimeStamp);
}
internal (TemperatureData, string, int) GetNewestWeatherforecastByStationId(string StationId, int day)
{
TemperatureData temperatureData = new TemperatureData { };
string date = "";
int forecastDay = 0;
using (SqlConnection conn = new SqlConnection(ConnectionString))
{
SqlCommand sqlCommand = new SqlCommand($"SELECT Max(Date) as Date, Max(Stores.Stores) as Stores, MAX(TempMean) as TempMean, AVG(Humidity) as Humidity, AVG(Pressure) as Pressure, min(TempMin) as TempMin, max(TempMax) as TempMax, Max(ForecastDay) as ForecastDay, Max(AlarmItem.AlarmItems) as AlarmItems FROM ForecastsFromArima JOIN (SELECT DISTINCT Subscriptions.StationId, COUNT(Subscriptions.ID) as Stores FROM Subscriptions Group by StationId) as Stores on Stores.StationId = ForecastsFromArima.StationId JOIN(SELECT SUM(Subscriptions.AlarmItems) as AlarmItems, MIN(Subscriptions.StartDate) as StartDate, Subscriptions.StationId FROM Subscriptions Group by Subscriptions.StationId) as AlarmItem ON AlarmItem.StationId = ForecastsFromArima.StationId WHERE Date = (SELECT MAX(DATE) FROM ForecastsFromArima) AND ForecastsFromArima.StationId = {StationId} AND ForecastsFromArima.ForecastDay = {day}", conn);
{
conn.Open();
using SqlDataReader sqlDataReader = sqlCommand.ExecuteReader();
while (sqlDataReader.Read())
{
temperatureData = new TemperatureData
{
Stores = Convert.ToSingle(sqlDataReader["Stores"]),
AlarmItems = Convert.ToSingle(sqlDataReader["AlarmItems"]),
TempMean = Convert.ToSingle(sqlDataReader["TempMean"]),
Humidity = Convert.ToSingle(sqlDataReader["Humidity"]),
Pressure = Convert.ToSingle(sqlDataReader["Pressure"]),
TempMin = Convert.ToSingle(sqlDataReader["TempMin"]),
TempMax = Convert.ToSingle(sqlDataReader["TempMax"])
};
date = sqlDataReader["Date"].ToString();
forecastDay = Convert.ToInt32(sqlDataReader["ForecastDay"].ToString());
}
conn.Close();
}
}
return (temperatureData, date, forecastDay);
}
ITemperatureDataService GetTemperatureDataService()
{
var mockContext = new Mock <IUnitOfWork>();
var expectedTemperatureData = new TemperatureData()
{
TemperatureDataID = 1, Temperature = 12, Huminity = 45, WindPower = 5
};
var mockDbSet = new Mock <ITemperatureData>();
mockDbSet.Setup(z =>
z.Find(
It.IsAny <Func <TemperatureData, bool> >(),
It.IsAny <int>(),
It.IsAny <int>()))
.Returns(
new List <TemperatureData>()
{
expectedTemperatureData
}
);
mockContext
.Setup(context =>
context.TemperatureDatas)
.Returns(mockDbSet.Object);
ITemperatureDataService TemperatureDataService = new TemperatureDataService(mockContext.Object);
return(TemperatureDataService);
}
public static void InsertTemperatureData()
{
Region lRegion = null;
using (var context = new IrrigationAdvisorContext())
{
#region Base
var lBase = new TemperatureData
{
Name = "noname",
Date = Utils.MIN_DATETIME,
RegionId = 0,
Min = 0,
Max = 0,
Average = 0,
ETC = 0,
Rain = 0,
};
#endregion
#region South
lRegion = (from region in context.Regions
where region.Name == Utils.NameRegionSouth
select region).FirstOrDefault();
//DataEntryDataTemperatures.DataTemperatures_South_2014(context, lRegion);
if (Program.ProcessFarm == Utils.IrrigationAdvisorProcessFarm.Demo)
{
DataEntryDataTemperatures.DataTemperatures_South_2015(context, lRegion);
}
DataEntryDataTemperatures.DataTemperatures_South_2016(context, lRegion);
DataEntryDataTemperatures.DataTemperatures_South_2017(context, lRegion);
DataEntryDataTemperatures.DataTemperatures_South_2018(context, lRegion);
#endregion
#region North
lRegion = (from region in context.Regions
where region.Name == Utils.NameRegionNorth
select region).FirstOrDefault();
//DataEntryDataTemperatures.DataTemperatures_North_2014(context, lRegion);
if (Program.ProcessFarm == Utils.IrrigationAdvisorProcessFarm.Demo)
{
DataEntryDataTemperatures.DataTemperatures_North_2015(context, lRegion);
}
DataEntryDataTemperatures.DataTemperatures_North_2016(context, lRegion);
DataEntryDataTemperatures.DataTemperatures_North_2017(context, lRegion);
DataEntryDataTemperatures.DataTemperatures_North_2018(context, lRegion);
#endregion
//context.TemperatureDatas.Add(lBase);
context.SaveChanges();
}
}
public override object Read(string path)
{
var rawData = new TemperatureData();
string txt;
using (var reader = new StreamReader(path))
{
txt = reader.ReadToEnd();
}
var grammar = new OpenFoamGrammar();
var parser = new Parser(grammar);
var tree = parser.Parse(txt);
foreach (ParseTreeNode rootEntryNode in tree.Root.FindDictEntries(null))
{
var identifier = rootEntryNode.GetEntryIdentifier();
switch (identifier)
{
//case "turbineArrayOn":
// rawData.TurbineArrayOn = rootEntryNode.GetBasicValBool();
// break;
}
}
return(rawData);
}
public static List <TemperatureData> GetData(string url) // TODO: Place in a Service
{
HttpWebRequest req = (HttpWebRequest)WebRequest.Create(url);
HttpWebResponse resp = (HttpWebResponse)req.GetResponse();
List <TemperatureData> data = new List <TemperatureData>();
using (StreamReader sr = new StreamReader(resp.GetResponseStream()))
{
sr.ReadLine(); // Ignore first line
int id = 1;
while (sr.Peek() != -1)
{
string line = sr.ReadLine();
List <string> lineValues = line.Split(',').ToList();
// Convert each line into an object
TemperatureData obj = new TemperatureData()
{
Id = id,
LocationName = lineValues[0],
Temperature = double.Parse(lineValues[1], CultureInfo.InvariantCulture),
ReadingTime = lineValues[2],
Latitude = double.Parse(lineValues[3], CultureInfo.InvariantCulture),
Longitude = double.Parse(lineValues[4], CultureInfo.InvariantCulture)
};
data.Add(obj);
id += 1;
}
}
return(data);
}
public async Task <IActionResult> PutTemperatureData([FromRoute] int id, [FromBody] TemperatureData temperatureData)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != temperatureData.ID)
{
return(BadRequest());
}
_context.Entry(temperatureData).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!TemperatureDataExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
public override object Read(string path)
{
var rawData = new TemperatureData();
string txt;
using (var reader = new StreamReader(path))
{
txt = reader.ReadToEnd();
}
var grammar = new OpenFoamGrammar();
var parser = new Parser(grammar);
var tree = parser.Parse(txt);
foreach (ParseTreeNode rootEntryNode in tree.Root.FindDictEntries(null))
{
var identifier = rootEntryNode.GetEntryIdentifier();
switch (identifier)
{
//case "turbineArrayOn":
// rawData.TurbineArrayOn = rootEntryNode.GetBasicValBool();
// break;
}
}
return rawData;
}
public void Get_InputId_CalledFindMethodOfDBSetWithCorrectId()
{
// Arrange
DbContextOptions opt = new DbContextOptionsBuilder <InquiryContext>()
.Options;
var mockContext = new Mock <InquiryContext>(opt);
var mockDbSet = new Mock <DbSet <TemperatureData> >();
mockContext
.Setup(context =>
context.Set <TemperatureData>(
))
.Returns(mockDbSet.Object);
TemperatureData expectedTemperatureData = new TemperatureData()
{
TemperatureDataID = 1
};
mockDbSet.Setup(mock => mock.Find(expectedTemperatureData.TemperatureDataID))
.Returns(expectedTemperatureData);
var repository = new TestTemperatureDataRepository(mockContext.Object);
//Act
var actualTemperatureData = repository.Get(expectedTemperatureData.TemperatureDataID);
// Assert
mockDbSet.Verify(
dbSet => dbSet.Find(
expectedTemperatureData.TemperatureDataID
), Times.Once());
Assert.Equal(expectedTemperatureData, actualTemperatureData);
}
public static void FillDb()
{
using (var db = new WeatherDbContext())
{
NumberFormatInfo provider = new NumberFormatInfo
{
NumberDecimalSeparator = ".",
NumberGroupSeparator = ",",
CurrencyDecimalDigits = 1
};
List <string> lines = File.ReadAllLines(filePath).ToList();
foreach (var line in lines)
{
string[] entries = line.Split(',');
var temperatureData = new TemperatureData
{
DateAndTime = DateTime.Parse(entries[0]),
Location = entries[1],
Temp = Convert.ToSingle(entries[2], provider),
Humidity = int.Parse(entries[3])
};
db.Temperatures.Add(temperatureData);
}
db.SaveChanges();
}
}
/// <summary>
/// Method handler that will return the current temperature and pressure information.
/// </summary>
/// <param name="methodRequest">The request that was sent from the server.</param>
/// <param name="userContext">The user context.</param>
/// <returns></returns>
public async Task <MethodResponse> GetTemperatureAndPreassure(MethodRequest methodRequest, object userContext)
{
// Print message to the console of the message that was received.
Console.ForegroundColor = ConsoleColor.Green;
Console.WriteLine($"Getting a request from Hub for temperature and preassure info.");
Console.ResetColor();
// Get temperature and preassure data.
Temperature temp = await _temperatureSensor.ReadTemperatureAsync();
double pressure = await _temperatureSensor.ReadPressureAsync();
// Print message to the console of the data.
Console.ForegroundColor = ConsoleColor.Green;
Console.WriteLine($"Temperature in degrees Fahrenheit: {temp.Fahrenheit}");
Console.WriteLine($"Preassure in Pascals: {pressure}");
Console.ResetColor();
// Construct the response object.
var result = new TemperatureData {
TemperatureInFahrenheit = temp.Fahrenheit, PreassureInPascals = pressure
};
var resultString = JsonConvert.SerializeObject(result);
return(new MethodResponse(Encoding.UTF8.GetBytes(resultString), 200));
}
public IHttpActionResult Post(string uniqueName, [FromBody] TemperatureData data)
{
try
{
if (data == null)
{
return(BadRequest("Resource data cannot be empty null or undifiend"));
}
if (string.IsNullOrWhiteSpace(uniqueName) || string.IsNullOrEmpty(uniqueName))
{
return(BadRequest("Resource name is required."));
}
using (var timeSeriesProxy = (TimeSeriesProxy)Configuration.DependencyResolver.GetService(typeof(TimeSeriesProxy)))
{
timeSeriesProxy.SetData(uniqueName + "_RSSI", DateTime.Now, data.RSSI.ToString(CultureInfo.InvariantCulture));
timeSeriesProxy.SetData(uniqueName + "_WakeTime", DateTime.Now, data.WakeTime.ToString(CultureInfo.InvariantCulture));
timeSeriesProxy.SetData(uniqueName + "_HeatIndex", DateTime.Now, data.HeatIndex.ToString(CultureInfo.InvariantCulture));
timeSeriesProxy.SetData(uniqueName + "_Humidity", DateTime.Now, data.Humidity.ToString(CultureInfo.InvariantCulture));
timeSeriesProxy.SetData(uniqueName + "_Temperature", DateTime.Now, data.Temperature.ToString(CultureInfo.InvariantCulture));
}
return(Ok());
}
catch (Exception ex)
{
return(InternalServerError(ex));
}
}
public ActionResult DeleteConfirmed(long id)
{
TemperatureData temperatureData = db.TemperatureDatas.Find(id);
db.TemperatureDatas.Remove(temperatureData);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public void Should_Not_Crash_When_Subzero_Is_Missing()
{
_testCsvFile = @"C:\Users\li.wirstrom\Documents\Code is King\FFCG.CodeIsKing\Meteorologist\src\WeatherData\testNoSubZero.csv";
List <TemperatureData> temperatureList = _fileReader.CSVReader(_testCsvFile, ';');
TemperatureData firstSubZero = _meteorologist.GetFirstBelowZero(temperatureList);
Assert.IsNull(firstSubZero);
}
public void Should_Save_Warmest_Temperature()
{
DateTime _warmestTemperature = new DateTime(2017, 10, 28, 12, 15, 44);
_testCsvFile = @"C:\Users\li.wirstrom\Documents\Code is King\FFCG.CodeIsKing\Meteorologist\src\WeatherData\testTemperatureData.csv";
List <TemperatureData> temperatureList = _fileReader.CSVReader(_testCsvFile, ';');
TemperatureData lowestTemperature = _meteorologist.GetColdestTemperature(temperatureList);
}
public string add(float temperature, int luminosity, int soilMoisture1, int soilMoisture2, int soilMoisture3)
{
var modelTemperature = new TemperatureData();
modelTemperature.RegistrationDate = DateTime.Now;
modelTemperature.Value = (decimal)temperature;
_db.TemperatureDatas.Add(modelTemperature);
var modelLuminosity = new LuminosityData();
modelLuminosity.RegistrationDate = DateTime.Now;
modelLuminosity.Value = luminosity;
_db.LuminosityDatas.Add(modelLuminosity);
var modelSoilMoisture1 = new SoilMoistureData();
modelSoilMoisture1.RegistrationDate = DateTime.Now;
modelSoilMoisture1.LineNr = 1;
modelSoilMoisture1.Value = soilMoisture1;
_db.SoilMoistureDatas.Add(modelSoilMoisture1);
var modelSoilMoisture2 = new SoilMoistureData();
modelSoilMoisture2.RegistrationDate = DateTime.Now;
modelSoilMoisture2.LineNr = 2;
modelSoilMoisture2.Value = soilMoisture2;
_db.SoilMoistureDatas.Add(modelSoilMoisture2);
var modelSoilMoisture3 = new SoilMoistureData();
modelSoilMoisture3.RegistrationDate = DateTime.Now;
modelSoilMoisture3.LineNr = 3;
modelSoilMoisture3.Value = soilMoisture3;
_db.SoilMoistureDatas.Add(modelSoilMoisture3);
_db.SaveChanges();
bool manualFansState = _db.SystemModuleStates.Single(sms => sms.ModuleName == "MANUAL_FANS").ModuleState;
bool manualHygrosState = _db.SystemModuleStates.Single(sms => sms.ModuleName == "MANUAL_HYGROS").ModuleState;
bool manualVentState = _db.SystemModuleStates.Single(sms => sms.ModuleName == "MANUAL_AIR_VENT").ModuleState;
string response = "";
if (manualFansState)
{
response += "sfx ";
}
if (manualHygrosState)
{
response += "shx ";
}
if (manualVentState)
{
response += "ovx ";
}
return(response);
}
public void Should_Save_First_Instance_Of_Lowest_Temperature()
{
_testCsvFile = @"C:\Users\li.wirstrom\Documents\Code is King\FFCG.CodeIsKing\Meteorologist\src\WeatherData\testTemperatureData.csv";
List <TemperatureData> temperatureList = _fileReader.CSVReader(_testCsvFile, ';');
TemperatureData lowestTemperature = _meteorologist.GetColdestTemperature(temperatureList);
DateTime _lowestTemperature = new DateTime(2017, 10, 28, 11, 35, 45);
Assert.AreNotEqual(_lowestTemperature, lowestTemperature);
}
public void Should_Save_First_Time_Temperature_Below_Zero()
{
_testCsvFile = @"C:\Users\li.wirstrom\Documents\Code is King\FFCG.CodeIsKing\Meteorologist\src\WeatherData\testTemperatureData.csv";
List <TemperatureData> temperatureList = _fileReader.CSVReader(_testCsvFile, ';');
TemperatureData firstSubZero = _meteorologist.GetFirstBelowZero(temperatureList);
DateTime correctFirstBelowZero = new DateTime(2017, 10, 28, 11, 30, 8);
Assert.AreEqual(correctFirstBelowZero, firstSubZero.TimeStamp);
Assert.AreEqual(-0.5, firstSubZero.Temperature);
}
public ActionResult Edit([Bind(Include = "TemperatureDataId,Name,Date,RegionId,Min,Max,Average,ETC,Rain")] TemperatureData temperatureData)
{
if (ModelState.IsValid)
{
db.Entry(temperatureData).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.RegionId = new SelectList(db.Regions, "RegionId", "Name", temperatureData.RegionId);
return(View(temperatureData));
}
public async Task <IActionResult> PostTemperatureData([FromBody] TemperatureData temperatureData)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
_context.Temperatures.Add(temperatureData);
await _context.SaveChangesAsync();
return(CreatedAtAction("GetTemperatureData", new { id = temperatureData.ID }, temperatureData));
}
private static void SendTelemetryData(string deviceId, double temp, double humidity)
{
Console.WriteLine("{0}: Sending data. Temp '{1}' / Hum '{2}'", DateTime.Now.ToLongTimeString(), temp, humidity);
var data = new TemperatureData()
{
DeviceId = deviceId,
Temperature = temp,
Humidity = humidity
};
client.Publish(TopicDevice2Service, Encoding.UTF8.GetBytes(JsonConvert.SerializeObject(data)));
}
public IHttpActionResult PostTemperature(TemperatureData data)
{
if (data == null || data.Temperature == null || data.Humidity == null)
{
return(InternalServerError(new System.Exception("Null parameters")));
}
var dao = new TemperatureDAO();
dao.Insert(data);
return(Ok());
}
// GET: TemperatureDatas/Details/5
public ActionResult Details(long?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
TemperatureData temperatureData = db.TemperatureDatas.Find(id);
if (temperatureData == null)
{
return(HttpNotFound());
}
return(View(temperatureData));
}
public JsonResult Convert(TemperatureData t)
{
if (t.Unit == "C")
{
t.Value = (t.Value * 1.8m) + 32;
t.Unit = "F";
}
else
{
t.Value = (t.Value - 32) / 1.8m;
t.Unit = "C";
}
return Json(t, JsonRequestBehavior.AllowGet);
}
/// <summary>
/// If TemperatureData exists in List, return the Temperature Data,
/// else return null
/// </summary>
/// <param name="pTemperatureData"></param>
/// <returns></returns>
public TemperatureData ExistTemperatureData(TemperatureData pTemperatureData)
{
TemperatureData lReturn = null;
foreach (TemperatureData item in TemperatureDataList)
{
if (item.Equals(pTemperatureData))
{
lReturn = item;
break;
}
}
return(lReturn);
}
public TemperatureData CreateTemperatureObject(string line)
{
var splitString = line.Split(";");
var splitDate = Array.ConvertAll(splitString[0].Split("-"), int.Parse);
var splitTime = Array.ConvertAll(splitString[1].Split(":"), int.Parse);
var temperatureData = new TemperatureData()
{
Date = new DateTime(splitDate[0], splitDate[1], splitDate[2], splitTime[0], splitTime[1], splitTime[2]),
AirTemperature = double.Parse(splitString[2]),
Quality = splitString[3]
};
return(temperatureData);
}
public JsonResult Convert(TemperatureData t)
{
if (t.Unit == "C")
{
t.Value = (t.Value * 1.8m) + 32;
t.Unit = "F";
}
else
{
t.Value = (t.Value - 32) / 1.8m;
t.Unit = "C";
}
return(Json(t, JsonRequestBehavior.AllowGet));
}
public async Task NotifyClient(TemperatureData temperature)
{
using (var context = IoTDbContext.Create())
{
var user = await context.Users.FirstOrDefaultAsync(u => u.Devices.Any(d => d.Key == temperature.DeviceId));
if (Connections.UserExists(user.Id))
{
var hubContext = GlobalHost.ConnectionManager.GetHubContext <TemperatureHub>();
var connId = Connections.GetConnections(user.Id).ToList();
hubContext.Clients.Clients(connId).receiveTemperature(temperature);
}
}
}
private void DoWork(object state)
{
//_logger.LogDebug($"DHT Service is working: {DateTime.Now}");
var temperature = new TemperatureData {
Temperature = _dht.Temperature.Celsius,
Humidity = _dht.Humidity,
IsLastReadSuccessful = _dht.IsLastReadSuccessful,
};
//_logger.LogDebug($"Read Success: {temperature.IsLastReadSuccessful}");
if (temperature.IsLastReadSuccessful)
{
_hubContext.Clients.All.SendAsync("ReceiveDhtStatus", $"Temperature: {_dht.Temperature.Celsius.ToString("0.0")} °C, Humidity: {_dht.Humidity.ToString("0.0")} %");
}
}
//private AnalogWaveform<double> _TemperatureData = new AnalogWaveform<double>(0);
#endregion
#region Constructors
public TemperatureHistoryViewModel()
{
//When Settings.CurrentTemperature is changed, the next point is appended to the TemperatureData property
Settings.CurrentTemperaturePropertyChanged += (sender, e) =>
{
TemperatureData.Append(new double[1] {
Settings.CurrentTemperature
});
CurrentTemperature = Settings.CurrentTemperature;
};
SetTemperatureCommand = new RelayCommand(
() => MessengerInstance.Send(new PidTimerMessage(true))
);
}
private object CreateDataModel(TemperatureData data, DateTime now)
{
return(data == null
? null
: new
{
d = data.CurrentDate,
t = data.Temperature,
h = data.Humidity,
dd = data.CurrentDate.ToShortTimeString(),
ddd = data.CurrentDate < now.AddDays(-1) ? data.CurrentDate.ToString("M") : null,
dt = FormatTemperature(data.Temperature),
dh = data.Humidity + "%"
});
}
// GET: TemperatureDatas/Edit/5
public ActionResult Edit(long?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
TemperatureData temperatureData = db.TemperatureDatas.Find(id);
if (temperatureData == null)
{
return(HttpNotFound());
}
ViewBag.RegionId = new SelectList(db.Regions, "RegionId", "Name", temperatureData.RegionId);
return(View(temperatureData));
}
