//public void RefreshButton_Click(object sender, RoutedEventArgs e) public void RefreshButton_Click() { using (DataBaseConnector dbService = new DataBaseConnector()) { List<ISettledList> tempSettledList = new List<ISettledList>(); List<IRoom> tempRoomList = new List<IRoom>(); foreach (var dbPer in Habitants) { bool foundf = false; tempSettledList = dbService.GetSettledListRecords(t => t.PersonUUID == dbPer.UUID).ToList(); if (tempSettledList.Count > 0) { string roomUUID = tempSettledList[0].RoomUUID; tempRoomList = dbService.GetRoomRecords(t => t.UUID == roomUUID).ToList(); if (tempRoomList.Count > 0) { dbPer.RoomNumber = tempRoomList[0].RoomNumber; dbPer.SettledDate = tempSettledList[0].SettledDate; foundf = true; } } if (foundf==false) { dbPer.RoomNumber = ""; dbPer.SettledDate = DateTime.MinValue; } } } }