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);
}
}
