public async Task AddAndRetrieve_MultipleSimpleObjects_Success()
{
var unitOfWork = new UserUnitOfWork(Database, CollectionName);
var person1 = new UserAggregate()
{
FirstName = "John",
Surname = "Smith"
};
var person2 = new UserAggregate()
{
FirstName = "Jane",
Surname = "Doe"
};
unitOfWork.Users.Add(person1);
unitOfWork.Users.Add(person2);
await unitOfWork.CommitAsync();
var person1Result = await unitOfWork.Users.QuerySingleAsync(user => user.Id == person1.Id);
var person2Result = await unitOfWork.Users.QuerySingleAsync(user => user.Id == person2.Id);
Assert.IsNotNull(person1Result);
Assert.IsNotNull(person2Result);
}
public override bool UpdateUserProfile()
{
bool result = false;
if (userId > 0)
{
using (var userUnitOfWork = new UserUnitOfWork(new AyudaContext()))
{
var userProfile = userUnitOfWork.UserProfiles.GetUserProfileByUserId(userId);
if (userProfile.UserProfileId > 0)
{
userProfile.FirstName = firstName;
userProfile.MiddleName = middleName;
userProfile.LastName = lastName;
userProfile.Gender = gender;
userProfile.BirthDate = birthDate;
userProfile.DateUpdated = DateTime.Now;
userUnitOfWork.UserProfiles.Update(userProfile);
result = userUnitOfWork.Complete() > 0;
userUnitOfWork.Dispose();
}
}
}
return(result);
}
public void GetUserCredentialByUsernameAndPasswordTest()
{
using (var userUnitOfWork = new UserUnitOfWork(new AyudaContext()))
{
var userCredential = userUnitOfWork.Users.GetUserCredentialByUsernameAndPassword("ajqportal", "Alvin123!!!");
}
}
public void InsertNewProject(string projectName)
{
Random r = new Random();
var unitOfwork = new ProjectUnitOfWork();
var userUnitOfWork = new UserUnitOfWork();
var projectManagers = userUnitOfWork.GetProjectManagers();
var projectManagersCount = projectManagers.Count;
var customers = unitOfwork.CustomerRepository.All().ToList();
var customerCount = customers.Count;
var customerIndex = r.Next(0, customerCount);
var projectManagerIndex = r.Next(0, projectManagersCount);
var newProject = new Project
{
CustomerId = customers[customerIndex].CustomerId,
ProjectManagerId = projectManagers[projectManagerIndex].Id,
Description = projectName,
ProjectName = projectName,
Areas = new List <Area> {
new Area
{
Name = "Area A"
}
}
};
unitOfwork.ProjectRepository.Add(newProject);
unitOfwork.SaveChanges();
}
public void AddDemoTicket()
{
var ticketUnitOfwork = new TicketUnitOfWork();
var userUnitOfwork = new UserUnitOfWork();
var random = new Random();
var projects = ticketUnitOfwork.ProjectRepository.All().ToList();
var defaultProjectId = projects[random.Next(0, projects.Count)].ProjectId;
var areas = ticketUnitOfwork.AreaRepository.Where(a => a.ProjectId == defaultProjectId).ToList();
var defaultAreaId = areas[random.Next(0, areas.Count)].AreaId;
var categories = ticketUnitOfwork.CategoryRepository.All().ToList();
var defaultCategoryId = categories[random.Next(0, categories.Count)].CategoryId;
var priorities = ticketUnitOfwork.PriorityRepository.All().ToList();
var defaultPriorityId = priorities[random.Next(0, priorities.Count)].PriorityId;
var normalUsers = userUnitOfwork.GetNormalUsers().ToList();
var projectManagers = userUnitOfwork.GetProjectManagers().ToList();
var statusId = (int)TicketStatus.Open;
var defaultUserId = normalUsers[random.Next(0, normalUsers.Count)].Id;
var ownerId = projectManagers[random.Next(0, projectManagers.Count)].Id;
var data = new TicketData
{
Title = "FirstIssue",
Content = "this is a content",
ProjectId = defaultProjectId,
CategoryId = defaultCategoryId,
PriorityId = defaultPriorityId,
UserId = defaultUserId,
CreatedBy = ownerId,
AreaId = defaultAreaId,
IsBillable = false
};
ticketUnitOfwork.NewTicket(data);
}
public static User GetUser(int id)
{
using (var uow = new UserUnitOfWork())
{
var user = uow.Users.Find(id);
return user;
}
}
public static User GetUser(string email)
{
using (var uow = new UserUnitOfWork())
{
var user = uow.Users.FirstOrDefault(u => u.Email == email);
return user;
}
}
//private DepartmentUnitOfWork _departmentUnitOfWork;
//private DesignationUnitOfWork _designationUnitOfWork;
public UserService()
{
_context = new SCHMDbContext();
_userUnitOfWork = new UserUnitOfWork(_context);
_userRoleUnitOfWork = new UserRoleUnitOfWork(_context);
//_departmentUnitOfWork = new DepartmentUnitOfWork(_context);
//_designationUnitOfWork = new DesignationUnitOfWork(_context);
}
public override bool CheckTokenIsStillActive()
{
bool result = false;
if (!string.IsNullOrEmpty(token))
{
using (var userUnitOfWork = new UserUnitOfWork(new AyudaContext()))
{
result = userUnitOfWork.UserTokens.IsTokenStillActiveByToken(token);
}
}
return(result);
}
public override UserCredential GetUserCredentialByUsernameAndPassword()
{
var userCredential = new UserCredential();
if (!string.IsNullOrEmpty(username) && !string.IsNullOrEmpty(password))
{
using (var userUnitOfWork = new UserUnitOfWork(new AyudaContext()))
{
userCredential = userUnitOfWork.Users.GetUserCredentialByUsernameAndPassword(username, password);
}
}
return(userCredential);
}
public override bool IsUsernameIsAlreadyTaken()
{
bool result = false;
if (!string.IsNullOrEmpty(username) && !string.IsNullOrEmpty(emailAddress) && !string.IsNullOrEmpty(contactNumber))
{
using (var userUnitOfWork = new UserUnitOfWork(new AyudaContext()))
{
result = userUnitOfWork.Users.IsUsernameIsAlreadyTaken(username, emailAddress, contactNumber);
}
}
return(result);
}
public async Task MongoDelta()
{
var collectionName = Guid.NewGuid().ToString();
var unitOfWork = new UserUnitOfWork(_database, collectionName);
for (var i = 0; i < NumberOfRecords; i++)
{
unitOfWork.Users.Add(new UserModel());
}
await unitOfWork.CommitAsync();
await _database.DropCollectionAsync(collectionName);
}
public override int GetUserIdByUsernameAndPassword()
{
int userId = 0;
if (!string.IsNullOrEmpty(username) && !string.IsNullOrEmpty(password))
{
using (var userUnitOfWork = new UserUnitOfWork(new AyudaContext()))
{
userId = userUnitOfWork.Users.GetUserIdByUsernameAndPassword(username, password);
}
}
return(userId);
}
public override UserProfile GetUserProfileByUserId()
{
var userProfile = new UserProfile();
if (userId > 0)
{
using (var userUnitOfWork = new UserUnitOfWork(new AyudaContext()))
{
userProfile = userUnitOfWork.UserProfiles.GetUserProfileByUserId(userId);
}
}
return(userProfile);
}
public override Guid GetUserKeyByUsernameAndPassword()
{
Guid userKey = new Guid();
if (!string.IsNullOrEmpty(username) && !string.IsNullOrEmpty(password))
{
using (var userUnitOfWork = new UserUnitOfWork(new AyudaContext()))
{
userKey = userUnitOfWork.Users.GetUserKeyByUsernameAndPassword(username, password);
}
}
return(userKey);
}
public async Task MongoDelta_ReplaceStrategy()
{
var unitOfWork = new UserUnitOfWork(_database, _collectionName);
var records = await unitOfWork.Users.QueryAsync(query => query.Take(NumberOfRecords));
foreach (var record in records)
{
ModifyUserRecord(record);
}
await unitOfWork.CommitAsync();
}
public override UserCredential GetUserCredentialByUserKey()
{
var userCredential = new UserCredential();
if (userKey.ToString().Length == 36)
{
using (var userUnitOfWork = new UserUnitOfWork(new AyudaContext()))
{
userCredential = userUnitOfWork.Users.GetUserCredentialByUserKey(userKey);
}
}
return(userCredential);
}
public override bool IsUserHasBeenDeleted()
{
var result = false;
if (userKey.ToString().Length == 36)
{
using (var userUnitOfWork = new UserUnitOfWork(new AyudaContext()))
{
result = userUnitOfWork.Users.IsUserDeleted(userKey);
}
}
return(result);
}
public async Task AddAndUpdate_SimpleObject_Success()
{
var testUser = await UserAggregate.AddTestUser(Database, CollectionName);
var unitOfWork = new UserUnitOfWork(Database, CollectionName);
var model = await unitOfWork.Users.QuerySingleAsync(user => user.Id == testUser.Id);
model.FirstName = "Bobby";
await unitOfWork.CommitAsync();
var updateQuery = await unitOfWork.Users.QuerySingleAsync(user => user.FirstName == "Bobby");
Assert.IsNotNull(updateQuery);
}
public static MessageDto UpdateUserEmail(string oldEmail, string newEmail)
{
using (var uow = new UserUnitOfWork())
{
var user = uow.Users.FirstOrDefault(u => u.Email == oldEmail);
if (user == null)
{
return new MessageDto("Could not find user.");
}
user.Email = newEmail;
uow.Save();
return new MessageDto(true);
}
}
public async Task AddAndRemove_SimpleObject_Success()
{
var testUser = await UserAggregate.AddTestUser(Database, CollectionName);
var unitOfWork = new UserUnitOfWork(Database, CollectionName);
var model = await unitOfWork.Users.QuerySingleAsync(user => user.Id == testUser.Id);
unitOfWork.Users.Remove(model);
await unitOfWork.CommitAsync();
var removeQueryResult = await unitOfWork.Users.QuerySingleAsync(user => user.FirstName == "John");
Assert.IsNull(removeQueryResult);
}
public static MessageDto UpdateUserName(int id, string firstName, string lastName)
{
using (var uow = new UserUnitOfWork())
{
var user = uow.Users.FirstOrDefault(u => u.Id == id);
if (user == null)
{
return new MessageDto("Could not find user.");
}
user.FirstName = firstName;
user.LastName = lastName;
uow.Save();
return new MessageDto(true);
}
}
public async Task MongoDelta_ReplaceStrategy()
{
var unitOfWork = new UserUnitOfWork(_database, _collectionName);
var records = await unitOfWork.DeltaUsers.QueryAsync(query => query.Take(NumberOfRecords));
foreach (var record in records)
{
record.DisplayName = Guid.NewGuid().ToString();
record.EmailAddress.EmailAddress = Guid.NewGuid().ToString();
record.EmailAddress.Verified = !record.EmailAddress.Verified;
}
await unitOfWork.CommitAsync();
}
public async Task AddAndRetrieve_SimpleObject_Success()
{
var unitOfWork = new UserUnitOfWork(Database, CollectionName);
unitOfWork.Users.Add(new UserAggregate()
{
FirstName = "John",
Surname = "Smith"
});
await unitOfWork.CommitAsync();
var queryResult = await unitOfWork.Users.QuerySingleAsync(user => user.FirstName == "John");
Assert.IsNotNull(queryResult);
}
public static User CreateNewUser(string firstName, string lastName, string email, string password)
{
using (var uow = new UserUnitOfWork())
{
var user = uow.Users.FirstOrDefault(u => u.Email == email);
if (user != null)
{
return null;
}
user = new User(firstName, lastName, email, password);
uow.Users.Add(user);
uow.Save();
return user;
}
}
public void SaveUser()
{
using (var unitOfWork = new UserUnitOfWork())
{
var userRepository = new UserRepository(unitOfWork);
userRepository.Add(new Domain.User {
Id = Guid.NewGuid().ToString(), BuyerName = "test1", dMoney = 12.0M, sName = "ok"
});
userRepository.Add(new Domain.User {
Id = Guid.NewGuid().ToString(), BuyerName = "test1", dMoney = 12.0M, sName = "ok"
});
userRepository.Add(new Domain.User {
Id = Guid.NewGuid().ToString(), BuyerName = "test1", dMoney = 12.0M, sName = "ok"
});
userRepository.UnitOfWork.Commit();
}
}
public static MessageDto UpdateUserPassword(int id, string oldPassword, string newPassword)
{
using (var uow = new UserUnitOfWork())
{
var user = uow.Users.FirstOrDefault(u => u.Id == id);
if (user == null)
{
return new MessageDto("Could not find user.");
}
if (!user.Authenticate(oldPassword))
{
return new MessageDto("Old password does not match.");
}
user.SavePassword(newPassword);
uow.Save();
return new MessageDto(true);
}
}
public override bool UpdateUserLogoutTime()
{
bool result = false;
if (loginKey.ToString().Length == 36)
{
using (var userUnitOfWork = new UserUnitOfWork(new AyudaContext()))
{
var userLogins = userUnitOfWork.UserLogins.GetUserLoginByLoginKey(loginKey);
userLogins.DateUpdated = DateTime.Now;
userLogins.LogoutTime = DateTime.Now;
userUnitOfWork.UserLogins.Update(userLogins);
result = userUnitOfWork.Complete() > 0;
userUnitOfWork.Dispose();
}
}
return(result);
}
public override bool InsertUserLogin()
{
bool result = false;
if (userId > 0)
{
using (var userUnitOfWork = new UserUnitOfWork(new AyudaContext()))
{
userUnitOfWork.UserLogins.Add(new UserLogin
{
UserId = userId,
ExpirationDate = DateTime.Now.AddMinutes(Convert.ToInt32(JsonHelper.GetJsonValue("Token:ExpirationMinutes")))
});
userUnitOfWork.Complete();
userUnitOfWork.Dispose();
}
}
return(result);
}
public override bool UpdateUserTokenDateUpdated()
{
bool result = false;
if (!string.IsNullOrEmpty(token))
{
using (var userUnitOfWork = new UserUnitOfWork(new AyudaContext()))
{
var userToken = userUnitOfWork.UserTokens.GetUserTokenByToken(token);
if (userToken.UserTokenId > 0)
{
userToken.DateUpdated = DateTime.Now;
userToken.ExpirationDate = DateTime.Now;
userUnitOfWork.UserTokens.Update(userToken);
result = userUnitOfWork.Complete() > 0;
userUnitOfWork.Dispose();
}
}
}
return(result);
}
public override UserToken InsertUserTokenAndRetrieveInsertedId()
{
var userToken = new UserToken();
if (!string.IsNullOrEmpty(token))
{
using (var userUnitOfWork = new UserUnitOfWork(new AyudaContext()))
{
userToken = new UserToken
{
UserId = userId,
UserLoginId = userLoginId,
Token = token,
ExpirationDate = DateTime.Now.AddMinutes(Convert.ToInt32(JsonHelper.GetJsonValue("Token:ExpirationMinutes")))
};
userUnitOfWork.UserTokens.Add(userToken);
userUnitOfWork.Complete();
userUnitOfWork.Dispose();
}
}
return(userToken);
}
public override bool InsertUserToken()
{
bool result = false;
if (!string.IsNullOrEmpty(token))
{
using (var userUnitOfWork = new UserUnitOfWork(new AyudaContext()))
{
userUnitOfWork.UserTokens.Add(new UserToken
{
Token = token,
ExpirationDate = DateTime.Now.AddMinutes(Convert.ToInt32(JsonHelper.GetJsonValue("Token:ExpirationMinutes"))),
UserId = userId,
UserLoginId = userLoginId
});
userUnitOfWork.Complete();
userUnitOfWork.Dispose();
result = true;
}
}
return(result);
}
public override bool UpdateUserPassword()
{
bool result = false;
if (userKey.ToString().Length == 36 && !string.IsNullOrEmpty(oldPassword) && !string.IsNullOrEmpty(newPassword))
{
using (var userUnitOfWork = new UserUnitOfWork(new AyudaContext()))
{
var user = userUnitOfWork.Users.GetUserByUserKey(userKey);
if (user.UserId > 0)
{
if (SecurePasswordHelper.Verify(oldPassword, user.Password))
{
user.Password = SecurePasswordHelper.Hash(newPassword);
userUnitOfWork.Users.Update(user);
result = userUnitOfWork.Complete() > 0;
userUnitOfWork.Dispose();
}
}
}
}
return(result);
}
public override bool CreateUserProfile()
{
bool result = false;
if (userId > 0 && !string.IsNullOrEmpty(firstName) && !string.IsNullOrEmpty(lastName))
{
using (var userUnitOfWork = new UserUnitOfWork(new AyudaContext()))
{
var userProfile = new UserProfile
{
UserId = userId,
FirstName = firstName,
MiddleName = middleName,
LastName = lastName,
Gender = gender,
BirthDate = birthDate
};
userUnitOfWork.UserProfiles.Add(userProfile);
result = userUnitOfWork.Complete() > 0;
userUnitOfWork.Dispose();
}
}
return(result);
}
public override int UpdateUserAndRetrieveUserId()
{
int userId = 0;
if (userKey.ToString().Length == 36)
{
using (var userUnitOfWork = new UserUnitOfWork(new AyudaContext()))
{
var user = userUnitOfWork.Users.GetUserByUserKey(userKey);
if (user.UserId > 0)
{
user.EmailAddress = emailAddress;
user.ContactNumber = contactNumber;
user.DateUpdated = DateTime.Now;
userUnitOfWork.Users.Update(user);
userUnitOfWork.Complete();
userUnitOfWork.Dispose();
userId = user.UserId;
}
}
}
return(userId);
}
public override int CreateUserAndRetrieveUserId()
{
int userId = 0;
if (!string.IsNullOrEmpty(username) && !string.IsNullOrEmpty(password))
{
using (var userUnitOfWOrk = new UserUnitOfWork(new AyudaContext()))
{
var user = new User
{
Username = username,
Password = SecurePasswordHelper.Hash(password),
EmailAddress = emailAddress,
ContactNumber = contactNumber
};
userUnitOfWOrk.Users.Add(user);
userUnitOfWOrk.Complete();
userId = user.UserId;
userUnitOfWOrk.Dispose();
}
}
return(userId);
}
public BaseUsersController()
{
MainUnitOfWork = new UserUnitOfWork();
}
public void Generate()
{
using (var uow = new UserUnitOfWork())
{
var user = UserGenerator.Generate(2, 3, 5, 6);
uow.Users.Add(user);
uow.Save();
}
}
