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