async Task <bool> SaveChanges() { meeting.meetingDay = daySelector.SelectedIndex; meeting.meetingName = meetingNameBox.Text; meeting.StartTime = startTimePicker.Time; meeting.rate = defaultRateBox.SelectedItem as Rate; List <MeetingUserGroup> meetingUserGroups = new List <MeetingUserGroup>(); foreach (UserGroup item in userGroupSelector.SelectedItems) { MeetingUserGroup meetingUserGroup = new MeetingUserGroup() { meetingID = meeting.meetingID, usrGroupId = item.groupID }; meetingUserGroups.Add(meetingUserGroup); } bool IsSuccess; if (meeting.newMeeting) { IsSuccess = await SettingsHelper.Instance.op2.AddNewMeeting(meeting, meetingUserGroups); } else { IsSuccess = await SettingsHelper.Instance.op2.UpdateMeeting(meeting, meetingUserGroups); } return(IsSuccess); }
/// <summary> /// Gets the MeetingGroup objects belonging to the passed MeetingID /// </summary> /// <param name="meetingID"></param> /// <returns></returns> public async Task <List <MeetingUserGroup> > GetMeetingGroupAsync(int meetingID) { lastEx = null; string Query = "SELECT * FROM Meeting_Group WHERE MeetingID=@MeetingID"; try { using (SqlConnection conn = new SqlConnection(connString)) { conn.Open(); using (SqlCommand cmd = conn.CreateCommand()) { cmd.CommandText = Query; cmd.Parameters.Add(new SqlParameter("@MeetingID", meetingID)); using (SqlDataReader dr = await cmd.ExecuteReaderAsync()) { List <MeetingUserGroup> meetingGroups = new List <MeetingUserGroup>(); while (dr.Read()) { MeetingUserGroup meetingGroup = new MeetingUserGroup(); meetingGroup.meeting_group_id = dr.GetInt32(0); meetingGroup.MeetingID = dr.GetInt32(1); meetingGroup.UserGroupId = dr.GetInt32(2); meetingGroups.Add(meetingGroup); } return(meetingGroups); } } } } catch (Exception ex) { lastEx = ex; Debug.WriteLine("[DataAccess] Exception: " + ex.Message); return(null); } }