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