/// <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});");
}
