/// <summary> /// Gets the equipment by room. /// </summary> /// <param name="room">The room.</param> /// <returns></returns> public IEnumerable<Equipment> GetEquipmentByRoom(Room room) { return equipments.Where(e => e.Value == room.Id).Select(key => key.Key); }
/// <summary> /// Deletes the specified entry. /// </summary> /// <param name="entry">The entry.</param> public override void Delete(Room entry) { DBConnection.ExecuteQuery($"DELETE FROM ConferenceRoom WHERE Id = {entry.Id};"); }
/// <summary> /// Updates the specified entry. /// </summary> /// <param name="entry">The entry.</param> public override void Update(Room entry) { DBConnection.ExecuteQuery($"UPDATE ConferenceRoom SET Capacity = {entry.Size} WHERE Id = {entry.Id};"); }
/// <summary> /// Creates the specified entry. /// </summary> /// <param name="entry">The entry.</param> public override void Create(Room entry) { DBConnection.ExecuteQuery($"INSERT INTO ConferenceRoom (Id, Capacity) VALUES ({entry.Id}, {entry.Size});"); }