public RoomMeasurementList getAllMeasurements(string roomCode)
{
//Only 1 room is real the rest is harcoded because we only have 1 set of sensors
RoomMeasurementList roomMeasurementList = new RoomMeasurementList();
roomMeasurementList.mockMeasurementsExceptRoomNo(roomCode);
RoomMeasurement roomMeasurement = new RoomMeasurement();
roomMeasurement.setMeasurementsFromMongo(_mongoRepository.LoadLastRoomMeasurement(_mongoRepository.modifyToMongoRoomID(roomCode)));
roomMeasurementList.addRoomMeasurement(roomMeasurement);
return(roomMeasurementList);
}
public RoomMeasurementList LoadAllMeasurements()
{
_roomMeasurement = database.GetCollection <MongoMeasurement>(_settings.MeasurementsCollectionName);
RoomMeasurementList measurementList = new RoomMeasurementList();
RoomMeasurement RoomMeasurement = new RoomMeasurement();
List <MongoMeasurement> mongoMeasurements =
_roomMeasurement.Find(FilterDefinition <MongoMeasurement> .Empty).ToList();
foreach (var m in mongoMeasurements)
{
RoomMeasurement = new RoomMeasurement();
RoomMeasurement.setMeasurementsFromMongo(m);
measurementList.addRoomMeasurement(RoomMeasurement);
}
return(measurementList);
}
public static void TransferDataFromMongoDb()
{
MongoRepository mongoRepository = new MongoRepository();
RoomMeasurementList roomMeasurements = mongoRepository.LoadAllMeasurements();
SqlConnection sqlConnection;
SqlCommand sqlCommand;
string connection =
"User ID=museum;password=Mus12345;server=sqlserversss.database.windows.net;Database=museum;";
sqlConnection = new SqlConnection(connection);
try
{
for (int i = 1; i < roomMeasurements.Measurements.Count; i++)
{
string sql =
"Insert into RoomMeasurements (roomNo,Temperature,Light,CO2,Humidity,MeasurementDate)" +
" values (@roomNo,@Temperature,@Light,@CO2,@Humidity,@MeasurementDate);";
sqlConnection.Open();
sqlCommand = new SqlCommand(sql, sqlConnection);
sqlCommand.Parameters.Add(@"roomNo", SqlDbType.VarChar).Value = roomMeasurements.Measurements[i].roomNo;
sqlCommand.Parameters.Add(@"Temperature", SqlDbType.Decimal).Value = roomMeasurements.Measurements[i].Temperature;
sqlCommand.Parameters.Add(@"Light", SqlDbType.Decimal).Value = roomMeasurements.Measurements[i].Light;
sqlCommand.Parameters.Add(@"Co2", SqlDbType.Decimal).Value = roomMeasurements.Measurements[i].Co2;
sqlCommand.Parameters.Add(@"Humidity", SqlDbType.Decimal).Value = roomMeasurements.Measurements[i].Humidity;
sqlCommand.Parameters.Add(@"MeasurementDate", SqlDbType.DateTime2).Value = roomMeasurements.Measurements[i].MeasurementDate;
sqlCommand.ExecuteNonQuery();
sqlCommand.Dispose();
sqlConnection.Close();
}
}
catch (Exception exception)
{
Console.WriteLine(" Transfer data from Mongodb is facing some issues" + exception.Message);
}
}
public RoomMeasurementList LoadAllRoomLastMeasurements()
{
RoomMeasurementList list = new RoomMeasurementList();
RoomMeasurement roomMeasurement = new RoomMeasurement();
_roomMeasurement = database.GetCollection <MongoMeasurement>(_settings.MeasurementsCollectionName);
for (int i = 1; i < 8; i++)
{
roomMeasurement = new RoomMeasurement();
BsonDocument filter = new BsonDocument("room_no", i);
MongoMeasurement mongoMeasurement = _roomMeasurement.Find(filter).SortByDescending(d => d.time).Limit(1)
.FirstOrDefault();
roomMeasurement.setMeasurementsFromMongo(mongoMeasurement);
list.Measurements.Add(roomMeasurement);
}
return(list);
}
