public void Update(Team teamToUpdate, Team newTeam, List <User> teamMembers) { _currentMembers = GetTeamMembers(teamToUpdate); using (MyAiesecNetDbContext db = new MyAiesecNetDbContext()) { db.Teams.Attach(teamToUpdate); teamToUpdate.Name = newTeam.Name; teamToUpdate.Description = newTeam.Description; teamToUpdate.Start = newTeam.Start; teamToUpdate.End = newTeam.End; teamToUpdate.Type = newTeam.Type; teamToUpdate.TeamsProjects = newTeam.TeamsProjects; if (teamMembers != null) { _usersToDelete = _currentMembers.Except(teamMembers, new UserListEqualityComparer()).ToList(); if (_usersToDelete != null) { teamToUpdate = DeleteTeamMembers(teamToUpdate); } _usersToAdd = teamMembers.Except(_currentMembers, new UserListEqualityComparer()).ToList(); if (_usersToAdd != null) { teamToUpdate = AddTeamMembers(teamToUpdate); } } db.SaveChanges(); } }
public static void Update(Activity activityToUpdate, Activity newActivity, List <User> usersToActivity) { _currentMembers = GetActivityMembers(activityToUpdate); using (MyAiesecNetDbContext db = new MyAiesecNetDbContext()) { db.Activities.Attach(activityToUpdate); activityToUpdate.Name = newActivity.Name; activityToUpdate.Description = newActivity.Description; activityToUpdate.TeamId = newActivity.TeamId; activityToUpdate.ProjectId = newActivity.ProjectId; if (usersToActivity != null) { _usersToDelete = _currentMembers.Except(usersToActivity, new UserListEqualityComparer()).ToList(); if (_usersToDelete.Count != 0) { activityToUpdate = DeleteActivityMembers(activityToUpdate); } _usersToAdd = usersToActivity.Except(_currentMembers, new UserListEqualityComparer()).ToList(); if (_usersToAdd.Count != 0) { activityToUpdate = AddActivityMembers(activityToUpdate); } } db.SaveChanges(); } }
public static void Add(Committee newCommittee) { using (MyAiesecNetDbContext db = new MyAiesecNetDbContext()) { db.Committees.Add(newCommittee); db.SaveChanges(); } }
public static void Add(Position newPosition) { using (MyAiesecNetDbContext db = new MyAiesecNetDbContext()) { db.Positions.Add(newPosition); db.SaveChanges(); } }
public static void Add(Project newProject) { using (MyAiesecNetDbContext db = new MyAiesecNetDbContext()) { db.Projects.Add(newProject); db.SaveChanges(); } }
public void Delete(Team teamToUpdate) { using (MyAiesecNetDbContext db = new MyAiesecNetDbContext()) { db.Teams.Attach(teamToUpdate); db.Teams.Remove(teamToUpdate); db.SaveChanges(); } }
public static void Delete(Committee committeeToUpdate) { using (MyAiesecNetDbContext db = new MyAiesecNetDbContext()) { db.Committees.Attach(committeeToUpdate); db.Committees.Remove(committeeToUpdate); db.SaveChanges(); } }
public static void Update(Committee committeeToUpdate, Committee newCommittee) { using (MyAiesecNetDbContext db = new MyAiesecNetDbContext()) { db.Committees.Attach(committeeToUpdate); committeeToUpdate.Name = newCommittee.Name; db.SaveChanges(); } }
public static void Delete(Position positionToUpdate) { using (MyAiesecNetDbContext db = new MyAiesecNetDbContext()) { db.Positions.Attach(positionToUpdate); db.Positions.Remove(positionToUpdate); db.SaveChanges(); } }
public static void Delete(Project projectToUpdate) { using (MyAiesecNetDbContext db = new MyAiesecNetDbContext()) { db.Projects.Attach(projectToUpdate); db.Projects.Remove(projectToUpdate); db.SaveChanges(); } }
public static void Update(Position positionToUpdate, Position newPosition) { using (MyAiesecNetDbContext db = new MyAiesecNetDbContext()) { db.Positions.Attach(positionToUpdate); positionToUpdate.Name = newPosition.Name; positionToUpdate.Description = newPosition.Description; db.SaveChanges(); } }
public static void Update(Project projectToUpdate, Project newProject) { using (MyAiesecNetDbContext db = new MyAiesecNetDbContext()) { db.Projects.Attach(projectToUpdate); projectToUpdate.Name = newProject.Name; projectToUpdate.Description = newProject.Description; db.SaveChanges(); } }
public static void Delete(Activity activityToUpdate) { using (MyAiesecNetDbContext db = new MyAiesecNetDbContext()) { db.Activities.Attach(activityToUpdate); List <UserActivity> ua = activityToUpdate.UsersActivities.ToList(); db.UsersActivities.RemoveRange(ua); db.Activities.Remove(activityToUpdate); db.SaveChanges(); } }
public void Add(Team newTeam, List <User> teamMembers) { using (MyAiesecNetDbContext db = new MyAiesecNetDbContext()) { if (teamMembers != null) { _usersToAdd = teamMembers; newTeam = AddTeamMembers(newTeam); } newTeam.CommitteeId = Session.committeeId; db.Teams.Add(newTeam); db.SaveChanges(); } }
public bool Register(User u) { using (MyAiesecNetDbContext db = new MyAiesecNetDbContext()) { Role r = db.Roles.Find(1); u.UsersRoles.Add(new UserRole() { Role = r, User = u }); db.Users.Add(u); db.SaveChanges(); return(true); } }
public static void Add(Activity newActivity, List <User> usersToActivity) { using (MyAiesecNetDbContext db = new MyAiesecNetDbContext()) { db.Activities.Attach(newActivity); if (usersToActivity != null) { _usersToAdd = usersToActivity; newActivity = AddActivityMembers(newActivity); } db.Activities.Add(newActivity); db.SaveChanges(); } }