public static bool removeScoutsFromMeeting(int meetingId, int scoutId) { bool scoutRemoved = true; using (var ctx = new SALAHContext()) { meeting meetingQuery = new meeting(); try { meetingQuery = ctx.Meetings.FirstOrDefault(m => m.meetingID == meetingId); string[] scoutsThatAttended = meetingQuery.scoutsThatAttended.Split(','); meetingQuery.scoutsThatAttended = ""; foreach (string s in scoutsThatAttended) { if (s != scoutId.ToString()) { meetingQuery.scoutsThatAttended = s + ","; } } } catch { scoutRemoved = false; } } return(scoutRemoved); }
private void addNewMeetingBtn_Click(object sender, EventArgs e) { var confirmResult = MessageBox.Show("Are you sure you want to save this meeting?", "Save Meeting", MessageBoxButtons.YesNo); if (confirmResult == DialogResult.Yes) { try { meeting newMeeting = new meeting(); newMeeting.Location = meetingPlaceTxtBx.Text; newMeeting.meetingDesc = meetingDescTxtBx.Text; newMeeting.DateTime = meetingDatePicker.Value.ToString(); newMeeting.meetingTitle = meetingTitleTxtBx.Text; meeting.addNewMeeting(newMeeting, currentGroup); main_screen open_screen = new main_screen(currentUser); open_screen.Show(); this.Close(); } catch { MessageBox.Show("Meeting could not be saved."); } } }
public void totalMeetingsRun() { if (mCurrentGroup.meetingIDs != null) { string[] meetingIDs = group.getMeetingIDs(mCurrentGroup); int meetingsRun = 0; foreach (string s in meetingIDs) { if (s != null && s != "") { int sInt = int.Parse(s); meeting meeting = meeting.getMeeting(sInt); DateTime meetingDate = DateTime.Parse(meeting.DateTime); if (meetingDate < DateTime.Today) { meetingsRun++; } } } totalNumMeetingsValueLbl.Text = meetingsRun.ToString(); } else { totalNumMeetingsValueLbl.Text = "No meetings run yet."; } }
public static bool wasScoutAtMeeting(int meetingId, int scoutId) { bool scoutMarkedPresent = false; using (var ctx = new SALAHContext()) { meeting meetingQuery = new meeting(); meetingQuery = ctx.Meetings.FirstOrDefault(m => m.meetingID == meetingId); if (meetingQuery.scoutsThatAttended != null) { string[] scoutsThatAttended = meetingQuery.scoutsThatAttended.Split(','); foreach (string s in scoutsThatAttended) { if (s != null && s != "") { int sInt = int.Parse(s); if (scoutId == sInt) { scoutMarkedPresent = true; } } } } return(scoutMarkedPresent); } }
public void highestAttendance() { if (mCurrentGroup.meetingIDs != null) { string[] meetingIDs = group.getMeetingIDs(mCurrentGroup); int highestAttendance = 0; foreach (string s in meetingIDs) { if (s != null && s != "") { int sInt = int.Parse(s); meeting meeting = meeting.getMeeting(sInt); if (meeting.attendance > highestAttendance || highestAttendance == 0) { highestAttendance = meeting.attendance; } } } highAttenMeetingValueLbl.Text = highestAttendance.ToString(); } else { highAttenMeetingValueLbl.Text = "No meetings run yet"; } }
public static bool addNewMeeting(meeting meeting, group group) { bool meetingAdded = false; bool meetingAddedToGroup = false; try { using (var ctx = new SALAHContext()) { ctx.Meetings.Add(meeting); ctx.SaveChanges(); } meetingAddedToGroup = group.addMeetingToGroup(group.groupID, meeting.meetingID); if (meetingAddedToGroup) { meetingAdded = true; } return(meetingAdded); } catch { meetingAdded = false; return(meetingAdded); } }
public void averageNumberAttendance() { if (mCurrentGroup.meetingIDs != null) { string[] meetingIDs = group.getMeetingIDs(mCurrentGroup); int[] meetingsAttendance = new int[meetingIDs.Length]; int i = 0; int sumOfAttendance = 0; int avgAttendance; foreach (string s in meetingIDs) { if (s != null && s != "") { int sInt = int.Parse(s); meeting meeting = meeting.getMeeting(sInt); DateTime meetingDate = DateTime.Parse(meeting.DateTime); if (meetingDate < DateTime.Today) { meetingsAttendance[i] = meeting.attendance; i++; } } } foreach (int j in meetingsAttendance) { sumOfAttendance = sumOfAttendance + j; } if (i != 0) { avgAttendance = sumOfAttendance / i; AvgAttValueLblAvgAttValueLbl.Text = avgAttendance.ToString(); } else { AvgAttValueLblAvgAttValueLbl.Text = "No meetings attended yet"; } } else { AvgAttValueLblAvgAttValueLbl.Text = "No meetings run yet"; } }
public static int getMeetingAttendanceNumber(int meetingId) { int attendanceNum = 0; using (var ctx = new SALAHContext()) { meeting meetingQuery = new meeting(); meetingQuery = ctx.Meetings.FirstOrDefault(m => m.meetingID == meetingId); attendanceNum = meetingQuery.attendance; } return(attendanceNum); }
private void displayMeetingsDGV_CellContentClick(object sender, DataGridViewCellEventArgs e) { if (e.RowIndex >= 0 && e.ColumnIndex >= 0) { if (displayMeetingsDGV.Rows[e.RowIndex].Cells[e.ColumnIndex].Value != null) { meeting Meeting = meeting.getMeeting(int.Parse(displayMeetingsDGV.Rows[e.RowIndex].Cells[0].Value.ToString())); editMeeting open_screen = new editMeeting(loggedInUser, selectedGroup, Meeting); this.Close(); open_screen.Show(); } } }
public static bool addScoutToMeeting(int meetingID, int scoutID) { bool scoutAdded = true; using (var ctx = new SALAHContext()) { meeting meetingQuery = new meeting(); try { bool scoutAlreadyAdded = false; meetingQuery = ctx.Meetings.FirstOrDefault(m => m.meetingID == meetingID); if (meetingQuery.scoutsThatAttended != null) { string[] scoutsThatAttended = meetingQuery.scoutsThatAttended.Split(','); foreach (string s in scoutsThatAttended) { if (s == scoutID.ToString()) { scoutAlreadyAdded = true; } } if (scoutAlreadyAdded == false) { meetingQuery.scoutsThatAttended += scoutID + ","; meetingQuery.attendance++; ctx.SaveChanges(); ctx.Dispose(); scoutAdded = true; } return(scoutAdded); } else if (meetingQuery.scoutsThatAttended == null) { meetingQuery.scoutsThatAttended += scoutID + ","; meetingQuery.attendance++; ctx.SaveChanges(); ctx.Dispose(); scoutAdded = true; } } catch { scoutAdded = false; return(scoutAdded); } } return(scoutAdded); }
public static bool RemoveMeetingFromGroup(group group, meeting meeting) { bool meetingRemovedFromGroup = false; using (var ctx = new SALAHContext()) { try { var result = ctx.Groups.SingleOrDefault(g => g.group_name == group.group_name); if (result != null) { group = result; } string[] oldGroupMeetings = group.meetingIDs.Split(','); for (int i = 0; i < oldGroupMeetings.Length; i++) { if (oldGroupMeetings[i] == meeting.meetingID.ToString()) { var result1 = ctx.Groups.SingleOrDefault(g => g.group_name == group.group_name); if (result1 != null) { result1.meetingIDs = ""; for (int j = 0; j < oldGroupMeetings.Length - 1; j++) { if (i != j) { result1.meetingIDs += oldGroupMeetings[j] + ","; } } } } } meetingRemovedFromGroup = true; ctx.SaveChanges(); ctx.Dispose(); } catch { meetingRemovedFromGroup = false; } } return(meetingRemovedFromGroup); }
private void meetingsChooseGroupCmbBx_SelectedIndexChanged(object sender, EventArgs e) { mNumberOfScoutsInGroup = 0; registerCheckedListBox1.Items.Clear(); string[] scoutIds = group.getScoutIDs(mCurrentGroup); string[] scoutNames = scout.getScoutNames(scoutIds); string chosenMeetingName = meetingsChooseGroupCmbBx.SelectedItem.ToString(); meeting selectedMeeting = meeting.getMeetingWName(chosenMeetingName); mCurrentMeeting = selectedMeeting; int p = 0; foreach (string s in scoutNames) { string nameAndId = s; nameAndId = scoutIds[p] + ") " + s; if (scoutIds[p] != "" && scoutIds != null) { int scoutId = int.Parse(scoutIds[p]); if (s != null && s != "") { if (meeting.wasScoutAtMeeting(mCurrentMeeting.meetingID, scoutId)) { registerCheckedListBox1.Items.Add(nameAndId, true); mNumberOfScoutsInGroup++; } else { registerCheckedListBox1.Items.Add(nameAndId, false); mNumberOfScoutsInGroup++; } } p++; } } meetingNotesRTxtBx.Text = selectedMeeting.meetingDesc; meetingTitle.Text = selectedMeeting.meetingTitle; }
/// <summary> /// change which group the scout belongs to /// </summary> /// <param name="oldGroup">group the scout currently belongs to</param> /// <param name="newGroup">group the scout is going to belong to</param> /// <param name="scout">the scout to be moved</param> /// <param name="moveGroup">if the scout needs to be moved</param> public static void changeGroupMeeting(group oldGroup, group newGroup, meeting meeting, bool moveGroup) { if (moveGroup == true) { using (var ctx = new SALAHContext()) { var result = ctx.Groups.SingleOrDefault(g => g.groupID == newGroup.groupID); if (result != null) { newGroup = result; } string[] oldGroupMeetings = oldGroup.meetingIDs.Split(','); for (int i = 0; i < oldGroupMeetings.Length; i++) { if (oldGroupMeetings[i] == meeting.meetingID.ToString()) { var result1 = ctx.Groups.SingleOrDefault(g => g.groupID == oldGroup.groupID); if (result1 != null) { result1.meetingIDs = ""; for (int j = 0; j < oldGroupMeetings.Length - 1; j++) { if (i != j) { result1.meetingIDs += oldGroupMeetings[j] + ","; } } } } } group.addMeetingToGroup(newGroup.groupID, meeting.meetingID); ctx.SaveChanges(); ctx.Dispose(); } } }
public static meeting getMeetingWName(string meetingName) { meeting Meeting = new meeting(); using (var ctx = new SALAHContext()) { var query = from data in ctx.Meetings //create a query to find the groupIDs of the logged in user where data.meetingTitle == meetingName select new { data.meetingID, data.meetingTitle, data.meetingDesc, data.Location, data.DateTime }; foreach (var result in query) { Meeting.meetingID = result.meetingID; Meeting.meetingDesc = result.meetingDesc; Meeting.meetingTitle = result.meetingTitle; Meeting.Location = result.Location; Meeting.DateTime = result.DateTime; } } return(Meeting); }
private void SetUpForm(user user, meeting meeting, group group) { currentUser = user; currentGroup = group; newGroup = new group(); currentMeeting = meeting; titleLbl.Text += meeting.meetingTitle; meetingTitleTxtBx.Text = meeting.meetingTitle; meetingDescTxtBx.Text = meeting.meetingDesc; meetingPlaceTxtBx.Text = meeting.Location; try { meetingDatePicker.Value = DateTime.Parse(meeting.DateTime); } catch { MessageBox.Show("No date was set for this meeting. Please set one before saving."); } updateComboBox(); chooseGroupMeetingComboBox.Text = group.group_name; }
public static bool deleteMeeting(int meetingID) { bool meetingDeleted = false; meeting meetingQuery = new meeting(); using (var ctx = new SALAHContext()) { try { meetingQuery = ctx.Meetings.FirstOrDefault(m => m.meetingID == meetingID); ctx.Meetings.Remove(meetingQuery); ctx.SaveChanges(); ctx.Dispose(); meetingDeleted = true; } catch { meetingDeleted = false; } } return(meetingDeleted); }
public editMeeting(user user, group group, meeting meeting) { InitializeComponent(); SetUpForm(user, meeting, group); }