public ChatroomContainerViewModel FetchRooms()
{
ChatroomContainerViewModel roomsList = new ChatroomContainerViewModel();
string SQL = "SELECT * FROM [Chatroom]";
List <KeyValuePair <object, object> > parameters = new List <KeyValuePair <object, object> >();
DataTable dt = new BaseMssqlContext().ExecuteQuery(SQL, parameters);
roomsList.Rooms = new List <ChatroomViewModel>();
for (int j = 0; j < dt.Rows.Count; j++)
{
roomsList.Rooms.Add(DataSetParser.DatasetToChatroom(dt, j));
}
foreach (ChatroomViewModel chatView in roomsList.Rooms)
{
List <int> members = new List <int>();
string SQLrooms =
"SELECT user_id FROM [Chatroom_User] WHERE chatroom_id = @Chatroom_Id AND access_verified = 1";
List <KeyValuePair <object, object> > param = new List <KeyValuePair <object, object> >();
param.Add(new KeyValuePair <object, object>("Chatroom_Id", chatView.Id));
DataTable dataTable = new BaseMssqlContext().ExecuteQuery(SQLrooms, param);
for (int i = 0; i < dataTable.Rows.Count; i++)
{
members.Add(Convert.ToInt32(dataTable.Rows[i][0]));
}
chatView.MemberList = members;
}
FillRoomList(roomsList);
return(roomsList);
}
private void FillRoomList(ChatroomContainerViewModel rooms)
{
foreach (ChatroomViewModel chatView in rooms.Rooms)
{
Chatrooms.Add(new Chatroom(chatView.Id, chatView.Name, chatView.NiceName, chatView.Administrator,
chatView.MemberList, chatView.ProfilePicture, chatView.MaxMembers));
}
}
