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