public void UpdateRoom(Room room)
        {
            ICollection<ValidationResult> validationResults;
            if (!room.Validate(out validationResults))
            {
                throw new AggregateException("Objektet klarade inte valideringen.",
                    validationResults.Select(vr => new ValidationException(vr.ErrorMessage)).ToList().AsReadOnly());
            }

            RoomDAL.UpdateRoom(room);
        }
        public void UpdateRoom(Room room)
        {
            try
            {
                using (var conn = new SqlConnection(ConnectionString))
                {
                    var cmd = new SqlCommand("appSchema.usp_UpdateRoom", conn);
                    cmd.CommandType = CommandType.StoredProcedure;

                    cmd.Parameters.Add("@RoomID", SqlDbType.TinyInt, 1).Value = room.RoomID;
                    cmd.Parameters.Add("@Heating", SqlDbType.Bit, 1).Value = room.Heating;
                    cmd.Parameters.Add("@RoomDescription", SqlDbType.VarChar, 50).Value = room.RoomDescription;
                    
                    conn.Open();

                    cmd.ExecuteNonQuery();
                }
            }
            catch
            {
                throw new ApplicationException("Ett fel inträffade då rummet skulle uppdateras i databasen.");
            }
        }