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