private void DefaultList_Select(object sender, EventArgs e)
{
if (DefaultList.SelectedItem != null)
{
MeetingsList.ClearSelected();
}
}
private void LoadMeetings()
{
string sqlCommandText =
"SELECT meeting.[meetingId], meeting.[name], meeting.[year], meeting.[date], meeting.hostId, CONCAT(member.[firstname], ' ', member.[lastname]) AS 'fullname' " +
"FROM meeting " +
"INNER JOIN member " +
"ON meeting.hostId = member.memberId;";
DataSet ds = Database.SqlQueryDataSet(sqlCommandText);
MeetingsList.Clear();
if (ds.Tables.Count > 0)
{
for (int index = 0; index < ds.Tables[0].Rows.Count; ++index)
{
DataRow row = ds.Tables[0].Rows[index];
if (row.RowState != DataRowState.Deleted)
{
MeetingModel m = new MeetingModel()
{
Id = (int)row["meetingId"],
Name = (string)row["name"],
Date = (DateTime)row["date"],
Year = (string)row["year"],
Host = new HostModel()
{
Id = (int)row["hostId"],
Name = (string)row["fullname"]
},
GroupMembers = LoadMembers((int)row["meetingId"])
};
MeetingsList.Add(m);
}
}
}
}
