public static string getGroupLocation(string groupId) { string groupLocation; try { int intGroupId = int.Parse(groupId); group groupQuery = new group(); using (var ctx = new SALAHContext()) { groupQuery = ctx.Groups.FirstOrDefault(m => m.groupID == intGroupId); groupLocation = location.getLocationWId(groupQuery.location_ID).locationName; return(groupLocation); } } catch (Exception e) { groupLocation = null; return(groupLocation); } }
public static location getLocationWId(string locationID) { location location = new location(); if (locationID != null && locationID != "") { int locationIDInt = int.Parse(locationID); using (var ctx = new SALAHContext()) { var query = from data in ctx.Locations //create a query to find the groupIDs of the logged in user where data.locationID == locationIDInt select new { data.locationName, data.Address, data.resourceIDs }; foreach (var result in query) { location.locationName = result.locationName; location.Address = result.Address; location.resourceIDs = result.resourceIDs; } } } return(location); }
public static string[] getMeetingNames(string[] meetingIDs) { string[] meetingNames = new string[meetingIDs.Length]; int i = 0; using (var ctx = new SALAHContext()) { foreach (string s in meetingIDs) { int idInt = 0; if (s != null && s != "") { idInt = int.Parse(s); } var query = from data in ctx.Meetings //create a query to find the groupIDs of the logged in user where data.meetingID == idInt select new { data.meetingTitle }; foreach (var result in query) { string title = result.meetingTitle; if (title != "" && title != null) { meetingNames[i] = result.meetingTitle; } else if (title == "" || title == null) { meetingNames[i] = "No title given"; } } i++; } } return(meetingNames); }
public static string[] getGroupNames(user user) { string[] userGroups = user.groupIDs.Split(','); string[] existingGroupNames = new string[userGroups.Length - 1]; int i = 0; try { using (var ctx = new SALAHContext()) { foreach (string s in userGroups) { int groupID; if (s != "") { groupID = int.Parse(s); group groupNamesQuery = ctx.Groups.FirstOrDefault(g => g.groupID == groupID); if (groupNamesQuery != null) { existingGroupNames[i] = groupNamesQuery.group_name; i++; } if (groupNamesQuery == null) { user.groupRemovedFromUser(groupID, user); } } } } } catch (Exception e) { MessageBox.Show("New group could not be created. Please try again with a different group name"); } return(existingGroupNames); }
private void saveBtn_Click(object sender, EventArgs e) { var confirmResult = MessageBox.Show("Are you sure you want to save your changes?", "Save changes", MessageBoxButtons.YesNo); if (confirmResult == DialogResult.Yes) { if (newGroup.group_name == currentGroup.group_name || newGroup.group_name == null) { moveGroup = false; } location.changeLocationsGroup(currentLocation, currentGroup, newGroup, moveGroup); int locationId = currentLocation.locationID; using (var ctx = new SALAHContext()) { var result = ctx.Locations.SingleOrDefault(l => l.locationID == locationId); if (result != null) { result.locationName = locationNameTxtBx.Text; result.venueNotes = venueNotesTxtBx.Text; result.Address = CreateAddress(); } ctx.SaveChanges(); ctx.Dispose(); } main_screen open_screen = new main_screen(currentUser); this.Close(); open_screen.Show(); } }
/// <summary> /// adds the users groups into the combobox for selection /// </summary> /// <param name="comboBox">target combo box</param> /// <param name="groups">string array of groups to be added</param> public static void AddGroupsToComboBox(ComboBox comboBox, string[] groups) { int length = groups.Length; //get length of the groupID array int groupID = 0; string[] groupNames = new string[length]; //new array to hold the names of the groups using (var ctx = new SALAHContext()) { for (int i = 0; i < length; i++) { if (groups[i] != "") { groupID = int.Parse(groups[i]); //parse the groupID from the groupID string array into a int variable var query = from data in ctx.Groups //create a query to find the name of the group from the groupID where data.groupID == groupID select new { data.group_name }; foreach (var result in query) { if (result.group_name != null && result.group_name != "") { groupNames[i] = result.group_name; //add the group name into the groupnames array } } if (groupNames[i] != null && groupNames[i] != "") { comboBox.Items.Add(groupNames[i]); //add the latest array entry into the combobox } } } } }
private void saveBtn_Click(object sender, EventArgs e) { var confirmResult = MessageBox.Show("Are you sure you want to save your changes to this resource?", "Save Changes", MessageBoxButtons.YesNo); if (confirmResult == DialogResult.Yes) { if (newLocation.locationID == currentLocation.locationID) { moveLocation = false; } resource.ChangeLocationOfResource(currentResource.resourceID, currentLocation.locationID, newLocation.locationID, moveLocation); int resourceId = currentResource.resourceID; using (var ctx = new SALAHContext()) { var result = ctx.Resources.SingleOrDefault(r => r.resourceID == resourceId); if (result != null) { result.name = resourceNameTxtBx.Text; result.notes = resourceNotesTxtBx.Text; result.quantity = int.Parse(quantityUpDown.Text); } ctx.SaveChanges(); ctx.Dispose(); } main_screen open_screen = new main_screen(currentUser); this.Close(); open_screen.Show(); } }