public int Add(string energyCounterNumber, string mountDate, string validDate, int roomId)
{
DatabaseConnection db = new DatabaseConnection();
Rooms room = new Rooms();
int counterId = db.QueryInsert("INSERT INTO energyCounters (energyCounterNumber, mountDate, validDate) OUTPUT inserted.energyCounterId VALUES ('" + energyCounterNumber + "','" + mountDate + "','" + validDate + "');");
room.AssignEnergyCounterToRoom(roomId, counterId);
return(counterId);
}
