public List <StudentModel> Get(string searchText, int itemsPerPage, int pageNumber, out int total) { List <Student> studentQuery = new List <Student>(); //server side validation if (!string.IsNullOrWhiteSpace(searchText)) { studentQuery = studentRepository.AsQueryable().Where(x => x.StudentId.ToString() == searchText || x.Name.ToString().Equals(searchText) || x.Name.Contains(searchText)).ToList(); } else { studentQuery = studentRepository.AsQueryable().ToList(); } total = studentQuery.Count(); List <Student> students = studentQuery.OrderByDescending(x => x.StudentId).Skip((pageNumber - 1) * itemsPerPage).Take(itemsPerPage).ToList(); List <StudentModel> studentModel = students.Select(x => new StudentModel { Id = x.StudentId, Name = x.Name, Phone = x.Phone, Email = x.Email, Organization = x.Organization, Address = addessService.Show(x.StudentId), }).ToList(); return(studentModel); }
public async Task Put_Removes_Obsoleted_And_Removes_Usages_In_Organization() { //Arrange - make sure the latest KLE is imported, and then remove an entire root tree await PrepareForDetailedTest(); var expectedTaskUsages = BuildTaskUsageIntegritySet().ToList(); //Add some task refs which we expect to be removed MutateDatabase(db => { using (var taskUsages = new GenericRepository <TaskUsage>(db)) using (var taskRefs = new GenericRepository <TaskRef>(db)) { var other = taskRefs.AsQueryable().First(); var objectOwnerId = other.ObjectOwnerId; var organizationUnitId = other.OwnedByOrganizationUnitId; var taskRef1 = taskRefs.Insert(CreateTaskRef(objectOwnerId, organizationUnitId)); var taskRef2 = taskRefs.Insert(CreateTaskRef(objectOwnerId, organizationUnitId)); taskRefs.Save(); //Add usages which we expect to be removed taskUsages.Insert(CreateTaskUsage(taskRef1, objectOwnerId, organizationUnitId)); taskUsages.Insert(CreateTaskUsage(taskRef2, objectOwnerId, organizationUnitId)); taskUsages.Save(); } }); //Act await PutKle(); //Assert VerifyTaskUsageIntegrity(expectedTaskUsages); }
public virtual JsonResult GetList(int?page, int?total) { try { var res = _rep.AsQueryable().OrderBy(i => true).Skip(((int)page - 1) * 13).Take(13).ToList(); return(Json(res, JsonRequestBehavior.AllowGet)); } catch (Exception e) { throw new BusinessException("Error :" + e.Message); } }
public async Task Put_Removes_Obsoleted_And_Removes_Usages_In_Systems() { //Arrange await PrepareForDetailedTest(); var systemDto = await ItSystemHelper.CreateItSystemInOrganizationAsync(A <string>(), TestEnvironment.DefaultOrganizationId, AccessModifier.Public); //Add some task refs to a system and save the expected keys (keys not removed) MutateDatabase(context => { using (var taskRefs = new GenericRepository <TaskRef>(context)) using (var systems = new GenericRepository <Core.DomainModel.ItSystem.ItSystem>(context)) { var itSystem = systems.GetByKey(systemDto.Id); var toKeep = taskRefs.AsQueryable().Take(2).ToList(); toKeep.ForEach(itSystem.TaskRefs.Add); systems.Save(); } }); var expectedTaskRefs = GetSystemTaskKeys(systemDto.Id); Assert.Equal(2, expectedTaskRefs.Count); //Add the task refs subject to removal MutateDatabase(db => { using (var systems = new GenericRepository <Core.DomainModel.ItSystem.ItSystem>(db)) using (var taskRefs = new GenericRepository <TaskRef>(db)) { var other = taskRefs.AsQueryable().First(); var objectOwnerId = other.ObjectOwnerId; var organizationUnitId = other.OwnedByOrganizationUnitId; var taskRef1 = taskRefs.Insert(CreateTaskRef(objectOwnerId, organizationUnitId)); var taskRef2 = taskRefs.Insert(CreateTaskRef(objectOwnerId, organizationUnitId)); taskRefs.Save(); //Add usages which we expect to be removed var itSystem = systems.GetByKey(systemDto.Id); itSystem.TaskRefs.Add(taskRef1); itSystem.TaskRefs.Add(taskRef2); systems.Save(); } }); //Act await PutKle(); //Assert var actualTaskRefs = GetSystemTaskKeys(systemDto.Id); VerifyTaskRefUsageKeys(expectedTaskRefs, actualTaskRefs); }
public async Task Put_Removes_Obsoleted_And_Removes_Usages_In_Projects() { //Arrange await PrepareForDetailedTest(); var project = await ItProjectHelper.CreateProject(A <string>(), TestEnvironment.DefaultOrganizationId); //Add some task refs to a project and save the expected keys (keys not removed) MutateDatabase(context => { using (var taskRefs = new GenericRepository <TaskRef>(context)) using (var projects = new GenericRepository <ItProject>(context)) { var itProject = projects.GetByKey(project.Id); var toKeep = taskRefs.AsQueryable().Take(2).ToList(); toKeep.ForEach(itProject.TaskRefs.Add); projects.Save(); } }); var expectedTaskRefs = GetProjectTaskRefKeys(project.Id); Assert.Equal(2, expectedTaskRefs.Count); //Add the task refs subject to removal MutateDatabase(db => { using (var projects = new GenericRepository <ItProject>(db)) using (var taskRefs = new GenericRepository <TaskRef>(db)) { var other = taskRefs.AsQueryable().First(); var objectOwnerId = other.ObjectOwnerId; var organizationUnitId = other.OwnedByOrganizationUnitId; var taskRef1 = taskRefs.Insert(CreateTaskRef(objectOwnerId, organizationUnitId)); var taskRef2 = taskRefs.Insert(CreateTaskRef(objectOwnerId, organizationUnitId)); taskRefs.Save(); //Add usages which we expect to be removed var itProject = projects.GetByKey(project.Id); itProject.TaskRefs.Add(taskRef1); itProject.TaskRefs.Add(taskRef2); projects.Save(); } }); //Act await PutKle(); //Assert var actualTaskRefs = GetProjectTaskRefKeys(project.Id); VerifyTaskRefUsageKeys(expectedTaskRefs, actualTaskRefs); }
public void ArticleWithIndexesIsNotReturnedWhenIndexIsNotInQuery() { var rep = new GenericRepository <ArticleDefinition>(); var guid1 = Guid.NewGuid(); var guid2 = Guid.NewGuid(); SetUp(new List <Guid> { guid1, guid2 }, rep); var query = new List <Guid>() { Guid.NewGuid() }; var result = rep.AsQueryable().Where(art => art.GetIndexes().Select(idx => idx.ReferenceId).Any(id => query.Contains(id))).ToList(); Assert.AreEqual(0, result.Count); }
public async Task Put_Removes_Obsoleted_And_Removes_Usages_And_Opt_Out_In_SystemUsages() { //Arrange await PrepareForDetailedTest(); var systemDto = await ItSystemHelper.CreateItSystemInOrganizationAsync(A <string>(), TestEnvironment.DefaultOrganizationId, AccessModifier.Public); //Add some task refs to a system, and an opt out in the system usage as well as additional task refs MutateDatabase(context => { using (var taskRefs = new GenericRepository <TaskRef>(context)) using (var systems = new GenericRepository <Core.DomainModel.ItSystem.ItSystem>(context)) { var itSystem = systems.GetByKey(systemDto.Id); var toKeep = taskRefs.AsQueryable().OrderBy(x => x.Id).Take(2).ToList(); toKeep.ForEach(itSystem.TaskRefs.Add); systems.Save(); } }); //Take system into use and add additional task refs as well as an opt out var usage = await ItSystemHelper.TakeIntoUseAsync(systemDto.Id, TestEnvironment.DefaultOrganizationId); MutateDatabase(context => { using (var taskRefs = new GenericRepository <TaskRef>(context)) using (var systems = new GenericRepository <ItSystemUsage>(context)) { var systemUsage = systems.GetByKey(usage.Id); var toOptOut = taskRefs.AsQueryable().OrderBy(x => x.Id).Skip(1).First(); var additional = taskRefs.AsQueryable().OrderBy(x => x.Id).Skip(2).First(); systemUsage.TaskRefs.Add(additional); systemUsage.TaskRefsOptOut.Add(toOptOut); systems.Save(); } }); var(expectedTaskRefKeys, expectedInheritedKeys, expectedOptOutKeys) = GetSystemUsageTasks(usage.Id); Assert.Equal(1, expectedTaskRefKeys.Count); Assert.Equal(2, expectedInheritedKeys.Count); Assert.Equal(1, expectedOptOutKeys.Count); //Add some additional which will be removed by import .. both to main system, opt out and local MutateDatabase(db => { using (var systems = new GenericRepository <Core.DomainModel.ItSystem.ItSystem>(db)) using (var usages = new GenericRepository <ItSystemUsage>(db)) using (var taskRefs = new GenericRepository <TaskRef>(db)) { var reference = taskRefs.AsQueryable().First(); var objectOwnerId = reference.ObjectOwnerId; var organizationUnitId = reference.OwnedByOrganizationUnitId; var taskRef1 = taskRefs.Insert(CreateTaskRef(objectOwnerId, organizationUnitId)); var taskRef2 = taskRefs.Insert(CreateTaskRef(objectOwnerId, organizationUnitId)); var taskRef3 = taskRefs.Insert(CreateTaskRef(objectOwnerId, organizationUnitId)); taskRefs.Save(); //Add inherited key which should be removed var system = systems.GetByKey(systemDto.Id); system.TaskRefs.Add(taskRef1); systems.Save(); //Add additional task ref and opt out which should be removed var systemUsage = usages.GetByKey(usage.Id); systemUsage.TaskRefs.Add(taskRef2); systemUsage.TaskRefsOptOut.Add(taskRef3); usages.Save(); } }); //Act await PutKle(); //Assert var(actualTaskRefKeys, actualInheritedKeys, actualOptOutKeys) = GetSystemUsageTasks(usage.Id); VerifyTaskRefUsageKeys(expectedTaskRefKeys, actualTaskRefKeys); VerifyTaskRefUsageKeys(expectedInheritedKeys, actualInheritedKeys); VerifyTaskRefUsageKeys(expectedOptOutKeys, actualOptOutKeys); }