public void DeleteAssignmentsTest() { var options = new DbContextOptionsBuilder <AppDBContext>() .UseInMemoryDatabase(databaseName: "AssignmentDeleteDatabase") .Options; using (var context = new AppDBContext(options)) { context.Assignment.Add(new Assignment { Id = "1", Name = "1", Description = "1" }); context.Assignment.Add(new Assignment { Id = "2", Name = "2", Description = "2" }); context.Assignment.Add(new Assignment { Id = "3", Name = "3", Description = "3" }); context.Assignment.Add(new Assignment { Id = "4", Name = "4", Description = "4" }); context.SaveChanges(); } using (var context = new AppDBContext(options)) { AssignmentRepository assignmentRepository = new AssignmentRepository(context); assignmentRepository.Delete("4"); context.SaveChanges(); List <Assignment> assignments = assignmentRepository.GetAll().ToList(); Assert.Equal(3, assignments.Count); } }
// GET: assignments public ActionResult ShowAssignments() { AssignmentRepository assignmentRepository = new AssignmentRepository(); var assignment = assignmentRepository.GetAll(); return(View(assignment.ToList())); }
// // GET: /Comment/ public ActionResult Index(int id) { var commentsRepository = new CommentsRepository(); var commentsList = new List <Comment>(); var commentsFromRepository = commentsRepository .GetAll(comment => comment.AssignmentId == id); //foreach (var comment in commentsFromRepository) //{ // if (comment.AssignmentId == id) // { // commentsList.Add(comment); // } //} ViewBag.AssignmentId = id; var assignmentRepository = new AssignmentRepository(); ViewBag.AssignmentTitle = assignmentRepository.GetById(id).Title; // Navigational Property Demo //var firstComment = commentsList.FirstOrDefault(); //ViewBag.AssignmentTitle = firstComment.Assignment.Title; commentsList.AddRange(commentsFromRepository); return(View(commentsList)); }
public void GetAssignmentTest() { var options = new DbContextOptionsBuilder <AppDBContext>() .UseInMemoryDatabase(databaseName: "AssignmentGetDatabase") .Options; using (var context = new AppDBContext(options)) { context.Assignment.Add(new Assignment { Id = "1", Name = "1", Description = "1" }); context.Assignment.Add(new Assignment { Id = "2", Name = "2", Description = "2" }); context.Assignment.Add(new Assignment { Id = "3", Name = "3", Description = "3" }); context.Assignment.Add(new Assignment { Id = "4", Name = "4", Description = "4" }); context.SaveChanges(); } using (var context = new AppDBContext(options)) { AssignmentRepository assignmentRepository = new AssignmentRepository(context); Assignment assignment = assignmentRepository.Get("1"); Assert.Equal("1", assignment.Name); } }
// GET: Courses/Create public ActionResult Create() { AssignmentRepository assignemntRepository = new AssignmentRepository(); ViewBag.SelectedAssignmentsId = assignemntRepository.GetAll().Select(x => new SelectListItem() { Value = x.AssignmentId.ToString(), Text = x.Title }); TrainerRepository trainerRepository = new TrainerRepository(); ViewBag.SelectedTrainersId = trainerRepository.GetAll().Select(x => new SelectListItem() { Value = x.TrainerId.ToString(), Text = x.LastName }); StudentRepository studentRepository = new StudentRepository(); ViewBag.SelectedStudentsId = studentRepository.GetAll().Select(x => new SelectListItem() { Value = x.StudentId.ToString(), Text = x.LastName }); return(View()); }
public void CheckTagExistAfterAdd() { //Arrange Tag tag = new Tag() { Id = 66, Name = "test" }; var options = new DbContextOptionsBuilder <Context>() .UseInMemoryDatabase(databaseName: "UsersDirectoryMVC") .Options; using (var context = new Context(options)) { //Act var assignmentRepository = new AssignmentRepository(context); assignmentRepository.AddTag(tag); var assignmentResult = assignmentRepository.GetTag(66); //Assert assignmentResult.Should().NotBeNull(); assignmentResult.Should().Equals(tag); } }
// GET: Assignment public ActionResult AssignmentTable(string sortOrder, string searchTitle, int?page) { ViewBag.CurrentTitle = searchTitle; ViewBag.CurrentSort = sortOrder; ViewBag.TitleShort = String.IsNullOrEmpty(sortOrder) ? "TitleDesc" : ""; AssignmentRepository assignmentRepository = new AssignmentRepository(); var assignments = assignmentRepository.GetAll(); // FILTERING if (!string.IsNullOrWhiteSpace(searchTitle)) { assignments = assignments.Where(x => x.Title.ToUpper().Contains(searchTitle.ToUpper())); } // SORTING switch (sortOrder) { case "TitleDesc": assignments = assignments.OrderByDescending(x => x.Title); break; default: assignments = assignments.OrderBy(x => x.Title); break; } // PAGINATION int pageSize = 4; int pageNuber = page ?? 1; return(View(assignments.ToPagedList(pageNuber, pageSize))); }
public void CheckAssignmentExistAfterDelete() { //Arrange Assignment assignment1 = new Assignment() { Id = 66, Name = "test", Description = "unit" }; Assignment assignment2 = new Assignment() { Id = 77, Name = "test", Description = "unit" }; var options = new DbContextOptionsBuilder <Context>() .UseInMemoryDatabase(databaseName: "UsersDirectoryMVC") .Options; using (var context = new Context(options)) { //Act var assignmentRepository = new AssignmentRepository(context); assignmentRepository.AddAssignment(assignment1); assignmentRepository.AddAssignment(assignment2); assignmentRepository.DeleteAssignment(66); var gerAssignment1 = assignmentRepository.GetAssignment(66); var gerAssignment2 = assignmentRepository.GetAssignment(77); //Assert gerAssignment1.Should().BeNull(); gerAssignment2.Should().Equals(assignment2); } }
public void CheckTagExistAfterDelete() { //Arrange Tag tag1 = new Tag() { Id = 66, Name = "test" }; Tag tag2 = new Tag() { Id = 77, Name = "test" }; var options = new DbContextOptionsBuilder <Context>() .UseInMemoryDatabase(databaseName: "UsersDirectoryMVC") .Options; using (var context = new Context(options)) { //Act var assignmentRepository = new AssignmentRepository(context); assignmentRepository.AddTag(tag1); assignmentRepository.AddTag(tag2); assignmentRepository.DeleteTag(66); var gerAssignment1 = assignmentRepository.GetTag(66); var gerAssignment2 = assignmentRepository.GetTag(77); //Assert gerAssignment1.Should().BeNull(); gerAssignment2.Should().Equals(tag2); } }
public void GetListOfAddedAssignmentsAndCheckAreEqualLikeModels() { //Arrange Assignment assignment1 = new Assignment() { Id = 66, Name = "test", Description = "unit" }; Assignment assignment2 = new Assignment() { Id = 67, Name = "test1", Description = "unit1" }; var options = new DbContextOptionsBuilder <Context>() .UseInMemoryDatabase(databaseName: "UsersDirectoryMVC") .Options; using (var context = new Context(options)) { //Act var assignmentRepository = new AssignmentRepository(context); assignmentRepository.AddAssignment(assignment1); assignmentRepository.AddAssignment(assignment2); var listOfAssignments = assignmentRepository.GetAllActiveAssignments(); //Assert listOfAssignments.FirstOrDefault(e => e.Id == 66).Should().Equals(assignment1); listOfAssignments.FirstOrDefault(e => e.Id == 67).Should().Equals(assignment2); } }
// GET: Stats public ActionResult Index() { StatsViewModel vm = new StatsViewModel(); CourseRepository courseRepository = new CourseRepository(); var courses = courseRepository.GetAll(); int courseCount = courses.Count(); vm.CoursesCount = courseCount; TrainerRepository trainerRepository = new TrainerRepository(); var trainers = trainerRepository.GetAll(); int trainerCount = trainers.Count(); vm.TrainersCount = trainerCount; AssignmentRepository assignmentRepository = new AssignmentRepository(); var assignments = assignmentRepository.GetAll(); int assignmentCount = assignments.Count(); vm.AssignmentsCount = assignmentCount; StudentRepository studentRepository = new StudentRepository(); var students = studentRepository.GetAll(); int studentCount = students.Count(); vm.StudentsCount = studentCount; vm.CourseTable = courses; return(View(vm)); }
public ActionResult Update(int id) { var assignmentRepository = new AssignmentRepository(); Assignment entity = assignmentRepository.GetById(id); return(View(entity)); }
// // GET: /Comment/ public ActionResult Index(int id) { var commentsRepository = new CommentsRepository(); var commentsList = new List <Comment>(); var commentsFromRepo = commentsRepository.GetAll(comment => comment.AssignmentId == id); // var commentsFromRepo = commentsRepository.GetAll(); //foreach (var comment in commentsFromRepo) //{ // if (comment.AssignmentId == id) // { // commentsList.Add(comment); // } //} ViewBag.AssignmentId = id; var assignmentRepository = new AssignmentRepository(); ViewBag.AssignmentTitle = assignmentRepository.GetById(id).Title; commentsList.AddRange(commentsFromRepo); return(View(commentsList)); }
public AccountsController(AssignmentRepository assignmentrepository, IMemoryCache cache, AccountRepository accountrepository, UserManager <IdentityUser> userManager) { this.assignmentrepository = assignmentrepository; this.accountrepository = accountrepository; this.cache = cache; _userManager = userManager; }
public static void AssignmentById(int?id) { AssignmentRepository assignmentRepository = new AssignmentRepository(); var assignment = assignmentRepository.GetById(id); Console.WriteLine("{0, -5}{1, -10}", assignment.AssignmentId, assignment.Title); }
public void SetUp() { _mapper = DtoMappings.GetMapperConfiguration().CreateMapper(); _userRepository = new UserRepository(_connection); _assignmentRepository = new AssignmentRepository(_connection, _mapper); _planRepository = new PlanRepository(_connection, _mapper); _user = _userRepository.GetUser(1).Result; }
public void SetUp() { var mapper = DtoMappings.GetMapperConfiguration().CreateMapper(); _shiftRepository = new ShiftRepository(_connection); _assignmentRepository = new AssignmentRepository(_connection, mapper); _planRepository = new PlanRepository(_connection, mapper); }
// // GET: /Assignment/ public ActionResult Index() { var assingments = new List <Assignment>(); var assingmentRepository = new AssignmentRepository(); assingments.AddRange(assingmentRepository.GetAll()); return(View(assingments)); }
// // GET: /Assignment/ public ActionResult Index() { ViewBag.StdGroup1 = "I am Batman"; List <Assignment> assignments = new List <Assignment>(); AssignmentRepository assignmentRepository = new AssignmentRepository(); assignments.AddRange(assignmentRepository.GetAll()); return(View(assignments)); }
public ActionResult Delete(int id) { var assignmentRepository = new AssignmentRepository(); Assignment entity = assignmentRepository.GetById(id); assignmentRepository.Delete(entity); return(RedirectToAction("Index")); }
// GET: Stats public ActionResult Index() { StatsViewModel vm = new StatsViewModel(); StudentRepository studentRepository = new StudentRepository(); var students = studentRepository.GetAll(); CourseRepository courseRepository = new CourseRepository(); var courses = courseRepository.GetAll(); TrainerRepository trainerRepository = new TrainerRepository(); var trainers = trainerRepository.GetAll(); AssignmentRepository assignmentRepository = new AssignmentRepository(); var assignments = assignmentRepository.GetAll(); vm.StudentsCount = students.Count(); vm.CoursesCount = courses.Count(); vm.TrainersCount = trainers.Count(); vm.AssignmentsCount = assignments.Count(); //Grouping Course Student vm.StudentsPerCourse = students .SelectMany(x => x.Courses.Select(y => new { Key = y, Value = x })) .GroupBy(y => y.Key, x => x.Value); //Grouping Course Trainer vm.TrainersPerCourse = trainers .SelectMany(x => x.Courses.Select(y => new { Key = y, Value = x })) .GroupBy(y => y.Key, x => x.Value); //Grouping Course Assignment vm.AssignmentPerCourse = courses .SelectMany(x => x.Assignments.Select(y => new { Key = x, Value = y })) .GroupBy(y => y.Key, x => x.Value); vm.Students = students; vm.Courses = courses; vm.Assignments = assignments; return(View(vm)); }
// GET: Assignment public ActionResult AssignmentTable(string sortOrder, string searchTitle, string searchDescription, int?page, int?pSize) { //--------------- FILTERING type ------------------ ViewBag.CurrentTitleName = searchTitle; ViewBag.CurrentDescriptionName = searchDescription; ViewBag.CurrentSortOrder = sortOrder; ViewBag.CurrentpSize = pSize; //---------------- SORTING Parameters -------------------- ViewBag.TitleNameSortParam = String.IsNullOrEmpty(sortOrder) ? "TitleNameDesc" : ""; ViewBag.DescriptionNameSortParam = sortOrder == "DescriptionAsc" ? "DescriptionDesc" : "DescriptionAsc"; ViewBag.SubTimeSortParam = sortOrder == "SubTimeAsc" ? "SubTimeDesc" : "SubTimeAsc"; ViewBag.TNView = "badge badge-primary"; ViewBag.DNView = "badge badge-primary"; ViewBag.STView = "badge badge-primary"; AssignmentRepository assignmentRepository = new AssignmentRepository(); var assignment = assignmentRepository.GetAll(); //--------------- FILTERING check ------------------ if (!string.IsNullOrWhiteSpace(searchTitle)) { assignment = assignment.Where(x => x.Title.ToUpper().Contains(searchTitle.ToUpper())); } if (!string.IsNullOrWhiteSpace(searchDescription)) { assignment = assignment.Where(x => x.Description.ToUpper().Contains(searchDescription.ToUpper())); } //---------------- SORTING check -------------------- switch (sortOrder) { case "TitleNameDesc": assignment = assignment.OrderByDescending(x => x.Title); ViewBag.TNView = "badge badge-danger"; break; case "DescriptionAsc": assignment = assignment.OrderBy(x => x.Description); ViewBag.DNView = "badge badge-success"; break; case "DescriptionDesc": assignment = assignment.OrderByDescending(x => x.Description); ViewBag.DNView = "badge badge-danger"; break; case "SubTimeAsc": assignment = assignment.OrderBy(x => x.SubTime); ViewBag.STView = "badge badge-success"; break; case "SubTimeDesc": assignment = assignment.OrderByDescending(x => x.SubTime); ViewBag.STView = "badge badge-danger"; break; default: assignment = assignment.OrderBy(x => x.AssignmentId); ViewBag.TNView = "badge badge-success"; break; } //----------------- PAGINATION check ------------------ int pageSize = pSize ?? 5; int pageNumber = page ?? 1; return(View(assignment.ToPagedList(pageNumber, pageSize))); }
public BaseTestController() { am = new Mock <IAuthorizeService>(); am.Setup(a => a.isDictaatOwner(It.IsAny <string>(), It.IsAny <string>())) .Returns(Task.FromResult(true)); am.Setup(a => a.IsDictaatContributer(It.IsAny <string>(), It.IsAny <string>())) .Returns(Task.FromResult(true)); //mock user store var userStore = new Mock <IUserStore <ApplicationUser> >(); var umm = new Mock <UserManager <ApplicationUser> >(userStore.Object, null, null, null, null, null, null, null, null); _user = new TestPrincipal(new Claim[] { new Claim(ClaimTypes.Name, "ssmulder"), new Claim(ClaimTypes.NameIdentifier, "06c52646-53fd-4a03-8009-d2ad921e954e") }); _config = new Mock <IOptions <ConfigVariables> >(); ConfigVariables vars = new ConfigVariables() { DictaatRoot = "//resources", PagesDirectory = "pages", DictaatConfigName = "dictaat.config.json", DictatenDirectory = "dictaten", TemplatesDirectory = "templates", MenuConfigName = "nav-menu.json", ImagesDirectory = "images", StyleDirectory = "styles", }; _config.Setup(c => c.Value).Returns(vars); //database var options = new DbContextOptionsBuilder <WebdictaatContext>() .UseSqlServer("Data Source=(localdb)\\webdictaat;Initial Catalog=webdictaat.test;Integrated Security=False;User ID=ssmulder;Password=password;Connect Timeout=60;Encrypt=False;TrustServerCertificate=True;ApplicationIntent=ReadWrite;MultiSubnetFailover=False") .Options; _context = new WebdictaatContext(options); //managers and factories _dictaatFactory = new Mock <IDictaatFactory>(); _dictaatFactory.Setup(df => df.GetDictaat(It.IsAny <string>())).Returns(new Domain.Dictaat() { Name = "Test" }); _dictaatFactory.Setup(df => df.CopyDictaat(It.IsAny <string>(), It.IsAny <DictaatDetails>())).Returns(new Domain.Dictaat() { Name = "Test2" }); _analytics = new Mock <IGoogleAnalytics>(); //repos _assignmentRepo = new AssignmentRepository(_context, null); _dictaatRepo = new DictaatRepository(_config.Object, _analytics.Object, _dictaatFactory.Object, _context); _participantRepo = new ParticipantRepository(_context, umm.Object); }
// GET: Stats public ActionResult Index() { StatsViewModel statsView = new StatsViewModel(); StudentRepository studentRepository = new StudentRepository(); var students = studentRepository.GetAll(); TrainerRepository trainerRepository = new TrainerRepository(); var trainers = trainerRepository.GetAll(); CourseRepository courseRepository = new CourseRepository(); var courses = courseRepository.GetAll(); AssignmentRepository assignmentRepository = new AssignmentRepository(); var assignments = assignmentRepository.GetAll(); statsView.StudentsCount = students.Count(); statsView.TrainersCount = trainers.Count(); statsView.CoursesCount = courses.Count(); statsView.AssignmentsCount = assignments.Count(); //Grouping Students Per Course statsView.StudentsPerCourse = from student in students group student by student.Course into x orderby x.Key select x; //Grouping Trainers Per Course statsView.TrainersPerCourse = trainers .SelectMany(x => x.Courses.Select(y => new { Key = y, Value = x })).GroupBy(y => y.Key, x => x.Value); //Grouping Assignments Per Course statsView.AssignmentPerCourse = assignments .SelectMany(x => x.Courses.Select(y => new { Key = y, Value = x })).GroupBy(y => y.Key, x => x.Value); //Grouping Assignments Per Student statsView.AssignmentPerStudent = assignments .SelectMany(x => x.MarkAssignments.Select(y => new { Key = x, Value = y })).GroupBy(x => x.Key, y => y.Value); statsView.Students = students; statsView.Courses = courses; statsView.Assignments = assignments; return(View(statsView)); }
public ActionResult Update(Assignment entity) { var assignmentRepository = new AssignmentRepository(); entity.UpdatedAt = DateTime.Now; assignmentRepository.Update(entity); return(RedirectToAction("Index")); }
public UnitOfWork(/*TakeMyTimeDbContext context*/) { this.context = new TakeMyTimeDbContext(); Projects = new ProjectRepository(context); Entries = new EntryRepository(context); Assignments = new AssignmentRepository(context); ProjectTypes = new ProjectTypeRepository(context); Subtasks = new SubtaskRepository(context); Statistics = new StatisticsRepository(context); }
public static void AllAssignments() { AssignmentRepository assignmentRepository = new AssignmentRepository(); var assignments = assignmentRepository.GetAll(); foreach (var assignment in assignments) { Console.WriteLine("{0, -5}{1, -10}", assignment.AssignmentId, assignment.Title); } }
public StudentCourseTrainerAssignment() { StudentRepository studentRepository = new StudentRepository(); CourseRepository courseRepository = new CourseRepository(); TrainerRepository trainerRepository = new TrainerRepository(); AssignmentRepository assignmentRepository = new AssignmentRepository(); Students = studentRepository.GetAll(); Courses = courseRepository.GetAll(); Trainers = trainerRepository.GetAll(); Assignments = assignmentRepository.GetAll(); }
public UnitOfWork(StudentHelperContext context) { _StudentHelperContext = context; Assignments = new AssignmentRepository(_StudentHelperContext); Courses = new CourseRepository(_StudentHelperContext); Exercises = new ExerciseRepository(_StudentHelperContext); Students = new StudentRepository(_StudentHelperContext); Teachers = new TeacherRepository(_StudentHelperContext); HelpRequests = new HelpRequestRepository(_StudentHelperContext); StudentExercises = new StudentExerciseRepository(_StudentHelperContext); StudentAssignments = new StudentAssignmentRepository(_StudentHelperContext); }
public ActionResult Create(Assignment entity) { entity.CreatedAt = DateTime.Now; entity.UpdatedAt = DateTime.Now; entity.IsDone = false; var assignmentRepository = new AssignmentRepository(); assignmentRepository.Insert(entity); return(RedirectToAction("Index")); }