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