private void InitializeData()
{
var res = rs.GetReservations(active).Select(r => new
{
Id = r.Id,
CheckIn = r.Start,
CheckOut = r.End,
ContactName = r.User.UserName == null ? "" : r.User.UserName,
RoomType = r.Type.Name,
Room = r.Room == null ? "" : r.Room.Nr.ToString()
}).OrderByDescending(r => r.CheckIn).ToList();
var rooms = rs.GetRooms().Select(r => new
{
Nr = r.Nr,
RoomType = r.Type == null ? "" : r.Type.Name
}).ToList();
dataGridView2.DataSource = res;
dataGridView1.DataSource = rooms;
}