public void SaveSilo(Model.Silo record, int bassinid)
{
using (Ringsted1Entities111 context = new Ringsted1Entities111())
{
Silo query = (from o in context.Silos
where o.BassinID == record.BassinID
select o).FirstOrDefault();
if (query == null)
{
Silo siloE = new Silo();
siloE.BassinID = bassinid;
siloE.FoodAmount = record.FoodAmount;
context.Silos.Add(siloE);
try
{
context.SaveChanges();
}
catch (Exception ex)
{
LoggerSingleton.Instance.Log("An exception occurred when attempting to save a new silo to the database: ", ex);
}
}
}
}
public void SaveSensor(Model.Sensor record)
{
using (Ringsted1Entities111 context = new Ringsted1Entities111())
{
Sensor query = (from o in context.Sensors
where o.BassinID == record.BassinID
select o).FirstOrDefault();
if (query == null)
{
Sensor sensorE = new Sensor();
sensorE.BassinID = record.BassinID;
sensorE.IPAddress = record.IP;
context.Sensors.Add(sensorE);
try
{
context.SaveChanges();
}
catch (Exception ex)
{
LoggerSingleton.Instance.Log("An exception occurred when attempting to save a new sensor to the database: ", ex);
}
}
}
}
public void SaveHall(Model.Hall record)
{
using (Ringsted1Entities111 context = new Ringsted1Entities111())
{
Hall query = (from o in context.Halls
where o.Name == record.Name
select o).FirstOrDefault();
//hall wasn't found in the database - create one
if (query == null)
{
Hall hallE = new Hall();
hallE.Name = record.Name;
context.Halls.Add(hallE);
try
{
context.SaveChanges();
}
catch (Exception ex)
{
LoggerSingleton.Instance.Log("An exception occurred when attempting to save a new hall to the database: ", ex);
}
}
}
}
public void SaveWarning(Model.Warning record)
{
using (Ringsted1Entities111 context = new Ringsted1Entities111())
{
Warning query = (from o in context.Warnings
where o.ID == 1
select o).FirstOrDefault();
if (query == null)
{
Warning warningE = new Warning();
warningE.Priority = record.Priority;
warningE.Message = record.Message;
context.Warnings.Add(warningE);
try
{
context.SaveChanges();
}
catch (Exception ex)
{
LoggerSingleton.Instance.Log("An exception occurred when attempting to save a new warning to the database: ", ex);
}
}
}
}
public void SaveSensorData(Model.SensorData record)
{
using (Ringsted1Entities111 context = new Ringsted1Entities111())
{
SensorData query = (from o in context.SensorDatas
where o.SensorID == record.SensorID
select o).FirstOrDefault();
if (query != null)
{
SensorData sensorDataE = new SensorData();
sensorDataE.SensorID = record.SensorID;
sensorDataE.AmbientTemperature = record.AmbientTemperature;
sensorDataE.WaterLevel = record.WaterLevel;
sensorDataE.WindSpeed = record.WindSpeed;
sensorDataE.WaterTemperature = record.WaterTemperature;
context.SensorDatas.Add(sensorDataE);
try
{
context.SaveChanges();
}
catch (Exception ex)
{
LoggerSingleton.Instance.Log("An exception occurred when attempting to save sensordata to the database: ", ex);
}
}
else
{
// test code - remember to remove this
SensorData sensorDataE = new SensorData();
sensorDataE.SensorID = record.SensorID;
sensorDataE.AmbientTemperature = record.AmbientTemperature;
sensorDataE.WaterLevel = record.WaterLevel;
sensorDataE.WindSpeed = record.WindSpeed;
sensorDataE.WaterTemperature = record.WaterTemperature;
context.SensorDatas.Add(sensorDataE);
try
{
context.SaveChanges();
}
catch (Exception ex)
{
LoggerSingleton.Instance.Log("An exception occurred when attempting to save sensordata to the database: ", ex);
}
}
}
}
public void SaveTrigger(Model.Trigger record, byte bassinid, byte warningid)
{
using (Ringsted1Entities111 context = new Ringsted1Entities111())
{
Trigger query = (from o in context.Triggers
where o.BassinID == bassinid
select o).FirstOrDefault();
if (query != null)
{
// fix this, this db insert exception
Trigger triggerE = new Trigger();
triggerE.DateTime = DateTime.Now;
triggerE.BassinID = bassinid;
triggerE.WarningID = warningid;
context.Triggers.Add(triggerE);
try
{
context.SaveChanges();
}
catch (Exception ex)
{
LoggerSingleton.Instance.Log("An exception occurred when attempting to save a new trigger to the database: ", ex);
}
}
//else
//{
// // TODO - test this
// Trigger triggerE = new Trigger();
// triggerE.DateTime = DateTime.Now;
// triggerE.WarningID = record.WarningID;
// triggerE.BassinID = record.BassinID;
// context.Triggers.Add(triggerE);
// try
// {
// context.SaveChanges();
// }
// catch (Exception ex)
// {
// LoggerSingleton.Instance.Log("An exception occurred when attempting to save a trigger to the database: ", ex);
// }
//}
}
}
public void SaveBassin(Model.Bassin record, int hallid)
{
using (Ringsted1Entities111 context = new Ringsted1Entities111())
{
Bassin query = (from o in context.Bassins
where o.HallID == record.HallID
select o).FirstOrDefault();
if (query == null)
{
Bassin bassinE = new Bassin();
bassinE.HallID = hallid;
context.Bassins.Add(bassinE);
try
{
context.SaveChanges();
}
catch (Exception ex)
{
LoggerSingleton.Instance.Log("An exception occurred when attempting to save a new bassin to the database: ", ex);
}
}
}
}
