public Group GetGroup(int id) { using (var db = new UserManagementDBContext()) { return(db.Groups.First(group => group.Id == id && !group.Deleted)); } }
#pragma warning disable CS1591 // Missing XML comment for publicly visible type or member public UsersController(UserManagementDBContext context, IMapper mapper, IAdService adService) #pragma warning restore CS1591 // Missing XML comment for publicly visible type or member { _context = context; _mapper = mapper; _adService = adService; }
public async Task RefreshToken_AuthTokenExpired() { using UserManagementDBContext context = CreateDnContext(); var db = CreateUnitOfWork(context); var tokenProvider = GetTokenProvider(); var mock = new Mock <IOptions <TokenServiceOptions> >(); var options = MockOptions(TimeSpan.FromSeconds(-1), TimeSpan.FromSeconds(10), 3); TokenService service = new TokenService(db, tokenProvider, options, new NullLogger <TokenService>()); var userid = Guid.NewGuid(); var fingerprint = Guid.NewGuid().ToString(); var useragent = Guid.NewGuid().ToString(); var(authToken, refreshToken) = await service.Create(userid, fingerprint, useragent); var dbRecords = await db.Tokens.GetAsync(a => a.UserId == userid); var(refreshedAuthToken, refreshedRefreshToken) = await service.Refresh(authToken, refreshToken, fingerprint, useragent); var dbRecordsRefreshed = await db.Tokens.GetAsync(a => a.UserId == userid); Assert.NotNull(authToken); Assert.NotNull(refreshToken); Assert.NotNull(refreshedAuthToken); Assert.NotNull(refreshedRefreshToken); Assert.NotEqual(authToken, refreshedAuthToken); Assert.NotEqual(refreshToken, refreshedRefreshToken); Assert.Single(dbRecordsRefreshed); Assert.NotEqual(dbRecordsRefreshed.First().Id, dbRecords.First().Id); }
public async Task CreateToken_MaxTokenCountReached() { using UserManagementDBContext context = CreateDnContext(); var db = CreateUnitOfWork(context); var tokenProvider = GetTokenProvider(); var mock = new Mock <IOptions <TokenServiceOptions> >(); var options = MockOptions(TimeSpan.FromSeconds(10), TimeSpan.FromSeconds(10), 3); TokenService service = new TokenService(db, tokenProvider, options, new NullLogger <TokenService>()); var userid = Guid.NewGuid(); var useragent = Guid.NewGuid().ToString(); var(authToken1, refreshToken1) = await service.Create(userid, Guid.NewGuid().ToString(), useragent); Assert.Single(await db.Tokens.GetAsync(a => a.UserId == userid)); var(authToken2, refreshToken2) = await service.Create(userid, Guid.NewGuid().ToString(), useragent); Assert.Equal(2, (await db.Tokens.GetAsync(a => a.UserId == userid)).Count()); var(authToken3, refreshToken3) = await service.Create(userid, Guid.NewGuid().ToString(), useragent); Assert.Equal(3, (await db.Tokens.GetAsync(a => a.UserId == userid)).Count()); var(authToken4, refreshToken4) = await service.Create(userid, Guid.NewGuid().ToString(), useragent); Assert.Single(await db.Tokens.GetAsync(a => a.UserId == userid)); }
public IEnumerable <User> GetUsers() { using (var db = new UserManagementDBContext()) { return(db.Users.Where(u => !u.Deleted)); } }
public User GetUser(Func <User, bool> predicate) { using (var db = new UserManagementDBContext()) { return(db.Users.Where(user => !user.Deleted).SingleOrDefault(predicate)); } }
public IEnumerable <User> GetUsers(Func <User, bool> predicate) { using (var db = new UserManagementDBContext()) { return(db.Users.Where(u => !u.Deleted).Where(predicate)); } }
public bool UsernameExists(string username) { using (var db = new UserManagementDBContext()) { return(db.Users.Count(u => u.Username == username && u.Deleted == false) > 0); } }
public IEnumerable <User> GetUsers(int pageIndex, int pageSize) { using (var db = new UserManagementDBContext()) { return(db.Users.Skip(pageIndex).Take(pageSize)); } }
public IEnumerable <Group> GetGroups() { using (var db = new UserManagementDBContext()) { return(db.Groups.Where(g => !g.Deleted)); } }
public IEnumerable <User> GetUsersNotInGroup(Group group) { using (var db = new UserManagementDBContext()) { return(db.Users.Where(u => !u.Deleted).Except(db.Users.Where(m => m.Groups.Contains(group)))); //return db.Users.Where(u => !u.Deleted).Except(db.GroupUsers.Where(g => g.GroupRef == group.Id).Select(g => g.User)); } }
public static IUnitOfWork CreateInMemoryDB() { var context = new UserManagementDBContext(GetDbContextOptions()); context.Database.EnsureDeleted(); context.Database.EnsureCreated(); return(new UnitOfWork(context)); }
private UserManagementDBContext CreateDnContext() { var context = new UserManagementDBContext(GetDbContextOptions()); context.Database.EnsureDeleted(); context.Database.EnsureCreated(); return(context); }
public IEnumerable <Group> GetGroupsAvaliableForUser(User user) { using (var db = new UserManagementDBContext()) { var groupRefsByUser = GetGroupsByUser(user).Select(g => g.Id); return(db.Groups.Where(g => !groupRefsByUser.Contains(g.Id))); } }
public IEnumerable <Group> GetGroupsByUser(User user) { using (var db = new UserManagementDBContext()) { db.Users.Attach(user); return(user.Groups); } }
public void CreateGroup(Group group) { using (var db = new UserManagementDBContext()) { group.Deleted = false; db.Groups.Add(group); db.SaveChanges(); } }
public void ActivateUser(Guid id) { using (var db = new UserManagementDBContext()) { var user = db.Users.Single(u => u.Id == id); user.IsApproved = true; user.ApprovedBy = GetCurrentUser().Id; db.SaveChanges(); } }
public void DeactivateUser(Guid id) { using (var db = new UserManagementDBContext()) { var user = db.Users.Single(u => u.Id == id); user.IsApproved = false; user.ApprovedBy = null; db.SaveChanges(); } }
public void RemoveUserFromGroup(Group group, User user) { using (var db = new UserManagementDBContext()) { db.Users.Attach(user); db.Groups.Attach(group); db.Users.Remove(user); db.SaveChanges(); } }
public void AddUserToGroup(Group group, User user) { using (var db = new UserManagementDBContext()) { db.Users.Attach(user); db.Groups.Attach(group); group.Users.Add(user); db.SaveChanges(); } }
public void EditGroup(int id, Group group) { using (var db = new UserManagementDBContext()) { var oldGroup = db.Groups.Single(g => g.Id == id && !g.Deleted); oldGroup.Name = group.Name; db.SaveChanges(); } _LmsService.Inform(UserNotifications.GroupEdit, group); }
public void ChangePassword(ChangePasswordModel changePasswordModel) { var user = GetCurrentUser(); using (var db = new UserManagementDBContext()) { user.Password = EncryptPassword(changePasswordModel.NewPassword); db.SaveChanges(); } SendEmail("admin@iudico", user.Email, "Iudico Notification", "Your passord has been changed."); }
public void DeleteGroup(int id) { using (var db = new UserManagementDBContext()) { var group = db.Groups.Single(g => g.Id == id && !g.Deleted); group.Users.Clear(); group.Deleted = true; db.SaveChanges(); _LmsService.Inform(UserNotifications.GroupDelete, group); } }
public void DeleteUser(Func <User, bool> predicate) { using (var db = new UserManagementDBContext()) { var user = db.Users.Where(u => !u.Deleted).Single(predicate); user.Deleted = true; user.Groups.Clear(); db.SaveChanges(); _LmsService.Inform(UserNotifications.UserDelete, user); } }
public void CreateUser(User user) { using (var db = new UserManagementDBContext()) { user.Password = EncryptPassword(user.Password); user.OpenId = user.OpenId ?? string.Empty; user.Deleted = false; user.IsApproved = true; user.CreationDate = DateTime.Now; user.ApprovedBy = GetCurrentUser().Id; db.Users.Add(user); db.SaveChanges(); } _LmsService.Inform(UserNotifications.UserCreate, user); }
public void EditAccount(EditModel editModel) { var identity = HttpContext.Current.User.Identity; using (var db = new UserManagementDBContext()) { var user = db.Users.Single(u => u.Username == identity.Name); user.Name = editModel.Name; user.OpenId = editModel.OpenId ?? string.Empty; user.Email = editModel.Email; db.SaveChanges(); SendEmail("admin@iudico", user.Email, "Iudico Notification", "Your details have been changed."); } }
public void EditUser(Guid id, EditUserModel user) { using (var db = new UserManagementDBContext()) { var oldUser = db.Users.Single(u => u.Id == id); oldUser.Name = user.Name; if (user.Password != null && user.Password != string.Empty) { oldUser.Password = EncryptPassword(user.Password); } oldUser.Email = user.Email; oldUser.OpenId = user.OpenId ?? string.Empty; oldUser.RoleId = user.RoleId; db.SaveChanges(); _LmsService.Inform(UserNotifications.UserEdit, oldUser); } }
public void RegisterUser(RegisterModel registerModel) { using (var db = new UserManagementDBContext()) { var user = new User { Username = registerModel.Username, Password = EncryptPassword(registerModel.Password), OpenId = registerModel.OpenId ?? string.Empty, Email = registerModel.Email, Name = registerModel.Name, Role = Role.Student, IsApproved = false, Deleted = false, CreationDate = DateTime.Now, ApprovedBy = null }; db.Users.Add(user); db.SaveChanges(); } }
public User GetCurrentUser() { if (HttpContext.Current.User == null) { var user = new User { RoleId = (int)Role.None }; return(user); } var identity = HttpContext.Current.User.Identity; if (!identity.IsAuthenticated) { return(null); } using (var db = new UserManagementDBContext()) { return(db.Users.Where(u => u.Username == identity.Name).FirstOrDefault()); } }
public UnitOfWork(UserManagementDBContext dbcontext) { Dbcontext = dbcontext; }