public async Task GetAllOrderedByAsync_ExpectAscendingOrder_And_IncludeCourses()
{
//Arrange
await SetUpData();
var firstUserName = User + "9";
var lastUserName = User + "1";
//Act
var courses = await CourseQueryRepository.GetAllAsync();
var allUsers = await UserQueryRepository.GetAllAsync();
for (var i = 0; i < courses.Count; i++)
{
courses[i].UserId = allUsers[i].Id;
}
await CourseCommandRepository.UpdateListAsync(courses);
var teachers = await this.UserQueryRepository.GetAllOrderedByAsync(user => user.FirstName, Sort.Asc, user => user.Courses);
//Assert
Assert.Equal(firstUserName, teachers.First().FirstName);
Assert.Equal(1, teachers.First().Courses.Count);
Assert.Equal(lastUserName, teachers.Last().FirstName);
Assert.Equal(1, teachers.Last().Courses.Count);
}
// private ICacheProvider _cacheProvider;
public AuthEventHandler(UserRepository userRepository, UserQueryRepository queryUserRepository,
SubDomainRepository subDomainRepository, SubDomainQueryRepository querySubDomainRepository)
{
_userRepository = userRepository;
_subDomainRepository = subDomainRepository;
_queryUserRepository = queryUserRepository;
_querySubDomainRepository = querySubDomainRepository;
}
// private ICacheProvider _cacheProvider;
public AuthAppService(UserRepository userRepository, UserQueryRepository queryUserRepository,
SubDomainRepository subDomainRepository, SubDomainQueryRepository querySubDomainRepository)
{
_userRepository = userRepository;
_subDomainRepository = subDomainRepository;
_queryUserRepository = queryUserRepository;
_querySubDomainRepository = querySubDomainRepository;
}
public AuthApplication()
{
this.userRoleQueryRepository = new UserRoleQueryRepository();
this.roleQueryRepository = new RoleQueryRepository();
this.rolePermissionQueryRepository = new RolePermissionQueryRepository();
this.permissionQueryRepository = new PermissionQueryRepository();
this.userQueryRepository = new UserQueryRepository();
}
public async Task Add_CheckCount_ExpectTwo()
{
//Act
await UserCommandRepository.AddAsync(new User { FirstName = "User1" });
await UserCommandRepository.AddAsync(new User { FirstName = "User2" });
var actualAmount = (await UserQueryRepository.GetAllAsync()).Count;
//Assert
Assert.Equal(2, actualAmount);
}
private async Task SetUpData()
{
for (var i = 0; i < 20; i++)
{
await UserCommandRepository.AddAsync(new User { FirstName = User + (i + 1) });
}
var firstUser = await UserQueryRepository.FirstAsync(s => true);
for (var i = 0; i < 20; i++)
{
await CourseCommandRepository.AddAsync(new Course { CourseName = Course + (i + 1), UserId = firstUser.Id });
}
}
public async Task Delete_CheckCount_ExpectZero()
{
//Act
await UserCommandRepository.AddAsync(new User { FirstName = "User1" });
await UserCommandRepository.AddAsync(new User { FirstName = "User2" });
var toDelete = await UserQueryRepository.GetAllAsync();
await UserCommandRepository.DeleteAsync(toDelete.First());
await UserCommandRepository.DeleteAsync(toDelete.Last());
var actualAmount = (await UserQueryRepository.GetAllAsync()).Count;
//Assert
Assert.Equal(0, actualAmount);
}
public async Task GetFilteredtWithPagingAndOrderAsync_And_IncludeCourses_PageSizeIsNegative_ExpectArgumentException()
{
//Arrange
await SetUpData();
//Act
var courses = await CourseQueryRepository.GetAllAsync();
var allUsers = await UserQueryRepository.GetAllAsync();
for (var i = 0; i < courses.Count; i++)
{
courses[i].UserId = allUsers[i].Id;
}
await CourseCommandRepository.UpdateListAsync(courses);
//Assert
await Assert.ThrowsAsync <ArgumentException>(() => this.UserQueryRepository.GetFilteredtWithPagingAndOrderAsync(t => t.FirstName.Contains(User), t => t.FirstName, 0, -1, Sort.Asc, t => t.Courses));
}
public async Task FindAsync_And_IncludeCourse_ExpectUserName_User3()
{
//Arrange
await SetUpData();
var expectedName = User + "3";
var course = await CourseQueryRepository.FirstAsync(s => true);
var user = await UserQueryRepository.FirstAsync(t => t.FirstName == expectedName);
course.UserId = user.Id;
await CourseCommandRepository.UpdateAsync(course);
//Act
var result = await this.UserQueryRepository.FindAsync(a => a.FirstName == expectedName, t => t.Courses);
//Assert
Assert.Equal(expectedName, result.First().FirstName);
Assert.Equal(1, result.First().Courses.Count);
}
public async Task UpdateAllAsync_Expect_TeacherNamesChanged()
{
//Arrange
var user1 = new User {
FirstName = "user1"
};
var user2 = new User {
FirstName = "user2"
};
var user3 = new User {
FirstName = "user3"
};
var user4 = new User {
FirstName = "user4"
};
var expectedTitle = "changed Name";
//Act
await UserCommandRepository.AddListAsync(new List <User> {
user1, user2, user3, user4
});
var toChange = await UserQueryRepository.GetAllAsync();
toChange.ForEach(teacher => teacher.FirstName = expectedTitle);
var firstPairOfTeachers = toChange.Take(2).ToList();
var scondPairOfTeachers = toChange.Skip(2).Take(2).ToList();
await UserCommandRepository.UpdateListAsync(firstPairOfTeachers);
await UserCommandRepository.UpdateListAsync(scondPairOfTeachers);
var teachers = await UserQueryRepository.GetAllAsync();
//Assert
foreach (var teacher in teachers)
{
Assert.Equal(expectedTitle, teacher.FirstName);
}
}
public async Task Update_Expect_TeacherNameChanged()
{
//Arrange
var expectedName = "changed name";
//Act
await UserCommandRepository.AddAsync(new User { FirstName = "User1" });
await UserCommandRepository.AddAsync(new User { FirstName = "User2" });
var toChange = await UserQueryRepository.GetAllAsync();
toChange.ForEach(teacher => teacher.FirstName = expectedName);
await UserCommandRepository.UpdateAsync(toChange.First());
await UserCommandRepository.UpdateAsync(toChange.Last());
var result = await UserQueryRepository.GetAllAsync();
//Assert
Assert.Equal(expectedName, result.First().FirstName);
Assert.Equal(expectedName, result.Last().FirstName);
}
public async Task GetAllAsync_AllUser_Expect20_And_IncludeCourse()
{
//Arrange
await SetUpData();
var courses = await CourseQueryRepository.GetAllAsync();
var allUsers = await UserQueryRepository.GetAllAsync();
for (var i = 0; i < courses.Count; i++)
{
courses[i].UserId = allUsers[i].Id;
}
await CourseCommandRepository.UpdateListAsync(courses);
//Act
var result = await this.UserQueryRepository.GetAllAsync(t => t.Courses);
//Assert
Assert.Equal(20, result.Count);
Assert.Equal(1, result.First().Courses.Count);
}
public async Task GetFilteredtWithPagingAndOrderAsync_ExpectAscendingOrder_And_IncludeCourses()
{
//Arrange
await SetUpData();
var siteOneFirstUserName = User + "9";
var SiteOneLastUserName = User + "5";
var siteTwoFirstUserName = User + "4";
var SiteTwoLastUserName = User + "19";
//Act
var courses = await CourseQueryRepository.GetAllAsync();
var allUsers = await UserQueryRepository.GetAllAsync();
for (var i = 0; i < courses.Count; i++)
{
courses[i].UserId = allUsers[i].Id;
}
await CourseCommandRepository.UpdateListAsync(courses);
var teacherSite1 = await this.UserQueryRepository.GetFilteredtWithPagingAndOrderAsync(t => t.FirstName.Contains(User), t => t.FirstName, 0, 5, Sort.Asc, t => t.Courses);
var teacherSite2 = await this.UserQueryRepository.GetFilteredtWithPagingAndOrderAsync(t => t.FirstName.Contains(User), t => t.FirstName, 1, 5, Sort.Asc, t => t.Courses);
//Assert
Assert.Equal(5, teacherSite1.Count);
Assert.Equal(siteOneFirstUserName, teacherSite1.First().FirstName);
Assert.Equal(SiteOneLastUserName, teacherSite1.Last().FirstName);
Assert.Equal(1, teacherSite1.Last().Courses.Count);
Assert.Equal(5, teacherSite2.Count);
Assert.Equal(siteTwoFirstUserName, teacherSite2.First().FirstName);
Assert.Equal(SiteTwoLastUserName, teacherSite2.Last().FirstName);
Assert.Equal(1, teacherSite2.Last().Courses.Count);
}
public async Task AddList_CheckCount_ExpectTwo()
{
//Arrange
var user1 = new User {
FirstName = "User1"
};
var user2 = new User {
FirstName = "User2"
};
//Act
await UserCommandRepository.AddListAsync(new List <User> {
user1
});
await UserCommandRepository.AddListAsync(new List <User> {
user2
});
var actualAmount = (await UserQueryRepository.GetAllAsync()).Count;
//Assert
Assert.Equal(2, actualAmount);
}
public UserApplication()
{
this.userStoreRepository = new UserStoreRepository();
this.userQueryRepository = new UserQueryRepository();
}
public QueryRepositoriesContainer(string connectionString)
{
UserQueryRepository = new UserQueryRepository(connectionString);
}
public Login Login(User user)
{
UserQueryRepository userRepo = new UserQueryRepository();
return(userRepo.Login(user));
}
