protected void AddComponentMembers(List <person> members, assignment_component rightassignmentcomponent) { try { int assignment_id = int.Parse(Request.QueryString["Assignment"]); int project_id = int.Parse(Request.QueryString["Project"]); // Create new assignment_component_persons foreach (var member in members) { assignment_component_person componentmember = new assignment_component_person { amtc_id = rightassignmentcomponent.amtc_id, amt_id = assignment_id, project_id = project_id, person_id = member.person_id }; ctx.assignment_component_person.Add(componentmember); member.assignment_component_person.Add(componentmember); rightassignmentcomponent.assignment_component_person.Add(componentmember); } ctx.SaveChanges(); } catch (Exception ex) { lbMessages.Text = ex.Message; } }
protected void CreateNewComponent(string componentname, List <person> personstoadd) { try { int assignment_id = int.Parse(Request.QueryString["Assignment"]); int project_id = int.Parse(Request.QueryString["Project"]); var rightassignment = ctx.assignment.Where(amt => amt.amt_id == assignment_id).SingleOrDefault(); if (rightassignment != null) { // Create new assignment_component assignment_component newcomponent = new assignment_component { amt_id = assignment_id, project_id = project_id, name = componentname, finished = false, edited = DateTime.Now }; ctx.assignment_component.Add(newcomponent); // Create new assignment_component_persons foreach (var person in personstoadd) { assignment_component_person componentmember = new assignment_component_person { amtc_id = newcomponent.amtc_id, amt_id = assignment_id, project_id = project_id, person_id = person.person_id }; ctx.assignment_component_person.Add(componentmember); person.assignment_component_person.Add(componentmember); newcomponent.assignment_component_person.Add(componentmember); } ctx.SaveChanges(); divAssignmentComponents.Controls.Clear(); FillComponentList(); lbMessages.Text = String.Empty; } } catch (Exception ex) { lbMessages.Text = ex.Message; } }