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 List <Position> Get()
{
using (MyAiesecNetDbContext db = new MyAiesecNetDbContext())
{
List <Position> positions = db.Positions.ToList();
return(positions);
}
}
public static List <Role> Get()
{
using (MyAiesecNetDbContext db = new MyAiesecNetDbContext())
{
List <Role> roles = db.Roles.ToList();
return(roles);
}
}
public static List <Committee> Get()
{
using (MyAiesecNetDbContext db = new MyAiesecNetDbContext())
{
List <Committee> committees = db.Committees.ToList();
return(committees);
}
}
public static void Add(Committee newCommittee)
{
using (MyAiesecNetDbContext db = new MyAiesecNetDbContext())
{
db.Committees.Add(newCommittee);
db.SaveChanges();
}
}
public List <Project> Get()
{
using (MyAiesecNetDbContext db = new MyAiesecNetDbContext())
{
List <Project> projects = db.Projects.ToList();
return(projects);
}
}
public static List <Activity> Get()
{
using (MyAiesecNetDbContext db = new MyAiesecNetDbContext())
{
List <Activity> activities = db.Activities.ToList();
return(activities);
}
}
public static List <Team> Get()
{
using (MyAiesecNetDbContext db = new MyAiesecNetDbContext())
{
List <Team> teams = db.Teams.Include("TeamsProjects").ToList();
return(teams);
}
}
public static void Add(Position newPosition)
{
using (MyAiesecNetDbContext db = new MyAiesecNetDbContext())
{
db.Positions.Add(newPosition);
db.SaveChanges();
}
}
public static List <User> GetCommitteMembers()
{
using (MyAiesecNetDbContext db = new MyAiesecNetDbContext())
{
List <User> members = db.Users.Where(x => x.CommitteeId == Session.committeeId).ToList();
return(members);
}
}
public static void Add(Project newProject)
{
using (MyAiesecNetDbContext db = new MyAiesecNetDbContext())
{
db.Projects.Add(newProject);
db.SaveChanges();
}
}
public static List <Project> GetByTeamId(int teamId)
{
using (MyAiesecNetDbContext db = new MyAiesecNetDbContext())
{
List <Project> projects = db.Teams.Where(y => y.Id == teamId).SelectMany(x => x.TeamsProjects.Select(z => z.Project)).ToList();
return(projects);
}
}
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 void Delete(Team teamToUpdate)
{
using (MyAiesecNetDbContext db = new MyAiesecNetDbContext())
{
db.Teams.Attach(teamToUpdate);
db.Teams.Remove(teamToUpdate);
db.SaveChanges();
}
}
public static void Delete(Project projectToUpdate)
{
using (MyAiesecNetDbContext db = new MyAiesecNetDbContext())
{
db.Projects.Attach(projectToUpdate);
db.Projects.Remove(projectToUpdate);
db.SaveChanges();
}
}
public List <User> GetTeamMembers(Team t)
{
using (MyAiesecNetDbContext db = new MyAiesecNetDbContext())
{
db.Teams.Attach(t);
List <User> users = t.UsersTeams.Select(y => y.User).ToList();
return(users);
}
}
public static void Delete(Position positionToUpdate)
{
using (MyAiesecNetDbContext db = new MyAiesecNetDbContext())
{
db.Positions.Attach(positionToUpdate);
db.Positions.Remove(positionToUpdate);
db.SaveChanges();
}
}
public static List <User> GetActivityMembers(Activity a)
{
using (MyAiesecNetDbContext db = new MyAiesecNetDbContext())
{
db.Activities.Attach(a);
List <User> users = a.UsersActivities.Select(y => y.User).ToList();
return(users);
}
}
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 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();
}
}
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 bool CheckExistingEmail(string email)
{
using (MyAiesecNetDbContext db = new MyAiesecNetDbContext())
{
User u = db.Users.FirstOrDefault(x => x.Email == email);
if (u != null)
{
return(true);
}
else
{
return(false);
}
}
}
public bool Login(string email, string password)
{
using (MyAiesecNetDbContext db = new MyAiesecNetDbContext())
{
User u = db.Users.FirstOrDefault(x => x.Email == email && x.Password == password);
if (u != null)
{
SetToSession(u);
return(true);
}
else
{
return(false);
}
}
}
public static bool LoginFromSession()
{
if (Settings.Default.Email != null)
{
using (MyAiesecNetDbContext db = new MyAiesecNetDbContext())
{
User u = db.Users.FirstOrDefault(x => x.Email == Settings.Default.Email);
if (u != null)
{
SetToSession(u);
return(true);
}
else
{
return(false);
}
}
}
else
{
return(false);
}
}
